0

Сделали подключение к базе данных, форму, проверили, что эта форма отдаёт значения, но в самой базе новых записей не появляется, как бы не старались, ничего не получается.
Не могли бы вы подсказать, в чём может возникнуть проблема?

Файл db.php

<?php
        $user = 'root';
        $password = 'root';  
      try {
        $db = new PDO("mysql:host=localhost; dbname=baza1", $user, $password);
      } catch (Exception $e) {
        echo $e->getMessage();
      }

Файл api.php

    <?php
function getChastById($db, $id) {
    $sql = "SELECT * FROM chast
    WHERE id_chast = :id_chast 
    ";

    $stmt = $db->prepare($sql);
    $stmt->bindValue('id_chast', $id, PDO::PARAM_INT);
    $stmt->execute();
    $row = $stmt->fetch(PDO::FETCH_ASSOC);
    return $row;
}

function getAllDivizii ($db) {
    $sql = "SELECT * FROM diviziya";
    $res = array();
    $stmt = $db->prepare($sql);
    $stmt->execute();
    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
        $res[$row['id_divizii']] = $row;
    }
    return $res;
}

function getAlldislokatsii ($db) {
    $sql = "SELECT * FROM dislokatsiya";
    $res1 = array();
    $stmt = $db->prepare($sql);
    $stmt->execute();
    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
        $res1[$row['id_dislokatsii']] = $row;
    }
    return $res1;
}
function getAllcorpusa ($db) {
    $sql = "SELECT * FROM corpus";
    $res2 = array();
    $stmt = $db->prepare($sql);
    $stmt->execute();
    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
        $res2[$row['id_corpusa']] = $row;
    }
    return $res2;
}
function getAllArmii ($db) {
    $sql = "SELECT * FROM armiya";
    $res3 = array();
    $stmt = $db->prepare($sql);
    $stmt->execute();
    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
        $res3[$row['id_armii']] = $row;
    }
    return $res3;
}
    function addChast($db, $chastId, $nomerChasti, $diviziyaId, $dislokatsiyaId, $nomerCorpusa, $nomerArmii) {
        $sql =  $db->prepare("INSERT INTO `chast` (`id_chast`, `nomer_chasti`, `kod_diviziya`, `kod_dislokatsiya`, `kod_corpusa`, `kod_armii`) VALUES(:id_chast, :nomer_chasti, :kod_diviziya, :kod_dislokatsiya, :kod_corpusa, :kod_armii)");
        $sql->bindValue(':id_chast', $chastId, PDO::PARAM_INT);
        $sql->bindValue(':nomer_chasti', $nomerChasti, PDO::PARAM_INT);
        $sql->bindValue(':kod_diviziya', $diviziyaId, PDO::PARAM_INT);
        $sql->bindValue(':kod_dislokatsiya', $dislokatsiyaId, PDO::PARAM_INT);
        $sql->bindValue(':kod_corpusa', $nomerCorpusa, PDO::PARAM_INT);
        $sql->bindValue(':kod_armii', $nomerArmii, PDO::PARAM_INT);
        $sql->execute();
    }

Файл chast.php

...
        <?php include 'db.php'; ?>
                <?php include 'api.php'; ?>
        <div>

            <button id="addButton" class="btn btn-default" style="margin-left: 15px">Добавить новую запись</button>

            <form action="" method="POST" role="form" style="display: none; margin-top: 20px;">

            <div class="form-group col-md-2">
              <label for="">id части</label>
              <input type="text" class="form-control" id="chastId" name="chastId">
            </div>
            <div class="form-group col-md-2">
              <label for="">Номер части</label>
              <input type="text" class="form-control" id="nomerChasti" name="nomerChasti">
            </div>
            <div class="form-group col-md-2">
              <label for="">Дивизия</label>
              <select id="diviziyaId" name="diviziyaId" class="form-control">
                <?php
                $divizii = getAllDivizii($db);
                foreach ($divizii as $key => $value) {
                    echo "<option value=".$value['id_divizii'].">".$value['nazvanieDivizii']."</option>";
                }
                ?>
              </select>
            </div>
            <div class="form-group col-md-2">
              <label for="">Дислокация</label>
              <select id="dislokatsiyaId" name="dislokatsiyaId" class="form-control">
                <?php
                $dislokatsii = getAlldislokatsii($db);
                foreach ($dislokatsii as $key => $value) {
                    echo "<option value=".$value['id_dislokatsii'].">".$value['nazvanieDislokatsii']."</option>";
                }
                ?>
              </select>
            </div>
                <div class="form-group col-md-2">
              <label for="">Код корпуса</label>
              <select id="$nomerCorpusa" name="$nomerCorpusa" class="form-control">
                <?php
                $corpusa = getAllcorpusa($db);
                foreach ($corpusa as $key => $value) {
                    echo "<option value=".$value['id_corpusa'].">".$value['nomer_corpusa']."</option>";
                }
                ?>
              </select>
            </div>
                <div class="form-group col-md-2">
              <label for="">Код армии</label>
              <select id="$nomerArmii" name="$nomerArmii" class="form-control">
                <?php
                $armii = getAllArmii($db);
                foreach ($armii as $key => $value) {
                    echo "<option value=".$value['id_armii'].">".$value['nomer_armii']."</option>";
                }
                ?>
              </select>
            </div>
          <button type="submit" class="btn btn-primary" style="margin-left: 15px;">Добавить</button>
        </form>
        </div>

        <?php
        var_dump($_POST);
            $chastId = $_POST['chastId'];
            $nomerChasti = $_POST['nomerChasti'];
            $diviziyaId = $_POST['diviziyaId'];
            $dislokatsiyaId = $_POST['dislokatsiyaId'];
            $nomerCorpusa = $_POST['nomerCorpusa'];
            $nomerArmii = $_POST['nomerArmii'];
        ?>
        <script>
                $("#addButton").click(function(){
                    $("form").slideDown();
                });
            </script>
    ...

0 Answers0