Guys, help, please, I can not find the info.
There is a php code:
<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>
And to it the PUT file:
$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";
As you can see, the fields are added dynamically (how many were found) Each field is a textarea, I need to change the database when I click "save" when I change each field.
The records in the database differ by user only by id, but I do not understand how to transfer it to PUT correctly.