I am making an ajax call to a .php page where I am making a query to the database. However, when I echo a value from the .php page, the entire html file is returned rather than just the numerical value I need.
This is my ajax script:
<script type="text/javascript">
$(document).ready(function()
{
$("#valuebutton").click(function()
{
var id1=$('.player1').val();
$.ajax
({
type: "POST",
url: "updatevaluebox.php",
data: ({g1: id1}),
cache: false,
success: function(value)
{
//alert(value);
$('#valuebox').val(value);
}
});
});
});
</script>
And this is the php page updatevaluebox.php:
<?php
require("connect_db.php");
$q="SELECT price FROM playerlist where id=".$_POST['g1'];
$r=mysqli_query($dbc,$q);
$price=mysqli_fetch_array($r,MYSQLI_NUM);
mysqli_close($dbc);
echo $price[0];
?>
Both files are in the same directory.
I have checked other answers to this question on stackoverflow but none seem to work.
The output I am getting from the alert statement looks like:
<html>
<head><title>
</title></head>
<body>
</body>
</html>5.5
The 5.5 at the end is the only value I need!
I have set the ajax dataType to text but even that doesn't help.
See Question&Answers more detail:os
