查看完整版本: 将数据库的内容读到二维数组并按指定列输出

将数据库的内容读到二维数组并按指定列输出

             <p><P><STRONG>将<a href="http://www.phpchina.com/javascript:;" onClick="javascript:tagshow(event, '%CA%FD%BE%DD%BF%E2');" target="_self"><u><strong>数据库</strong></u></a>的内容读到二维数组并按指定列输出</STRONG> </P><P>＜? <BR>$host = "localhost";&nbsp;&nbsp;&nbsp;//主机名 <BR>$user = "root";&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//mysql用户名 <BR>$password = "";&nbsp;&nbsp;&nbsp;&nbsp;//mysql密码 <BR>$database = "doc";&nbsp;&nbsp;//mysql数据库名 <BR>$tables = "mclass";&nbsp;&nbsp;//表名 <BR><BR>$conn=mysql_connect("$host","$user","$password") or die("数据库打开出错"); <BR>mysql_select_db("$database"); <BR><BR>&nbsp;&nbsp;&nbsp;$query="select * from $tables"; <BR>&nbsp;&nbsp;&nbsp;&nbsp;$result=mysql_query($query,$conn); <BR>&nbsp;&nbsp;&nbsp;&nbsp;$i=0; <BR>&nbsp;&nbsp;&nbsp;&nbsp;$j=0; <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;while($row=mysql_fetch_row($result)){ <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$array[$i][$j] = $row[0].$row[1]; <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$array2[$i][$j] = $row[0]; <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$j++; // echo $i.",".$j.$row[1]."＜br＞"; <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if($j==3) { <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$i++; <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$j=0; <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;} //else {$j++ ;} <BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;} <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$amax=count($array);//获是数组内数据个数。 <BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;$rows=2;&nbsp;&nbsp;//设置列数 <BR><BR>&nbsp;&nbsp;&nbsp;//开始显示数据 <BR>&nbsp;&nbsp;for ($x=0; $x＜=$amax-1; $x++) { <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;for ($y=0; $y＜= $rows; $y++) { <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;echo "＜a href="http://www.phpchina.com/.$array2[$x][$y]."＞".$array[$x][$y]."＜/a＞|" ; <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;} <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;echo "＜p＞"; <BR>&nbsp;&nbsp;&nbsp;&nbsp;} <BR><BR>/* <BR>显示结果为 <BR>aaa|bbb|ccc <BR>ddd|eee|fff <BR>lll|mmm|nnn <BR>..... <BR>*/ <BR><BR>?＞&nbsp;&nbsp;<BR></P></p>     <center><input type="image" onclick=copyToClipBoard() src="http://www.phpchina.com/images/phpcn_book_bu_tj.gif" border="0"></center>