Documentation

MySqlDb

PHP class Database name should be provided once needed.

Table of Contents

$db  : mixed
For sotring database connection reference.
$query  : mixed
$settings  : mixed
For sotring database settings.
__construct()  : void
Set the values.
close()  : void
Close database connection.
count()  : bool
Prepare a query to count data from database.
createDb()  : bool
Creating database if not exists.
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.
dbSettings()  : void
Database default setting.

Properties

$db

For sotring database connection reference.

private mixed $db

$settings

For sotring database settings.

private mixed $settings

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 —

createDb()

Creating database if not exists.

public createDb( $name) : bool
Parameters
$name :

name of database

Return values
bool —

createTbl()

Creating table.

public createTbl( $dbname, mixed $sql) : bool
Parameters
$dbname :

name of database $sql => for creating tables

$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
$name :

name of database

Return values
bool —

deleteTbl()

Deleting table if not exists.

public deleteTbl( $dbname, mixed $table) : bool
Parameters
$dbname :

name of database $table => $table name

$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
$string :
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
Parameters
$status :

true : false true means open false colse

Return values
bool —

dbSettings()

Database default setting.

private dbSettings( $host, mixed $user, mixed $pass) : void
Parameters
$host :

Database host $user Database user $pass Database pass

$user : mixed
$pass : mixed
Return values
void —

Search results