社区
学习
工具库
AI工具
休闲
搜索
简体中文
首页 > 后端开发 > php教程 > javascript - PHP和Ajax做的分页跳转,可是出不来。望大神能看看

javascript - PHP和Ajax做的分页跳转,可是出不来。望大神能看看

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
发布： 2023-03-03 08:38:02
原创
1429 人浏览过

想做一个ajax局部刷新分页跳转，可是不知道为什么用ajax接受的数据在页面
上显示出来总是这么一句话MySql ErrorNo database selected 然后我做了几个测试
发现echo"111111";echo"22222";echo"3333"echo"4444";只有4444输出！PHP我不是很懂
所以想麻烦大神们看下是怎么回事！小弟在此谢过了！

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

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

<code><meta http-equiv="Content-Type" content="text/html; charset=utf8">

<?php if($_REQUEST['page'])

{

    $page = $_REQUEST['page'];

    $page=1;

    $cur_page = $page;

    $page -= 1;

    $per_page = 10;

    $previous_btn = true;

    $next_btn = true;

    $first_btn = true;

    $last_btn = true;

    $start = $page * $per_page;

 

 

    $conn=mysqli_connect("localhost","root","","info");

    mysqli_query($conn,"SET NAMES 'utf8'");

    **echo "44444444";**

    $query_pag_data = "SELECT id,name from content LIMIT $start, $per_page";

    $result_pag_data = mysql_query($query_pag_data) or die('MySql Error' . mysql_error());

    $msg = "";

    while ($row = mysql_fetch_array($result_pag_data)) {

        $htmlmsg=htmlspecialchars($row['name']);

        $msg .= "<li><b>" . $row['id'] . "</b> " . $htmlmsg . "";

    }

    $msg = "<div class="data"><ul>" . $msg . "</ul></div>"; // Content for Data

 

    **echo "3333333333333333333333";**

    /* --------------------------------------------- */

    $query_pag_num = "SELECT COUNT(*) AS count FROM content";

    $result_pag_num = mysql_query($query_pag_num);

    $row = mysql_fetch_array($result_pag_num);

    $count = $row['count'];

    $no_of_paginations = ceil($count / $per_page);

 

    **echo "2222222222";**

 

    /* ---------------Calculating the starting and endign values for the loop----------------------------------- */

    if ($cur_page >= 7) {

        $start_loop = $cur_page - 3;

        if ($no_of_paginations > $cur_page + 3)

            $end_loop = $cur_page + 3;

        else if ($cur_page  $no_of_paginations - 6) {

            $start_loop = $no_of_paginations - 6;

            $end_loop = $no_of_paginations;

        } else {

            $end_loop = $no_of_paginations;

        }

    } else {

        $start_loop = 1;

        if ($no_of_paginations > 7)

            $end_loop = 7;

        else

            $end_loop = $no_of_paginations;

    }

    /* ----------------------------------------------------------------------------------------------------------- */

    $msg .= "<div class="pagination">

<ul>";

 

    // FOR ENABLING THE FIRST BUTTON

    if ($first_btn && $cur_page > 1) {

        $msg .= "<li p="1" class="active">First</li>";

    } else if ($first_btn) {

        $msg .= "<li p="1" class="inactive">First</li>";

    }

 

    // FOR ENABLING THE PREVIOUS BUTTON

    if ($previous_btn && $cur_page > 1) {

        $pre = $cur_page - 1;

        $msg .= "<li p="$pre" class="active">Previous</li>";

    } else if ($previous_btn) {

        $msg .= "<li class="inactive">Previous</li>";

    }

    for ($i = $start_loop; $i {$i}";

        else

            $msg .= "<li p="$i" class="active">{$i}</li>";

    }

 

    // TO ENABLE THE NEXT BUTTON

    if ($next_btn && $cur_page Next";

    } else if ($next_btn) {

        $msg .= "<li class="inactive">Next</li>";

    }

 

    // TO ENABLE THE END BUTTON

    if ($last_btn && $cur_page Last";

    } else if ($last_btn) {

        $msg .= "<li p="$no_of_paginations" class="inactive">Last</li>";

    }

    $goto = "<input type="text" class="goto" size="1" style="margin-top:-1px;margin-left:60px;"><input type="button" id="go_btn" class="go_button" value="Go">";

    $total_string = "<span class="total" a="$no_of_paginations">Page <b>" . $cur_page . "</b> of <b>$no_of_paginations</b></span>";

    $msg = $msg . "</ul>" . $goto . $total_string . "</div>";  // Content for pagination

    **echo $msg;**

    **echo "1111111111111";**

}

?>

</code>

登录后复制
登录后复制

以上是代码

回复内容：

想做一个ajax局部刷新分页跳转，可是不知道为什么用ajax接受的数据在页面
上显示出来总是这么一句话MySql ErrorNo database selected 然后我做了几个测试
发现echo"111111";echo"22222";echo"3333"echo"4444";只有4444输出！PHP我不是很懂
所以想麻烦大神们看下是怎么回事！小弟在此谢过了！

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

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

<code><meta http-equiv="Content-Type" content="text/html; charset=utf8">

<?php if($_REQUEST['page'])

