Online PHP editor | refs for puKfE

<?php function prepared_mysqli_query($query) { //initializing required variables $first_half = ''; $placeholders = ''; $data_types = ''; $values = ''; //getting the first half of query $trim_end = strrpos($query,'('); $first_half = substr($query, 0, $trim_end); //getting the values to be inserted $open = strrpos($query,'('); $close = strrpos($query,')'); $values = substr($query,($open+1),($close+1)); $values_stripped = substr($values,0,-1); $values_array = explode(",",$values_stripped); $values_count = count($values_array); //generating placeholders $ph = "("; for ($i = 1; $i < $values_count; $i++) { $ph.= "?,"; } $ph.= "?)"; $placeholders .= $ph; //getting value types $types =''; for ($i = 0; $i < $values_count; $i++){ $str = gettype($values_array[0]); $types .= $str[0]; } $data_types .= $types; //execution $query = $first_half.$placeholders; return ["query" => $query, "data_types" => $data_types, "values" => $values_array ]; } var_dump(prepared_mysqli_query("INSERT INTO `tablename` (`column1`, `column2`, `column3`) VALUES (NULL, 'v1', 'v2');")); var_dump(prepared_mysqli_query("INSERT INTO `tablename` (`column1`, `column2`, `column3`) VALUES (NOW(), 'v1', 'v2');")); var_dump(prepared_mysqli_query("INSERT INTO `tablename` (`column1`, `column2`, `column3`) VALUES ('test,with,commas', 'v1', 'v2');")); var_dump(prepared_mysqli_query("INSERT INTO `tablename` (`column1`, `column2`, `column3`) VALUES ('v0', 'v1', 'v2') ON DUPLICATE KEY UPDATE `column2` = 'v2';"));