<?php

class Database {

    public function connect_db() {
        $this->connection = mysqli_connect('localhost', 'DEHU', 'A12b3c4d', 'order_user');
        if(mysqli_connect_error()) {
            die("Database Connection Failed" . mysqli_connect_error() . mysqli_connect_errno());
        }
    }
}

$database = new Database();
$database->connect_db();

public function create($cname, $user, $email, $pass, $fname, $lname);
    $sql = "INSERT INTO 'order_user' (company, user, email, pass, firstname, lastname) VALUES ('$cname', '$user', '$email', '$pass', '$fname', '$lname')";
    $res = mysqli_query($this->connection, $sql);
    if($res) {
        return true;
    } else {
        return false;
    }

public function read() {
    $sql = "SELECT * FROM 'order_user'";
    $res = mysqli_query($this->connection, $sql);
    return $res;
}

public function update(($cname, $user, $email, $pass, $fname, $lname, $id){
    $sql = "UPDATE `order_user` SET company='$cname' username='$user', email='$email', password='$pass' firstname='$fname', lastname='$lname', WHERE id=$id";
    if($res) {
        return true;
    } else {
        return false;
    }

}

public function delete($id) {
    $sql = "DELETE FROM 'order_user' WHERE id=$id";
    $res = mysqli_query($this->connection, $sql);
    if($res) {
        return true;
    } else {
        return false;
    }
}
?>