Guest User

Untitled

a guest
Dec 18th, 2018
279
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.19 KB | None | 0 0
  1. <?php
  2.  
  3. $json = '[{"id":"1","nombre":"Jose","edad":"25","genero":"masculino","email":"josegonzales9871@gmail.com","localidad":"Madrid","telefono":"912546524"},{"id":"2","nombre":"Juan","edad":"31","genero":"masculino","email":"juanrodriguez65465@gmail.com","localidad":"Barcelona","telefono":"934654654"},{"id":"3","nombre":"Antonio","edad":"43","genero":"masculino","email":"antoni654654@gmail.com","localidad":"Valencia","telefono":"214748366"},{"id":"4","nombre":"Angelina","edad":"35","genero":"femenino","email":"angelina654456@gmail.com","localidad":"New York","telefono":"247483647"}]';
  4.  
  5.  
  6. $datosclientes = json_decode($json, true);
  7.  
  8.  
  9. $server = "localhost";
  10. $user = "root";
  11. $pass = "";
  12. $bd = "demo_json";
  13.  
  14. //Creamos la conexión
  15. $conexion = mysqli_connect($server, $user, $pass,$bd)
  16. or die("Ha sucedido un error inexperado en la conexion de la base de datos");
  17.  
  18.  
  19. foreach ($datosclientes as $cliente) {
  20.  
  21. mysqli_query($conexion,"INSERT INTO clientes (nombre,edad,genero,email,localidad,telefono)
  22. VALUES ('".$cliente['nombre']."',".$cliente['edad'].",'".$cliente['genero']."','".$cliente['email']."','".$cliente['localidad']."',".$cliente['telefono'].")");
  23.  
  24. }
  25.  
  26.  
  27. mysqli_close($conexion);
  28.  
  29. ?>
Add Comment
Please, Sign In to add comment