(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_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); ?>
转载请注明原文地址: https://ju.6miu.com/read-1300285.html