PHP Database::feelArray Examples

Example #1

File: sampleEasyMysqli.php Project: AllanKlaus/easymysqli

 *
*/
$db = new Database();
$table = 'tb_users';
//If you want to debug SQL user the debug true
$debug = false;
$arrayInsert['user'] = '******';
$arrayInsert['email'] = 'userEmail';
$arrayInsert['pass'] = '******';
// ENCRYPT IT
//Using insert command
$db->insert($table, $arrayInsert, $debug);
//You can omit $debug like this
//$db->insert($table, $arrayInsert);
//Use simple select command
$result = $db->select($table);
//Using select with WHERE
$whereSelect = 'WHERE id = 1';
$result = $db->select($table, $whereSelect);
//Get result by select
$row = $db->feelArray($result);
//Using update command
$arrayWhere['user'] = '******';
$arrayWhere['email'] = 'updateUserEmail';
$arrayWhere['pass'] = '******';
// ENCRYPT IT
$arrayWhere['id'] = 1;
$db->update($table, $arrayUpdate, $arrayWhere);
//Using delete command
$arrayDelete['id'] = 1;
$db->insert($table, $arrayDelete);