Rumah >pembangunan bahagian belakang >tutorial php >javascript - PHP和Ajax做的分页跳转,可是出不来。望大神能看看
javascript - PHP和Ajax做的分页跳转,可是出不来。望大神能看看
- WBOYasal
- 2016-12-05 13:44:111372semak imbas
想做一个ajax局部刷新分页跳转，可是不知道为什么用ajax接受的数据在页面
上显示出来总是这么一句话MySql ErrorNo database selected 然后我做了几个测试
发现echo"111111";echo"22222";echo"3333"echo"4444";只有4444输出！PHP我不是很懂
所以想麻烦大神们看下是怎么回事！小弟在此谢过了！
<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我不是很懂
所以想麻烦大神们看下是怎么回事！小弟在此谢过了！
<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()这个，链接里有，你看下。
mysql 和mysqli混用！
上面用的$conn=mysqli_connect("localhost","root","","info");
下面用mysql_query($query_pag_data)
要不改成
<code class="php">$conn=mysql_connect("localhost","root","","info");
mysql_query($conn,"SET NAMES 'utf8'");</code>
这个报错是因为没有选择数据库呀，你在连接之后执行一下mysqli_query('use database')，database是你的数据库，另外像楼上说的，别mysqli和mysql混杂用，php官方已经放弃mysql扩展了，用pdo或者mysqli
Kenyataan：
Kandungan artikel ini disumbangkan secara sukarela oleh netizen, dan hak cipta adalah milik pengarang asal. Laman web ini tidak memikul tanggungjawab undang-undang yang sepadan. Jika anda menemui sebarang kandungan yang disyaki plagiarisme atau pelanggaran, sila hubungi admin@php.cn
Artikel sebelumnya：Linode 安装完 Ubuntu之后 FTP里看不到文件Artikel seterusnya：正则表达式 - php怎么用正则获取a标签的内容？
Artikel berkaitan
Lihat lagi- Cara menggunakan cURL untuk melaksanakan permintaan Dapatkan dan Hantar dalam PHP
- Cara menggunakan cURL untuk melaksanakan permintaan Dapatkan dan Hantar dalam PHP
- Cara menggunakan cURL untuk melaksanakan permintaan Dapatkan dan Hantar dalam PHP
- Cara menggunakan cURL untuk melaksanakan permintaan Dapatkan dan Hantar dalam PHP
- Semua simbol ungkapan dalam ungkapan biasa (ringkasan)