Ajax调用JS+PHP不起作用 - Ajax call JS + PHP not working

Ajax call JS + PHP not working

本文关键字：不起作用 JS+PHP 调用 Ajax | 更新日期: 2023-09-27

Chrome控制台错误：POST http://********************500（内部服务器错误）

JS-

$.ajax({
                    method: "POST",
                    url:"ajax.php",
                    data: {
                        x: x,
                        y: y
                    },
                    success:function(data){...}
                 });

PHP

<?php
date_default_timezone_set('Europe/Madrid');
$link = mysql_connect("*******", "*******", "******");
mysql_select_db("******") or die ("no database");

$name = $_POST['x'];
$score = $_POST['y'];
// Get the current date
$current_date = date('d-m-Y H:i:s');
$sqlCommand = "INSERT INTO hungry_bird (date_played, name, score)
               VALUES('$current_date ', '$name', '$score')";
$results = mysql_query($sqlCommand) or die (mysql_error());
mysql_close($link);

?>

你知道问题出在哪里吗？谢谢

$link = mysqli_connect("*******", "*******", "******");
mysqli_select_db($link, "******") or die ("no database");
$name = $_POST['x'];
$score = $_POST['y'];
$sqlCommand = "INSERT INTO hungry_bird (date_played, name, score)
               VALUES('CURDATE()', '$name', '$score')";
$results = mysqli_query($link, $sqlCommand) or die (mysqli_error($link));
mysqli_close($link);