SHOW:
|
|
- or go back to the newest paste.
1 | - | <? |
1 | + | // $query = $pdo->prepare("SELECT * FROM cards LIMIT :offset, :count"); |
2 | - | $sql = "SELECT * FROM cards"; |
2 | + | // $query->bindValue(":offset", 20, PDO::PARAM_INT); |
3 | - | foreach ($pdo->query($sql) as $row) { |
3 | + | // $query->bindValue(":count", 10, PDO::PARAM_INT); |
4 | - | echo '<tr><td>' . $row['name'] . '</td><td>' . $row['rarity'] . "★" . '</td><td>' . "<img src=upload/{$row['img']} />" . '</td></tr>'; |
4 | + | |
5 | - | } |
5 | + | // $query->execute(); |
6 | - | ?> |
6 | + | |
7 | // $row = $query->fetchAll(); |