Now my pagination is all right, just read all the data on the first page, how can I segment the data? I can not use limit, because it is for Oracle operation, I just want to use this for ($i = $start; $i < $end; $i + +) loop to segment the data, thank you, who can help?
------Solution--------------------
It's very convenient to use ADODB.
------Solution--------------------
SELECT * FROM (select RowNum rm,s_qzjx_azsqd.* from S_QZJX_AZSQD) where s_qzjx_azsqd.ejdwbm= ' $coid ' and s_qzjx_azsqd.sub STR (sblbdm,1,2) = ' $id ' and rm> =1 and RM <=10 1 to 10 rows in Oracle----
------Solution--------------------
Don't use anything that's not universal!
If you are MySQL, use the legendary top paging feature--limit!!
If the MSSQL is alive with other databases, please use the Mosaic SELECT statement to page out! Make sure you use the cool!
Hey, the specific method is not to publish, is not published ~ And so I finished writing functions, a piece of post it
------Solution--------------------
"The first page reads out all the data." If you save an array, you're going to end up with a subscript.
------Solution--------------------
$totalpage = $i/$msgnum;
if ($page > $totalpage) {$page = $totalpage;}
if ($totalpage > Round ($totalpage)) {$totalpage =round ($totalpage) +1;}
else{$totalpage =round ($totalpage);}
\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
There's also a problem here $page will appear decimals, I will write:
$totalpage =ceil ($i/$msgnum);
if ($page > $totalpage) {$page = $totalpage;}
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.