php高效率獲取數(shù)據(jù)分頁
Jun 13, 2016 pm 12:00 PM
php高效獲取數(shù)據(jù)分頁
mysql.php 獲取數(shù)據(jù)庫中的記錄，完全個(gè)人經(jīng)驗(yàn)總結(jié)，僅供參考！
/**
*PHP+MYSQL數(shù)據(jù)庫基本功能
*http://blog.csdn.net/yown
*/
############################################
#獲取序列ID
############################################
function getSequence() {
$sql = "update sequence set id=last_insert_id(id+1);";
$sql2= "select last_insert_id();";
global $dbuser,$dbpass,$host,$database,$printsql;
$link = mysql_connect($host,$dbuser,$dbpass);
if(! $link){
? return mysql_error();
}
mysql_select_db($database);
mysql_query("SET NAMES UTF8");?
if($printsql) echo "
".$sql."
";
mysql_query($sql);
if($printsql) echo "
".$sql2."
";
$result = mysql_query($sql2);
if(mysql_num_rows($result)==0){
? mysql_close($link);
? return "";
}
$myrow = mysql_fetch_row($result);
$ret=$myrow[0];
mysql_close($link);
return $ret;
}
############################################
#獲取strSql第N條記錄中的第N列數(shù)據(jù),下標(biāo)從1開始
############################################
function getData($strsql,$row,$col) {
global $dbuser,$dbpass,$host,$database,$printsql;
$link = mysql_connect($host,$dbuser,$dbpass);
if(! $link){
? return mysql_error();
}
mysql_select_db($database);
mysql_query("SET NAMES UTF8");?
if($printsql) echo "
".$strsql."
";
$result = mysql_query($strsql);
if(mysql_num_rows($result)==0){
? mysql_close($link);
? return "";
}
$i=0;
while($myrow = mysql_fetch_row($result)){
?? if($i==$row-1){
????? $ret=$myrow[$col-1];
??? ? break;
?? }
?? $i=$i+1;
}
mysql_close($link);
return $ret;
}
############################################
#獲取strSql第N條記錄
############################################
function getRowData($strsql,$row) {
global $dbuser,$dbpass,$host,$database,$printsql;
$link = mysql_connect($host,$dbuser,$dbpass);
if(! $link){
? return mysql_error();
}
mysql_select_db($database);
mysql_query("SET NAMES UTF8");?
if($printsql) echo "
".$strsql."
";
$result = mysql_query($strsql);
if(mysql_num_rows($result)==0){
? mysql_close($link);
? return "";
}
$i=0;
while($myrow = mysql_fetch_array($result)){
?? if($i==$row-1){
????? $ret=$myrow;
??? ? break;
?? }
?? $i=$i+1;
}
mysql_close($link);
return $ret;
}
############################################
#獲取strSql記錄集存入數(shù)組中
############################################
function getResultSetData($strsql) {
global $dbuser,$dbpass,$host,$database,$printsql;
$link = mysql_connect($host,$dbuser,$dbpass);
if(! $link){
? return mysql_error();
}
mysql_select_db($database);
mysql_query("SET NAMES UTF8");?
if($printsql) echo "
".$strsql."
";
$result = mysql_query($strsql);
if(mysql_num_rows($result)==0){
? mysql_close($link);
? return "";
}
while($myrow = mysql_fetch_array($result)){
????? $ret[]=$myrow;??? ?
}
mysql_close($link);
return $ret;
}
############################################
#執(zhí)行strSql
############################################
function executeSql($strsql) {
global $dbuser,$dbpass,$host,$database,$printsql;
$link = mysql_connect($host,$dbuser,$dbpass);
if(! $link){
? return mysql_error();
}
mysql_select_db($database);
mysql_query("SET NAMES UTF8");?
if($printsql) echo "
".$strsql."
";
mysql_query($strsql);
$ret =mysql_affected_rows($link);
mysql_close($link);
return $ret;
}
/*
?分頁
*/
?function Pager(&$curpage,&$pagesize,&$tsql,&$psql,&$totalpage,&$totalrow,&$pagerset){
?$curpage=isset($curpage)?intval($curpage):1;//當(dāng)前頁
?$totalpage=0;//總頁數(shù)
?$totalrow=0;//總記錄數(shù)
?if($printsql) echo "
".$tsql."
";
?if($curpage
?? $curpage=1;
?}
?
?$totalrow=getData($tsql,1,1);//取得總記錄數(shù)
?$totalrow=strlen(totalrow)==0?0:$totalrow;?
?if($totalrow>0){
?? $totalpage=$totalrow%$pagesize==0?(int)($totalrow/$pagesize):(int)($totalrow/$pagesize)+1;
??? if($curpage>$totalpage){
????? $curpage=1;
?? }
??????
?? $psql=$psql." limit ".(($curpage-1)*$pagesize).",".$pagesize;
??? if($printsql) echo "
".$psql."
";?
??? $pagerset=getResultSetData($psql);//取得當(dāng)前頁記錄
?}
?if($totalrow==0||$totalrow=="0"){ $curpage=1;}
?
}
?>
? 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
1783
16
1728
56
1579
28
1443
31
MySQL?? mysqldump? ???? ?? ??? ?????
Jul 06, 2025 am 02:55 AM
MySQLDump? MySQL ??????? ??? ??? ???? ???? ?????. ??????? ???? ?? ?? ? ?? ?? ???? SQL ??? ?????. 1. ?? ??? ????? ??? ?????? ??? ???? ??? SQL ???? ?????. 2. ??? ?????? ?? ??? ??? ???? TB ?? ???? ?? ???? ???? ????. 3. ???? ???-single transaction,-databases,-all-databases,-routines ?; 4. MySQL ??? ???? ?? ?? ?? ?? ?? ? ??? ?? ??? ???? ? ????. 5. ??? ????? ????? ?? ? ?? ??? ???? ?? ????.
MySQL ? ? ???? NULL ?? ?????
Jul 05, 2025 am 02:46 AM
MySQL?? NULL ?? ?? ? ? 1. ???? ?? ? ? ? ??? NotNull? ???? ?? ??? NULL? ?????. 2. iSnull ?? ISNOTNULL = ??! =; 3. Ifnull ?? Coalesce ??? ????? ???? ???? ? ??? ? ????. 4. ?? ?? ????? NULL ?? ?? ??? ?? ???? ??? ?? ? ORM ??? ?? ?? ?????? ??????. NULL? ???? ?? ?? ???? ??? ???? ?? ?? ?? ????. ??? ???? ??, ?? ? ???? ?? ? ??? ?? ??? ??? ?? ???????. ??? ??? ???? ??? ?? ?? ??? ????? ?? ? ????.
MySQL?? ??? ?? ???? ???? ??? ????.
Jul 05, 2025 am 02:42 AM
GroupBy? ???? ???? ????? ?? ??? ???? ? ???? ??? ? ??? ????? ? ?????. ?? ??, GroupByCustomer_ID? ???? ? ??? ? ???? ??? ? ????. ???? ? 1,000 ? ??? ? ??? ??? ?? ? ? ????. ?? ? ? ?? ??? GroupBy? ??????, ?? ?? ?? ???? ???? ??? ??? ? ? ????. ???? ???? ? ??? ? ??, ?? ?? ??? ? ?? ???? ???? ?????.
MySQL?? ?? ? ????? ??? ?????
Jul 05, 2025 am 02:41 AM
MySQL ???? ????? Limit and Offset? ???? ????? ??? ??? ?? ??? ?? ????. 1. ?? ? ???? ?? ????, ???? ?? ??? ????, ??? limitnoffsetm???. 2. ?? ??? ??? ???? ??? ??? ???? ???? ??? ????. 3. ??? ???? ?? ???, ??? ??? ? ??? ?? ??? ?????. 4. ?? ???? ?? ???? ??? ???? ?? ? ?? ?? ?? ???? ???? ????. ???? ?????. "?? ???"??? ???? ??? ??? ???? ????.
MySQL?? ???? ?? ? ?? ?? ??
Jul 08, 2025 am 02:50 AM
MySQL? ???? ??? ???? InnoDB ?? ??? ???? ??? ???? ???? ?????. 1. ????? ??? SQL ?? ????, ?? ?? ?? ?? ??? ?????. 2. ? ???? ???, ???, ?? ? ???? ?????. 3. ????? ???? ????? ??? STARTTRANSACTION, CONMING ? ROLLBACK???. 4. 4 ?? ?? ???? ?? ??, ?? ? ??, ?? ??? ?? ? ???? ?????. 5. ????? ???? ???? ?? ??? ??? ?? ??? ?? ?? ? ??? ????? ??????. ??? ????? ?? MySQL? ?? ???? ?? ??? ?? ? ? ????.
MySQL?? ?????? ? ??? ?? ??
Jul 06, 2025 am 02:41 AM
MySQL ?????? ? ???? ??? ??? information_schema? ?? ????? ?? ? ??? ??? ? ????. 1. ?? ?????? ?? ?? : SQL ?? ???? selecttable_schemaas'database ', sum (data_length index_length)/1024/1024as'size (mb) 'frominformation_schema.tablessgroupbytable_schema; ?? ??????? ? ??? ??? ?? ??????? ???? ??? ?? ? ? ????. 2. ?? ??? ??? ?????? : selectta? ??????
MySQL?? ??? ?? ? ???? ??? ?????
Jul 08, 2025 am 02:51 AM
?? ?? ? ?? ?? ??? ??? ??? ?????? ?? ??? ??? ?????? ??? ?????? ?????? ??? ?????. ? ?? ?? ???? ????. ??, ??????, ??? ? ??? ?? ??? UTF8MB4? ???? ???? ShowCreatedAtabase/Table? ???? ? Alter ??? ??????. ??, ?????? ??? ? UTF8MB4 ?? ??? ???? ?? ?? ??? ????? SetNames? ??????. ??, ?? ??? ????? ???? UTF8MB4_UNICODE_CI? ???? ?? ? ????? ???? ???? ?????? ???? ?? ? ? ?? ?? ??? ????? ??????.
MySQL?? ??? 1 ? ?? ??? ?????
Jul 06, 2025 am 02:52 AM
MySQL? ??? ??? ???? ??? ????? ?? ??? ?????. 1. ??? ?? ??, ?? ??? ????? ?? ? ?? ID? ???? ?? ???? ???? ?? ?? ??? ??????. 2. MySQLDump? ???? ??? ????? ???? ???? ???? ??? ?????. 3. ???? ??? ?? ID ? ??? ??? ???? Changemaster ??? ???? ??? ?????? ???? ?? ???? ??????. 4. ????, ??, ??? ??? ? ?? ?? ??? ?? ???? ??? ???? ?? ??? ????????. ?? ??? ?? ??? ???? ?????? ??????.
