Advertisement
Guest User

Untitled

a guest
Mar 27th, 2017
45
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.76 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. </head>
  5. <body>
  6. <div class=CSSTableGenerator>
  7. <table>
  8. <thead>
  9. <tr>
  10. <th>ID</th>
  11. <th>Code</th>
  12. <th>Name</th>
  13. <th></th>
  14. </tr>
  15. </thead>
  16. <tbody>
  17.  
  18. <?php
  19. require ("upName.php");
  20. for($i = 1; $i <= $usr; $i++)
  21. {
  22. echo"<form action='?' method='POST'>";
  23. echo"<tr>";
  24. echo"<td><div id='id'>".$id[$i]."</div></td>";
  25. echo"<td><div id='code'><input type='hidden' name='id' value='" . $id[$i] . "|".$id[$i]."' />".$code[$i]."</div></td>";
  26. echo"<td><div id='name'><input id='name' name='name' value='$name[$i]' /></div></td>";
  27. echo"<td><input type='submit' id='muuda' value='Muuda' /></td>";
  28. echo"</tr>";
  29. echo"</form>";
  30. }
  31. ?>
  32.  
  33. <script>
  34.  
  35. </script>
  36.  
  37. </tbody>
  38. </table>
  39. </div>
  40. </body>
  41. </html>
  42.  
  43. <?php
  44. $usr=0;
  45. $sql="SELECT * from user where code like '%IN%' ";
  46. $sensors = $db->query($sql);
  47. $result1=$sensors->fetchAll(PDO::FETCH_ASSOC);
  48.  
  49. $namee=$_POST['name'];
  50. $codee=$_POST['code'];
  51. $idd=explode('|', $_POST['id']);
  52. $idd1=trim($idd[0]);
  53. $idd2=trim($idd[1]);
  54. $idd2=$idd2+1;
  55. if(empty($_POST['name'])){}else{
  56. $sql2="UPDATE user set name='" .$namee. "' where id IN('" .$idd1. "','".$idd2."') ";
  57. if(isset($_SESSION['name'])) {
  58. $sensorss = $db->query($sql2);
  59. $result2=$sensors->fetchAll(PDO::FETCH_ASSOC);}}
  60. header("Location: $_SERVER[PHP_SELF]");
  61. //Debug::dump($sql2);
  62.  
  63. foreach ($result1 as $row)
  64. {
  65.  
  66.  
  67. $usr++;
  68. $id[$usr]= $row["id"];
  69. $code[$usr]= $row["code"];
  70. $name[$usr]= $row["name"];
  71.  
  72. $code[$usr]=explode(' ', $code[$usr]);
  73. $code[$usr]=trim($code[$usr][0]);
  74.  
  75. }
  76.  
  77. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement