PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
Copy Clear
Copy Format Clear
<?php class A{ public function __construct(private mysqli $mysqli){ } private array $arr = []; private mysqli_stmt $stmt; public function bind(&$param){ $this->arr[] =& $param; } public function prepare(){ $this->stmt = $this->mysqli->prepare('SELECT ?'); } public function execute(){ $params = []; foreach ($this->arr as $value) { $params[] = $value; } $this->stmt->bind_param('s', ...$params); $this->stmt->execute(); return $this->stmt->get_result()->fetch_row(); } } mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT); $mysqli = new mysqli('localhost', 'user', 'password', 'test'); $mysqli->set_charset('utf8mb4'); // always set the charset $a = new A($mysqli); $abc = 'foo'; $a->bind($abc); $a->prepare(); var_dump($a->execute()); $abc = 'bar'; var_dump($a->execute());
Show:  
Copy Clear