}
//Once that you have execute any query, you can get total rows.
echo "Total rows: " . $db->rowCount() . "<br>";
$rs = null;
//You can delete rows from table with two methods...
//Method 1
$db->query("DELETE FROM TB_USERS WHERE ID=1;");
//Method 2 table condition without "WHERE"
$getAffectedRows = $db->delete("TB_USERS", "ID=1");
//You can update rows from table with two methods...
//Method 1
$db->query("UPDATE TB_USERS SET COMPANY='Freelancer MX' WHERE ID=2;");
//Method 2 table set new data [field=data] condition without "WHERE"
$getAffectedRows = $db->delete("TB_USERS", "NAME='wArLeY996',COMPANY='Freelancer MX'", "ID=2");
//If you need get columns name, you can do it...
$column_array = $db->columns("TB_USERS");
if ($column_array != false) {
foreach ($column_array as $column) {
echo "{$column}<br>";
}
} else {
echo "ERROR";
}
$column_array = null;
//If you need get all tables from you database...
$rs = $db->ShowTables("DB_NAME");
//Depending of your type database you can specify the database
foreach ($rs as $row) {
$tmp_table = $row[0];
echo "The table from database is: ({$tmp_table})<br>";
}
