Guest User

Untitled

a guest
Jan 14th, 2018
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.14 KB | None | 0 0
  1. <?php
  2. $servername = "localhost";
  3. $username = "username";
  4. $password = "password";
  5. $dbname = "myDB";
  6.  
  7. // Create connection
  8. $conn = new mysqli($servername, $username, $password, $dbname);
  9. // Check connection
  10. if ($conn->connect_error) {
  11. die("Connection failed: " . $conn->connect_error);
  12. }
  13.  
  14. $sql = "SELECT * FROM htmldata WHERE element='pobject'"; #SQL SELECT query
  15. $result = $conn->query($sql);
  16.  
  17. if ($result->num_rows > 0) {
  18. while($row = $result->fetch_assoc()) {
  19. $pdata = $row['data'];
  20. }
  21. }
  22. $conn->close();
  23. ?>
  24.  
  25. <html>
  26. <body>
  27. <p><?php echo $pdata; ?></p>
  28. </body>
  29. </html>
  30.  
  31. <?php
  32.  
  33. if(!isset($_POST['pdata'])){
  34. echo "No data passed";
  35. }else{
  36. $pdata = $_POST['pdata'];
  37. $servername = "localhost";
  38. $username = "username";
  39. $password = "password";
  40. $dbname = "myDB";
  41.  
  42. // Create connection
  43. $conn = new mysqli($servername, $username, $password, $dbname);
  44. // Check connection
  45. if ($conn->connect_error) {
  46. die("Connection failed: " . $conn->connect_error);
  47. }
  48.  
  49. $sql = "UPDATE htmldata SET data='$pdata' WHERE element='pobject'";
  50. $result = $conn->query($sql);
  51. $conn->close();
  52. }
  53.  
  54. ?>
Add Comment
Please, Sign In to add comment