PHP Call with Ajax

Question

我必须调用这个php文件

<?php
session_start();
require 'connect.php';
//Prendo le tre variabili dalla form
if(isset($_POST['Titolo'])) {
$title_rew = $conn->real_escape_string($_POST['Titolo']);
}
if(isset($_POST['Voto'])) {
$voto_rew = $conn->real_escape_string($_POST['Voto']);
}
if(isset($_POST['Review'])) {
$review_rew = $conn->real_escape_string($_POST['Review']);
}
if(isset($_POST['ID_locale'])) {
$id_rew = $conn->real_escape_string($_POST['ID_locale']);
}
$current_date = date('Y-m-d');
$sql = "INSERT INTO recensione (Titolo_R, Voto_R, Commento_R, IDnegozio_R, Email_R, Utente_R, Data_R) 
VALUES ('$title_rew', '$voto_rew', '$review_rew','$id_rew','".$_SESSION['emailSessione']."','".$_SESSION['usernameSessione']."','$current_date')";
$result = mysqli_query($conn,$sql) or die(mysqli_error($conn));
//Chiudo la connessione
$conn->close(); 
header("location:..locals_page.php");
?>

我试过这个

$("#submit_review").unbind().click(function() {
var chx = document.getElementsByName("Voto");
for (var i=0; i<chx.length; i++) {
// If you have more than one radio group, also check the name     attribute
// for the one you want as in && chx[i].name == 'choose'
// Return true from the function on first match of a checked item
$.post("php/insert_comment.php" );
return true;
}
// End of the loop, return false
alert("Seleziona almeno il voto!");
return false;
});

但是那里不起作用。这很奇怪，因为有一个按钮提交和一个

<form role="form" id="review-form" method="post" action="php/insert_comment.php">

它正在工作。 但是现在我必须在没有按钮类型"提交"的情况下执行此操作

提前感谢大家

Answer 1

试试这个

$.ajax({
url : "php/insert_comment.php",
type : "post",
data : $("#review-form").serialize();
success : function(data){
alert(data); // show when ajax return response from php script
}
})

Answer 2

用于该按钮上注册的 onClick 事件，并使用 jquery 发送 ajax 请求

$.ajax({
type:'POST',
url : "your url",
data : $('form').serializeArray(),
cache: false,
success:function(response){
console.log(response) // your result from php
}
})

Answer 3

单引号将 $ 视为字符串

$sql = "INSERT INTO recensione (Titolo_R, Voto_R, Commento_R, IDnegozio_R, Email_R, Utente_R, Data_R) 
VALUES ('".$title_rew."', '".$voto_rew."', '".$review_rew."','".$id_rew."','".$_SESSION['emailSessione']."','".$_SESSION['usernameSessione']."','$current_date')";