我想在同一個頁面上
做新增資料和查詢資料的動作
這個網頁是接收第一個頁面所傳來的資料
insert到資料庫，然後，我在從資料庫裡面
select出來。 這就是我的目的了!!
<程式碼>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=big5">
<title>無標題文件</title>
</head>
<body>
<?php
$id = $_POST["id"];
$pw = $_POST["pw"];
$name = $_POST["name"];
$ad = $_POST["ad"];
$phone = $_POST["phone"];
$link = mysql_connect("localhost","root","");
$db_selected = mysql_select_db("buysomething",$link);
$sql = "insert into customer (id,pw,name,ad,phone) values ('$id','$pw','$name','$ad','$phone')";
mysql_query("SET NAMES 'big5'");
$result = mysql_query($sql,$link);
if(!$result)
{
die(mysql_error());
}
mysql_close($link);
echo "<script>";
echo "alert('成功寫入資料庫!!');";
echo "</script>";
$link = mysql_connect("localhost","root","");
$db_selected = mysql_select_db("buysomething",$link);
$sql1 = "select * from customer "
mysql_query("SET NAMES 'big5'");
$result1 = mysql_query($sql1,$link);
$userid = mysql_result($result1,0,"id");
$password = mysql_result($result1,0,"pw");
$username = mysql_result($result1,0,"name");
$address = mysql_result($result1,0,"ad");
$userphone = mysql_result($result1,0,"phone");
echo "以下資料已寫入資料庫!!".'<br>';
echo "帳號:$userid".'<br>';
echo "密碼:$password".'<br>';
echo "姓名:$username".'<br>';
echo "地址:$address".'<br>';
echo "電話:$userphone".'<br>';
mysql_close($link);
?>
</body>
</html>
錯誤訊息為:
Parse error: syntax error, unexpected T_STRING in
C:\AppServ\www\ben\insertdata1.php on line 34
請大家告訴我!! 要怎樣修正呢?
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 59.115.215.222
推
07/21 11:52, , 1F
07/21 11:52, 1F
推
07/21 13:06, , 2F
07/21 13:06, 2F
推
07/21 13:14, , 3F
07/21 13:14, 3F
PHP 近期熱門文章
PTT數位生活區 即時熱門文章
