License: MIT

This PHP class lat you perform Mysqli prepared statements in just one line.

Documenttation:

The first and only parameter in the constructer is an array with host, username, password and database name for the mysql server

$sqli = new sqli(["127.0.0.1", "", "", "test"]);

Find more examples in Example.php

$query - standard sql statement with question marks as placeholders

$dataMode - string with the number of variables and length of string, types must match the parameters in the statement.

i for integer

d for double

s for string

b for blob and will be sent in packets

$parameters - array of variables for the placehoders

All the metohed retun a standart object with following parameters, and some more for the spefic methodes

status: true if the prepare method in the ordinery mysqli class return true

error_msg: error from the connection if the prepare methode returns false

affected_rows: affected rows from the sql statement

$sqli->push("insert into test (msg) VALUES (?)", "s", "Just a test");

Find more examples in Example.php

Do also return following:

id: the id there has ben insert if sql statement was a insert statement

$sqli->pull_once("SELECT msg as message FROM test WHERE id=?", "i", 1);

Find more examples in Example.php

Do also return following:

data: array of the feilds of the (first) row there has ben selected, empty array of nothing has ben selected

count: the row count there has ben selected from the sql statement

$sqli->pull_multiple("SELECT id, msg as message FROM test");

Find more examples in Example.php

Do also return following:

data: array of the rows there has ben selected from the sql statement, each item is a array of the feilds

count: the row count there has ben selected from the sql statement