Advertisement
Guest User

Select pdo

a guest
Jun 16th, 2019
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.30 KB | None | 0 0
  1. $sql = "SELECT * FROM chest WHERE id>:start";
  2. $stmt = $pdo->prepare($sql);
  3. $stmt.bindValue(":start", $start, PDO:PARAM_INT);
  4. $stmt->execute()
  5. $data = $stmt->fetch();
  6. if($data->rowCount() > 0){
  7.     //faça algo aqui com os dados
  8.     while($row = $data->fetch(PDO:FETCH_ASSOC){
  9.         echo json_encode($row);
  10.     }
  11. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement