3v4l.org

run code in 300+ PHP versions simultaneously
<?php $table = 'test'; $tableNames= array('col1' => 'str', 'col2' => 3, 'col4' => 5.5); $query = "INSERT INTO $table ("; $query .= implode(', ', array_keys($tableNames)); $query .= ") VALUES ("; $query .= str_repeat('?, ', count($tableNames) - 1); $query .= "?)"; echo $query; $types = str_repeat('s', count($tableNames)); $stmt->bind_param($types, ...$tableNames);

preferences:
28.4 ms | 406 KiB | 5 Q