<?php

class Database
{
    private $con;

    function __construct()
    {
    $this->con = mysqli_connect("localhost", "root", "", "winkeldb") or die ("Verbinding mislukt!");
    }

    function addKlant($user, $pass, $naam, $adres, $email, $postcode, $woonplaats, $geslacht, $geboortedatum, $nieuwsbrief)
    {
    $query = "INSERT INTO klant VALUES (0,'$user','$pass','$naam','$adres','$email','$postcode','$woonplaats','$geslacht','$geboortedatum','$nieuwsbrief',NULL)";
    mysqli_query($this->con, $query) or die ("Query mislukt!");
    }
    function getKlantemail($email)
    {
    $query = "SELECT * FROM klant where email = '$email' ";
    return mysqli_query($this->con, $query);
    }

    function addProduct($naam, $omschrijving, $prijs, $file_name)
    {
    $query = "INSERT INTO product VALUES (0,'$naam', '$omschrijving', $prijs, '$file_name')";
    mysqli_query($this->con, $query) or die ("Query mislukt!");
    }

    function getProducts()
    {
    $query = "SELECT * FROM product ";
    return mysqli_query($this->con, $query);
    }
    function getProduct($id)
    {
    $query = "SELECT * FROM product WHERE id = $id ";
    return mysqli_query($this->con, $query);
    }
    function editProduct($id,$naam,$omschrijving,$prijs,$file_name)
    {
    $query = "UPDATE product SET naam='$naam', omschrijving='$omschrijving',prijs='$prijs',pic='$file_name' WHERE id = $id ";
    return mysqli_query($this->con, $query);
    }
    function delProduct($id)
    {
    $query = "DELETE FROM product WHERE id = $id";
    mysqli_query($this->con, $query);
    }
    function getLogin($user,$pass)
    {
    $query = "SELECT naam,admin FROM klant WHERE username = '$user' AND password = '$pass' ";
    return mysqli_query($this->con, $query);
    }
    function getCat($id)
    {
    $query = "SELECT * FROM categorie WHERE id = $id ";
    return mysqli_query($this->con, $query);
    }
    function getAllCat()
    {
    $query = "SELECT * FROM categorie ";
    return mysqli_query($this->con, $query);
    }

    function addCat($naam)
    {
    $query = "INSERT INTO categorie VALUE (0,'$naam')";
    mysqli_query($this->con, $query);
    }

        function delCat($id)
    {
    $query = "DELETE FROM categorie WHERE id = $id";
    mysqli_query($this->con, $query);
    }


        function delCatPic($id)
    {
    $query = "DELETE FROM foto WHERE cat_id = $id";
    mysqli_query($this->con, $query);
    }


}

?>