php数据库插入数据问题,死活插不进去,求大神指导
程序员文章站
2024-02-08 19:33:10
...
本帖最后由 hipyaohop 于 2013-06-28 10:12:39 编辑
$(".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);
?>
PHP 数据库 MySQL jquery
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);
?>
回复讨论(解决方案)
$sql="INSERT INTO orderlist (keshi,month,day) VALUES('$pkeshi','$pmonth','$pday')";
非常感谢,谢谢
上一篇: php合并二维数组相同的key
下一篇: php xdebug的配置有关问题