Advertisement
Skorpius

Select Statement Structure (Named Params)

Jun 24th, 2022
942
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.48 KB | None | 0 0
  1.                // Named params
  2.                $uname = $_POST['username'];
  3.                $sql = "SELECT * FROM users WHERE username = :username LIMIT 1";
  4.                $stmt = $pdo->prepare($sql);
  5.                $stmt->bindParam('username', $uname);
  6.                $stmt->execute();
  7.  
  8.                while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
  9.  
  10.                     $id = htmlentities($row['id']);
  11.                     $username = htmlentities($row['username']);
  12.  
  13.                }//While loop close
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement