作者caty1010 (MR.Q)
看板PHP
标题连结资料库的问题
时间Sat Jul 21 11:09:36 2007
我想在同一个页面上
做新增资料和查询资料的动作
这个网页是接收第一个页面所传来的资料
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
1F：推 cpper:你先自己设中断点执行看看,一段一段执行,才能抓到错误的行 07/21 11:52
2F：推 tonytsai88:$sql1 = "select * from customer " 这行後面少了; 07/21 13:06
3F：推 caty1010:真的~~谢谢你!!改过之後，可以跑了.. 07/21 13:14