(1)
<?
//连接到本地mysql数据库
$myconn=mysql_connect("localhost","root","root");
//选择test为操作库
mysql_query("set names 'gbk'"); // //这就是指定数据库字符集,一般放在连接数据库后面就系了
mysql_select_db("test",$myconn);
$strSql="select * from user";
//用mysql_query函数从user表里读取数据
$result=mysql_query($strSql,$myconn);
while($row=mysql_fetch_array($result))//通过循环读取数据内容
{
?>
(2)
2.获取表数据02
mysql_connect("localhost","dev","mysql");
mysql_select_db("dev");
$result=mysql_query("select id,name from tb_test");
while($row=mysql_fetch_object($result)){
echo "ID:" .$row->id." text: ".$row->name."
\n";
}
<?
//连接到本地mysql数据库
$myconn=mysql_connect("localhost","root","root");
//选择test为操作库
mysql_query("set names 'gbk'"); // //这就是指定数据库字符集,一般放在连接数据库后面就系了
mysql_select_db("test",$myconn);
$strSql="select * from user";
//用mysql_query函数从user表里读取数据
$result=mysql_query($strSql,$myconn);
while($row=mysql_fetch_array($result))//通过循环读取数据内容
{
?>
(2)
2.获取表数据02
mysql_connect("localhost","dev","mysql");
mysql_select_db("dev");
$result=mysql_query("select id,name from tb_test");
while($row=mysql_fetch_object($result)){
echo "ID:" .$row->id." text: ".$row->name."
\n";
}
?>
(三)
mysql_connect("localhost","dev","mysql");
mysql_select_db("dev");
$result=mysql_query("select id,name from tb_test");
print "";
print "";
print "";
while ($row = mysql_fetch_array($result))
{
print "";
print "";
print "";
}
print "
{$row["id"]} {$row["name"]}
";
?>
<?
}
//关闭对数据库的连接
mysql_close($myconn);
?>