javascript - 将javascript中的数据源发送到mySQL数据库

Question

我在脚本中编写了此代码以将数据源事件保存在数据库中，但没有任何反应，数据库中没有保存任何值:

$.ajax({
    url:"insert.php",
    type:"POST",
    data:{id:event.id, name:event.name, startDate:event.startDate, endDate:event.endDate},
    success:function(){
        alert("Added Successfully");
    }
})  

文件insert.php:

<?php

$connect = new PDO('mysql:host=localhost;dbname=recuperation', 'root', '');
$query = "INSERT INTO events (id, name, startDate, endDate) VALUES (:id, :name, :startDate, :endDate)";
$statement = $connect->prepare($query);
$statement->execute( array(':id'  => $_POST['event.id'], ':name'  => $_POST['event.name'], ':startDate' => $_POST['event.startDate'],':endDate' => $_POST['event.endDate']));

?>

Answer 1

您需要在命名 json 对象时获取发布的值:

{
    id: event.id,
    name: event.name,
    startDate: event.startDate,
    endDate: event.endDate
}

因此，您的帖子值将位于这些键中:id、name 等。将 $_POST['event.name'] 更改为 $_POST['name']。试试这个:

$statement->execute( array(':id'  => $_POST['id'], ':name'  => $_POST['name'], ':startDate' => $_POST['startDate'],':endDate' => $_POST['endDate']));