jquery ajax连接mysql,获得使用PHP和jQuery的AJAX从MySQL数据库中的数据

I want to get data from mysql database using php and jquery ajax. 'process.php' is the php file which connects to database and get mysql data. It works when it is run separately, but when called using ajax it doesn't work. Can someone please help to correct error? Here is my html file:

$(document).ready(function(){

function showRoom(){

$.ajax({

type:"POST",

url:"process.php",

data:{action:showroom},

success:function(data){

$("#content").html(data);

}

});

}

showRoom();

});

Here is my process.php file

$link=mysqli_connect("localhost","root","raspberry","homebot");

if (mysqli_connect_errno())

echo "Failed to connect to MySQL: " . mysqli_connect_error();

$action=$_POST["action"];

if($action=="showroom"){

$query="SELECT * FROM user";

$show=mysqli_query($link,$query) or die ("Error");

while($row=mysqli_fetch_array($show)){

echo "

$row['name']";

}

}

?>

解决方案

There are two syntax errors in your ajax call:

$(document).ready(function(){

function showRoom(){

$.ajax({

type:"POST",

url:"process.php",

data:{action:"showroom"},

success:function(data){

$("#content").html(data);

}

});

}

showRoom();

});

Keep in mind that jQuery's ajax expects an object as parameter. Inside an object the syntax is

{ key : value }

You had type="POST" which is correct in declarative syntax, but incorrect when defining an object key.

Second, the data property of the aforementioned object should be an object too. So instead of action=showroom it should be

{action:"showroom"}