* helpful in cases where searching float values stored on varchar fields
* $db->PGetAll($sql, array('s' => 99.3, 1));
*/
$sql = 'SELECT * FROM tests WHERE id=? AND col1=?';
$rs = $db->PGetAll($sql, array(3, 's' => 'string'));
var_dump($rs);
/**
* using the Prepare method,
* Useful when building dynamic queries that require prepared statements
* The prepare method automatically detect the input type,
* you can also override this, using something like: Prepare('s','1e1');
* if no input it will return the array with the prepared statements
*/
$X = 3;
$id = 1;
$db->Prepare($id);
$sql = 'SELECT * FROM tests WHERE id=? ';
if ($X == 3) {
$db->Prepare($X);
$sql .= 'AND id !=? ';
}
$db->Prepare('s', 'ai eu');
$sql .= 'AND col1=?';
/**
* this will produce a query like:
* "sql: SELECT * FROM tests WHERE id=? AND id !=? AND col1=?" with params = ["iis",1,3,"ai eu"]
*/
echo "sql: {$sql}", PHP_EOL;
echo 'Args: ', PHP_EOL;
print_r($db->Prepare());
$rs = $db->PgetAll($sql, $db->Prepare());
