[SQL] 網頁表單 傳遞至 SQL 檢錯??
資料庫名稱：SQL
資料庫版本：
內容/問題描述：可以幫我看看哪裡有錯誤嗎 ?
表單完成後 資料一直傳送不進去資料庫 但是網頁會跳轉到我預設的位置
<?php
$Text1= $_REQUEST["Text1"];
$userid= $_REQUEST["userid"];
$Text5=$_REQUEST["Text5"];
$email= $_REQUEST["email"];
//接收html表單傳來的資訊
$Text1= $_REQUEST["Text1"];
$userid= $_REQUEST["userid"];
$Text5=$_REQUEST["Text5"];
$email= $_REQUEST["email"];
//下面這一格是多行文字的接收
$Text112=nl2br($_REQUEST["Text112"]);
//連結MySQL Server
$conn = mysql_connect("XXXXX.000webhost.com", "XXXXXXXXXX",
"XXXXXXXXXX");
//選擇資料庫
mysql_select_db("XXXXXXXXX", $conn);
//指定提取資料的校對字元表
mysql_query("set character set UTF-8");
//將單引號置換為雙引號
Function chgStr($data)
{
$chgStr = "'" . str_replace("'", "''", $data) . "'";
return $chgStr;
}
//將資料寫入資料庫
$sql="Insert Into PersonalDetails (姓名,電話,手機,電子信箱,自我介紹,日期)
Values
('$Text1','$userid','$Text5','$email','$Text12','$date')";
$sql = $sql . chgStr($Text1) . ",";
$sql = $sql . chgStr($userid) . ",";
$sql = $sql . chgStr($Text5) . ",";
$sql = $sql . chgStr($email) . ",";
$sql = $sql . chgStr($Text112) . ",";
$sql = $sql . date("Y-m-j H:i:s") . "')";
mysql_query($sql);
//將網頁轉向至首頁
header("Location: index.html");
?>
--
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 114.34.178.163
※ 文章網址: http://www.ptt.cc/bbs/Database/M.1414134631.A.03F.html
推
10/24 16:52, , 1F
10/24 16:52, 1F
→
10/24 16:52, , 2F
10/24 16:52, 2F
推
10/25 05:52, , 3F
10/25 05:52, 3F
→
10/25 05:53, , 4F
10/25 05:53, 4F
→
10/25 05:56, , 5F
10/25 05:56, 5F
→
10/25 05:58, , 6F
10/25 05:58, 6F
→
10/25 06:00, , 7F
10/25 06:00, 7F
→
10/25 06:01, , 8F
10/25 06:01, 8F
→
10/25 06:08, , 9F
10/25 06:08, 9F
→
10/25 06:10, , 10F
10/25 06:10, 10F
→
10/27 08:41, , 11F
10/27 08:41, 11F