diff options
author | Kyle Kaminski <kyle@kkaminsk.com> | 2013-06-16 03:25:26 -0500 |
---|---|---|
committer | Kyle Kaminski <kyle@kkaminsk.com> | 2013-06-16 03:25:26 -0500 |
commit | 1bad4fc00814e2c03ecadaa7faf93c6372f5bd30 (patch) | |
tree | 88104590feefcb804f5fa0ca57ee1a6c76cbf0a7 /databases.php | |
download | phpsandbox-1bad4fc00814e2c03ecadaa7faf93c6372f5bd30.tar.gz phpsandbox-1bad4fc00814e2c03ecadaa7faf93c6372f5bd30.tar.bz2 phpsandbox-1bad4fc00814e2c03ecadaa7faf93c6372f5bd30.zip |
initial commit
Diffstat (limited to 'databases.php')
-rw-r--r-- | databases.php | 40 |
1 files changed, 40 insertions, 0 deletions
diff --git a/databases.php b/databases.php new file mode 100644 index 0000000..02ea225 --- /dev/null +++ b/databases.php @@ -0,0 +1,40 @@ +<?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>
+
|