Nearly every site that you visit nowadays has some sort of database storage in place, many sites opt to use MySQL databases when using PHP. However, many people haven’t yet taken the step to interacting with databases properly in PHP. Here we guide you through what you should be doing – using PHP’s MySQLi class – with a hat-tip to the one way that you definitely shouldn’t be doing it.
1 2 3 4 5 | $db = new mysqli('localhost', 'user', 'pass', 'demo'); if($db->connect_errno > 0){ die('Unable to connect to database [' . $db->connect_error . ']'); } |
user -> db user name
pass -> db password
demo -> database name