How do i pass a variable from Jquery to PHP?
var itemId = $(this).attr('name');
$.ajax({
url: "loaditems.php",
method: "GET",
success: function(result){
alert(result);
}});
I want to add a number in PHP at the end of my SQL request.
$sql = "SELECT * FROM SmiteItems WHERE ID = ";
I know there are many questions like this, but other questions are made by people who have more complicated structures which i don't understand.
Use the POST method, then try using PHP PDO for making sql queries http://php.net/manual/en/pdo.query.php
var itemId = $(this).attr('name');
$.ajax({
url: "loaditems.php",
method: "POST", //change
data: { myVar: itemId }
success: function(result) {
alert(result);
}
});
Then in your PHP code
//Get post value from AJAX
$itemId = $_POST['myVar'];
\\PDO Example
$sql = "SELECT * FROM SmiteItems WHERE ID = ?";
$result = $pdo->prepare($sql);
$result->bindparam(1, $itemId);
$result->execute();
add data in ajax call and use that data in target url:
var itemId = $(this).attr('name');
$.ajax({
url: "loaditems.php",
method: "GET",
data: {number:itemId},
success: function(result){
alert(result);
}
});
and then in loaditems.php
$sql = "SELECT * FROM SmiteItems WHERE ID = " . $_GET['number'];
As this is not a database and security question, I write no more about SQL INJECTION. Please use "post" method and read more about injection.
+ to . For difference between get and post security, please check this: security.stackexchange.com/questions/33837/… @MehdiBounya