Guest User

PHP

a guest
Dec 4th, 2018
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.68 KB | None | 0 0
  1. <?php
  2. $servername = "localhost";
  3. $username = "root";
  4. $password = "123";
  5. $dbname = "emildeveloping";
  6.  
  7. // Create connection
  8. $conn = mysqli_connect($servername, $username, $password, $dbname);
  9. // Check connection
  10. if (!$conn) {
  11. die("Connection failed: " . mysqli_connect_error());
  12. }
  13.  
  14. if (isset($_POST['update'])) {
  15. $id = $_POST['id'];
  16. $subject = $_POST['subject'];
  17. $news = $_POST['news'];
  18.  
  19. // sql to delete a record
  20. $sql = "UPDATE news SET subject= '$subject', SET news= '$news' WHERE id=$id";
  21.  
  22. if (mysqli_query($conn, $sql)) {
  23. echo "Record deleted successfully";
  24. } else {
  25. echo "Error deleting record: " . mysqli_error($conn);
  26. }
  27. }
  28.  
  29. mysqli_close($conn);
  30. ?>
Add Comment
Please, Sign In to add comment