<?php
$conn = mysql_connect("127.0.0.1","root",""); //連接mysql數據庫
mysql_select_db("temp"); //選擇數據庫
$exec="select * from wind"; //選擇數據表
$result = mysql_query($exec); //執行記錄
while ($rs=mysql_fetch_object($result))
{
echo "姓名:".$rs->name."<br>";//等于rs.name
echo "電話:".$rs->tel."<br>";
echo "地址:".$rs->addr."<br><br>";
}
?>
<form method="post" action="day22.php">
用戶名:<input type='text' name='name'><br>
電 話:<input type='text' name='tel'><br>
地 址:<input type='text' name='addr'><br>
<input type='submit' value='提交'><br><br>
</form>
========處理頁
<?php
$conn = mysql_connect("127.0.0.1","root",""); //連接mysql數據庫
mysql_select_db("temp"); //選擇數據庫
$sql = "insert into wind(name,tel,addr)values('".$_post['name']."','".$_post['tel']."','".$_post['addr']."')";
//刪除,修改只需改$sql語句即可
//刪除 $sql ="delete from wind where......"
//修改 $sql = "update wind set item1='".$_post['item1']."' where ...";
$rs1 = mysql_query($sql);
echo "數據插入成功!";
echo"<script>location.href('day2.php');</script>";
?>
新聞熱點
疑難解答