getRooms.php

<?php


$conn = new mysqli("localhost", "example", "password", "yourDB");



// Check connection



if ($conn->connect_error) {



    die("Connection failed: " . $conn->connect_error);

echo 'error hai';



	

}

$sql ="SELECT * from Rooms";

$result = $conn->query($sql);


$rooms= array();

while($row = $result->fetch_assoc())
{
	$obj= array();
	array_push($obj,$row['rid']);
	array_push($obj,$row['room_name']);
	
	
	array_push($rooms,$obj);

}
echo json_encode($rooms);
	



?>