Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- header('Content-Type: application/json ');
- $servername = "localhost";
- $username = "root";
- $password = "root";
- $database = "base";
- $conn = new mysqli($servername, $username, $password, $database);
- if ($conn->connect_error) {
- die("Ошибка соединения: " . $conn->connect_error);
- }
- $massiv = array();
- $id = isset($_GET['id']) ? $_GET['id'] : '';
- $sql = "SELECT * FROM express where id between ($id+1) and ($id+20) ";
- $stmt = $conn->prepare($sql); $stmt->execute();
- $stmt->bind_result($id, $type, $added, $start, $finish, $kapper, $kf, $opisanie);
- while($stmt->fetch()){
- $temp = [
- 'id'=>+$id,
- 'type'=>$type,
- 'added'=>$added,
- 'start'=>$start,
- 'finish'=>$finish,
- 'kapper'=>$kapper,
- 'kf'=>$kf,
- 'opisanie'=>$opisanie
- ];
- array_push($massiv, $temp);
- }
- echo json_encode($massiv);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement