Advertisement
Guest User

Untitled

a guest
May 6th, 2018
147
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.19 KB | None | 0 0
  1.     while($row = $result->fetch_assoc()) {
  2.     echo "<tr>";
  3.     echo "<td>" . $row["nr"]. "</td>";
  4.     echo '<td><form method="post"><input type="text" value="' . $row["name"]. '" name="nametochange"/></form></td>';
  5.    
  6.     }
  7. echo    "</table>";
  8.     echo '<form method="post"><input type="submit" name="OkEditAction" id="'. $ID.'" value="OK" /><input type="hidden" value="'.$ID.'" name="OkEdit2"/></form>';
  9.     echo '<form method="post"><input type="submit" name="NotOkEditAction" id="'. $ID.'" value="Anuluj" /><input type="hidden" value="'.$ID.'" name="OkEdit3"/></form>';
  10.    
  11.  
  12. } else {
  13.     echo "0 results";
  14. }
  15. $conn->close();
  16.  
  17. }  
  18.  
  19.  
  20. function OkEditAction()
  21. {
  22.  
  23. echo "</table>";
  24. $ID = $_POST['OkEdit2'];
  25. $imiedozmiany = $_POST['nametochange'];
  26. $servername = "localhost";
  27. $username = xxx;
  28. $password = xxx;
  29. $dbname = xxx;
  30.  
  31. header('Content-Type: charset=UTF-8');
  32.  
  33. // Create connection   
  34. $conn = new mysqli($servername, $username, $password, $dbname);
  35.  
  36. // Check connection
  37. if ($conn->connect_error) {
  38.     die("Connection failed: " . $conn->connect_error);
  39. }
  40.  
  41. else
  42.    
  43. {
  44. echo $ID;
  45. $sql = "UPDATE zlecenia SET name ='". $imiedozmiany."' WHERE nr=". $ID;
  46. echo $sql;
  47. $result = $conn->query($sql);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement