Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html lang="en-us">
- <?php require_once('database.php');?>
- <head>
- <meta charset="UTF-8">
- <meta name="viewport" content="width=device-width, initial-scale=1">
- <title>Choose About Page</title>
- <style>
- #usernameidtext
- #usernameidtext input {
- font-size:20px;font-family: "HelveticaNeue-Light", "Helvetica Neue Light", "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-weight: 300;
- padding:10px;
- }
- }
- </style>
- </head>
- <body>
- <form method="post">
- <div>
- <label for="username">Username:</label>
- <input type="text" id="usernameidtext" name="username">
- </div>
- <div>
- <input type="submit" value="Send Query" />
- </div>
- </form>
- <?php
- $username = $_POST['username'];
- $query = $con->prepare("SELECT aboutMeText FROM aboutMeTextPages WHERE username=?"); // prepare a query
- $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.
- $query->execute(); // actually perform the query
- $result = $query->get_result(); // retrieve the result so it can be used inside PHP
- $r = $result->fetch_array(MYSQLI_ASSOC); // bind the data from the first result row to $r
- echo $r['aboutMeText']; // will return the price
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment