Home Backend Development PHP Tutorial PHP example code: AJAX pagination display data_PHP tutorial

PHP example code: AJAX pagination display data_PHP tutorial

Jul 21, 2016 pm 02:56 PM
ajax php code Pagination Example Tutorial data show

Bangkejia (www.Bkjia.com) tutorial PHP example code: AJAX paging to display data.

Files for debugging

以下为引用的内容:


帮客之家提供教程LIEHUO.NET 关注站长,建设互联网!
<script> <br>function viewpage(p){ <br>if(window.XMLHttpRequest){ <br>var xmlReq = new XMLHttpRequest(); <br>} else if(window.ActiveXObject) { <br>var xmlReq = new ActiveXObject('Microsoft.XMLHTTP'); <br>} <br>var formData = "page="+p; <br>xmlReq.onreadystatechange = function(){ <br>if(xmlReq.readyState == 4){ <br>document.getElementById('content2').innerHTML = xmlReq.responseText; <br>} <br>} <br>xmlReq.open("post", "Example8_7_1.php", true); <br>xmlReq.setRequestHeader("Content-Type", "application/x-www-form-urlencoded"); <br>xmlReq.send(formData); <br>return false; <br>} <br></script>



数据分页显示




Another file called Example8_7_1.php

The following is the quoted content:
header("Content-Type: text/html;charset=GB2312");
$pagesize=10;
//echo $_POST['page'];
$db=mysql_connect("localhost","root",""); //Create a database connection
mysql_query("set character set utf- 8");
mysql_select_db("optics");
$result = mysql_query("Select count(DISTINCT articleid) FROM product");
$myrow = mysql_fetch_array($result);
$ numrows=$myrow[0];
$pages=intval($numrows/$pagesize);
if ($numrows%$pagesize)
$pages++;
if (isset($_POST[ 'page'])){
$page=intval($_POST['page']);
}
else{
//Set to the first page
$page=1 ;
}
$first=1;
$prev=$page-1;
$next=$page+1;
$last=$pages;
//Calculate Record offset
$offset=$pagesize*($page - 1);
//Read the specified number of records

//$result=mysql_query("select `id`, count ( * ) from ".book." GROUP BY `id` order by id desc limit $offset,$pagesize");
$result=mysql_query("select * from product GROUP BY `articleid` order by articleid desc limit $offset,$pagesize");
$num = @mysql_num_rows($result);

while ($row = @mysql_fetch_array($result,MYSQL_NUM)) {
$hotelname[] = $row[0];
$name[]=$row[1];
$author[]=$row[2];
$publisher[]=$row[3];
$isbn[]=$row[4];
$type[]=$row[5];
$smallpic[]=$row[6];
//$countpeople[] = $row[1];
}
echo "n";
echo "n";
echo "";
for($a=0;$ a<$num;$a++)
{
echo "n";
echo "";
echo "";
echo "";
echo "";
echo "";
echo " ";
echo " ";
echo "";
}
echo "
ID numberNameAuthorPublished CompanyISBN numberTypePrice
".$hotelname[ $a]."".$name[$a]."".$author[$a]."".$publisher[$a]."".$ isbn[$a]."".$type[$a]."
n";
echo "echo "border=0>";
echo "
";
echo "
";
echo "

Page ".$page."/ Total ".$pages." pages | Total ".$numrows." items | ";
if ($page>1) echo "Homepage | ";
if ($page>1) echo "Previous page | ";
if ($page<$pages) echo " Next page | ";
if ($page<$pages) echo "Last page< /a>";
echo "Go to page ";
echo "

";

?>

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/364312.htmlTechArticleLieHuo.Net tutorial PHP example code: AJAX paging display data. Files for debugging: The following is the quoted content: html head title Liehuo.net provides tutorials LIEHUO.NET Follow the webmaster,...
Statement of this Website
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

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Roblox: Bubble Gum Simulator Infinity - How To Get And Use Royal Keys
1 months ago By 尊渡假赌尊渡假赌尊渡假赌
Nordhold: Fusion System, Explained
1 months ago By 尊渡假赌尊渡假赌尊渡假赌
Mandragora: Whispers Of The Witch Tree - How To Unlock The Grappling Hook
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Hot Topics

