Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- set_time_limit(2000);
- $url = 'http://kacperlukasik.pl/api.json';
- $obj = json_decode(file_get_contents($url), true);
- $host = "localhost";
- $db_user = "root";
- $db_password = "admin1";
- $db_name = "bitnami_wordpress";
- // Create connection
- $conn = new mysqli($host, $db_user, $db_password, $db_name);
- // Check connection
- $data = strip_tags($key['aktualnosc']);
- $data2 = str_replace(" ","-",$key['tytul'])
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- foreach ($obj as $key) {
- // TUTAJ NAZWA WARTOSCI, TAKIE JAK W TABELI
- $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])'
- $conn->query($sql);
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement