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