Forpersonaluseonlyinstudyandresearch;,使用关联数组(associatively-indexedarrays)十分有帮助,下面我们看一个基本的数字格式的数组遍历:<?php$temp[0]="richmond";$temp[1]="tigers";$temp[2]="premiers";for($x=0;$x<count($temp);$x++){echo$temp[$x];echo"";}?>复制代码然而另外一种更加节省代码的方式是:<?php$temp=array("richmond","tigers","premiers");foreach($tempas$element)echo"$element";?>复制代码foreach还能输出文字下标:<?php$temp=array("club"=>"richmond","nickname"=>"tigers","aim"=>"premiers");foreach($tempas$key=>$value)echo"$key:$value";?>复制代码PHP手册中描述了大约50个用于处理数组的函数。:<?php$temp="hello"echo"$tempworld";?>复制代码但是需要说明的是,尽管下面的例子没有错误:<?php$temp=array("one"=>1,"two"=>2);//输出::Thefirstelementis1echo"Thefirstelementis$temp[one].";?>复制代码但是如果后面那个echo语句没有双引号引起来的话,就要报错,因此建议使用花括号:<?php$temp=array("one"=>1,"two"=>2);echo"Thefirstelementis{$temp["one"]}.";?>:<?php$connection=mysql_connect("localhost","albert","shhh");mysql_select_db("winestore",$connection);$result=mysql_query("SELECTcust_id,surname,firstnameFROMcustomer",$connection);while($row=mysql_fetch_array($result)){echo"ID:\t{$row["cust_id"]}\n";echo"Surname\t{$row["surname"]}\n";echo"Firstname:\t{$row["firstname"]}\n\n";}?>复制代码函数mysql_fetch_array()把查询结果的一行放入数组,可以同时用两种方式引用,例如cust_id可以同时用下面两种方式:$row["cust_id"]或者$row[0]。显然,前者的可读性要比后者好多了。在多表连查中,如果两个列名字一样,最好用别名分开:,,FROMwinery,
PHP和MySQL开发的8个技巧 来自淘豆网www.taodocs.com转载请标明出处.