neil.mckillop.org teaching:php
https://neil.mckillop.org/
2026-05-21T04:21:20+0100
neil.mckillop.org
https://neil.mckillop.org/
https://neil.mckillop.org/lib/tpl/dokuwiki/images/favicon.ico
-
text/html
2020-04-19T22:02:08+0100
Anonymous (anonymous@undisclosed.example.com)
teaching:php:database
https://neil.mckillop.org/teaching/php/database?rev=1587330128&do=diff
Teaching PHP
Making a MySQL database connection
$host = "localhost";
$dbname = "database_name";
$username = "username";
$password = "password";
$port = 3306;
$charset = "utf8mb4";
$connection_string = "mysql:host=$host;dbname=$dbname;port=$port;charset=$charset";
$db_settings = array(PDO::ATTR_ERRMODE => PDO::ERRMODE_WARNING,
PDO::ATTR_PERSISTENT => true);
$db = new PDO($connection_string, $username, $password, $db_settings);