phprest_api/server.php at master · sasmita22/phprest_api · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
<?php

	function open_window($url){
   		echo '<script>window.location.replace ("'.$url.'", "mywindow","status=0,toolbar=0");</script>';
	};

	$server = "localhost";
	$username = "root";
	$password = "";
	$database = "restoran_db";

	$mysqli = new mysqli($server, $username, $password, $database);


	@$operasi = $_GET['operasi'];

	switch ($operasi) {
		case "view" :
			$result = mysqli_query($mysqli, "SELECT * FROM makanan") or die(mysql_error());
			$data_array = array();
			while ($data = mysqli_fetch_assoc($result)){
				$data_array[] = $data;
			}
			echo json_encode($data_array);

			mysqli_close($mysqli);

			break;

		case "insert" :
			$json_string = file_get_contents('php://input');

			$params = array();
			$params = json_decode($json_string,true);
			//rint(count($params));

			for ($i=0; $i < count($params); $i++) {
				$query = "insert into makanan values('".$params[$i]['id_makanan']."','".$params[$i]['nama']."','".$params[$i]['deskripsi']."','".$params[$i]['harga_beli']."','".$params[$i]['harga_jual']."') ";

				if ($result = mysqli_query($mysqli,$query)){
					print("Seccess!");
				}

			}

			mysqli_close($mysqli);
			break;

		case "get_makanan_by_id" :
			@$id = $_GET['id'];

			$result = mysqli_query($mysqli, "SELECT * FROM makanan WHERE id_makanan = '$id'");
			$data_array = array();

			while ($data = mysqli_fetch_assoc($result)){
				$data_array[] = $data;
			}
			echo json_encode($data_array);

			mysqli_close($mysqli);

			break;

		case "update" :
			@$id = $_GET['id'];


			$json_string = file_get_contents('php://input');

			$params = array();
			$params = json_decode($json_string,true);

			$query = "UPDATE makanan SET nama = '".$params['nama']."' , deskripsi =  '".$params['deskripsi']."' , harga_beli =
			'".$params['harga_beli']."' , harga_jual =  '".$params['harga_jual']."' WHERE id_makanan = '$id'";


			if ($result = mysqli_query($mysqli,$query)){
				print("Seccess Update!");
			} else {
				echo mysqli_error($mysqli);
			}

			mysqli_close($mysqli);
			break;

		case "delete" :
			@$id = $_GET['id'];
			$query = mysqli_query($mysqli, "DELETE FROM makanan WHERE id_makanan = '$id'");

			if ($query) {
            	echo "Delete Data Berhasil";
        	} else {
            	echo mysqli_error($mysqli);
        	}

        	mysqli_close($mysqli);
			break;

		case "tampil_by_id" :
			@$id = $_GET['id'];

			$result = mysqli_query($mysqli, "SELECT * FROM makanan WHERE id_makanan = '$id'");
			$data_array = array();

			while ($data = mysqli_fetch_assoc($result)){
				$data_array[] = $data;
			}

			open_window($data_array[0]['path']);


			break;

		default:
			break;
	}


?>