Java Tutorial
1677
14
PHP Tutorial
1279
29
C# Tutorial
1257
24
The Continued Use of PHP: Reasons for Its Endurance The Continued Use of PHP: Reasons for Its Endurance Apr 19, 2025 am 12:23 AM

What’s still popular is the ease of use, flexibility and a strong ecosystem. 1) Ease of use and simple syntax make it the first choice for beginners. 2) Closely integrated with web development, excellent interaction with HTTP requests and database. 3) The huge ecosystem provides a wealth of tools and libraries. 4) Active community and open source nature adapts them to new needs and technology trends.

What happens if session_start() is called multiple times? What happens if session_start() is called multiple times? Apr 25, 2025 am 12:06 AM

Multiple calls to session_start() will result in warning messages and possible data overwrites. 1) PHP will issue a warning, prompting that the session has been started. 2) It may cause unexpected overwriting of session data. 3) Use session_status() to check the session status to avoid repeated calls.

The Compatibility of IIS and PHP: A Deep Dive The Compatibility of IIS and PHP: A Deep Dive Apr 22, 2025 am 12:01 AM

IIS and PHP are compatible and are implemented through FastCGI. 1.IIS forwards the .php file request to the FastCGI module through the configuration file. 2. The FastCGI module starts the PHP process to process requests to improve performance and stability. 3. In actual applications, you need to pay attention to configuration details, error debugging and performance optimization.

What is the significance of the session_start() function? What is the significance of the session_start() function? May 03, 2025 am 12:18 AM

session_start()iscrucialinPHPformanagingusersessions.1)Itinitiatesanewsessionifnoneexists,2)resumesanexistingsession,and3)setsasessioncookieforcontinuityacrossrequests,enablingapplicationslikeuserauthenticationandpersonalizedcontent.

Composer: Aiding PHP Development Through AI Composer: Aiding PHP Development Through AI Apr 29, 2025 am 12:27 AM

AI can help optimize the use of Composer. Specific methods include: 1. Dependency management optimization: AI analyzes dependencies, recommends the best version combination, and reduces conflicts. 2. Automated code generation: AI generates composer.json files that conform to best practices. 3. Improve code quality: AI detects potential problems, provides optimization suggestions, and improves code quality. These methods are implemented through machine learning and natural language processing technologies to help developers improve efficiency and code quality.

Using Laravel: Streamlining Web Development with PHP Using Laravel: Streamlining Web Development with PHP Apr 19, 2025 am 12:18 AM

Laravel optimizes the web development process including: 1. Use the routing system to manage the URL structure; 2. Use the Blade template engine to simplify view development; 3. Handle time-consuming tasks through queues; 4. Use EloquentORM to simplify database operations; 5. Follow best practices to improve code quality and maintainability.

PHP and IIS: Making Them Work Together PHP and IIS: Making Them Work Together Apr 21, 2025 am 12:06 AM

Configuring and running PHP on IIS requires the following steps: 1) Download and install PHP, 2) Configuring IIS and adding FastCGI module, 3) Create and set up an application pool, 4) Create a website and bind to an application pool. Through these steps, you can easily deploy PHP applications on your Windows server and improve application stability and efficiency by configuring scaling and optimizing performance.

H5: Key Improvements in HTML5 H5: Key Improvements in HTML5 Apr 28, 2025 am 12:26 AM

HTML5 brings five key improvements: 1. Semantic tags improve code clarity and SEO effects; 2. Multimedia support simplifies video and audio embedding; 3. Form enhancement simplifies verification; 4. Offline and local storage improves user experience; 5. Canvas and graphics functions enhance the visualization of web pages.

See all articles