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

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

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:

array mysql_fetch_assoc (resource $Result_Set)

The sample code is as follows:

<&#63;php
$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']<br />\n";
 echo "Title = $Row['Title']<br />\n";
 echo "Author = $Row['Author']<br />\n";
}
&#63;>

I hope this article will be helpful to everyone’s PHP programming design.

http://www.bkjia.com/PHPjc/969477.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/969477.htmlTechArticleHow to query mysql database in php and save the results to an array, mysql array. This article describes the example of php querying mysql database and Method to save results to an array. Share it with everyone for your reference...