主页 / 问题 / 1543191
Accepted
Valentin
Asked:2023-09-29 20:53:58 +0000 UTC2023-09-29 20:53:58 +0000 UTC

为什么在输出 SELECT 的循环内连接到一个数据库的 INSERT 会给出 SELECT 错误？

  • 772

大家好！

我的主机上有两个网站，每个网站都有自己的数据库。在两个 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 - 就是这样......

php

1 个回答

  1. Best Answer

    $string 未定义，因此 $sql2 不起作用：您混淆了 stringArr 和 string

    • 1

相关问题