Return to Snippet

Revision: 23447
at February 8, 2010 01:45 by chrismendis

Initial Code
// (1) Open the database connection

   $connection = mysql_connect("localhost","fred","shhh");

   // (2) Select the winestore database

   mysql_select_db("winestore", $connection);

   // (3) Run the query on the winestore through the connection

   $result = mysql_query ("SELECT * FROM

                          wine", $connection);

   // (4) While there are still rows in the result set, fetch the current

   // row into the array $row

   while ($row = mysql_fetch_array($result, MYSQL_NUM))


     // (5) Print out each element in $row, that is, print the values of

     // the attributes

      foreach ($row as $attribute)

         print "{$attribute} ";

      // Print a carriage return to neaten the output

      print "\n";


Initial URL

Initial Description

Initial Title
Connecting to a MySQL DB

Initial Tags
mysql, database

Initial Language