Skip to content

Instantly share code, notes, and snippets.

@oriolrivera
Created November 12, 2013 17:02
Show Gist options
  • Save oriolrivera/7434595 to your computer and use it in GitHub Desktop.
Save oriolrivera/7434595 to your computer and use it in GitHub Desktop.
php mysql convertir listado de datos separado por comas en un array para recorrerlo e insertar cada dato en una base de datos
<?php
$var="Alfa Romeo,Aston Martin,Audi,Autovaz,Bentley,Bmw,Cadillac,Caterham,Chevrolet,Chrysler,Citroen,Daihatsu,Dodge,Ferrari ,Fiat,Ford,Honda,Hummer,Hyundai,Isuzu,Jaguar,Jeep,Kia,Lamborghini,Lancia,Land Rover,Lexus,Lotus,Maserati,Mazda,Mercedes Benz,MG,Mini,Mitsubishi,Morgan,Nissan,Opel,Peugeot,Porsche,Renault,Rolls Royce,Rover,Saab,Seat,Skoda,Smart,Ssangyong,Subaru,Suzuki,Tata,Toyota,Volkswagen,Volvo";
$arraisico=split(",",$var);
for($i=0;$i<count($arraisico);$i++) {
echo $arraisico[$i];
mysql_query("INSERT INTO marcas (marca) VALUES ('".$arraisico[$i]."')");
}
?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment