PHP query MySQL database and save the results to an array method _php tips

This article describes the PHP query MySQL database and save the results to the array method. Share to everyone for your reference. The specific analysis is as follows:

The MYSQL_FETCH_ASSOC function is mainly used here.

The MYSQL_FETCH_ASSOC syntax is as follows:

Array Mysql_fetch_assoc (Resource $Result _set)

The example code is as follows:

<?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";
}
? >

I hope this article will help you with your PHP program design.