PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
Copy Clear
Copy Format Clear
<?php $cond = []; $arr_data = [ array( "stock_id" => 846, "order_count" => 2, "order_price" => 22, "total" => 44, "profit" => 2, "order_date" => '21.06.2021', "short_date" => '06.2021' ), array( "stock_id" => 849, "order_count" => 1, "order_price" => 54, "total" => 54, "profit" => 53, "order_date" => '21.06.2021', "short_date" => '06.2021' ) ]; foreach ($arr_data as $val) { $res[] = "(".str_repeat('?, ', count($val)-1)."?)"; } $values = implode(',\n', array_map( function ($line) { return '(' . implode(',', array_fill(0, count($line), '?')) . ')'; }, $arr_data )); echo '<pre>'; print_r($res); print_r($values); echo '</pre>';
Show:  
Copy Clear