nstruth2

Untitled

Jul 18th, 2023
118
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.28 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html lang="en-us">
  3. <?php require_once('database.php');?>
  4. <head>
  5.     <meta charset="UTF-8">
  6.     <meta name="viewport" content="width=device-width, initial-scale=1">
  7.     <title>Choose About Page</title>
  8.     <style>
  9.         #usernameidtext
  10.  
  11. #usernameidtext input {
  12. font-size:20px;font-family: "HelveticaNeue-Light", "Helvetica Neue Light", "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-weight: 300;
  13. padding:10px;
  14. }
  15. }
  16.     </style>
  17. </head>
  18. <body>
  19.     <form method="post">
  20.         <div>
  21.         <label for="username">Username:</label>
  22.         <input type="text" id="usernameidtext" name="username">
  23.     </div>
  24.     <div>
  25.         <input type="submit" value="Send Query" />
  26.     </div>
  27.     </form>
  28.     <?php
  29.     $username = $_POST['username'];
  30.         $query = $con->prepare("SELECT aboutMeText FROM aboutMeTextPages WHERE username=?"); // prepare a query
  31. $query->bind_param('s', $username); // binding parameters via a safer way than via direct insertion into the query. 'i' tells mysql that it should expect an integer.
  32. $query->execute(); // actually perform the query
  33. $result = $query->get_result(); // retrieve the result so it can be used inside PHP
  34. $r = $result->fetch_array(MYSQLI_ASSOC); // bind the data from the first result row to $r
  35. echo $r['aboutMeText']; // will return the price
  36. ?>
  37. </body>
  38.  
  39. </html>
Advertisement
Add Comment
Please, Sign In to add comment