How to query mysql database in php and save the results to an array_PHP tutorial

How to query mysql database in php and save the results to an array

This article mainly introduces the method of querying mysql database in php and saving the results to an array. An example analysis of php Friends who need tips on using mysql_fetch_assoc to query the database can refer to it

The example in this article describes how to query the MySQL database in PHP and save the results to an array. Share it with everyone for your reference. The specific analysis is as follows:

The mysql_fetch_assoc function is mainly used here

The syntax of mysql_fetch_assoc is as follows:

?

1	array mysql_fetch_assoc (resource $Result_Set)

1

array mysql_fetch_assoc (resource $Result_Set)

The sample code is as follows:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19

$UserName = 'abc'; $Password = '1234'; $DbHandle = mysql_connect ('localhost', $UserName, $Password); if (!$DbHandle) { die 'No database connection could be established.'; } $DBName = 'w3db; if (!mysql_select_db ($DBName, $DbHandle)) { die 'Database could not be selected.'; } $Query = "SELECT ISBN, Title, Author FROM articles"; $articles = mysql_query ($Query, $DbHandle)); while ($Row = mysql_fetch_assoc ($articles)) { echo "ISBN = $Row['ISBN'] n"; echo "Title = $Row['Title'] n"; echo "Author = $Row['Author'] n"; } ?>

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19

n"; echo "Title = $Row['Title'] n"; echo "Author = $Row['Author'] n"; } ?>

I hope this article will be helpful to everyone’s PHP programming design. http://www.bkjia.com/PHPjc/969969.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/969969.htmlTechArticleHow to query mysql database with php and save the results to an array. This article mainly introduces how to query mysql database with php and save it to an array. The method of saving the results to an array, an example analysis of PHP using mysql_fet...