Online PHP editor | rfc for puKfE

@ 2020-12-29T19:25:13Z

<?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';"));

Output for git.master, git.master_jit, rfc.property-hooks: array(3) { ["query"]=> string(72) "INSERT INTO `tablename` (`column1`, `column2`, `column3`) VALUES (?,?,?)" ["data_types"]=> string(3) "sss" ["values"]=> array(3) { [0]=> string(4) "NULL" [1]=> string(5) " 'v1'" [2]=> string(6) " 'v2')" } } array(3) { ["query"]=> string(76) "INSERT INTO `tablename` (`column1`, `column2`, `column3`) VALUES (NOW(?,?,?)" ["data_types"]=> string(3) "sss" ["values"]=> array(3) { [0]=> string(1) ")" [1]=> string(5) " 'v1'" [2]=> string(6) " 'v2')" } } array(3) { ["query"]=> string(76) "INSERT INTO `tablename` (`column1`, `column2`, `column3`) VALUES (?,?,?,?,?)" ["data_types"]=> string(5) "sssss" ["values"]=> array(5) { [0]=> string(5) "'test" [1]=> string(4) "with" [2]=> string(7) "commas'" [3]=> string(5) " 'v1'" [4]=> string(6) " 'v2')" } } array(3) { ["query"]=> string(72) "INSERT INTO `tablename` (`column1`, `column2`, `column3`) VALUES (?,?,?)" ["data_types"]=> string(3) "sss" ["values"]=> array(3) { [0]=> string(4) "'v0'" [1]=> string(5) " 'v1'" [2]=> string(47) " 'v2') ON DUPLICATE KEY UPDATE `column2` = 'v2'" } }

This tab shows result from various feature-branches currently under review by the php developers. Contact me to have additional branches featured.

Active branches

Archived branches

Once feature-branches are merged or declined, they are no longer available. Their functionality (when merged) can be viewed from the main output page

2022-12-01 RFC: Property hooks - included in PHP 8.4
2020-03-21 RFC: Is_Literal - declined
2020-12-04 Enumerations - included in PHP 8.1
2018-06-15 Typed Properties v2 - implemented in PHP 7.4
2016-08-12 Object typehint - included in PHP 7.2
2016-08-14 Arrow functions - withdrawn
2016-05-29 array_change_keys() - withdrawn
2016-04-19 Lexical scope support for anonymous classes - suspended
2016-04-17 Functional Interfaces - declined
2016-03-16 Typed Properties - superseded in favor of Typed Properties 2.0
2015-08-27 Callable Prototypes - declined
2015-05-01 Short Closures - declined / withdrawn in favor of Arrow Functions
2015-02-18 Scalar type hints v5 - included in PHP 7
2015-02-14 Union Types - declined
2013-09-22 Anonymous classes - included in PHP 7

preferences:dark modelive previewkey bindings