PHP MySQL
PHP has a great set of functions for accessing a MySQL databaseusing php to fetch data from mysql
There are four ways to fetch a row of data from mysql$row = mysql_fetch_array() defaults to MYSQL_BOTH, you'll get an array with both associative and number indices. $row = mysql_fetch_assoc() or MYSQL_ASSOC, you only get associative indices $row = mysql_fetch_row() or MYSQL_NUM, you only get number indices $row = mysql_fetch_object()
test.php
<?
$db = mysql_connect("localhost", "<mysqlusername>", "<mysqlpassword>");
$res = mysql_query("show databases") ;
echo "<pre>\n" ;
while ( $row = mysql_fetch_row ($res) )
{
print_r ($row ) ;
echo "\n" ;
}
echo "<pre>\n" ;
?>
$db = mysql_connect("localhost", "<mysqlusername>", "<mysqlpassword>");
$res = mysql_query("show databases") ;
echo "<pre>\n" ;
while ( $row = mysql_fetch_row ($res) )
{
print_r ($row ) ;
echo "\n" ;
}
echo "<pre>\n" ;
?>
output
Array ( [0] => information_schema ) Array ( [0] => mysql )
REFERRERS
PhpFunctions
PhpMySqlDatabases
