Guest User

Untitled

a guest
May 30th, 2018
156
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.97 KB | None | 0 0
  1. <form action="" method="POST">
  2. <div class="table1">
  3. <table class="table_price">
  4. <caption>Таблица №1</caption>
  5. <tr>
  6. <th>Наименование</th>
  7. <th colspan="2">Запись</th>
  8. </tr>
  9. <tr>
  10. <td>Насос 1</td>
  11. <td><input type="number" name="Pump_1" id="" value="<?php echo ($result['Pump_1']); ?>" min="0" max="100" step="1"></td>
  12. <td><input type="button" class="but1" name="b1" value="Обработать" ></td>
  13. </tr>
  14. <tr>
  15. <td>Насос 2</td>
  16. <td><input type="number" name="Pump_1" id="" value="<?php echo ($result['Pump_1']); ?>" min="0" max="100" step="1"></td>
  17. <td><input type="button" class="but1" name="b2" value="Обработать" ></td>
  18. </tr>
  19. <tr>
  20. <td>Насос 3</td>
  21. <td><input type="number" name="Pump_1" id="" value="<?php echo ($result['Pump_1']); ?>" min="0" max="100" step="1"></td>
  22. <td><input type="button" class="but1" name="b3" value="Обработать" ></td>
  23. </tr>
  24. <tr>
  25. <td>Насос 4</td>
  26. <td><input type="number" name="Pump_1" id="" value="<?php echo ($result['Pump_1']); ?>" min="0" max="100" step="1"></td>
  27. <td><input type="button" class="but1" name="b4" value="Обработать" ></td>
  28. </tr>
  29.  
  30. <?php
  31. $sql = mysqli_query($link ,"SELECT `ID`, `Pump_1`, FROM `mybd`");
  32. while ($result = mysqli_fetch_array($sql)) {
  33. $str=mb_convert_encoding('mybd', "UTF-8", "cp-1251");
  34. echo '<td>'.$result['Pump_1'].'</td>';
  35. }
  36. ?>
  37. </table>
  38. </div>
  39. </form>
  40.  
  41. <?php
  42. $host="localhost";
  43. $user="root";
  44. $pass="a-1800";
  45. $db_name="mybd";
  46. $link=mysqli_connect($host,$user,$pass,$db_name);
  47. $cod=mysqli_set_charset( $link,'utf8' );
  48.  
  49. $sql = mysqli_query( $link,'UPDATE `TABLES_1`TABLES_2`TABLES_3`TABLES_4` SET '
  50. .'`Pump_1` = "'.$_POST['Pump_1'].'",'
  51. .'`Pump_2` = "'.$_POST['Pump_2'].'",'
  52. .'`Pump_3` = '.$_POST['Pump_3'].' ','
  53. .'`Pump_4` = "'.$_POST['Pump_4'].' '
  54. .'WHERE `ID` = '.$_GET['red_id']);
  55. ?>
Add Comment
Please, Sign In to add comment