<?php
error_reporting(E_ALL | E_STRICT);
ini_set("display_errors", 1);
/* create connection */
$connection = mysql_connect("localhost", "sandbox", "brotato333");
if (!$connection)
die("Could not connect to the database: " . mysql_error());
/* once you get the handle, select a database to use */
$db_select = mysql_select_db("sandbox", $connection);
if (!$db_select)
die("Failed to select a database: " . mysql_error());
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Hacker's Corner</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
</head>
<body>
<h2>Hello, world!</h2>
<p>
<?php
/* the return type is of resource, collection of rows essentially */
$query = mysql_query("select * from subjects", $connection);
if (!$query)
die("Could not query: " . mysql_error());
while ($row = mysql_fetch_array($query)) /* for each row */
echo $row[1] . " " . $row[2] . "<br />\n"; /* note, [0] would be the id field */
mysql_close($connection);
?>
</p>
</body>
</html>