Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <body>
- <form name="form" action="PUTDBUI.php" method="post">
- <div class="border">
- <div class="header"><img class="image" src="1233.jpg" alt="БД"> Работа с базами данных</div>
- <div class="bd">Справочник "чёрный список ФЛ"</div>
- <div class="find">Найти пользователя по ИИН:<input class="input1" type="number" name="inp1" id="inp1" value="<?php echo $ClientCheckINN ?>"></div>
- <div><button class="but" formmethod="post" name="but1" id="but1">Найти</button><button class="but">Создать</button></div>
- </div>
- <input type="hidden" name="zc" id="zc" value="<?php $ClientCheckINN ?>">
- <?php if (mysqli_num_rows($q) == 0) {
- if ($ClientCheckINN != "") {
- echo 'Клиент не найден в Чёрном списке';
- }
- } else { if ($ClientCheckINN != ""){
- echo '
- <div class="tab">Результаты поиска:</div>';
- echo '<table class="simple-little-table">
- <tr>
- <th class="simple-little-table">Дата добавления</th>
- <th class="simple-little-table">Дата актуальности</th>
- <th class="simple-little-table">Дата завершения</th>
- <th class="simple-little-table">БИН</th>
- <th class="simple-little-table">ФИО</th>
- <th class="simple-little-table">Персона Нонграта</th>
- <th class="simple-little-table">Признак ИП</th>
- <th class="simple-little-table">Срок просрочки</th>
- <th class="simple-little-table">Сумма просрочки</th>
- <th class="simple-little-table">Группа в ЧС</th>
- <th class="simple-little-table">Статус</th>
- <th class="simple-little-table">Причина добавления</th>
- </tr>';
- while($row=mysqli_fetch_array($q))
- {
- echo '
- <input type="hidden" id="Id" name="Id" value="' . $row[0] . '"
- <tr>
- <td class="simple-little-table"><textarea class="inp2" id="ta1' . $Id . '" name="ta1' . $Id . '">' . $row[1] . '</textarea></td>
- <td class="simple-little-table"><textarea class="inp2" id="ta2' . $Id . '" name="ta2' . $Id . '">' . $row[2] . '</textarea></td>
- <td class="simple-little-table"><textarea class="inp2" id="ta3' . $Id . '" name="ta3' . $Id . '">' . $row[3] . '</textarea></td>
- <td class="simple-little-table"><textarea class="inp2" id="ta4' . $Id . '" name="ta4' . $Id . '">' . $row[4] . '</textarea></td>
- <td class="simple-little-table"><textarea class="inp2" id="ta5' . $Id . '" name="ta5' . $Id . '">' . $row[5] . '</textarea></td>
- <td class="simple-little-table"><textarea class="inp2" id="ta6' . $Id . '" name="ta6' . $Id . '">' . $row[6] . '</textarea></td>
- <td class="simple-little-table"><textarea class="inp2" id="ta7' . $Id . '" name="ta7' . $Id . '">' . $row[7] . '</textarea></td>
- <td class="simple-little-table"><textarea class="inp2" id="ta8' . $Id . '" name="ta8' . $Id . '">' . $row[8] . '</textarea></td>
- <td class="simple-little-table"><textarea class="inp2" id="ta9' . $Id . '" name="ta9' . $Id . '">' . $row[9] . '</textarea></td>
- <td class="simple-little-table"><textarea class="inp2" id="ta10' . $Id . '" name="ta10' . $Id . '">' . $row[10] . '</textarea></td>
- <td class="simple-little-table"><textarea class="inp2" id="ta11' . $Id . '" name="ta11' . $Id . '">' . $row[11] . '</textarea></td>
- <td class="simple-little-table"><textarea class="inp2" id="ta12' . $Id . '" name="ta12' . $Id . '">' . $row[12] . '</textarea></td>
- </tr>'; }}
- echo '</table>';
- echo '<button class="but" formmethod="post" name="but4" id="but4">Создать</button>';}?>
- </form>
- </body>
- $servername = "адрес базы";
- $username = "пользователь мой";
- $password = "пароль мой";
- $db = "База";
- $conn = mysqli_connect($servername, $username, $password, $db);
- mysqli_query($conn, "SET NAMES 'utf8' COLLATE 'utf8_general_ci'");
- mysqli_query($conn, "SET CHARACTER SET 'utf8'");
- if (isset($_POST["inp1"])) {
- $ClientCheckINN = $_POST['inp1'];
- } else {
- $ClientCheckINN = "";
- }
- $query = "SELECT * FROM id WHERE (IIN='$ClientCheckINN')";
- $q = mysqli_query($conn, $query);
- $row=mysqli_fetch_array($q);
- if (isset($_POST['but4'])) {
- for ($ll = 0; $ll <= mysqli_num_rows($q); $ll++) {
- $Id{$ll} = $row[0];
- $name = "Id" . $ll;
- }
- if (isset($_POST[$name])) {
- $Id = $_POST[$name];
- }
- print_r($Id);
- $nza = "ta1" . $Id;
- if (isset($_POST[$nza])) {
- $date = $_POST[$nza];
- $query = "UPDATE id SET add_date='2017-01-11' WHERE id_2='" . $Id . "'";
- $result = mysqli_query($conn, $query);
- print_r($result);
- }
- }
- include "DBUI.php";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement