title: PHP PDO: How to insert multiple rows?
body: <p>I've many sql statements but I want but I wonder if there is any method or function to shorten and do it in the fewest possible lines using PHP PDO.</p>
  
  <p>One idea I have is to create an array with the following names: Perfiles, Usuarios, Customer, Mps, Poliza and Servicios together something like a foreach but I have no concrete idea, could you help me?</p>
  
  <p><strong>SQL STATEMENTS</strong></p>
  
  <pre><code>$sqlpermsPer = "INSERT INTO t_perfiles_permisos (Id_Perfil, Area_Permiso, Buscar, Crear, Eliminar, Modificar)
                                              VALUES ($idPerfil,'Perfiles',0,0,0,0)";
  $resultpermsPer = $this-&gt;dbConnect-&gt;query($sqlpermsPer) or die ($sqlpermsPer);
  
  sqlpermsC = "INSERT INTO t_perfiles_permisos (Id_Perfil, Area_Permiso, Buscar, Crear, Eliminar, Modificar)
                                              VALUES ($idPerfil,'Clientes',0,0,0,0)";
  $resultpermsC = $this-&gt;dbConnect-&gt;query($sqlpermsC) or die ($sqlpermsC);
  
  $sqlpermsU = "INSERT INTO t_perfiles_permisos (Id_Perfil, Area_Permiso, Buscar, Crear, Eliminar, Modificar)
                                              VALUES ($idPerfil,'Usuarios',0,0,0,0)";
  $resultpermsU = $this-&gt;dbConnect-&gt;query($sqlpermsU) or die ($sqlpermsU);
  
  $sqlpermsM = "INSERT INTO t_perfiles_permisos (Id_Perfil, Area_Permiso, Buscar, Crear, Eliminar, Modificar)
                                              VALUES ($idPerfil,'Mps',0,0,0,0)";
  $resultpermsM = $this-&gt;dbConnect-&gt;query($sqlpermsM) or die ($sqlpermsM);
  
  $sqlpermsP = "INSERT INTO t_perfiles_permisos (Id_Perfil, Area_Permiso, Buscar, Crear, Eliminar, Modificar)
                                              VALUES ($idPerfil,'Poliza',0,0,0,0)";
  $resultpermsP = $this-&gt;dbConnect-&gt;query($sqlpermsP) or die ($sqlpermsP);
  
  $sqlpermsS = "INSERT INTO t_perfiles_permisos (Id_Perfil, Area_Permiso, Buscar, Crear, Eliminar, Modificar)
                                              VALUES ($idPerfil,'Servicio',0,0,0,0)";
  $resultpermsS = $this-&gt;dbConnect-&gt;query($sqlpermsS) or die ($sqlpermsS);
  </code></pre>
  
  <p>Thanks in advance!</p>