Import Data to WordPress

Szkielet skryptu to importu danych do bazy WordPress z dowolnej bazy MySQL

Plik class.php

<?php
/*
	Name: Import Data to WordPress  
	Auhor: Paweł Kosmala
	Website: https://pawelkosmala.pl/
	Version: 20200805  
	License: GNU General Public License
 */


    function str2url($text) {
        $text = trim($text);
        $znaki = array('1', '2', '3', '4', '5', '6', '7', '8', '9', '0', 'q', 'w', 'e', 'r', 't', 'y', 'u', 'i', 'o', 'p', 'a', 's', 'd', 'f', 'g', 'h', 'j', 'k', 'l', 'z', 'x', 'c', 'v', 'b', 'n', 'm');
        $tmp = strtolower(str_replace(array("ę", "ó", "ą", "ś", "ł", "ż", "ź", "ć", "ń", "Ę", "Ó", "Ą", "Ś", "Ł", "Ż", "Ź", "Ć"), array("e", "o", "a", "s", "l", "z", "z", "c", "n", "E", "O", "A", "S", "L", "Z", "Z", "C"), $text));
        $ile = strlen($tmp);
        $text = "";
        $oz = "";
        for ($i = 0; $i <= $ile; $i++) {
            $znak = substr($tmp, $i, 1);
            //echo $znak;
            if (in_array($znak, $znaki)) {
                $oz = $znak;
                $text.=$znak;
            } elseif ($oz != "-") {
                $text.="-";
                $oz = "-";
            }
        }
        return $text;
    }

    class WordPress {
        
        public $db="";
        
        public function __construct() {
            $this->db=new mysqli(db::$wp_host,db::$wp_user,db::$wp_pass,db::$wp_db);
            $this->db->query("SET NAMES 'utf8'");   
        }
        
        private function returnId($sql,$id) {
            $result=$this->db->query($sql);
            $row=mysqli_fetch_assoc($result);
            return (int)@$row[$id];
        }


        public function isPost($post_author, $post_date, $post_title, $post_content) {
            $sql="SELECT id FROM wp_posts WHERE "
                    . "post_author='".$post_author."' "
                    . "AND post_date='".$post_date."' "
                    . "AND post_title='".$post_title."' "
                    . "AND post_content='".$post_content."' ";
            $result=$this->db->query($sql);
            $row=mysqli_fetch_assoc($result);
            return (int)@$row["id"];
        }
        
        public function addPost($post_author, $post_date, $post_title, $post_content, $post_name="") {
            $sql="INSERT INTO wp_posts "
                    . "(post_author, post_date, post_title, post_content, post_name) "
                    . "VALUES "
                    . "('".$post_author."', '".$post_date."', '".$post_title."', '".$post_content."', '".$post_name."') ";            
            $this->db->query($sql);            
        }
        
        public function savePost($post_author, $post_date, $post_title, $post_content, $post_name="") {
           $postId=$this->isPost($post_author, $post_date, $post_title, $post_content);
           if ($postId) {
               echo $post_name."\n";
               $sql="UPDATE wp_posts SET "
                       ." post_author='".$post_author."', "
                       ." post_date='".$post_date."', "
                       ." post_title='".$post_title."', "
                       ." post_content='".$post_content."', "
                       ." post_name='".$post_name."' "
                       . "WHERE id=".$postId;
               //echo $sql."\n"; die();
               $this->db->query($sql);
           } else 
               $this->addPost ($post_author, $post_date, $post_title, $post_content,  $post_name=""); 
        }
        
        public function saveImage($post_author,$nazwa, $fromUrl) {
            $sql="SELECT id FROM wp_posts WHERE "
                    . "post_author='".$post_author."' "
                    . "AND post_name='".$nazwa."' "
                    . "AND post_type='attachment' "
                    . "AND post_mime_type='image/jpeg' ";
            $postId=$this->returnId($sql, "id");
            if (!$postId) {
                $year=date("Y");
                $m=date("m");
                file_put_contents(db::$wp_dirupload.$year."/".$m."/".$nazwa,file_get_contents($fromUrl));
                $url=db::$wp_url."wp-content/uploads/".$year."/".$m."/".$nazwa;
                $sql="INSERT INTO wp_posts "
                    . "(post_author, post_date, post_title,  post_name, post_type, post_mime_type, guid, post_status ) "
                    . "VALUES "
                    . "('".$post_author."', '".date("Y-m-d H:i:s")."', '".$nazwa."', '".$nazwa."', 'attachment', 'image/jpeg', '".$url."', 'inherit') ";  
                $this->db->query($sql);
                $sql="SELECT id FROM wp_posts WHERE "
                    . "post_author='".$post_author."' "
                    . "AND post_name='".$nazwa."' "
                    . "AND post_type='attachment' "
                    . "AND post_mime_type='image/jpeg' ";
                $postId=$this->returnId($sql, "id");
            }
            return $postId;
        }
        
        public function saveThumbnail($postId, $photoId) {
            $sql="SELECT meta_id FROM wp_postmeta WHERE post_id=".$postId." AND meta_key='_thumbnail_id' AND meta_value='".$photoId."' LIMIT 1";
            $metaId=$this->returnId($sql, "meta_id");
            if ($metaId) {
                $sql="UPDATE wp_postmeta SET meta_value='".$photoId."' WHERE  post_id=".$postId." AND meta_key='_thumbnail_id'";
            } else {
                $sql="INSERT INTO wp_postmeta (post_id,meta_key,meta_value) VALUES ("
                        . "'".$postId."',"
                        . "'_thumbnail_id',"
                        . "'".$photoId."'"
                        . ") ";
            }
            $this->db->query($sql);
        }
        
        public function saveRedirection($fromUrl, $toUrl) {
            $sql="SELECT id FROM wp_redirection_items WHERE url='".$fromUrl."' LIMIT 1 ";
            $result=$this->db->query($sql);
            $row=mysqli_fetch_assoc($result);
            $id=(int)@$row["id"];
            if (!$id) {
                $sql="INSERT INTO wp_redirection_items "
                        . "(url, match_url, status, action_type, action_code, action_data, match_type) "
                        . "VALUES "
                        . "('".$fromUrl."', '".$fromUrl."', 'enabled', 'url', '301', '".$toUrl."', 'url') ";
                $this->db->query($sql);
            }
        }
        
        public function id2Url($postId) {
            $sql="SELECT post_name FROM wp_posts WHERE id=".$postId;
            $result=$this->db->query($sql);
            $row=mysqli_fetch_assoc($result);
            return @$row["post_name"];
        }       
        
        
        public function isTerm($name,$slug) {
            $sql="SELECT term_id FROM wp_terms WHERE name='".$name."' AND slug='".$slug."' LIMIT 1 ";
            $result=$this->db->query($sql);
            $row=mysqli_fetch_assoc($result);
            return (int)@$row['term_id'];
        }
        
        public function saveTerm($name,$slug, $description="", $taxonomy='category') {
            $termId=$this->isTerm($name, $slug);
            if (!$termId) {
                $sql="INSERT INTO wp_terms (name,slug) VALUES ('".$name."','".$slug."') ";
                $result=$this->db->query($sql);
                $termId=$this->isTerm($name, $slug);
                $sql="INSERT INTO wp_term_taxonomy (term_id,taxonomy,description) VALUES ('".$termId."', '".$taxonomy."', '".$description."') ";
                $result=$this->db->query($sql);
            }
            return $termId;
        }
        
        public function post2Term($postId, $termId) {
            $sql="SELECT object_id FROM wp_term_relationships WHERE object_id=".$postId." AND term_taxonomy_id=".$termId." LIMIT 1";
            if (!$this->returnId($sql, "object_id")) {
                $sql="INSERT INTO wp_term_relationships (object_id,term_taxonomy_id) VALUES ('".$postId."','".$termId."') ";
                $this->db->query($sql);
            }
            
        }
        
    }
    
    class dbImport {
        public $db="";
        
        public function __construct() {
            $this->db=new mysqli(db::$from_host,db::$from_user,db::$from_pass,db::$from_db);
            $this->db->query("SET NAMES 'utf8'");  
        }
        
        public function posts() {
            $sql="SELECT teksty.*, kategorie.name AS kategorieUrl "
                    . "FROM teksty "
                    . "LEFT JOIN kategorie ON (kategorie.id=teksty.kategorie_id) ";
            $result=$this->db->query($sql);
            $posts=array();
            while ($row = mysqli_fetch_assoc($result)) {
                $posts[]=$row;
            }           
            return $posts;
        }
        
        public function id2Kategorie($id) {
            $sql="SELECT * FROM kategorie WHERE id=".$id." ";
            $result=$this->db->query($sql);
            return mysqli_fetch_assoc($result);
        }
        
        public function zdjecie($id) {
            $sql="SELECT * FROM zdjecia WHERE id=".$id." ";
            $result=$this->db->query($sql);
            return mysqli_fetch_assoc($result);
        }
        
        public function tagi() {
            $sql="SELECT * FROM tagi ";
            $result=$this->db->query($sql);
            $tagi=array();
            while ($row = mysqli_fetch_assoc($result)) {
                $tagi[]=$row;
            }           
            return $tagi;
        }
        
    }
    

Plik run.hp

<?php
/*
	Name: Import Data to WordPress  
	Auhor: Paweł Kosmala
	Website: https://pawelkosmala.pl/
	Version: 20200805  
	License: GNU General Public License
 */

    class db {
        
        static $wp_host="localhost";
        static $wp_db="wordpress";
        static $wp_user="root";
        static $wp_pass="";
        static $post_author_default=1;
        static $wp_url=""; /*Docelowa domena WordPress */
        static $wp_dirupload="/var/www/domena.pl"; /* ścieżka do instalacji WordPress*/
        
        static $from_host=""; //Host bazy danych importu
        static $from_db=""; //nazwa bazy danych importu
        static $from_user=""; //użytkownik bazy danych importu
        static $from_pass=""; //hasło użytkownika bazy danych importu 
		static $hostImportImage="https://jakasdomena.pl/useruploads/";	        
    }
    
    $termsMaps=array();
    
    include 'class.php';

    $wp=new WordPress();
    $import=new dbImport();
    
    $posts=$import->posts();
        
    foreach($posts as $post) {
        $postId=$wp->isPost(db::$post_author_default, $post['data'] , $post['title'], $post['text']);  
        $zdjecie=$import->zdjecie($post["zdjecie_id"]);
        $photoId=$wp->saveImage(db::$post_author_default, $zdjecie["nazwa"], db::$hostImportImage.$zdjecie["nazwa"]);
        $wp->saveThumbnail($postId, $photoId);
    }
?>
Narzędzia dla copywritera