mysql+php分頁類（已測(cè)）
Jun 13, 2016 pm 12:30 PM
復(fù)制代碼 代碼如下:
/*?????
mysql_pager.class.php?????
三個(gè)參數(shù)。?mysql_query()的結(jié)果,?url變量page,?您要的每頁記錄數(shù)?????
例子在這個(gè)文件底部?????
淡水河邊整理測(cè)試?????
*/??????
class?mysql_pager?{??????
??//?define?properties??????
??var?$page;??????
??var?$result;??????
??var?$results_per_page?=?3;??????
??var?$total_pages;????????
/*???????
Define?the?methods?????
??下面是構(gòu)造函數(shù)，和類同名（>php4）?????
???需要查詢的結(jié)果句柄，當(dāng)前頁碼，每頁記錄數(shù)?????
???like:??$f->mysql_pager($result,?1,?15);?????
*/??????
function?mysql_pager(?$result,?$current_page,?$results_per_page?)?{??????
????if(!$result){??????
????????echo?"
????????return;??????
????????}??????
???$this->result?=?$result;??????
???if(!$current_page?||?$current_page?????????$this->page?=?1;??????
???else?$this->page?=?$current_page;??????
???if(!emptyempty($results_per_page))????????
??????$this->results_per_page?=?$results_per_page;??????
???$numrows?=?@mysql_num_rows($this->result);????????
???if(!$numrows)?{??????
??????echo?"
??????return;??????
??????}??????
???$this->total_pages?=?ceil($numrows?/?$this->results_per_page);????????
}??????
/*???????
??下面是打印內(nèi)容的函數(shù)，可以不用，也可以根據(jù)自己的需要擴(kuò)展?????
??這里只是打印出id?????
*/??????
function?print_paged_results()?{????????
????echo?"
| ".?$row["id"]?.?" |
}??????
/*???????
??下面是打印頁碼和鏈接的函數(shù)?????
??在我們需要顯示頁碼的地方調(diào)用?????
*/??????
function?print_navigation()?{??????
????global?$PHP_SELF;??????
????echo?"
????for($i?=?1;?$i?total_pages;?$i++)?{?#loop?to?print?>????????
???????if($i?==?1?&&?$this->page?>?1)??#Prints?the???????????echo?"page?-?1)."\"?onMouseOver=\"status="Previous?Page";return?true;\"?onMouseOut=\"status="?";return?true;\">?";????????
???????if($i?==?$this->page)??#Doesn"t?print?a?link?itself,?just?prints?page?number???????
??????????echo?"?$i?";????????
???????if($i?!=?$this->page)??#Other?links?that?aren"t?this?page?go?here???????
??????????echo?"?$i?";????????
???????if($i?==?$this->total_pages?&&?$this->page?!=?$this->total_pages)??#??Link?for?next?page?>>??(not?on?last?page)????????
??????????echo?"page?+?1)."\"?onMouseOver=\"status="Go?to?the?Next?Page";return?true;\"?onMouseOut=\"status="?";return?true;\">?";????????
???????}??????
????echo?"
??}??????
}??????
/*?????
???mysql_connect($server,?$uname,?$pass?);?????
???mysql_select_db("$db");?????
???$result=?@mysql_query("Select?*?FROM?table");?????
???$p?=?new?mysql_pager(?$result,?$page=$_GET["page"],?10?);?????
???$p->print_navigation();?????
???$p->print_paged_results();?????
???$p->print_navigation();?????
*/??????
?>?
? AI ??
Undress AI Tool
??? ???? ??
Undresser.AI Undress
???? ?? ??? ??? ?? AI ?? ?
AI Clothes Remover
???? ?? ???? ??? AI ?????.
Clothoff.io
AI ? ???
Video Face Swap
??? ??? AI ?? ?? ??? ???? ?? ???? ??? ?? ????!
?? ??
??? ??
???++7.3.1
???? ?? ?? ?? ???
SublimeText3 ??? ??
??? ??, ???? ?? ????.
???? 13.0.1 ???
??? PHP ?? ?? ??
???? CS6
??? ? ?? ??
SublimeText3 Mac ??
? ??? ?? ?? ?????(SublimeText3)
??? ??
8638
17
1784
16
1729
56
1580
28
1444
31
??? ??? ?? ?? : PHP ???
Jul 15, 2025 am 02:48 AM
phphasthreecommentstyles : //, #forsingle-lineand/.../formulti-lline.usecommentstoexplainwhycodeexists, notwhatitdoes.marktodo/fixMeitemsandDisableCodeTemporlinlyDuingDeBugging.aVoidOver-commentingsimplOgic.writeCoCoCoCoCoConcomeCOCOCOCONCOCOCOCOCOCOCOCOCISE
Windows? PHP? ???? ??
Jul 15, 2025 am 02:46 AM
Windows? PHP? ???? ?? ???? ??? ?????. 1. ??? PHP ??? ?????? ?? ??????. Apache? ?? ThreadSafe ??? ????? Nginx??? ThreadSafe ??? ???? ?? ????. 2. php.ini ??? ???? php.ini-development ?? php.ini-production? php.ini? ?????. 3. ?? ? ??? ?? ??? ?? ?? ??? PHP ??? ??????. 4. PHP? ????? ?????? ??? ????? ?? ?? ?? PHP-V? ???? ?? ??? ???? ?? ?? ??? ??????. 5. Apache? ???? ?? httpd.conf?? p? ???????.
PHP ?? : ??
Jul 15, 2025 am 02:46 AM
PHP? ?? ???? 4 ?? ?? ??? ?????. 1. PHP ??? ?????? ??? ??? ???? ?? ?????. 2. Echo ? Print? ????? ?? ???? ????, ??? Echo? ?? ?? ??? ?????? ??????. 3. ?? ???? ?? ???? ??????? //, # ? //; 4. ? ??? ?????? ????? ??? ?? ????? ??? ??? ??? ?? ???? ??? ????. ??? ?? ??? ????? ???? ???? PHP ??? ???? ? ??? ? ? ????.
? ?? PHP ???? : ???? ??
Jul 16, 2025 am 03:42 AM
? ?? PHP ???? ??? ???? ??? ?????? ?? ?? ?? ??? ???? XAMPP/MAMP/LAMP? ?? ? ?? ??? ???? ???? ??? ???? ??? ?????. ??, hello.php?? ??? ??? ?? ??? ???? ???? ??????. ??, PHP ? HTML? ???? ?? ??? ??? ???? ?? ????. ?????, ???? ??, ?? ?? ? ?? ?? ??? ?? ???? ?????? ???? ???? ?? ????? ???????.
PHP ? ???? ??? ??????
Jul 16, 2025 am 03:45 AM
phpisaserver-sideScriptingLanguageUsedForWebDevelopment, ?? ProcessesData, InteractSwithDatabases ? SendShtmlTobrowsers.commonusesincludeusera-sectentication, e-commerceplatforms
PHP 8 ?? ???
Jul 16, 2025 am 03:41 AM
???? PHP8? ???? ??? ??? ????. 1. ????? ??? ?? ????; 2. PHP8 ? ?? ?? ??? ??????. 3. ??? ????? ????? ??? ??????. 4. ??? ?? ?? ??? ??????. Windows ???? Zip ???? ?????? ?? ?? ? ?? ?? ??? ???? ???? ????? ?? ??? ??? ?? ? ? ????. MACOS ???? Homebrew? ???? ? ??, PHP8 ??, ?? ?? ?? ? ?? ??? ?? ??? ???? ?? ????. ?? ??? ?? ????? ???? ????? ????? ??? ?? ??? ??? ??? ? ????.
PHP?? ?? ?? (??/??)? ??? ??????
Jul 16, 2025 am 03:48 AM
ToHandleFileOperationsInphp, useAppreptFunctionsandModes.1.TOREADAFILE, USEFILE_GET_CONTENTS () FORSMALLFILESORFGETS () inALOOPFORLE-by-lineProcessing.2.TOWRITETOAFILE, USEFILE_PUTE_CONTENTS () USEFILE_PUTE_CONTENTS () FORSIMPLEWRITE () FORSIMPLAGFILE (ORFENDFLAG)
??? ???? ?? ?????? ? ?????
Jul 15, 2025 am 02:54 AM
?, ApythonclasscanhavemultiplecontructorsthrowaltiveTechniques.1.usedefaultargumentsinthe__init__methodtoallowflexibleinitializationswithvaryingnumbersofparameters.2.defineclassmethodsasaltistuctructorsforcecalobbebcreati
