php数据库插入数据问题,死活插不进去,求大神指导
本帖最后由 hipyaohop 于 2013-06-28 10:12:39 编辑
jquery代码:
$(".detailtextable").click(function () {
$s_keshi=$(".cla_title").attr("alt");
$s_month=$(".nyr_center").attr("alt");
$s_day=$(this).attr("alt");
$.ajax({
type: "POST",
url: "http://localhost/hos1/orderinsert.php",
data: {skeshi:$s_keshi,smonth:$s_month,sday:$s_day},
success: function(){
alert(1);
}
});
});
$s_day,$s_keshi..里面都有数据,alert过了.
orderinsert.php代码:
session_start();
$con = mysql_connect("localhost","root","mysql");
if(!$con)
{
die("Could not connect: " . mysql_error());
}
$pkeshi=$_POST['skeshi'];
$pmonth=$_POST['smonth'];
$pday=$_POST['sday'];
mysql_select_db("hos_db",$con);
$sql="INSERT INTO orderlist (keshi,month,day)
VALUES($pkeshi,$pmonth,$pday)";
mysql_query("set names 'utf8'");
if(!mysql_query($sql,$con))
{
die("Error: " . mysql_error());
}
mysql_close($con);
?>
Statement:The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn