Home >Backend Development >PHP Tutorial >PHP simply implements querying the database and returning json data_PHP tutorial

PHP simply implements querying the database and returning json data_PHP tutorial

WBOY
WBOYOriginal
2016-07-13 09:57:05776browse

PHP simply implements querying the database and returning json data

Sample code one:

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

// 设置返回json格式数据

header('content-type:application/json;charset=utf8');

 

//连接数据库

$link = mysql_connect("localhost", "root", "root") or die("Unable to connect to the MySQL!");

 

mysql_query("SET NAMES 'UTF8'");

 

mysql_select_db("jilinwula", $link) or die("Unable to connect to the MySQL!");

 

// 获取分页参数

$page = 0 ;

$pageSize = 3;

 

if(!is_null($_GET["page"])) {

$page = $_GET["page"];

}

 

if(!is_null($_GET["pageSize"])) {

$pageSize = $_GET["pageSize"];

}

 

// 查询数据到数组中

$result = mysql_query("select username,password from userinfo limit " . $page . ", ". $pageSize ."");

 

$results = array();

while ($row = mysql_fetch_assoc($result)) {

$results[] = $row;

}

 

// 将数组转成json格式

echo json_encode($results);

 

// 关闭连接

mysql_free_result($result);

 

mysql_close($link);

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
//Set to return json format data header('content-type:application/json;charset=utf8'); //Connect to database $link = mysql_connect("localhost", "root", "root") or die("Unable to connect to the MySQL!"); mysql_query("SET NAMES 'UTF8'"); mysql_select_db("jilinwula", $link) or die("Unable to connect to the MySQL!"); //Get paging parameters $page = 0 ; $pageSize = 3; if(!is_null($_GET["page"])) { $page = $_GET["page"]; } if(!is_null($_GET["pageSize"])) { $pageSize = $_GET["pageSize"]; } //Query data into array $result = mysql_query("select username,password from userinfo limit " . $page . ", ". $pageSize .""); $results = array(); while ($row = mysql_fetch_assoc($result)) { $results[] = $row; } //Convert the array into json format echo json_encode($results); //Close connection mysql_free_result($result); mysql_close($link);

Sample code two:

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

//需要执行的SQL语句

//单条

$sql="select id,name from tbl_user where id=1";

//多条数据

//$sql="select id,name from tbl_user";

//调用conn.php文件进行数据库操作

require('Conn.php');

//提示操作成功信息,注意:$result存在于conn.php文件中,被调用出来

if($result)

{

// $array=mysql_fetch_array($result,MYSQL_ASSOC);

/*数据集

$users=array();

$i=0;

while($row=mysql_fetch_array($result,MYSQL_ASSOC)){

echo $row['id'].'-----------'.$row['name'].'
';

$users[$i]=$row;

$i ;

 

}

echo json_encode(array('dataList'=>$users));

 

*/

 

/*单条数据*/

 

$row=mysql_fetch_row($result,MYSQL_ASSOC);

 

echo json_encode(array('jsonObj'=>$row));

}

 

mysql_free_result($result);

//释放结果

mysql_close();

//关闭连接

 

?>

1 2 3

4

6 7 8 9 10
11 12
13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46
<🎜> <🎜> <🎜>//SQL statement to be executed<🎜> <🎜>//Single entry<🎜> <🎜>$sql="select id,name from tbl_user where id=1";<🎜> <🎜>//Multiple pieces of data<🎜> <🎜>//$sql="select id,name from tbl_user";<🎜> <🎜> <🎜> <🎜>//Call the conn.php file to perform database operations<🎜> <🎜>require('Conn.php');<🎜> <🎜> <🎜> <🎜>//Prompt for successful operation information, note: $result exists in the conn.php file and is called out<🎜> <🎜>if($result)<🎜> <🎜>{<🎜> <🎜> <🎜> <🎜>// $array=mysql_fetch_array($result,MYSQL_ASSOC);<🎜> <🎜> <🎜> <🎜> <🎜> <🎜>/*Dataset<🎜> <🎜> <🎜> <🎜>$users=array();<🎜> <🎜>$i=0;<🎜> <🎜>while($row=mysql_fetch_array($result,MYSQL_ASSOC)){<🎜> <🎜> <🎜> <🎜>echo $row['id'].'-----------'.$row['name'].'
'; $users[$i]=$row; $i ; } echo json_encode(array('dataList'=>$users)); */ /*Single piece of data*/ $row=mysql_fetch_row($result,MYSQL_ASSOC); echo json_encode(array('jsonObj'=>$row)); } mysql_free_result($result); //Release results mysql_close(); //Close the connection ?>
http://www.bkjia.com/PHPjc/985142.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/985142.htmlTechArticlephp simple implementation of querying the database and returning json data sample code one: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 // Set return...
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn