PHP MySQL Access Quick Reference

· Connect to database server

$dbh = mysql_connect($serverURL, $userId, $password);

Example:

$dbh = mysql_connect(“localhost”, “info3103wdu”, “info3103”);

Successful connection: $dbh != NULL

· Connect to database

$dbConnection = mysql_select_db($databaseName);

Example:

$dbConnection = mysql_connect(“info3103db”);

Successful connection: $dbConnection != NULL

· Query database

$queryResult = mysql_query("sql_statement");

Example:

$queryResult = mysql_query("select name, address from userInfoTable");

Successful query: $queryResult != NULL;

· Retrieve query result

o Get each row

while ($row = mysql_fetch_array($queryResult)) { …. }

o Get a column in a row

$index = 2;

$columnValue = $row[$index];

$colName = “name”;

$columnValue = $row[$colName];