Free Software Server Environment: PHP MySQL

PHP MySQL

PHP has a great set of functions for accessing a MySQL database

using 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" ;

?>

output

Array
(
	[0] => information_schema
)
Array
(
	[0] => mysql
)

REFERRERS
PhpFunctions

There are no comments on this page. [Add comment]

Valid XHTML 1.0 Transitional∞ :: Valid CSS∞ :: Powered by WikkaWiki ∞

Page was generated in 0.0476 seconds