Joshua Moore-Oliva wrote:
Try this function... it's one part of a php class I've been thinking about making open-source. Give it any sql statement and a page (0 based for the page) and a number of records for a page and you are set.
I've only tested this on postgresql.
function pageSql( $sql, $page, $recs_per_page ) {
$this->isString( '$sql', $sql );
$this->isInt( '$page', $page );
$this->isInt( '$recs_per_page', $recs_per_page );
$sql = trim( $sql );
$sql = substr( $sql, strlen( "SELECT" ) );
if ( $sql[strlen($sql)-1] != ";" ) {
$sql .= ";";
}
$sql = sprintf( "CREATE TEMP SEQUENCE temp_sequence;\n"
. "CREATE TEMP TABLE temp_table AS\n"
. " SELECT nextval( 'temp_sequence' ) AS temporary_idASDF, %s\n"
. "SELECT ( SELECT COUNT(*) FROM temp_table\n"
. " WHERE temporary_idASDF > %d ) AS recs_remaining, \n"
. " * FROM temp_table\n"
. " WHERE temporary_idASDF > %d\n"
. " AND temporary_idASDF < %d\n"
. " ORDER BY temporary_idASDF;"
, $sql
, ( $page + 1 ) * $recs_per_page + 1
, $page * $recs_per_page
, ( $page + 1 ) * $recs_per_page + 1 );
return $sql;
}
On February 12, 2003 11:58 am, Lucas Lain wrote:
Hi.. i'm new at this mailing list and you can say that i'm a newbie in Php programming :) i dont know how to pass a connection to a database between pages. I want to show the results in multiple pages with a unique connection. can anyone help me? Thanks in advance. Lucas-- Lucas Lain [EMAIL PROTECTED] Argentina
-- Lucas Lain [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
