我想将我的 csv 上传文件的第 1 行放入表 tab1........ 并将第 2 行放入表 tab2
我努力了:
$myid = 231;
if (isset($_POST["submit"])) {
$file = $_FILES['file']['tmp_name'];
if (($handle = fopen($file, "r")) !== FALSE) {
$row = 0;
while (($data = fgetcsv($handle, 100000, ",")) !== FALSE) {
if ($row == 1) {
$row++;
continue;
}
$row++;
foreach (['tab1', 'tab2'] as $table) {
$stmt = $pdo->prepare("UPDATE $table SET fname=?, lname=? WHERE id=?");
$stmt->execute([$data[0], $data[1], $myid]);
}
}
fclose($handle);
}
}
千巷猫影