我写的代码如下:<?php $conn=mysql_connect("localhost","root","123456");mysql_select_db("test",$conn);mysql_query("setnamesutf8");$query="select*fromtable";$result=mysql_qu...
我写的代码如下:
$conn=mysql_connect("localhost","root","123456");
mysql_select_db("test",$conn);
mysql_query("set names utf8");
$query="select * from table";
$result=mysql_query($query,$conn);
$i=1;
while($row=mysql_fetch_array($result)){
if($i%2!=0) //一行两栏
{
?>
<?php echo "姓名:$row[1]\n \n \n \n \n \n \n \n \n \n \n \n 性别:$row[2]年龄:$row[3]\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n 籍贯:$row[4]";?>
}
else
{
?>
<?php echo "姓名:$row[1]\n \n \n \n \n \n \n \n \n \n \n \n 性别:$row[2]年龄:$row[3]\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n 籍贯:$row[4]";?>
}
$i=$i++;
}
?>
姓名:aaa 性别:男 姓名:bbb 性别:男
年龄:20 籍贯:usa 年龄:21 籍贯:chn
姓名:ccc 性别:男 姓名:ddd 性别:男
年龄:30 籍贯:jap 年龄:55 籍贯:usa
展开