PHP INSERT INTO插入不了資料問題
提交表單用INSERT INTO插入資料,但總是空白,沒提示出錯。請問那裡有問題了?
@header("content-Type: text/html; charset=utf-8");
require_once 'inc/site_config.php';
require_once 'inc/db_connections.php';
require_once 'inc/function.php';
mysql_query('set character set "utf8"');
session_start();
if($_REQUEST['action']=='postreg'){
$sql_check_usr="select * from `reguser` where `UserId`='".$_SESSION['uid']."'";
$info=mysql_query($sql_check_usr);
$dingdanhao=date("YmjHis").$info[UserId];
$spc=$_SESSION[producelist];
$slc= $_SESSION[quatity];
$shouhuoren=$_POST['trusername'];
$dizhi=$_POST['address'];
$youbian=$_POST['phone'];
$tel=$_POST['mob'];
$email=$_POST['email'];
if(trim($_POST['d_content'])==""){
$leaveword="";
}
else{
$leaveword=$_POST['d_content'];
}
$xiadanren=$_SESSION['uid'];
$time=date("Y-m-j H:i:s");
$total=$_SESSION[total];
$sql_add_usr="INSERT INTO onlineorder (dingdanhao,spc,slc,UserName,address,phone,mobile,mail,yqinfo,OrderTime,UserId,total_price) VALUES ('$dingdanhao','$spc','$slc','$trusername','$address','$phone','$mob','$email','$d_content','$time','$xiadanren','$total')";
mysql_query($sql_add_usr);
}
php insert
------解決方案--------------------
把SQL語句列印出來,然後到PHPMYADMIN等工具中運行SQL語句看看結果如何。
這個是常用的檢查SQL正確性方法。
------解決方案--------------------
$info=mysql_query($sql_check_usr);
$dingdanhao=date("YmjHis").$info[UserId];
$info 是個結果資源集,$info[UserId] 這樣用不對
mysql_query($sql_add_usr) or die(mysql_error()); //這樣看看是否報錯