fork download
copy 
  1. <?php
  2.  
  3. $nomes = ['João', 'Maria', 'Afonso', 'Ana'];
  4. $parentescos = ['Pai', 'Filha', 'Avô', 'Avó'];
  5. $nascimentos = ['01/01/980', '01/02/1999', '01/03/1930', '01/04/1934'];
  6.  
  7. $query = 'INSERT INTO moradores (nome, parentesco, nascimento) VALUES ';
  8. for ($i = 0; $i < count($nomes); ++$i)
  9. 	$query .= ($i?',':'')."('{$nomes[$i]}','{$parentescos[$i]}','{$nascimentos[$i]}')";
  10.  
  11. echo $query;
Success #stdin #stdout 0.02s 25836KB
comments ()
stdin
copy 
Standard input is empty
stdout
copy 
INSERT INTO moradores (nome, parentesco, nascimento) VALUES ('João','Pai','01/01/980'),('Maria','Filha','01/02/1999'),('Afonso','Avô','01/03/1930'),('Ana','Avó','01/04/1934')
https://ideone.com/2Mke5D
language:
PHP (php 7.3.5)
created:
4 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!