PHP
|
MySQL
|
JS
|
HTML
|
CSS
|
Blocks
|
More
|
Editor
APDO
|
AHTML
|
Modules
|
$stmt = $pdo -> prepare('SELECT * FROM ' . DB_NAME . ' WHERE `v1` = ? AND `v2` = ? AND `v3` = ? AND `v4` = ?'); $stmt->execute([$v1,$v2,$v3,$v4]); $result = $stmt->fetchAll(PDO::FETCH_ASSOC);
$statement = $pdo->query("SELECT some_field FROM some_table"); $row = $statement->fetch(PDO::FETCH_ASSOC); echo htmlentities($row['some_field']);
$stmt = $pdo->prepare('SELECT name FROM users WHERE id = :id'); $id = filter_input(INPUT_GET, 'id', FILTER_SANITIZE_NUMBER_INT); $stmt->bindParam(':id', $id, PDO::PARAM_INT); $stmt->execute();
class FooModel { protected $db; public function __construct(PDO $db) { $this->db = $db; } public function getAllFoos() { return $this->db->query('SELECT * FROM table'); } } include 'models/FooModel.php'; $fooModel = new FooModel($db); $fooList = $fooModel->getAllFoos();