Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- require 'includes/dbconnect.php';
- if(isset($_GET['id'])){
- $id = $_GET['id'];
- }
- $sql = 'SELECT * FROM users WHERE user_id = :id';
- $query = $pdo->prepare($sql);
- $query->execute(['id' => $id]);
- $user = $query->fetch();
- if(isset($_POST['submit'])){
- $username = $_POST['username'];
- $email = $_POST['email'];
- $sql = 'UPDATE users SET username = :username, email = :email WHERE user_id = :id ';
- $query = $pdo->prepare($sql);
- $query->bindParam('username', $username);
- $query->bindParam('email', $email);
- $query->bindParam('id', $id);
- $query->execute();
- header("Location: users.php");
- }
- ?>
- <div class="mt-2">
- <div class="container">
- <form method="post">
- <input type="text" name="username" value="<?php echo $user['username']; ?>" placeholder="Enter your username"><br>
- <input type="text" name="email" value="<?php echo $user['email']; ?>" placeholder="Enter your email"><br>
- <input type="submit" name="submit" value="Submit">
- </form>
- </div>
- </div>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement