PHPize Online / SQLize Online  /  SQLtest Online

<?php $stmt = $mysqli->prepare('SELECT 1 as asd,23 as a,4 as bcvbvc'); $stmt->execute(); $stmt->store_result(); $meta = $stmt->result_metadata(); $fields = $meta->fetch_fields(); $columnNames = array_map(static function (stdClass $field): string { return $field->name; }, $fields); $boundValues = array_fill(0, count($columnNames), null); $refs = []; foreach ($boundValues as &$value) { $refs[] =& $value; } $stmt->bind_result(...$refs); $stmt->fetch(); var_dump($boundValues);