PHP link excelsql paging the following is a PHP link excel program. if I want to set pagination, what should I do? Selecttop11 * from [Sheet1 $]; in this way, 11 records can be selected for the next time, but what should I do after 11 records? Please help me. PHPcode & lt ;? Php $ co PHP link excel SQL paging
Below is the PHP link excel program. if I want to set pagination, what should I do? Select top 11 * from [Sheet1 $]; in this way, 11 records can be selected for the next time, but what should I do after 11 records? Please help me.
PHP code
Open ($ connstr); $ SQL = "select top 11 * from [Sheet1 $]"; $ rs = $ conn-> execute ($ SQL ); if ($ rs-> eof | $ rs-> bof) {echo "no book information! ";} Else {while (! $ Rs-> eof) {?>
Fields (number); echo $ fields-> value;?>
Fields (title); echo $ fields-> value;?>
Fields (datetime); echo $ fields-> value;?>
Fields (sale); echo $ fields-> value;?>
Movenext ;}}?>
------ Solution --------------------
$ Conn = new com ("adodb. connection ");
You can use SQL statements for database operations.
In fact, you can use the PHPExcel class for excel operations.
