php - 使用php从远程mysql表插入mysql数据

Question

使用 php，我尝试访问远程 mysql 表并将其导入本地服务器。但是，我不知道如何让导入工作。我不断收到“在非对象上调用成员函数bind_param()”错误。

<?php
$localDB = new mysqli("", "", "", "");  //filled in for actual but ignored for question
$remoteDB = new mysqli("", "", "", ""); //filled in for actual but ignored for question
$pat = "0";

$getQuery = "SELECT eventname, da, mont, yea, autoinc, pic, codez, emai, pricof, excl FROM `eventannoun` WHERE da > ?";
$getStmt = $remoteDB->prepare($getQuery);
$getStmt->bind_param('i', $pat); //error here
$getStmt->execute();
$getStmt->bind_result($message, $da, $mont, $yea, $autoinc, $pic, $codez, $emai, $pricof, $excl);

$putQuery = "INSERT INTO `eventannoun` (eventname, da, mont, yea, autoinc, pic, codez, emai, pricof, excl) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
$putStmt = $localDB->prepare($putQuery);
$putStmt->bind_param('siiiiisssi',$message, $da, $mont, $yea, $autoinc, $pic, $codez, $emai, $pricof, $excl);

while ($getStmt->fetch()) {
  $putStmt->execute();
  $putStmt->fetch();
}
$getStmt->close();
$putStmt->close();
?>

Answer 1

您确定可以远程连接到该mysql吗？

检查服务器上的3306端口是否打开(使用http://www.yougetsignal.com/tools/open-ports/等工具)

如果它是开放的，您可能需要将您的 IP 列入白名单