mysql - 如何使用 PHP 从表中复制多行并将它们插入到 MySql DB 中的另一个表中？

Question

<?php
    $conn = mysqli_connect('hostname','username','passwd','dbname');
    $query = 'SELECT name,mobileno FROM test';
    $result = mysqli_query($conn,$query);

    while($row = $result->fetch_array()) {
        $name = $row['name'];
        $monileno = $row['mobileno'];

        $query2 = "INSERT INTO test2(name2,mobileno2) VALUES('$name','$monileno')";
        mysqli_query($conn,$query2);
       }
?>


CREATE TABLE `test` (
  `id` INT(9) AUTO_INCREMENT PRIMARY KEY, 
  `name` varchar(128) NOT NULL,
  `mobileno` varchar(128) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `test` (`id`, `name`, `mobileno`) VALUES
(1, 'Omar Faruq', '01911775477'),
(2, 'omar Al Faruq', '01911775477'),
(3, 'Helal Uddin', '01914351075');

CREATE TABLE `test2` (
  `id` INT(9) AUTO_INCREMENT PRIMARY KEY, 
  `name` varchar(128) NOT NULL,
  `mobileno` varchar(128) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

此代码适用于 Xampp/wamp，但当我将此脚本上传到 RHEL7.2 网络服务器时，它不起作用。

Answer 1

<?php
$conn = mysqli_connect('hostname','username','passwd','dbname');
$query = 'SELECT name,mobileno FROM test';
$result = mysqli_query($conn,$query);

while ($row = mysqli_fetch_assoc($result)) { 
  $name = mysqli_escape_string($conn, $row['name']);
  $monileno = mysqli_escape_string($conn, $row['mobileno']); 

$query2 = "INSERT INTO test2(name2,mobileno2) VALUES('$name','$monileno')";
mysqli_query($conn,$query2);
?>

并更改数据库:

创建表 test2 ( id INT(9) AUTO_INCREMENT 主键， name2 varchar(128) 默认 NULL， mobileno2 varchar(128) 默认 NULL) ENGINE=InnoDB 默认字符集=latin1;

终于可以在 RHEL7 上运行了。我真的很开心……谢谢大家