clearLimit

clearLimit

_{[easySQLite3 >= v0.1.0 (Beta)]}

Clear the records limit that was set using setLimit() function.

Description

clearLimit( void ) : boolean

This function is used to clear the records limit for querying/updating/deleting records of the database that was set using setLimit() function.

Parameters

None.

Return Values

The function returns a boolean value. It returns true after clearing the records limit.

Examples

Example #1 : Clear records limit

include "easySQLite3.class.php";

$db = new easySQLite3("database.sqlite");

$db->setLimit( 5, 10 );

echo "Before clearing the records limit:-\n";

var_dump( $db->getLimit() );

$db->clearLimit();

echo "\nAfter clearing the records limit:-\n";

var_dump( $db->getLimit() );

This will output:

Before clearing the records limit:-
string(17) "LIMIT 5 OFFSET 10"

After clearing the records limit:-
string(0) ""

Notes

Related Functions

• setLimit - Set the records limit for querying/updating/deleting records of the database.
• getLimit - Get the records limit for querying/updating/deleting records of the database that was set using setLimit() function.
• showRecords - Show records of a database using prepared statement.
• updateRecords - Update records of a database using prepared statement.
• deleteRecords - Delete records from a database using prepared statement.

Back to Functions list