求高手帮我看看PHP添加 本帖最后由 nihao_110 于 2010-07-28 21:04:28 编辑 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 <?php$db_host="127.0.0.1:3306";$db_user="root";$db_psw="";$db_name="mysql";$connection=mysql_connect($db_host,$db_user,$db_psw)or die("连接服务器失败");mysql_select_db($db_name,$connection)or die("选择数据库失败");$sql = "insert into `hotel_activities_2`('hotel_id','start_date','end_date','content','source','s_type') values (`hot`='{$_POST[hot]}',`start`='{$_POST[start]}',`end`='{$_POST[end]}',`ctn`='{$_POST[ctn]}', `sre`='{$_POST[sre]}',`s_tp`='{$_POST[s_tp]}')"; if(mysql_query($query)){ echo "保存数据成功";}else{ //这里改一下,看看执行查询时是什么错误 $message = 'Invalid query: ' . mysql_error() . "\n"; $message .= 'Whole query: ' . $sql; die($message);}mysql_close($connection);?> 这个错误是什么Invalid query: Query was empty Whole query: insert into `hotel_activities_2`('hotel_id','start_date','end_date','content','source','s_type') values (`hot`='3',`start`='3',`end`='3',`ctn`='33', `sre`='33',`s_tp`='3') insert into (字段) values (对应值)不是 values (字段=值) SQL语句不对<?php$db_host="127.0.0.1:3306";$db_user="root";$db_psw="";$db_name="mysql";$connection=mysql_connect($db_host,$db_user,$db_psw)or die("连接服务器失败");mysql_select_db($db_name,$connection)or die("选择数据库失败");//原先的SQL语句不对$sql = "insert into `hotel_activities_2`('hotel_id','start_date','end_date','content','source','s_type') values ('{$_POST[hot]}','{$_POST[start]}','{$_POST[end]}','{$_POST[ctn]}', '{$_POST[sre]}','{$_POST[s_tp]}')"; if(mysql_query($query)){ echo "保存数据成功";}else{ //这里改一下,看看执行查询时是什么错误 $message = 'Invalid query: ' . mysql_error() . "\n"; $message .= 'Whole query: ' . $sql; die($message);}mysql_close($connection);?> <?php$db_host="127.0.0.1:3306";$db_user="root";$db_psw="";$db_name="mysql";$connection=mysql_connect($db_host,$db_user,$db_psw)or die("连接服务器失败");mysql_select_db($db_name,$connection)or die("选择数据库失败");$hot=$_POST["hot"];$start=$_POST["start"];$end=$_POST["end"];$ctn=$_POST["ctn"];$sre=$_POST["sre"];$s_tp=$_POST["s_tp"];$sql = "insert into `hotel_activities_2`('hotel_id','start_date','end_date','content','source','s_type') values ($hot,$start,$end,$ctn, $sre,$s_tp])"; if(mysql_query($query)){echo "保存数据成功";}else{ $message = 'Invalid query: ' . mysql_error() . "\n"; $message .= 'Whole query: ' . $sql; die($message);}mysql_close($connection);?>我改成这样还是不行 $sql = "insert into `hotel_activities_2`('hotel_id','start_date','end_date','content','source','s_type') values ($hot,$start,$end,$ctn, $sre,$s_tp])"; //????还有,你 hotel_id 不是自增吧?我改成这个,你看看。$sql = "insert into `hotel_activities_2`('hotel_id','start_date','end_date','content','source','s_type') values ('$hot','$start','$end','$ctn', '$sre','$s_tp')"; 你现在MySQL中把你要执行的SQL语句执行一下,调试正确后再移到php代码中 你打印sql出来,在 phpmyadmin里跑一下看看报啥错。 extjs的grid加载不到store的内容 thinkphp PHP中用ODBC连接映射的局域网Access数据库失败 用iframe做无刷新上传,如何取得上传文件的大小 用PHP开发的WAP网站 跳转问题 求助,公司产品有sn码,想在网站给对应的sn码相应积分 DZ 7.0 论坛中 这些都有什么含义???? php聊天室 xajax 如何跨域请救数据 晕啦,怎么都不对,用过smarty的朋友帮忙看看 MYSQL同一数据库的两个表如何相互访问? 诡异诡异诡异诡异诡异诡异!很诡异的问题!需要高手回答下!!!!!! 注册表单怎么才能支持繁体字?
$db_host="127.0.0.1:3306";
$db_user="root";
$db_psw="";
$db_name="mysql";
$connection=mysql_connect($db_host,$db_user,$db_psw)or die("连接服务器失败");
mysql_select_db($db_name,$connection)or die("选择数据库失败");$sql = "insert into `hotel_activities_2`('hotel_id','start_date','end_date','content','source','s_type') values
(`hot`='{$_POST[hot]}',`start`='{$_POST[start]}',`end`='{$_POST[end]}',`ctn`='{$_POST[ctn]}', `sre`='{$_POST[sre]}',`s_tp`='{$_POST[s_tp]}')"; if(mysql_query($query)){
echo "保存数据成功";
}else{
//这里改一下,看看执行查询时是什么错误
$message = 'Invalid query: ' . mysql_error() . "\n";
$message .= 'Whole query: ' . $sql;
die($message);
}
mysql_close($connection);
?>
Invalid query: Query was empty Whole query: insert into `hotel_activities_2`('hotel_id','start_date','end_date','content','source','s_type') values (`hot`='3',`start`='3',`end`='3',`ctn`='33', `sre`='33',`s_tp`='3')
<?php
$db_host="127.0.0.1:3306";
$db_user="root";
$db_psw="";
$db_name="mysql";
$connection=mysql_connect($db_host,$db_user,$db_psw)or die("连接服务器失败");
mysql_select_db($db_name,$connection)or die("选择数据库失败");//原先的SQL语句不对
$sql = "insert into `hotel_activities_2`('hotel_id','start_date','end_date','content','source','s_type') values ('{$_POST[hot]}','{$_POST[start]}','{$_POST[end]}','{$_POST[ctn]}', '{$_POST[sre]}','{$_POST[s_tp]}')"; if(mysql_query($query)){
echo "保存数据成功";
}else{
//这里改一下,看看执行查询时是什么错误
$message = 'Invalid query: ' . mysql_error() . "\n";
$message .= 'Whole query: ' . $sql;
die($message);
}
mysql_close($connection);
?>
$db_host="127.0.0.1:3306";
$db_user="root";
$db_psw="";
$db_name="mysql";
$connection=mysql_connect($db_host,$db_user,$db_psw)or die("连接服务器失败");
mysql_select_db($db_name,$connection)or die("选择数据库失败");
$hot=$_POST["hot"];
$start=$_POST["start"];
$end=$_POST["end"];
$ctn=$_POST["ctn"];
$sre=$_POST["sre"];
$s_tp=$_POST["s_tp"];$sql = "insert into `hotel_activities_2`('hotel_id','start_date','end_date','content','source','s_type') values
($hot,$start,$end,$ctn, $sre,$s_tp])"; if(mysql_query($query)){
echo "保存数据成功";
}else{
$message = 'Invalid query: ' . mysql_error() . "\n";
$message .= 'Whole query: ' . $sql;
die($message);
}
mysql_close($connection);
?>我改成这样还是不行
($hot,$start,$end,$ctn, $sre,$s_tp])"; //????还有,你 hotel_id 不是自增吧?
我改成这个,你看看。
$sql = "insert into `hotel_activities_2`('hotel_id','start_date','end_date','content','source','s_type') values
('$hot','$start','$end','$ctn', '$sre','$s_tp')";