<?php
include("db.php");
$proses = $_GET["a"];
switch($proses){
case "insert":
	$name = $_POST["barang"];
	$price =$_POST["harga"];
	$pict = $_FILES["pic"]["type"];
	$temp = explode(".", $_FILES["pic"]["name"]);
	$ext = $temp[count($temp)-1];
	$sql ="INSERT INTO barang(nama,harga,extensi_gambar) VALUES (".$name.",".$price.".".$ext.")";
	$result = mysqli_query($link,$sql);
	if($result)
	{
		echo "data saved";
	}
	else {
		echo"sql error";
	}
	break;
case "update":
	$name = $_POST["barang"];
	$price =$_POST["harga"];
	$pict = $_FILES["pic"]["type"];
	$temp =explode(".", $_FILES["pic"]["name"]);
	$ext = $temp(count($temp)-1);
	$sql ="SELECT * FROM barang where nama =".$name;
	$result = mysqli_query($link, $sql);
	if($result)
	{
		$sql1 = "UPDATE barang set nama='". $name . ",harga =".$price.",extensi_gambar" . $ext. "'";
		$result1 = mysqli_query($link, $sql1);
		echo "SAVED";
	}
	else {
		echo"sql error";
	}
	break;
case "delete":
	$name = $_POST["barang"];
	$price =$_POST["harga"];
	$pict = $_FILES["pic"]["type"];
	$temp =explode(".", $_FILES["pic"]["name"]);
	$ext = $temp(count($temp)-1);
	$sql ="SELECT * FROM barang where nama =".$name;
	$result = mysqli_query($link, $sql);
	if($result)
	{
		$sql1 = "DELETE from barang where nama=". $name ;
		$result1 = mysqli_query($link, $sql1);
		echo "SAVED";
	}
	else {
		echo"sql error";
	}
	break;
}



?>