Advertisement
Guest User

Untitled

a guest
Mar 16th, 2019
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.74 KB | None | 0 0
  1. <body>
  2. <form name="form" action="PUTDBUI.php" method="post">
  3. <div class="border">
  4. <div class="header"><img class="image" src="1233.jpg" alt="БД"> Работа с базами данных</div>
  5. <div class="bd">Справочник "чёрный список ФЛ"</div>
  6. <div class="find">Найти пользователя по ИИН:<input class="input1" type="number" name="inp1" id="inp1" value="<?php echo $ClientCheckINN ?>"></div>
  7. <div><button class="but" formmethod="post" name="but1" id="but1">Найти</button><button class="but">Создать</button></div>
  8. </div>
  9. <input type="hidden" name="zc" id="zc" value="<?php $ClientCheckINN ?>">
  10. <?php if (mysqli_num_rows($q) == 0) {
  11. if ($ClientCheckINN != "") {
  12. echo 'Клиент не найден в Чёрном списке';
  13. }
  14. } else { if ($ClientCheckINN != ""){
  15. echo '
  16. <div class="tab">Результаты поиска:</div>';
  17. echo '<table class="simple-little-table">
  18. <tr>
  19. <th class="simple-little-table">Дата добавления</th>
  20. <th class="simple-little-table">Дата актуальности</th>
  21. <th class="simple-little-table">Дата завершения</th>
  22. <th class="simple-little-table">БИН</th>
  23. <th class="simple-little-table">ФИО</th>
  24. <th class="simple-little-table">Персона Нонграта</th>
  25. <th class="simple-little-table">Признак ИП</th>
  26. <th class="simple-little-table">Срок просрочки</th>
  27. <th class="simple-little-table">Сумма просрочки</th>
  28. <th class="simple-little-table">Группа в ЧС</th>
  29. <th class="simple-little-table">Статус</th>
  30. <th class="simple-little-table">Причина добавления</th>
  31. </tr>';
  32. while($row=mysqli_fetch_array($q))
  33. {
  34. echo '
  35. <input type="hidden" id="Id" name="Id" value="' . $row[0] . '"
  36. <tr>
  37. <td class="simple-little-table"><textarea class="inp2" id="ta1' . $Id . '" name="ta1' . $Id . '">' . $row[1] . '</textarea></td>
  38. <td class="simple-little-table"><textarea class="inp2" id="ta2' . $Id . '" name="ta2' . $Id . '">' . $row[2] . '</textarea></td>
  39. <td class="simple-little-table"><textarea class="inp2" id="ta3' . $Id . '" name="ta3' . $Id . '">' . $row[3] . '</textarea></td>
  40. <td class="simple-little-table"><textarea class="inp2" id="ta4' . $Id . '" name="ta4' . $Id . '">' . $row[4] . '</textarea></td>
  41. <td class="simple-little-table"><textarea class="inp2" id="ta5' . $Id . '" name="ta5' . $Id . '">' . $row[5] . '</textarea></td>
  42. <td class="simple-little-table"><textarea class="inp2" id="ta6' . $Id . '" name="ta6' . $Id . '">' . $row[6] . '</textarea></td>
  43. <td class="simple-little-table"><textarea class="inp2" id="ta7' . $Id . '" name="ta7' . $Id . '">' . $row[7] . '</textarea></td>
  44. <td class="simple-little-table"><textarea class="inp2" id="ta8' . $Id . '" name="ta8' . $Id . '">' . $row[8] . '</textarea></td>
  45. <td class="simple-little-table"><textarea class="inp2" id="ta9' . $Id . '" name="ta9' . $Id . '">' . $row[9] . '</textarea></td>
  46. <td class="simple-little-table"><textarea class="inp2" id="ta10' . $Id . '" name="ta10' . $Id . '">' . $row[10] . '</textarea></td>
  47. <td class="simple-little-table"><textarea class="inp2" id="ta11' . $Id . '" name="ta11' . $Id . '">' . $row[11] . '</textarea></td>
  48. <td class="simple-little-table"><textarea class="inp2" id="ta12' . $Id . '" name="ta12' . $Id . '">' . $row[12] . '</textarea></td>
  49. </tr>'; }}
  50. echo '</table>';
  51. echo '<button class="but" formmethod="post" name="but4" id="but4">Создать</button>';}?>
  52. </form>
  53. </body>
  54.  
  55. $servername = "адрес базы";
  56. $username = "пользователь мой";
  57. $password = "пароль мой";
  58. $db = "База";
  59. $conn = mysqli_connect($servername, $username, $password, $db);
  60. mysqli_query($conn, "SET NAMES 'utf8' COLLATE 'utf8_general_ci'");
  61. mysqli_query($conn, "SET CHARACTER SET 'utf8'");
  62. if (isset($_POST["inp1"])) {
  63. $ClientCheckINN = $_POST['inp1'];
  64. } else {
  65. $ClientCheckINN = "";
  66. }
  67. $query = "SELECT * FROM id WHERE (IIN='$ClientCheckINN')";
  68. $q = mysqli_query($conn, $query);
  69. $row=mysqli_fetch_array($q);
  70.  
  71. if (isset($_POST['but4'])) {
  72. for ($ll = 0; $ll <= mysqli_num_rows($q); $ll++) {
  73. $Id{$ll} = $row[0];
  74. $name = "Id" . $ll;
  75. }
  76. if (isset($_POST[$name])) {
  77. $Id = $_POST[$name];
  78. }
  79. print_r($Id);
  80. $nza = "ta1" . $Id;
  81. if (isset($_POST[$nza])) {
  82. $date = $_POST[$nza];
  83. $query = "UPDATE id SET add_date='2017-01-11' WHERE id_2='" . $Id . "'";
  84. $result = mysqli_query($conn, $query);
  85. print_r($result);
  86. }
  87. }
  88.  
  89.  
  90. include "DBUI.php";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement