Advertisement
Guest User

Untitled

a guest
Mar 13th, 2016
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. <?php
  2.  
  3. $user = 'root';//Seu usuário do banco de dados
  4. $pass = '???';//Seu senha de conexão.
  5. $conn = new PDO('mysql:host=localhost;dbname=test', $user, $pass);
  6.  
  7. $destUrl = 'http://steamcommunity.com/profiles/' . $steamid . '/inventory/json/730/2/';
  8.  
  9. $data = file_get_contents($destUrl, false);
  10. $data = json_decode($data, true);
  11. $data1= array_keys($data['rgDescriptions']);
  12. $data2= $data['rgDescriptions'];
  13.  
  14. $conn->beginTransaction();
  15.  
  16. $sql = 'INSERT INTO sua_tabela (id, name, market_hash_name, market_name)
  17. VALUES (?, ?, ?, ?)';
  18.  
  19. $conn = $dbh->prepare($sql);
  20.  
  21. for($i = 0; $i < count($data1); ++$i) {
  22.  
  23. $conn->execute(array(
  24. $data1[$i],
  25. $data2[$data1[$i]]['name'],
  26. $data2[$data1[$i]]['market_hash_name'],
  27. $data2[$data1[$i]]['market_name'];
  28. ));
  29.  
  30. }
  31.  
  32. $dbh->commit();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement