Create, Read, Update, Delete wrapper for MySQL. Simple, easy to use class using PDO for simplifing redundant MySQL connections and methods.
$crud = crud::obtain('localhost', 'databaseUsername', 'databasePassword', 'databaseName');$result = $crud->query("SELECT * FROM your_table");
print_r($result);$data['firstname'] = 'Jack';
$data['lastname'] = 'Jones';
$crud->insert('your_table', $data);$data['firstname'] = 'Joe';
$data['lastname'] = 'Mama';
$crud->update('your_table', $data, 'user_id=4');$crud->delete('your_table', 'id=123');Empties all data from the table.
$crud->truncate('your_table');Completely deletes the table.
$crud->drop('your_table');