Revision: 44090
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at April 6, 2011 03:49 by echoCarlos
Initial Code
<?php
// 1. Create a database connection
$connection = mysql_connect("localhost","root","");
if (!$connection){
die("Database connection failed: " . mysql_error());
}
// 2. Select a database to use
$db_select = mysql_select_db("widget_corp", $connection);
if (!$db_select){
die("Database selection failed: " . mysql_error());
}
?>
<html>
<head>
<title>PHP with MySQL</title>
</head>
<body>
<?php
// 3. Perform database query
$result = mysql_query("SELECT * FROM subjects", $connection);
if (!$result){
die("Database query failed: " . mysql_error());
}
// 4. Use returned data
while ($row = mysql_fetch_array($result)){
echo $row["menu_name"]." ".$row["position"]."<br />";
}
?>
</body>
</html>
<?php
// 5. Close connection
mysql_close($connection);
?>
Initial URL
Initial Description
Initial Title
PHP Connect MySQL
Initial Tags
Initial Language
PHP