fork download 
  1. <?php
  2. $d1 = "a:1,b:2,c:3,d:4"; //field number variable.. sometimes 4 or 10
  3. $d2 = explode(',', $d1);
  4.  
  5. foreach ($d2 as $key => $value) {
  6.     $arr1 = explode(':',$d2[$key]);
  7.     if(count($arr1)==2){
  8.       $arr[$arr1[0]]= $arr1[1];
  9. }
  10.     }
  11. $fields= implode(",",array_keys($arr));
  12. $values=implode(",",array_values($arr));
  13. $query="Insert into Table1 (".$fields.") values (".$values.")";
  14. print_r($query);;
  15. ?>
Success #stdin #stdout 0s 82880KB
comments (?)
stdin 
Standard input is empty
stdout 
Insert into Table1 (a,b,c,d) values (1,2,3,4)
https://ideone.com/EXAPOt
language:
PHP (php 7.3.5)
created:
6 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!