【代码集合】连接数据库、查询所有数据，API接口定义

连接数据库、查询所有数据，API接口定义

<?php

$dbhost = 'localhost:3306';  //mysql服务器主机地址
$dbuser = 'root';      //mysql用户名
$dbpass = 'root';//mysql用户名密码
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(!$conn ) 
{
  die('Could not connect: ' . mysql_error());
}


mysql_select_db('jqueryui');


$rs = mysql_query('select * from crud_datagrid');
$result = array();
while($row = mysql_fetch_object($rs)){
    array_push($result, $row);
}

echo json_encode($result);

mysql_close($conn);


?>