Home

📔 Documentation

Standard implementation

$db = new slsql(array("dbName" => "myDB"));
$db->connect();
$result = $db->send('SELECT * FROM user WHERE id = ?', array("1"))
echo var_dump($result);

Simplified

$db = new slsql(array("dbName" => "myDB"));
$result = $db->send('SELECT * FROM user WHERE id = ?', array("1"))
echo var_dump($result);

Static implementation

$result = slsql::go('SELECT * FROM user WHERE id = ?', array("1"));
echo var_dump($result);

🧾 Commands (object slsql)

Contruct($params)

IN : $params = array([dbName*, host, dbType, user, psw ])

*Required

connect()

Not mandatory. During "send()" method the object creates the connection if it does not exist.

Connect to database.

Return :

• [status] = true(OK)/false(Problem),
• [message] = Exception message => if [status] = false

send($query, $params)

Send Request.

!!! send($query, $params) -> https://secure.php.net/manual/en/pdo.prepare.php

IN : ($request, $array) :

• Request : sql request
• Array: Array with data insertion

Return :

• [value] = result,
• [status] = true(OK)/false(Problem),
• [message] = Exception message => if [status] = false

🧾 Commands (static)

go($request, $array)

Send Request.

!! The parameters are in the .env file

IN : ($request, $array) :

• Request : sql request
• Array: Array with data insertion

Return :

• [value] = result,
• [status] = true(OK)/false(Problem),
• [message] = Exception message => if [status] = false