<?php
	// $servername = "localhost";
	// $username = "root";
	// $password = "";
	// $dbname = "PortalLokalBandung";

	$servername = "localhost";
	$username = "1293089";
	$password = "081362369204";
	$dbname = "1293089";

	// MySQL Main Database name: 1293089
	// MySQL Database username: 1293089
	// MySQL Database password: equal with account password
	// MySQL Database host: localhost

	// in: query basis data yang ingin dieksekusi
	// proses:	1. Buka koneksi ke basis data
	//			2. Periksa koneksi,
	//			   jika gagal maka selesai, mengembalikan objek array {error: true, data: $conn->connect_error}
	//			3. Melakukan eksekusi query ke basis data
	//			4. Periksa error eksekusi basis data
	//			   jika terjadi kesalahan maka mengembalikan pesan error
	//			5. Menutup koneksi basis data
	//			6. Mengembalikan data hasil eksekusi query pada basis data, dengan format:
	// out:	{
	//		error: false,
	//		data: <hasil eksekusi query>
	// }
	function __do__query($query){
		global $servername, $username, $password, $dbname;

		// Create connection
		$conn = new mysqli($servername, $username, $password, $dbname);

		// Check connection
		// ERROR: Gagal melakukan koneksi ke database
		if ($conn->connect_error)
		    return (object)array(
		    	'error' => true,
		    	'data' => $conn->connect_error
		    );

		// Request query
		$hasil = $conn->query($query);

		// Iniatializing error message variable
		$errorDB = "";

		// If query error, get the error message
		if(!$hasil)
			$errorDB = $conn->error;

		// Close connection
		$conn->close();

		// If query succes return result
		// ERROR: Gagal melakukan query pada databse
		if($hasil == true)
		    return (object)array(
		    	'error' => false,
		    	'data' => $hasil
		    );

		// Else return error message
	    return (object)array(
	    	'error' => true,
	    	'data' => $errorDB
	    );
	}


	// ------------------
	// Contoh Select Data
	$query2 = "SELECT UID, nama, status, photoURL, WisataID, judul, isi, photos, likes, dislikes, tanggal, (SELECT EXISTS(SELECT UID FROM LikeDislike WHERE UID = $u AND LikeDislike.WisataID = Wisata.WisataID AND isLike=1)) as have_likes, (SELECT EXISTS(SELECT UID FROM LikeDislike WHERE UID = $u AND LikeDislike.WisataID = Wisata.WisataID AND isLike=0)) as have_dislikes FROM Wisata NATURAL JOIN BuatPosting NATURAL JOIN Pengguna ORDER BY tanggal DESC LIMIT 10;";
	$retval2 = __do__query($query2);
	$value2 = array();
	while($temp = $retval2->data->fetch_assoc()){
		array_push($value2, $temp);
	}

    // output data ke interface user pelaku
	echo json_encode(array("error" => false, "data" => $value2));


	// ------------------
	// Contoh Update Data
	$query3 = "UPDATE Pengguna SET nama=\"$nama\", photoURL=\"$def_pp\", status=\"$status\" WHERE UID=\"$uid\";";
	$retval3 = __do__query($query3);
	$value3 = $retval3->data;


	// ------------------
	// Contoh Insert Data
	$query = "INSERT INTO Komentar(WisataID, UID, isi) VALUES (\"$wid\", \"$uid\", \"$komentar\")";
	$retval3 = __do__query($query);
	$value3 = $retval3->data;

?>