Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $name = NULL;
- $floor = NULL;
- //sprawdza czy podano name i floor i zwraca potrzebne dane
- if(isset($_POST['name']) && isset($_POST['floor']))
- {
- $name = $_POST['name'];
- $floor = $_POST['floor'];
- $dbconn = new DatabaseConnect;
- $stmt = $dbconn->prepare("select m.id, b.name, m.floor, m.image, m.image_width, m.image_height, m.image_md5 from maps m left join buildings b on m.building_id = b.id where b.name=? and m.floor=?");
- $stmt->bind_param("si",$name,$floor);
- $stmt->execute();
- header('Content-Type: application/json');
- return json_encode($stmt->get_result()->fetch_all(MYSQLI_ASSOC));
- }
- //jesli nie podano floor zwraca wszystkie mapki
- if(isset($_POST['name']))
- {
- $name = $_POST['name'];
- $dbconn = new DatabaseConnect;
- $stmt = $dbconn->prepare("select * from maps left join buildings on maps.building_id = buildings.id where buildings.name=?" );
- $stmt->bind_param("s",$name);
- $stmt->execute();
- header('Content-Type: application/json');
- return json_encode($stmt->get_result()->fetch_all(MYSQLI_ASSOC));
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement