lul

<?php
$username = "root";
$password = "";
$conn = new PDO('mysql:host=localhost;dbname=Mobile',$username,$password);
// variable dalemnya//
$kosIDweb;
$kosNameweb;
$addressweb;
$regionweb;
$cityweb;
$provinceweb;
$countryweb;
$pricelowestweb;
$pricehighestweb;
$additionaldetailsweb;
$latitudeweb;
$longitudeweb;
$emailweb;
//  //
$queryselectupdate = "select * from kos where kosID = 1";
$stmt = $conn->prepare($queryselectupdate);
$stmt->execute();
$result = $stmt->fetch();
?>
<!DOCTYPE html>
<html>
<head>
	<title>testing web service</title>
</head>
<body>
Ini Buat Insert
<form method="get">
	<input type="text" name='kosNameweb'>kosName
	<br>
	<input type="text" name='addressweb'>address
	<br>
	<input type="text" name='regionweb'>region
	<br>
	<input type="text" name='cityweb'>city
	<br>
	<input type="text" name='provinceweb'>province
	<br>
	<input type="text" name='countryweb'>country
	<br>
	<input type="text" name='pricelowestweb'>price lowest
	<br>
	<input type="text" name='pricehighestweb'>price highest
	<br>
	<input type="text" name='additionaldetailsweb'>additionaldetails
	<br>
	<input type="text" name='latitudeweb'>latitude
	<br>
	<input type="text" name='longitudeweb'>longitude
	<br>
	<input type="text" name='emailweb'>email
	<br>
	<button type="submit" name='insert'>insert</button>
</form>
=================================================
<br>
Ini buat Update
<?php
echo "
<form method = 'get'>
	<input type='text' name='kosNameweb' value='".$result['kosID']."' disabled>kosID
	<br>
	<input type='text' name='kosNameweb' value='".$result['kosName']."'>kosName
	<br>
	<input type='text' name='addressweb' value='".$result['address']."'>address
	<br>
	<input type='text' name='regionweb' value='".$result['region']."'>region
	<br>
	<input type='text' name='cityweb' value='".$result['city']."'>city
	<br>
	<input type='text' name='provinceweb' value='".$result['province']."'>province
	<br>
	<input type='text' name='countryweb' value='".$result['country']."'>country
	<br>
	<input type='text' name='pricelowestweb' value='".$result['priceLowest']."'>price lowest
	<br>
	<input type='text' name='pricehighestweb' value='".$result['priceHighest']."'>price highest
	<br>
	<input type='text' name='additionaldetailsweb' value='".$result['additionalDetails']."'>additionaldetails
	<br>
	<input type='text' name='latitudeweb' value='".$result['latitute']."'>latitude
	<br>
	<input type='text' name='longitudeweb' value='".$result['longitude']."'>longitude
	<br>
	<input type='text' name='emailweb' value='".$result['email']."'>email
	<br>
	<button type='submit' name='update'>update</button>
</form>
"?>
<br>
</body>
</html>
<?php

//buat insert
if(isset($_GET['insert'])){
$kosNameweb = $_GET['kosNameweb'];
$addressweb = $_GET['addressweb'];
$regionweb = $_GET['regionweb'];
$cityweb = $_GET['cityweb'];
$provinceweb = $_GET['provinceweb'];
$countryweb = $_GET['countryweb'];
$pricelowestweb = $_GET['pricelowestweb'];
$pricehighestweb = $_GET['pricehighestweb'];
$additionaldetailsweb = $_GET['additionaldetailsweb'];
$latitudeweb = $_GET['latitudeweb'];
$longitudeweb = $_GET['longitudeweb'];
$emailweb = $_GET['emailweb'];
$queryinsert = "INSERT INTO `kos` (`kosID`, `kosName`, `address`, `region`, `city`, `province`, `country`, `priceLowest`, `priceHighest`, `additionalDetails`, `latitute`, `longitude`, `email`) VALUES (NULL, '$kosNameweb', '$addressweb', '$regionweb', '$cityweb', '$provinceweb', '$countryweb', '$pricelowestweb', '$pricehighestweb', '$additionaldetailsweb', '$latitudeweb', '$longitudeweb', '$emailweb')";
$stmt = $conn->query($queryinsert);
}


$queryselect = "select * from kos";
$queryupdate = "UPDATE `kos` SET /*yang mau diganti */ WHERE `kos`.`kosID` = 1";
$querydelete = "delete from kos where kosID = ";

$stmt = $conn->query($queryselect);
$test;
class kos{
	public $kosID;
	public $kosName = "";
	public $address = "";
	public $region = "";
	public $city = "";
	public $province = "";
	public $country = "";
	public $pricelowest;
	public $pricehighest;
	public $additionaldetails;
	public $latitude;
	public $longitude;
	public $email;

	function __construct($kosID,$kosName,$address,$region,$city,$province,$country,$pricelowest,$pricehighest,$additionaldetails,$latitude,$longitude,$email){
		$this->kosID = $kosID;
		$this->kosName = $kosName;
		$this->address = $address;
		$this->region = $region;
		$this->city = $city;
		$this->province = $province;
		$this->country = $country;
		$this->pricelowest = $pricelowest;
		$this->pricehighest = $pricehighest;
		$this->additionaldetails = $additionaldetails;
		$this->latitude = $latitude;
		$this->longitude = $longitude;
		$this->email = $email;
	}
}
$kosarray = array();
foreach($stmt as $lol){
$ganteng = new kos($lol[0],$lol[1],$lol[2],$lol[3],$lol[4],$lol[5],$lol[6],$lol[7],$lol[8],$lol[9],$lol[10],$lol[11],$lol[12]);
$kosarray[] = $ganteng;
};
$json = json_encode($kosarray);
echo $json;
echo "<br>";
$decoded = json_decode($json);
echo "<br>";
var_dump($decoded);
echo "<br>";
echo $decoded[1]->kosName;

?>