3v4l.org

run code in 300+ PHP versions simultaneously
<?php $data = ['col1'=>'val1','col2'=>'val2','col3'=>'val3','companyId'=>1]; $query = "INSERT INTO `yourtable` ( ".implode(' , ', array_keys($data)).") VALUES ('".implode("' , '", array_values($data))."')"; echo $query; ?>
Output for 7.1.0 - 7.1.33, 7.2.0 - 7.2.34, 7.3.0 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.28, 8.2.0 - 8.2.18, 8.3.0 - 8.3.6
INSERT INTO `yourtable` ( col1 , col2 , col3 , companyId) VALUES ('val1' , 'val2' , 'val3' , '1')
preferences:
214.01 ms | 403 KiB | 225 Q