Advertisement
Guest User

php

a guest
Jan 22nd, 2019
150
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.88 KB | None | 0 0
  1. <?php
  2. $server = "149.156.115.209";
  3. $user = "s306055";
  4. $password = "filipmusial";
  5. $db = "s306055";
  6. $dbconnect = mysqli_connect($server,$user,$password,$db);
  7. mysqli_set_charset($dbconnect, 'utf8');
  8. //edycja rekordów
  9.  
  10. if(isset($_POST['addUser'])){
  11. $usrName = $_POST['name'];
  12. $usrSurName = $_POST['surname'];
  13. $usrCar = $_POST['favCar'];
  14. $queryAdd = "insert into questbook values('','$usrName','$usrSurName','$usrCar')";
  15. mysqli_query($dbconnect,$queryAdd);
  16. }
  17. if(isset($_POST['delUser'])){
  18. $usrId = $_POST['userId'];
  19. $queryDel = "delete from questbook where $usrId = id";
  20. mysqli_query($dbconnect,$queryDel);
  21.  
  22. }
  23. ////
  24.  
  25.  
  26. $all = "select * from questbook";
  27. $queryAll = mysqli_query($dbconnect,$all);
  28. //rysowanie tabeli
  29. while($tab = mysqli_fetch_row($queryAll))
  30. {
  31. echo '<tr>';
  32. foreach($tab as $row)
  33. {
  34. echo '<td style="border: 1px solid black;">'.$row.'</td>';
  35. }
  36. echo '</tr>';
  37. }
  38.  
  39. mysqli_close($dbconnect);
  40. ?>
  41. </table>
  42. <p>
  43. Sign in
  44. </p>
  45. <form name="add" method="post">
  46. Name: <input type="text" name="name"><br>
  47. Surname: <input type="text" name="surname"><br>
  48. Favorite Car: <input type="text" name="favCar"><br>
  49. <input type="submit" value="Add" name="addUser">
  50. </form>
  51. <p>
  52. Delete
  53. </p>
  54. <form name="del" method="post">
  55. Choose ID to delete: <input type="text" name="userId">
  56. <input type="submit" value="Delete" name="delUser">
  57. </form>
  58. </div>
  59. </div>
  60. </div>
  61. </div>
  62. </section>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement