<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php
$conn=mysql_connect("localhost","root","");
mysql_select_db("school",$conn);//选择数据库
if($conn){
echo "connect success<br>";
mysql_query("SET NAMES 'GBK'");
$num_rows=mysql_num_rows($result);
echo $num_rows;
echo "<table border=1><tr><td>用户名</td></tr>";
while($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$users=$row["name"];
echo "<tr><td>".$users."</td></tr>";
}
echo "</table>"; */
$sql = "insert into student(name,age) values('aa',11)";
mysql_query("SET NAMES 'GBK'");//处理乱码
mysql_query($sql,$conn);
echo "insert num : ";
$recode="select name,age from student";
$result=mysql_query($recode,$conn);
$num_rows = mysql_num_rows($result);//获取记录数
echo $num_rows;
echo "<table border=1><tr><td>user name</td><td> age </td></tr>";
while($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$users=$row["name"];
$age=$row["age"];
echo "<tr><td>".$users."</td><td>".$age."</td></tr>";
}
echo "</table>";
}else{
echo "connect fails";
}
?>
问题: 这个程序每刷新一次数据库就自动添加一行记录,怎么修改,可以组织它呢?分数不多,谢谢大牛们了!!
mysql_query("SET NAMES 'GBK'");//处理乱码
mysql_query($sql,$conn);
把这个删了
//参考if($_SERVER['REQUEST_METHOD'] == 'POST')
{
//TODO post提交的时候,插入数据
}
else
{
//TODO get方式的时候,查询数据
}