Skip to content

Instantly share code, notes, and snippets.

@carlaizumibamford
Last active March 14, 2022 16:50
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save carlaizumibamford/d9404c1f1220d673d85e to your computer and use it in GitHub Desktop.
Save carlaizumibamford/d9404c1f1220d673d85e to your computer and use it in GitHub Desktop.
Debugging When Establishing A MySQL Database
<?php
$con = mysql_connect('localhost', 'root', '1234');
if (!$con) {
exit('Cannot connect database.');
}
$result = mysql_select_db('phpdb', $con);
if (!$result) {
exit('Cannot select database.');
}
$result = mysql_query('SET NAMES utf8', $con);
if (!$result) {
exit('Cannot define character code.');
}
$result = mysql_query('SELECT * FROM table', $con);
while ($data = mysql_fetch_array($result)) {
echo '<p>' . $data['id'] . ':' . $data['name'] . ':' . $data['email'] . "</p>\n";
}
$con = mysql_close($con);
if (!$con) {
exit('Cannot end database connection.');
}
?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment