SqLite
PHP class Database name should be provided once needed.
Table of Contents
- $db : mixed
- For sotring database connection reference.
- $query : mixed
- __construct() : void
- Set the values.
- close() : void
- Close database connection.
- count() : bool
- Prepare a query to count data from database.
- createTbl() : bool
- Creating table.
- delete() : bool
- Prepare a query to delete data from database.
- deleteDb() : bool
- Deleting database if not exists.
- deleteTbl() : bool
- Deleting table if not exists.
- insert() : integar
- Prepare a query to insert into db.
- quote() : string
- quote the string.
- select() : bool
- Prepare a query to select data from database.
- update() : bool
- Prepare a query to Update data in database.
- connect() : bool
- Open database connection.
Properties
$db
For sotring database connection reference.
private
mixed
$db
$query
private
mixed
$query
Methods
__construct()
Set the values.
public
__construct() : void
Return values
void —close()
Close database connection.
public
close() : void
Return values
void —count()
Prepare a query to count data from database.
public
count( $params) : bool
Parameters
- $params :
-
array(); 'table' Names of table 'db_name' => Database name 'columns' Names of columnswant to select 'wheres' Specify a selection *
Return values
bool —createTbl()
Creating table.
public
createTbl(mixed $sql) : bool
Parameters
- $sql : mixed
Return values
bool —delete()
Prepare a query to delete data from database.
public
delete( $params) : bool
Parameters
- $params :
-
array array(); 'table' Names of table 'db_name' => Database name 'wheres' Specify a selection criteria to get required records
Return values
bool —deleteDb()
Deleting database if not exists.
public
deleteDb( $name) : bool
Parameters
Return values
bool —deleteTbl()
Deleting table if not exists.
public
deleteTbl(mixed $table) : bool
Parameters
- $table : mixed
Return values
bool —insert()
Prepare a query to insert into db.
public
insert(mixed $params) : integar
Parameters
- $params : mixed
Return values
integar —or boolean
quote()
quote the string.
public
quote( $string) : string
Parameters
Return values
string —select()
Prepare a query to select data from database.
public
select(mixed $params) : bool
Parameters
- $params : mixed
Return values
bool —update()
Prepare a query to Update data in database.
public
update(mixed $params) : bool
Parameters
- $params : mixed
Return values
bool —connect()
Open database connection.
private
connect( $status) : bool