Accessing a MySQL database using PHP

The following is an example of how to connect to a MySQL database using PHP. In the example, we are connecting to a database using the username "jsmith" and the password "1234". A successful connection will store a link identifier in the variable $link, otherwise an error will be displayed.

$host = "hostname";
$user = "jsmith";
$pwd = "1234";

$link = mysql_connect($host,$user,$pwd);
if (!$link) {
  echo("ERROR: " . mysql_error() . "\n");

Now for an example of how to execute an SQL statement using PHP. In this example, we will be retreiving a price and stock count using a product id number.

$SQL = "SELECT price, stock FROM products WHERE id=101";
if ($link) $query_result =
mysql_db_query("database name", $SQL, $link);

if (!$query_result) {
  echo("ERROR: " . mysql_error() . "\n");

while ($row = mysql_fetch_array($query_result)) {
  echo $row["price"];
  echo $row["stock"];

<-- Previous