MySQL PHP example

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.

Related posts:

1. PHP memo to myself
2. blog machine
3. MySQL
4. PHP Form
5. Very simple php snippet