Connecting to a MySQL DB - PHP Snipplr Social Repository

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

PHP

Choose a language for easy browsing: