简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Backend Development > PHP Tutorial > body text

An example of paging display of ODBC data using PHP_PHP tutorial

WBOY
Release： 2016-07-21 16:01:42
Original
915 people have browsed it

$pagesize = 2; //The number of records displayed on one page

$con = odbc_connect("access_test","","",SQL_CUR_USE_ODBC) or die("Unable to connect to ODBC data source access_test"); // Connect an ODBC data source
$sql = "select count(*) as total from test"; //Get the total number of records SQL statement
$rst = odbc_exec($con,$sql) or die("$sql Query error"); //Execute the SQL statement to get the total number of records
$recordcount = odbc_result($rst,1); //Get the total number of records, you can also use $recordcount = odbc_result($rst,"total") here ;
odbc_free_result($rst); //Release resources

$pagecount = bcdiv($recordcount+$pagesize-1,$pagesize,0); //Calculate the total number of pages

if(!isset($page)) $page = 1; //If no page number is specified, the default is to display the first page
if($page<1) $page = 1; //If the page number is greater than 1 If the page number is small, the first page will be displayed
if($page>$pagecount) $page = $pagecount; //If the page number is larger than the total number of pages, the last page will be displayed

if($page> 0){ //The page number is larger than 0, indicating that there is data
echo '>> paging';
echo 'Home page ';
if($page>1){
echo ' ';
}
else{
echo 'Previous page';
}
if($page<$pagecount){
echo '< ;a href="' . $PHP_SELF . '?page='. ($page+1) . '">Next page ';
}
else{
echo ' Next page';
}
echo 'Last page ';
echo 'Page: ' . $page . '/' . $pagecount . 'Page';
echo $pagesize . 'Bar/page';
echo 'Total' . $recordcount . 'Bar';

$sql = "select * from test"; //Get data SQL statement
$rst = odbc_exec($con,$sql) or die("$sql query error"); //Execute to get data SQL statement

$fieldcount = odbc_num_fields($rst); //Get the total number of fields

echo '

';
echo '';
for($i=1;$i<=$fieldcount;$i++){
echo ''; //Display $i field name
}
echo '';
$rowi = ($page-1)* $pagesize+1;
for($i=0;$i<$pagesize;$i++){
echo '';
if($rowi>$recordcount){
for($j=0;$j<$fieldcount;$j++){
echo '';
}
}
else{
odbc_fetch_into($rst,$rowi,&$row);
for($j=0;$j<$fieldcount;$j++){
$field = $row[$j];
if ($field=='') $field = ' ';
             echo '
' .odbc_field_name($rst, $i) . '
' . ;
                                                                                                                                                                                                                                                                                    ; 🎜>}
else{
echo "No data";
}

odbc_close($con); //Close the connection and release resources
?>



www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/316761.htmlTechArticle$pagesize = 2; //The number of records displayed on one page $con = odbc_connect(access_test,,,SQL_CUR_USE_ODBC) or die(Unable to connect to ODBC data source access_test); //Connect to an ODBC data source $sql = select co...
Related labels：
odbc php Pagination accomplish number data show use Record
source：php.cn
Previous article：PHP and XML: Using expat function (2)_PHP tutorial Next article：PHP and XML: Using the expat function (3)_PHP Tutorial
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
PHP arrays obtained from URL parameters do not behave as expected I have a URL parameter that contains the category ID and I want to treat it as an array li...
From 2024-04-06 22:09:02
0
1
1428
Move the content to the left by adding the Width property I have provided margins to the body. main {left margin: 200px; right margin: 200px; text a...
From 2024-04-06 22:01:35
0
3
816
Where should I place CustomLog directive in apache I'm using php:7.2-apachedocker. I need to disable health check url login access log. Based...
From 2024-04-06 22:03:59
0
1
990
The page suddenly cannot pull css or bootstrap So I'm developing a page, I did part of it yesterday and it worked great, and today I cont...
From 2024-04-06 21:58:04
0
1
800
Dynamically modify inline CSS styles in Javafx I'm trying to change the background image of a pane when the application is maximized. My ...
From 2024-04-06 20:57:16
0
1
487
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！