//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>";
}
//If you need get all databases...
$rs = $db->ShowDBS();
//Depending of your type database you can get results
foreach ($rs as $row) {
$tmp_table = $row[0];
echo "Database named: ({$tmp_table})<br>";
}
//Disconnect from database
$db->disconnect();
/******************************************