{

    $page = $_REQUEST['page'];

    $page=1;

    $cur_page = $page;

    $page -= 1;

    $per_page = 10;

    $previous_btn = true;

    $next_btn = true;

    $first_btn = true;

    $last_btn = true;

    $start = $page * $per_page;

 

 

    $conn=mysqli_connect("localhost","root","","info");

    mysqli_query($conn,"SET NAMES 'utf8'");

    **echo "44444444";**

    $query_pag_data = "SELECT id,name from content LIMIT $start, $per_page";

    $result_pag_data = mysql_query($query_pag_data) or die('MySql Error' . mysql_error());

    $msg = "";

    while ($row = mysql_fetch_array($result_pag_data)) {

        $htmlmsg=htmlspecialchars($row['name']);

        $msg .= "<li><b>" . $row['id'] . "</b> " . $htmlmsg . "";

    }

    $msg = "<div class="data"><ul>" . $msg . "</ul></div>"; // Content for Data

 

    **echo "3333333333333333333333";**

    /* --------------------------------------------- */

    $query_pag_num = "SELECT COUNT(*) AS count FROM content";

    $result_pag_num = mysql_query($query_pag_num);

    $row = mysql_fetch_array($result_pag_num);

    $count = $row['count'];

    $no_of_paginations = ceil($count / $per_page);

 

    **echo "2222222222";**

 

    /* ---------------Calculating the starting and endign values for the loop----------------------------------- */

    if ($cur_page >= 7) {

        $start_loop = $cur_page - 3;

        if ($no_of_paginations > $cur_page + 3)

            $end_loop = $cur_page + 3;

        else if ($cur_page  $no_of_paginations - 6) {

            $start_loop = $no_of_paginations - 6;

            $end_loop = $no_of_paginations;

        } else {

            $end_loop = $no_of_paginations;

        }

    } else {

        $start_loop = 1;

        if ($no_of_paginations > 7)

            $end_loop = 7;

        else

            $end_loop = $no_of_paginations;

    }

    /* ----------------------------------------------------------------------------------------------------------- */

    $msg .= "<div class="pagination">

<ul>";

 

    // FOR ENABLING THE FIRST BUTTON

    if ($first_btn && $cur_page > 1) {

        $msg .= "<li p="1" class="active">First</li>";

    } else if ($first_btn) {

        $msg .= "<li p="1" class="inactive">First</li>";

    }

 

    // FOR ENABLING THE PREVIOUS BUTTON

    if ($previous_btn && $cur_page > 1) {

        $pre = $cur_page - 1;

        $msg .= "<li p="$pre" class="active">Previous</li>";

    } else if ($previous_btn) {

        $msg .= "<li class="inactive">Previous</li>";

    }

    for ($i = $start_loop; $i {$i}";

        else

            $msg .= "<li p="$i" class="active">{$i}</li>";

    }

 

    // TO ENABLE THE NEXT BUTTON

    if ($next_btn && $cur_page Next";

    } else if ($next_btn) {

        $msg .= "<li class="inactive">Next</li>";

    }

 

    // TO ENABLE THE END BUTTON

    if ($last_btn && $cur_page Last";

    } else if ($last_btn) {

        $msg .= "<li p="$no_of_paginations" class="inactive">Last</li>";

    }

    $goto = "<input type="text" class="goto" size="1" style="margin-top:-1px;margin-left:60px;"><input type="button" id="go_btn" class="go_button" value="Go">";

    $total_string = "<span class="total" a="$no_of_paginations">Page <b>" . $cur_page . "</b> of <b>$no_of_paginations</b></span>";

    $msg = $msg . "</ul>" . $goto . $total_string . "</div>";  // Content for pagination

    **echo $msg;**

    **echo "1111111111111";**

}

?>

</code>

登录后复制
登录后复制

以上是代码

看一下文档啊 少年 点击链接
既然你是用的mysqli，三楼说的没错，选择一下数据库，mysqli是mysqli_select_db()这个，链接里有，你看下。
javascript - PHP和Ajax做的分页跳转,可是出不来。望大神能看看

javascript - PHP和Ajax做的分页跳转,可是出不来。望大神能看看

mysql 和mysqli混用！
上面用的$conn=mysqli_connect("localhost","root","","info");
下面用mysql_query($query_pag_data)

要不改成

1

2

$conn=mysql_connect("localhost","root","","info");

mysql_query($conn,"SET NAMES 'utf8'");

登录后复制

这个报错是因为没有选择数据库呀，你在连接之后执行一下mysqli_query('use database')，database是你的数据库，另外像楼上说的，别mysqli和mysql混杂用，php官方已经放弃mysql扩展了，用pdo或者mysqli

相关标签：
javascript php
上一篇：Linode 安装完 Ubuntu之后 FTP里看不到文件 下一篇：正则表达式 - php怎么用正则获取a标签的内容？
本站声明
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn
作者最新文章
最新问题
JavaScript教程：利用JavaScript创建和读取cookie中的值
来自于 1970-01-01 08:00:00
0
0
0
怎么实现 JavaScript点与圆的位置关系
来自于 1970-01-01 08:00:00
0
0
0
JavaScript钩子函数是什么？
来自于 1970-01-01 08:00:00
0
0
0
javascript - 正则表达式匹配两个字符串之间的内容
来自于 1970-01-01 08:00:00
0
0
0
c++ 调用javascript
来自于 1970-01-01 08:00:00
0
0
0
相关专题
更多>
热门推荐
热门教程
更多>
相关教程
热门推荐
最新课程
最新下载
更多>
网站特效
网站源码
网站素材
前端模板