大家好!
我的主机上有两个网站,每个网站都有自己的数据库。在两个 WordPress 网站上。我想将一个类别的所有新闻从一个网站转移到另一个网站。我已经了解到Wordpress对此有一个现成的机制。但首先我尝试在旧数据库中选择并在新数据库中插入。我想知道为什么这不起作用:
<?php
$servername = "localhost";
$database = "xxxxxxxxxx";
$username = "xxxxxxxxxxxx";
$password = "xxxxxxxxxxxx";
$servername2 = "localhost";
$database2 = "xxxxxxxxxxxxxx";
$username2 = "xxxxxxxxxxxxx";
$password2 = "xxxxxxxxxxxxx";
$conn = mysqli_connect($servername, $username, $password, $database);
$conn2 = mysqli_connect($servername2, $username2, $password2, $database2);
$sql = "SELECT * FROM wp_posts";
$counter = 600;
$iterator = 1;
if($result = $conn->query($sql)){
foreach($result as $row){
$stringArr[] = "(" . $counter . ", '" . $row['post_author'] . "', '" . $row['post_date'] . "', '" . $row['post_date_gmt'] . "',
'" . $row['post_content'] . "', '" . $row['post_title'] . "', '" . $row['post_excerpt'] . "',
'" . $row['post_status'] . "', '" . $row['comment_status'] . "', '" . $row['ping_status'] . "',
'" . $row['post_password'] . "', '" . $row['post_name'] . "', '" . $row['to_ping'] . "',
'" . $row['pinged'] . "', '" . $row['post_modified'] . "', '" . $row['post_modified_gmt'] . "',
'" . $row['post_content_filtered'] . "', '" . $row['post_content_filtered'] . "', " . $row['post_parent'] . ",
'" . $row['guid'] . "', " . $row['menu_order'] . ", '" . $row['post_type'] . "', '" . $row['post_mime_type'] . "',
" . $row['comment_count'] . ")";
/*
if($iterator%50 == 0) {
print_r($stringArr);
exit;
}*/
$iterator++;
$counter++;
/*
print_r($string);
$sql2 = "INSERT INTO serjam_wp1.wp_post VALUES (" . $string . ")";
if ($conn2->query($sql2) === TRUE) {
echo "New record created successfully";
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
如果将 INSERT 删除到第二个数据库中,则第一个数据库中的所有内容都会完美地显示在浏览器中。但是一旦 $sql2 使用 INSERT - 就是这样......







