Advertisement
Guest User

Untitled

a guest
Feb 22nd, 2018
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.16 KB | None | 0 0
  1. <?php
  2. set_time_limit(2000);
  3.  
  4.  
  5.  
  6. $url = 'http://kacperlukasik.pl/api.json';
  7. $obj = json_decode(file_get_contents($url), true);
  8.  
  9. $host = "localhost";
  10. $db_user = "root";
  11. $db_password = "admin1";
  12. $db_name = "bitnami_wordpress";
  13. // Create connection
  14. $conn = new mysqli($host, $db_user, $db_password, $db_name);
  15. // Check connection
  16. $data = strip_tags($key['aktualnosc']);
  17. $data2 = str_replace(" ","-",$key['tytul'])
  18. if ($conn->connect_error) {
  19. die("Connection failed: " . $conn->connect_error);
  20. }
  21. foreach ($obj as $key) {
  22. // TUTAJ NAZWA WARTOSCI, TAKIE JAK W TABELI
  23. $sql = 'INSERT INTO wp_posts(post_author, post_date, post_date_gmt, post_content, post_title, post_excerpt, post_status, comment_status, ping_status, post_password, post_name, to_ping, pinged, post_modified, post_modified_gmt, post_content_filtered, post_parent, guid, menu_order, post_type, post_mime_type, comment_count) VALUES ([$key["autor"],[$key["data"],[$key["data"],[$data],[$key["tytul"]],[""],["publish"],["open"],["open"],[""],[$data2],[""],[""],[$key["data"]],[$key["data"]],[""],[0],[""],[0],["post"],[""],[0])'
  24.  
  25. $conn->query($sql);
  26. }
  27.  
  28. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement