daigo.org

PHP-MySQL really simple example


<?php
// Connecting, selecting database
$link = mysql_connect(”localhost”, “_USERNAME_“, “_PASSWORD_“)
   or die(’Could not connect: ‘ . mysql_error());
echo ‘Connected successfully’;
mysql_select_db(”_DB_NAME_“) or die(’Could not select database’);

// Performing SQL query
$query = ‘SELECT * FROM _TABLE_NAME_ ‘;
echo ‘Query successfully’;

$result = mysql_query($query) or die(’Query failed: ‘ . mysql_error());
echo ‘Result successfully’;

// Printing results in HTML
// say this table has following fields: sitename, url and info

while ($line = mysql_fetch_assoc($result)) {
          echo “t<li><a href=”{$line[url]}”>{$line[sitename]}</a>: {$line[info]}</li>n”;
}

// Free resultset
mysql_free_result($result);

// Closing connection
mysql_close($link);
?>


php.net’s mysql function page

Also found cool page for php Form Values reference.

This entry was posted on Saturday, December 4th, 2004 at 12/04/2004 @ 10:00 am and is filed under Linux, Mac, and LAMP Open Source. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.