将那个row以表格形式输出,不会。。
<?php
$conn = mysql_connect("localhost","root","123456") or die(mysql_error()."数据服务器连接失败!");
mysql_select_db("course");
$sql = "select * from course_table";
mysql_query("set names 'gb2312'");
$result = mysql_query($sql,$conn);
mysql_close($conn); while(null!=($row = mysql_fetch_row($result))){
foreach ($row as $val){
print "|". $val. "|"; }
print "<br />";
}
mysql_free_result($result);
?>
<?php
$conn = mysql_connect("localhost","root","123456") or die(mysql_error()."数据服务器连接失败!");
mysql_select_db("course");
$sql = "select * from course_table";
mysql_query("set names 'gb2312'");
$result = mysql_query($sql,$conn);
mysql_close($conn); while(null!=($row = mysql_fetch_row($result))){
foreach ($row as $val){
print "|". $val. "|"; }
print "<br />";
}
mysql_free_result($result);
?>
<?php
$conn = mysql_connect("localhost","root","123456") or die(mysql_error()."数据服务器连接失败!");
mysql_select_db("course");
$sql = "select * from course_table";
mysql_query("set names 'gb2312'");
$result = mysql_query($sql,$conn);
echo "<table>";
mysql_close($conn); while($row = mysql_fetch_row($result)){
echo "<tr>";
foreach ($row as $val){
echo "<td>{$val}</td>";
}
echo "</tr>"
}
echo "</table>";
mysql_free_result($result);
?>
[/code]
$conn = mysql_connect("localhost","root","123456") or die(mysql_error()."数据服务器连接失败!");
mysql_select_db("course");
$sql = "select * from course_table";
mysql_query("set names 'gb2312'");
$result = mysql_query($sql,$conn);
mysql_close($conn);
echo "<tabel>";
while($row = mysql_fetch_row($result)){
echo "<tr>";
foreach ($row as $val){
echo "<td>{$val}</td>";
}
echo "</tr>";
}
echo "</table>";
mysql_free_result($result);
?>