PHPize | SQLize | SQLtest

<?php // $mysqli is already declared as a working database connection by this sandbox class Example { private $mysqli; public function __construct($mysqli) { $this->mysqli = $mysqli; } public function get(string $sql, array $data): mysqli_result|array { $stmt = $this->mysqli->prepare($sql); $stmt->execute($data); return $stmt->get_result() ?: []; } } $example = new Example($mysqli); foreach ($example->get('SELECT * FROM example', []) as $row) { echo "<div>{$row['name']}</div>\n"; } echo "\n---\n"; foreach ($example->get('SELECT * FROM example WHERE name = ?', ['Ned']) as $row) { echo "<div>{$row['name']}</div>\n"; } echo "\n---\n"; foreach ($example->get('SELECT * FROM example WHERE name = ? OR flag = ?', ['Bill', 'foo']) as $row) { echo "<div>{$row['name']}</div>\n"; }