PHP實作資料庫的分頁類別
最近在實作一個商品的管理專案,對商品的資料能進行分頁的輸出.
因此,實作了一個分頁類別運算,具體程式碼如下:
<code>class SepPage{ <span>var</span><span>$rs</span>; <span>var</span><span>$pagesize</span>; <span>var</span><span>$nowpage</span>; <span>var</span><span>$array</span>; <span>var</span><span>$conn</span>; <span>var</span><span>$sqlarr</span>; function ShowData(<span>$sqlarr</span>,<span>$conn</span>,<span>$pagesize</span>,<span>$nowpage</span>){ <span>//定义方法</span><span>if</span>(<span>!</span>isset(<span>$nowpage</span>)<span>||</span><span>$nowpage</span><span>==</span><span>""</span>) <span>//判断变量值是否为空</span><span>$this</span><span>-></span>nowpage<span>=</span><span>1</span>; <span>else</span><span>$this</span><span>-></span>nowpage<span>=</span><span>$nowpage</span>; <span>$this</span><span>-></span>pagesize<span>=</span><span>$pagesize</span>;<span>//定义每页输出的记录数</span><span>$this</span><span>-></span>conn<span>=</span><span>$conn</span>;<span>//链接数据库返回的标识</span><span>$this</span><span>-></span>sqlstr<span>=</span><span>$strsql</span>;<span>//执行查询语句</span><span>$this</span><span>-></span>rs<span>=</span><span>$this</span><span>-></span>conn<span>-></span>PageExecute(<span>$this</span><span>-></span>sqlstr,<span>$this</span><span>-></span>pagesize,<span>$this</span><span>-></span>nowpage); @this<span>-></span><span>array</span><span>=</span><span>$this</span><span>-></span>rs<span>-></span>GetRows();<span>//获取记录数</span><span>if</span>(count(<span>$this</span><span>-></span><span>array</span>)<span>==</span><span>0</span><span>||</span><span>$this</span><span>-></span>rs<span>==</span><span>false</span>) <span>return</span><span>false</span>; <span>else</span><span>return</span><span>$this</span><span>-></span><span>array</span>; } function ShowPage(<span>$contentname</span>,<span>$utits</span>,<span>$anothersearchstr</span>,<span>$anothersearchstrs</span>,<span>$class</span>){ <span>$allrs</span><span>=</span><span>$this</span><span>-></span>conn<span>-></span>Execute(<span>$this</span><span>-></span>sqlstr);<span>//执行查询语句</span><span>$record</span><span>=</span>count(<span>$allrs</span><span>-></span>GetRows());<span>//统计记录总数</span><span>$pagecount</span><span>=</span>ceil(<span>$record</span><span>/</span><span>$this</span><span>-></span>pagesize);<span>//计算共有几页</span><span>$str.</span><span>=</span><span>$contentname.</span><span>" "</span><span>.</span><span>$record.</span><span>"& nbsp;"</span><span>.</span><span>$utits.</span><span>" "</span>每 页<span>&</span>nbsp;<span>".$this->pagesize."</span><span>&</span>nbsp;<span>".$utits."</span><span>&</span>nbsp; 第<span>&</span>nbsp;<span>".$this->rs->AbsolutePage()."</span><span>&</span>nbsp;页<span>/</span> 共<span>&</span>nbsp;<span>".$pagecount."</span><span>&</span>nbsp;页<span>"; $str.="</span><span>&</span>nbsp;<span>&</span>nbsp;<span>&</span>nbsp;<span>&</span>nbsp;<span>"; if(!$this->rs->AtFirstPage()) $str.="</span><span>a href<span>=</span><span>".$_SERVER['PHP_SELF']."</span><span>?</span>page<span>=</span><span>1</span><span>&</span> parameter1<span>=</span><span>".$anothersearchstr."</span><span>&</span> parameter2<span>=</span><span>".anothersearchsstrs."</span>class<span>=</span><span>".$class."</span><span>></span> 首页<span>/a<span>></span><span>"; else $str.="</span><span>font color<span>=</span><span>'#555555'</span><span>></span>首页<span>/font<span>></span><span>"; $str.="</span><span>&</span>nbsp<span>"; if(!$this->rs->AtLastPage()) $str.="</span><span>a href<span>=</span><span>".$_SERVER['PHP_SELF']."</span><span>?</span>page<span>=</span> (<span>$this</span><span>-></span>rs<span>-></span>AbsolutePage()<span>+</span><span>1</span>)<span>.</span><span>"& parameter1="</span><span>.</span><span>$anothersearchstr.</span><span>"& parameter2="</span><span>.</span>anothersearchsstrs<span>.</span><span>"class="</span><span>.</span><span>$class.</span><span>"> 下一页"</span>; <span>else</span><span>$str.</span><span>=</span><span>"<font color="#555555">下一页</font>"</span>; <span>$str.</span><span>=</span><span>" "</span>; <span>if</span>(<span>!</span><span>$this</span><span>-></span>rs<span>-></span>AtLastPage()) <span>$str.</span><span>=</span><span>"<a href="</span><span>.</span><span>%24_SERVER</span><span>%5B</span><span>'PHP_SELF'</span><span>%5D</span><span>." parameter1=".$anothersearchstr." parameter2=".anothersearchsstrs." class=".$class."> 尾页</a>"; else $str.="<font color="#555555">尾页</font>"; if(count($this->array)==0 || $this->rs==false) return ""; else return $str; } }</span></span></span></span></span></span></code>').addClass('pre-numbering').hide(); $(this).addClass('has-numbering').parent().append($numbering); for (i = 1; i ').text(i)); }; $numbering.fadeIn(1700); }); });
以上就介紹了 PHP實作資料庫的分頁類,包括了方面的內容,希望對PHP教學有興趣的朋友有幫助。

本文討論了PHP中的crypt()和password_hash()的差異,以進行密碼哈希,重點介紹其實施,安全性和對現代Web應用程序的適用性。

文章討論了通過輸入驗證,輸出編碼以及使用OWASP ESAPI和HTML淨化器之類的工具來防止PHP中的跨站點腳本(XSS)。

自動加載PHP會在需要時自動加載類文件,從而通過減少內存使用和增強代碼組織來提高性能。最佳實踐包括使用PSR-4和有效組織代碼。

本文討論了在PHP中管理文件上傳大小的管理,重點是2MB的默認限制以及如何通過修改PHP.INI設置來增加它。

本文討論了PHP 7.1中引入的PHP中的無效類型,允許變量或參數為指定類型或NULL。它突出顯示了諸如提高可讀性,類型安全性和明確意圖的好處,並解釋瞭如何聲明

本文討論了unset()和unlink()功能在編程中的差異,重點關注其目的和用例。 unset()從內存中刪除變量,而unlink()從文件系統中刪除文件。兩者都對效率至關重要


熱AI工具

Undresser.AI Undress
人工智慧驅動的應用程序,用於創建逼真的裸體照片

AI Clothes Remover
用於從照片中去除衣服的線上人工智慧工具。

Undress AI Tool
免費脫衣圖片

Clothoff.io
AI脫衣器

Video Face Swap
使用我們完全免費的人工智慧換臉工具,輕鬆在任何影片中換臉!

熱門文章

熱工具

Safe Exam Browser
Safe Exam Browser是一個安全的瀏覽器環境,安全地進行線上考試。該軟體將任何電腦變成一個安全的工作站。它控制對任何實用工具的訪問,並防止學生使用未經授權的資源。

EditPlus 中文破解版
體積小,語法高亮,不支援程式碼提示功能

SublimeText3 Linux新版
SublimeText3 Linux最新版

SublimeText3 Mac版
神級程式碼編輯軟體(SublimeText3)

PhpStorm Mac 版本
最新(2018.2.1 )專業的PHP整合開發工具