Advertisement
mqpanda

Untitled

Feb 22nd, 2023
911
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 6.62 KB | None | 0 0
  1. AddCar.php
  2. <?php
  3. if ($_SERVER['REQUEST_METHOD'] === 'POST') {
  4.  
  5.     $name = $_POST['Name'];
  6.     $number = $_POST['Number'];
  7.     $connection = mysqli_connect('localhost', 'root', 'root', 'parking');
  8.     $pyk = mysqli_query($connection, "INSERT INTO cars (`carName`, `carNumber`) VALUES ('$name', '$number')");
  9.     mysqli_close($connection);
  10.  
  11.     echo "<h1>Машина добавлена!</h1><br>
  12.        <a href = 'index.php'>Главное меню</a>" . $number;
  13. } else {
  14.  
  15.     echo '
  16.        <form action="/addCar.php" method="POST">
  17.            <label for="Name">Название:</label><br>
  18.            <input type="text" id="Name" name="Name"><br>
  19.            <label for="Number">Номер машины:</label><br>
  20.            <input type="text" id="Number" name="Number"><br><br>
  21.            <input type="submit" value="Submit">
  22.        </form>
  23.        ';
  24. }
  25. Form.php
  26. <meta charset="utf-8">
  27. <?php
  28.     $sql_server = 'localhost';
  29.     $sql_user = 'root';
  30.     $sql_pwd = 'root';
  31.     $sql_db = 'parking';
  32.     $connect = mysqli_connect($sql_server, $sql_user, $sql_pwd, $sql_db);
  33.     if (!$connect) {
  34.         exit("Ошибка " . mysqli_connect_error());
  35.     }
  36.     $res = mysqli_query($connect, "SELECT * FROM places WHERE Reserved = 0;");
  37.     $parkingArr = mysqli_fetch_array($res);
  38.     if(sizeof($parkingArr) == 0)
  39.     {
  40.         echo "Свободных мест нет";
  41.     }
  42.     else
  43.     {
  44.         echo '<h1>Парковка</h1>
  45.              <form action="index.php" method = "GET">
  46.              <p>Номер места
  47.              <select>';
  48.         foreach ($res as $row)
  49.         {
  50.             echo "<option value='" . $row['ID'] . "'>" . $row['ID'] . "</option>";
  51.         }
  52.         echo '</select></p>
  53.        <p>Название машины <input type="text" name = "CarName"></p>
  54.        <p>Номер машины <input type="text" name = "CarNum"></p>
  55.        <p><input type="submit" value = "Занять место"></p>
  56.        </form>';
  57.     }
  58. ?>
  59. Index.php
  60. <?php
  61.  
  62. include 'show.php';
  63.  
  64. echo '
  65.  <a href="\addCar.php"><button>Добавить машину</button></a>
  66.  <a href="\takePlace.php"><button>Занять парковочное место</button></a>
  67.  <a href="\removePlace.php"><button>Освободить парковочное место</button></a><br><br>
  68.  
  69.  <form action="index.php" mothod="GET">
  70.  <button name="button" value="1">Показать парковочные места</button>
  71.  <button name="button" value="2">Показать машины</button>
  72.  ';
  73.  
  74. if ($_GET['button'] == 1)
  75.     show_park();
  76. elseif ($_GET['button'] == 2)
  77.     show_cars();
  78. removePlace.php
  79. <meta charset="utf-8">
  80. <?php
  81.  
  82. if ($_SERVER['REQUEST_METHOD'] === 'POST') {
  83.     $placeID = $_POST['placeID'];
  84.  
  85.     $connect = mysqli_connect('localhost', 'root', 'root', 'parking');
  86.  
  87.     $stmt1 = mysqli_query($connect, "UPDATE places SET `Reserved`=0 WHERE ID = '$placeID'");
  88.     $stmt1 = mysqli_query($connect, "DELETE FROM `parking` WHERE PlaceID = '$placeID'");
  89.  
  90.     mysqli_close($connect);
  91.     echo "<h1>Место свободно!</h1><br>
  92.    <a href = 'index.php'>Главное меню</a>";
  93. } else {
  94.     $connect = mysqli_connect('localhost', 'root', 'root', 'parking');
  95.  
  96.     $resPlaces = mysqli_query($connect, "SELECT * FROM places WHERE Reserved = 1;");
  97.  
  98.     $parkingArr = mysqli_fetch_array($resPlaces);
  99.     if (sizeof($parkingArr) == 0) {
  100.         echo "Все места свободны";
  101.     } else {
  102.         echo "<h1>Парковка</h1>
  103.              <form action='removePlace.php' method = 'POST'>
  104.              <p>Номер места
  105.              <select name='placeID'>";
  106.         foreach ($resPlaces as $row) {
  107.             echo "<option value= " . $row['ID'] . " >" . $row['ID'] . "</option>";
  108.         }
  109.         echo "</select>
  110.        <p><input type='submit' value = 'Освободить место'></p>
  111.        </form>";
  112.     }
  113.     mysqli_close($connect);
  114. }
  115. ?>
  116. show.php
  117. <?php
  118.  
  119. function show_park()
  120. {
  121.     $connect = mysqli_connect('localhost', 'root', 'root', 'parking');
  122.     $resPlaces = mysqli_query($connect, "SELECT * FROM parking");
  123.     echo '<table><tr><th>ID</th><th>Парковочное место</th><th>Машина</th></tr>';
  124.         while($row = mysqli_fetch_array($resPlaces))
  125.         {
  126.             echo '<tr><td>'.$row['ID'].'</td><td>'.$row['PlaceID']."</td><td>".$row['CarID'].'</td></tr>';
  127.         }
  128.         echo '</table>';
  129. }
  130.  
  131. function show_cars()
  132. {
  133.     $connect = mysqli_connect('localhost', 'root', 'root', 'parking');
  134.     $resCars = mysqli_query($connect, "SELECT * FROM cars");
  135.     echo '<table><tr><th>ID</th><th>Название машины</th><th>Номер</th></tr>';
  136.         while($row = mysqli_fetch_array($resCars))
  137.         {
  138.             echo '<tr><td>'.$row['ID'].'</td><td>'.$row['carName']."</td><td>".$row['carNumber'].'</td></tr>';
  139.         }
  140.         echo '</table>';
  141. }
  142. takePlace.php
  143. <meta charset="utf-8">
  144. <?php
  145.  
  146. if ($_SERVER['REQUEST_METHOD'] === 'POST') {
  147.     $placeID = $_POST['placeID'];
  148.     $carID = $_POST['carID'];
  149.  
  150.     $connect = mysqli_connect('localhost', 'root', 'root', 'parking');
  151.  
  152.     $stmt = mysqli_prepare($connect, "INSERT INTO parking (`PlaceID`, `CarID`) VALUES (?, ?)");
  153.     $stmt->bind_param("si", $placeID, $carID);
  154.     $stmt->execute();
  155.     mysqli_stmt_close($stmt);
  156.    
  157.     $stmt1 = mysqli_query($connect, "UPDATE places SET `Reserved`=1 WHERE ID = '$placeID'");
  158.  
  159.     mysqli_close($connect);
  160.     echo "<h1>Место ваше!</h1><br>
  161.    <a href = 'index.php'>Главное меню</a>";
  162. } else {
  163.     $connect = mysqli_connect('localhost', 'root', 'root', 'parking');
  164.  
  165.     $resPlaces = mysqli_query($connect, "SELECT * FROM places WHERE Reserved = 0;");
  166.     $resCars = mysqli_query($connect, "SELECT * FROM cars");
  167.  
  168.     $parkingArr = mysqli_fetch_array($resPlaces);
  169.     if (sizeof($parkingArr) == 0) {
  170.         echo "Свободных мест нет";
  171.     } else {
  172.         echo "<h1>Парковка</h1>
  173.              <form action='takePlace.php' method = 'POST'>
  174.              <p>Номер места
  175.              <select name='placeID'>";
  176.         foreach ($resPlaces as $row) {
  177.             echo "<option value= ". $row['ID'] ." >" . $row['ID'] . "</option>";
  178.         }
  179.         echo "</select>
  180.              <select name='carID'>";
  181.         foreach ($resCars as $row) {
  182.             echo "<option value= ". $row['ID'] ." >" . $row['carName'] . ' | ' . $row['carNumber'] . "</option>";
  183.         }
  184.         echo '</select></p>
  185.        
  186.        <p><input type="submit" value = "Занять место"></p>
  187.        </form>';
  188.     }
  189.     mysqli_close($connect);
  190. }
  191. ?>
  192.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement