PHP self-training project digital paging effect, PHP training project paging_PHP tutorial

PHP self-training project digital paging effect, PHP training project paging

Learning points:
1. LIMIT usage
2. Various parameters
3 .Hyperlink call

First: first set up the digital paging module in the file; my file is (blog.php)

<span>//</span><span>分页模块</span>
<span>$_page</span> = <span>$_GET</span>['page'<span>];
</span><span>$_pagesize</span> = 10<span>;
</span><span>$_pagenum</span> = (<span>$_page</span> - 1) * <span>$_pagesize</span><span>;
</span><span>//</span><span>首页要得到所有的数据总和</span>
<span>$_num</span>=<span>mysql_num_rows</span>(_query("SELECT tg_id FROM tg_user"<span>));
</span><span>$_pageabsolute</span>=<span>$_num</span> / <span>$_pagesize</span>;

One thing to note is when fetching sets from the database

//We must re-read the result set every time instead of re-executing the SQL statement.
$_result = _query("SELECT tg_username,tg_sex,tg_face FROM tg_user ORDER BY tg_reg_time DESC LIMIT $_pagenum,$_pagesize");
Set the effect of paging loop

<span><div id="page_num">
    <ul>
    <?php <span>for</span>(<span>$i</span>=0;<span>$i</span><<span>$_pageabsolute</span>;<span>$i</span>++<span>){
        </span><span>if</span> (<span>$_page</span> == (<span>$i</span>+1<span>)) {
            </span><span>echo</span> '<li><a href="blog.php?page='.(<span>$i</span>+1).'" class="selected">'.(<span>$i</span>+1).'</a></li>'<span>;
        }</span><span>else</span><span>{
            </span><span>echo</span> '<li><a href="blog.php?page='.(<span>$i</span>+1).'">'.(<span>$i</span>+1).'</li>'<span>;
        }
    } </span>?>
    </ul>
    </div></span>

Corresponding CSS

#page_num {
	height:20px;
	clear:both;
	padding:10px 0;
	position:relative;
}
#page_num ul {
	position:absolute;
	right:30px;
	height:20px;
}
#page_num ul li {
	float:left;
	width:26px;
	height:20px;
}
#page_num ul li a {
	display:block;
	width:20px;
	height:20px;
	line-height:20px;
	border:1px solid #333;
	text-align:center;
	text-decoration:none;
}
#page_num ul li a:hover,#page_num ul li a.selected {
	background:#666;
	font-weight:bold;
	color:#fff;
}

　

http://www.bkjia.com/PHPjc/1037987.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/1037987.htmlTechArticlePHP self-practice project digital paging effect, PHP practice project paging learning points: 1. LIMIT usage 2. Various Parameter 3. Hyperlink call first: first set the digital paging module in the file; my text...