数据库

    xiaoxiao2025-06-24  5

    (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
    最新回复(0)