How to use PHP associative array query results_PHP tutorial

You may be interested in The following is the specific operation code:

<ol class="dp-xml"><li class="alt">
<span><strong><font color="#006699"><span class="tag"><?</SPAN><SPAN class=tag-name>php</SPAN></FONT></STRONG><SPAN>   </SPAN></SPAN><LI class=""><SPAN>$</SPAN><SPAN class=attribute><FONT color=#ff0000>connection</FONT></SPAN><SPAN> = </SPAN><SPAN class=attribute-value><FONT color=#0000ff>mysql_connect</FONT></SPAN><SPAN>("localhost", "albert", "shhh");   </SPAN></SPAN><LI class=alt><SPAN>mysql_select_db("winestore", $connection);   </SPAN><LI class=""><SPAN> </SPAN><LI class=alt><SPAN>$</SPAN><SPAN class=attribute><FONT color=#ff0000>result</FONT></SPAN><SPAN> = </SPAN><SPAN class=attribute-value><FONT color=#0000ff>mysql_query</FONT></SPAN><SPAN>("SELECT cust_id, surname,   </SPAN></SPAN><LI class=""><SPAN>firstname FROM customer", $connection);   </SPAN><LI class=alt><SPAN> </SPAN><LI class=""><SPAN>while ($</SPAN><SPAN class=attribute><FONT color=#ff0000>row</FONT></SPAN><SPAN> = </SPAN><SPAN class=attribute-value><FONT color=#0000ff>mysql_fetch_array</FONT></SPAN><SPAN>($result))   </SPAN></SPAN><LI class=alt><SPAN>{   </SPAN><LI class=""><SPAN>echo "ID:t{$row["cust_id"]}n";   </SPAN><LI class=alt><SPAN>echo "Surnamet{$row["surname"]}n";   </SPAN><LI class=""><SPAN>echo "First name:t{$row["firstname"]}nn";   </SPAN><LI class=alt><SPAN>}   </SPAN><LI class=""><SPAN></SPAN><SPAN class=tag><STRONG><FONT color=#006699>?></span></font></strong></span><span>  </span>
</li></ol>

The function mysql_fetch_array() puts a row of the query result into an array, which can be referenced in two ways at the same time. For example, cust_id can be referenced in the following two ways at the same time: $row["cust_id"] or $row[0]. Obviously, the former is much more readable than the latter.

In multi-table query of PHP associative array query results, if two column names are the same, it is best to separate them with aliases:

SELECT winery.name AS wname,
region. name AS rname,
FROM winery, region
WHERE winery.region_id = region.region_id;

The reference of column name is: $row["wname"] and $row[" rname"].

When the table name and column name are specified, only the column name is quoted:

SELECT winery.region_id
FROM winery

The reference of the column name is : $row["region_id"].

The reference of the aggregate function is the reference name:

SELECT count(*)
FROM customer;

The reference of the column name is: $row["count(*) )"].

The above are all the specific steps for PHP associative array query results.

http://www.bkjia.com/PHPjc/446371.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/446371.htmlTechArticleYou may know the following specific operation code: ?php $ connection = mysql_connect ("localhost","albert" ,"shhh"); mysql_select_db("winestore",$connection); $ result = mysql_qu...