<?php
/*
* sql functions
*/
include('config.php');

#connect
function connect(){
   $conn = mysqli_connect(HOST, USER, PASS, DB);
 if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
}
   return $conn;
}

#query function
function query($sql)
{
    $conn = connect();
    $result = mysqli_query($conn,$sql) or die(mysqli_error());
    return $result;
}

#result from db.
 function result($sql) {

    $conn = connect();
        $result = mysqli_query($conn,$sql) or die(mysqli_error($conn));
    while ($row = mysqli_fetch_array($result)) {
        $rows[] = $row;
    }
    return $row;
}


#insert to database
function insert($sql)
{
    $conn = connect();
    #sql query.
    $result = mysqli_query($conn,$sql) or die(mysqli_error($conn));
    if($result){
        return true;
    }  else {
        return false;
    }

}


#products sql functions

#view products
function viewProducts()
{
        $conn = connect();
        $result = mysqli_query($conn,'select * from vare') or die(mysqli_error($conn));
    if(!$result){
            return false;
        }else{
        return $result;
        }
};

#

#insert products
function creatProducts($vgid, $vareName, $Pris, $Beskrivelse,$antal,$img)
{
    $img = array();
    $conn = connect();
    $sql = 'INSERT INTO vare (vgid,vareName,Pris,Beskrivelse,antal,img_1,img_2,img_3,img_4) VALUES ()';
    $result = mysqli_query($conn,$sql) or die(mysqli_error($conn));
}

#update products
function UpdateProducts($vgid, $vareName, $Pris, $Beskrivelse,$antal,$img)
{
    $conn = connect();
    $sql = 'UPDATE SET vare vgid,vareName,Pris,Beskrivelse,antal,img_1,img_2,img_3,img_4 WHERE $vgid';
    $result = mysqli_query($conn,$sql) or die(mysqli_error($conn));
}


#view products
function DeleteProducts($vgid)
{
    $conn = connect();
    $sql = 'DELETE FROM vare WHERE vgID="'.$vgid.'"';
    $result = mysqli_query($conn,$sql) or die(mysqli_error($conn));
    return $result;

}


#select spefikt vare.
function viewProduct($vgid)
{
        $conn = connect();
        $result = mysqli_query($conn,'select * from vare where vgID="'.$vgid.'"') or die(mysqli_error($conn));
    if(!$result){
            return false;
        }else{
        return $result;
        }
};




$vgid = 2;
#$result = viewProducts();
$result = DeleteProducts($vgid);
if(!$result){
    echo "Er ikke slettet. id:".$vgid."";
}else{
    echo 'Det er slettet.';
}

#while($row = mysqli_fetch_array($result)){
#    echo $row['vareName'];
#}

//$menu = query('select * from test');
//foreach ($menu as $row){
//    echo $row['name'];
//}

#$indhold = "hejsa med dig";
#$result = insert('insert into test (name) values ("'.$indhold.'")');

?>