connection = mysqli_connect($host, $user, $password, $dbname);
if (mysqli_connect_errno()) {
return "Failed to connect to MySQL: " . mysqli_connect_error();
exit();
}
}
function check_table_exists($table)
{
$this->table_name = $table;
$sql = "SHOW TABLES LIKE '$table' ";
$result = mysqli_query($this->connection, $sql);
if (mysqli_num_rows($result) > 0) {
return true;
} else {
return false;
}
}
public function query($table_name, $sql)
{
$this->sql = $sql;
$this->table_name = $table_name;
// if (!$this->check_table_exists($table_name)) {
// echo "[SQL] TABLE NAME DOES NOT EXIST OR IS INCORRECT $table_name";
// }
$result = mysqli_query($this->connection, $this->sql);
if (mysqli_error($this->connection)) {
echo "[SQL QUERY FAILED] on " . $_SERVER['REQUEST_URI'] . " at line " . __LINE__ . ": " . mysqli_error($this->connection) . "
";
echo "[SQL QUERY]: " . $sql;
exit();
} else {
if (stripos(trim($sql), 'INSERT') === 0) {
return mysqli_insert_id($this->connection);
} else {
return $result;
}
}
}
}
class nav
{
/**
* Start Navbar
*/
function __construct()
{
?>