Backend Development
PHP Tutorial
Regarding the two paging styles of digital paging and text paging in php, mysql, and html for your reference_PHP tutorial
Regarding the two paging styles of digital paging and text paging in php, mysql, and html for your reference_PHP tutorial
Please do not pirate, please add the source when reprinting http://blog.csdn.net/yanlintao1
Please do not pirate, please add the source when reprinting http://blog.csdn.net/yanlintao1
First of all, I hope it will be helpful to show you the style, and I also hope you can give me your opinions and suggestions:
The first type: digital paging
Second: Paginate text
php paging function (I wrote it in the common.inc.php public file introduced below):
/*
*_page()分页的相关参数
*@param int $_pagesize 每页存有几个好友
*@param $_sql 获取所有字段
* */
function _page($_sql,$_size){
global $_pagenum,$_pagesize,$_pageabsolute,$_num,$_page;
//分页模块以及容错处理
//第几页
if(isset( $_GET['page'])){
$_page = $_GET['page'];
if(empty($_page)||$_page<0||!is_numeric($_page)){
$_page = 1;
}else{
$_page = intval($_page);
}
}else{
$_page = 1;
}
//每页有几个好友
$_pagesize = $_size;
//得到所有数据综合
$_num = _num_rows(_query($_sql));
//ceil见大于等于1就进位,计算有多少页
if($_num == 0){
$_pageabsolute = 1;
}else{
$_pageabsolute = ceil($_num/$_pagesize);
}
if($_page>$_pageabsolute){
$_page=$_pageabsolute;
}
//从数据库的第几条数据开始
$_pagenum = ($_page-1)*$_pagesize;
}
/*
* _paging分页函数
* @access public 表示函数对外公开
* @param int $_type 若为1则按数字分页，若为2按文本形式分页
* $_pageabsolute 共多少页
* $_page 第几页
* $_num 一共有多少条数据
* */
function _paging($_type){
global $_pageabsolute,$_page,$_num;
if($_type==1){
echo '<div id="page_num">';
echo '<ul>';
for($i=0;$i<$_pageabsolute;$i++){
if($_page==($i+1)){
echo '<li>'.($i+1).'</li>';
}else{
echo '<li>'.($i+1).'</li>';
}
}
echo '</ul>';
echo '</div>';
}elseif($_type==2){
echo '<div id="page_text">';
echo '<ul>';
echo '<li>'.$_page.'/'.$_pageabsolute.'页 |</li>';
echo '<li>共有<strong>'.$_num.'</strong>条数据 |</li>';
if($_page==1){
echo '<li>首页 |</li>';
echo '<li>下一页 | </li>';
echo '<li>尾页 | </li>';
}elseif($_page==$_pageabsolute){
echo '<li>首页 | </li>';
echo '<li>上一页 | </li>';
echo '<li>尾页 |</li>';
}else{
echo '<li>首页 | </li>';
echo '<li>上一页 | </li>';
echo '<li>下一页 | </li>';
echo '<li>尾页 | </li>';
}
echo '</ul>';
echo '</div>';
}
}html code:
*/
//引入公共文件
require './includer/common.inc.php';
//分页模块,第一个参数获取总条数，第二个参数获得每页有几个好友
global $_pagenum,$_pagesize;
_page("SELECT tg_id FROM tg_guest", 2);
//从数据库中取数据,按照注册时间顺序排列
$_result = _query("SELECT tg_username,tg_sex,tg_face,tg_id FROM tg_guest ORDER BY tg_reg_time DESC LIMIT $_pagenum,$_pagesize");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>博友</title>
<?php
require ROOT_PATH.'includer/title.inc.php';
?>
<script type="text/javascript" src="js/blog_message.js"></script>
</head>
<body>
<?php
require ROOT_PATH.'includer/header.inc.php';
?>
<div id="blog">
<h2 id="博友界面">博友界面</h2>
<?php
while(!!$_rows=_fetch_array_list($_result,MYSQL_ASSOC)){
$_html = array();
$_html['tg_username'] = $_rows['tg_username'];
$_html['tg_face'] = $_rows['tg_face'];
$_html['tg_sex'] = $_rows['tg_sex'];
$_html['tg_id'] = $_rows['tg_id'];
$_html = _html($_html);
?>
<dl>
<dt class="user"><?php echo $_html['tg_username']?>(<?php echo $_html['tg_sex']?>)</dt>
<dt><img src="http://blog.csdn.net/yanlintao1/article/details/<?php echo $_html['tg_face']? alt="Regarding the two paging styles of digital paging and text paging in php, mysql, and html for your reference_PHP tutorial" >" alt="<?php echo $_html['tg_username']?>"></img></dt>
<dd class="message">">发消息</dd>
<dd class="friend">加好友</dd>
<dd class="guest">写留言</dd>
<dd class="flower">送鲜花</dd>
</dl>
<?php }?>
<?php
//销毁结果集
_free_result($_result);
//1为数字分页，2为文本分页
_paging(2);
?>
</div>
<?php
require ROOT_PATH.'includer/footer.inc.php';
?>
</body>
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
macOS: How to change the color of desktop widgets
Oct 07, 2023 am 08:17 AM
In macOS Sonoma, widgets don't have to be hidden off-screen or forgotten in the Notification Center panel like they did in previous versions of Apple's macOS. Instead, they can be placed directly on your Mac’s desktop – they’re also interactive. When not in use, macOS desktop widgets fade into the background in a monochrome style, reducing distractions and allowing you to focus on the task at hand in the active application or window. However, when you click on the desktop, they return to full color. If you prefer a drab look and want to retain that aspect of uniformity on your desktop, there's a way to make it permanent. The following steps demonstrate how it is done. Open the System Settings app
Guide to solving misalignment of WordPress web pages
Mar 05, 2024 pm 01:12 PM
Guide to solving misaligned WordPress web pages In WordPress website development, sometimes we encounter web page elements that are misaligned. This may be due to screen sizes on different devices, browser compatibility, or improper CSS style settings. To solve this misalignment, we need to carefully analyze the problem, find possible causes, and debug and repair it step by step. This article will share some common WordPress web page misalignment problems and corresponding solutions, and provide specific code examples to help develop
CSS web background image design: create various background image styles and effects
Nov 18, 2023 am 08:38 AM
CSS web page background image design: Create various background image styles and effects, specific code examples are required Summary: In web design, background images are an important visual element, which can effectively enhance the attractiveness and readability of the page. This article will introduce some common CSS background image design styles and effects, and provide corresponding code examples. Readers can select and apply these background image styles and effects according to their own needs and preferences to achieve better visual effects and user experience. Keywords: CSS, background image, design style, effect, code representation
Use the :nth-last-child(2) pseudo-class selector to select the style of the second-to-last child element
Nov 20, 2023 am 11:22 AM
Use the :nth-last-child(2) pseudo-class selector to select the style of the penultimate child element. Specific code examples are required. In CSS, the pseudo-class selector is a very powerful tool that can be used to select the document tree. specific elements. One of them is the :nth-last-child(2) pseudo-class selector, which selects the second-to-last child element and applies styles to it. First, let's create a sample HTML document so that we can use this pseudo-class selector in it. by
CSS text effects: add various special effects and styles to text
Nov 18, 2023 am 10:30 AM
CSS text effects: Adding various special effects and styles to text requires specific code examples 1. Introduction In web design, text is an indispensable part. By adding special effects and styles to the text, you can make the page more lively and interesting and improve the user's reading experience. This article will introduce some common CSS text effects and provide corresponding code examples for readers' reference and learning. 2. Text color Text color is one of the most basic text effects. By setting the color property, you can change the color of the text. Here is an example
CSS web navigation bar design: making various navigation bar styles
Nov 18, 2023 pm 04:41 PM
CSS web navigation bar design: To create various navigation bar styles, specific code examples are required. The navigation bar is one of the most important components in web design. It not only facilitates users to browse different pages of the website, but also provides a clear guide to the website structure. . When designing a navigation bar, the problem we often face is how to create a navigation bar that is both beautiful and functional. This article will introduce some common CSS navigation bar design methods and give corresponding code examples to help readers better understand and apply them. Basic navigation bar Basic navigation bar is the most common
Use the :root pseudo-class selector to select the style of the root element of the document
Nov 20, 2023 pm 02:18 PM
Using the :root pseudo-class selector to select the style of the root element of the document requires specific code examples. In CSS, we can use the :root pseudo-class selector to select the root element of the document and specify a specific style for it. The :root pseudo-class selector is equivalent to selecting html elements in most cases, but when a namespace exists in the document, the :root pseudo-class selector will select the root element of the default namespace. Here is a concrete code example that shows how to use the :root pseudo-class selector to select the root element of the document.
Front-end and back-end responsibilities and skill requirements
Mar 25, 2024 pm 07:00 PM
Front-end and back-end are two indispensable parts of software development, and they respectively bear different responsibilities and skill requirements. This article will explore the job content and requirements of front-end and back-end development engineers in terms of responsibilities and skills. 1. Responsibilities and skill requirements of front-end engineers Front-end engineers are responsible for implementing user interface and interactive functions and facing users directly. They need to have the following responsibilities and skill requirements: implement the user interface design of the website or application to ensure good page visual effects and interactive experience; Work closely with UI/UX designers to transform design drafts into
