如何將此文件導(dǎo)入到mysql，行之間有空格？ 通過 phpmyadmin 這是可能的，但我需要通過網(wǎng)站來完成。<?php// Check if file was uploaded & there were no errorsif ($_FILES && $_FILES['csv-file']['error'] == 0) { $extension = pathinfo($_FILES['csv-file']['name'],PATHINFO_EXTENSION); // Check if extension is csv then proceed to import if($extension == 'csv'){ // Open file for reading $file = fopen($_FILES['csv-file']['tmp_name'], 'r'); // Loop through all rows of file and insert them to database table while (!feof($file)) { // Get current row as recordset $row = fgetcsv($file); if (!empty($row)) { $data = []; $data['numbers'] = htmlentities($row[0]); $data['tids'] = htmlentities($row[1]); $data['date'] = htmlentities($row[2]); $data['time'] = htmlentities($row[3]); $data['zero'] = htmlentities($row[4]); $data['terminal_sn'] = htmlentities($row[5]); $data['space'] = htmlentities($row[6]); $records[] = $data; mysqli_query($dbcon,"INSERT INTO employees (".implode(",",array_keys($data)).") VALUES ('".implode("','",array_values($data))."')"); } } }else{?>這是我的 .csv 文件，其中包含數(shù)據(jù)：10222157120501 T0040922 07/09/2020 18:13:56 0 315-525-348 110223157120502 T0040923 07/09/2020 18:15:24 0 318-027-497 110224157120503 T0040924 07/09/2020 18:15:36 0 316-176-614 110225157120504 T0040925 07/09/2020 18:16:25 0 317-377-077 1
1 回答
蝴蝶刀刀
TA貢獻1801條經(jīng)驗 獲得超8個贊
// prepare the insert query once outside the loop
$sql = 'INSERT INTO employees (`numbers`, `tids`, `date`, `time`,
`zero`, `terminal_sn`, `space`)
VALUES(?,?,?,?,?,?,?)';
$stmt = $dbcon->prepare($sql);
if (($handle = fopen($_FILES['csv-file']['name'], "r")) !== FALSE) {
while (($data = fgetcsv($handle, 1000, " ")) !== FALSE) {
// space delimiter ^
// bind the columns to the query parameters
$stmt->bind_param('sssssss', $row[0], $row[1], $row[2], $row[3],
$row[4],$row[5], row[6]);
// execute the query with parameters replaced with data
$stmt->execute();
}
fclose($handle);
}
- 1 回答
- 0 關(guān)注
- 160 瀏覽
添加回答
舉報
0/150
提交
取消