Guest User

Untitled

a guest
May 3rd, 2018
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.57 KB | None | 0 0
  1. $json = file_get_contents('datosCriptomonedas.json');
  2. $datosclientes = json_decode($json, true);
  3.  
  4. $server = "localhost";
  5. $user = "root";
  6. $pass = "";
  7. $bd = "crypto4all";
  8.  
  9. //Creamos la conexión
  10. $conexion = mysqli_connect($server, $user, $pass,$bd)
  11. or die("Ha sucedido un error inexperado en la conexion de la base de datos");
  12.  
  13. //var_dump($cliente);
  14.  
  15. foreach ($datosclientes as $cliente) {
  16.  
  17. mysqli_query($conexion,"INSERT INTO criptomoneda (nombre,volumen)
  18. VALUES ('".$cliente[0]['ticker']['base']."',".$cliente[0]['ticker']['volume'].")");
  19. }
  20.  
  21. mysqli_close($conexion);
Add Comment
Please, Sign In to add comment