我尝试从表 1 中获取所有值,然后将它们推入一个数组中。然后我将数组插入表2,但收到错误消息:“非法字符串偏移量'name'”,“非法字符串偏移量'lat'”,“非法字符串偏移量'lng'” 我已经搜索了这个错误并且尝试修复它,但我做不到。有人能帮我解决这个问题吗?这是我的代码:
$query = "DELETE FROM gpsdata";
$query_input = "SELECT name, lat, lng FROM gpsdata";
$result = mysqli_query($connect, $query_input);
while ($data = mysqli_fetch_array($result)) {
if (is_array($data)) {
$sql = array();
foreach ($data as $row) {
$sql[] = '(' . $row['name'] . ', ' . $row['lat'] . ', ' . $row['lng'] . ')';
};
$query2 = "INSERT INTO gpsdata_backup (name, lat, lng) VALUES ' . implode(',', $sql)'";
$result_insert = mysqli_query($connect, $query2);
}
}
海绵宝宝撒
慕斯709654