Advertisement
Guest User

edit

a guest
Dec 16th, 2018
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.34 KB | None | 0 0
  1. <html><meta charset="utf-8">
  2. <?php
  3. /**
  4. * Created by PhpStorm.
  5. * User: 455
  6. * Date: 16.12.2018
  7. * Time: 20:15
  8. */
  9.  
  10. if(isset($_GET['id'])){
  11. $id = $_GET['id'];
  12. $link = mysqli_connect ("localhost" , "root" , "", 'test');
  13.  
  14.  
  15. if($_POST['update'] == true) {
  16.  
  17. $name = $_POST['name'];
  18. $birthdate = $_POST['birthdate'];
  19. $experience = $_POST['experience'];
  20.  
  21. $sql = "UPDATE users SET name='$name', birth_date='$birthdate', experience='$experience' WHERE id=$id";
  22. if ($link->query($sql) == TRUE) {
  23. echo '<meta http-equiv="refresh" content="0;index.php">';
  24. } else {
  25. echo "Error updating record: " . $link->error;
  26. }
  27. }
  28.  
  29.  
  30. $ath = mysqli_query($link, "select * from users where id=$id;");
  31. $user = mysqli_fetch_array($ath);
  32. ?>
  33.  
  34. <form method="POST" action="edit.php?id=<?=$id?>">
  35. <input type="hidden" name="update" value="true">
  36. <label>Имя</label><input type="text" name="name" value="<?=$user['name']?>"><br>
  37. <label>Дата рождения</label><input type="date" name="birthdate" value="<?=$user['birth_date']?>"><br>
  38. <label>Опыт</label><input type="text" name="experience" value="<?=$user['experience']?>"><br>
  39. <button type="submit">Сохранить</button><br>
  40. </form>
  41.  
  42. <?php
  43. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement