CSV数据导入问题

Question

最近你好我已经下载了一个脚本来导入数据到数据库。我已经创建了一个表单，用户将上传文件，并从那我想要的数据添加到数据库我不知道我做得正确或不正确，因为我得到500内部服务器错误的错误可能是我的代码搞砸了向上。

require('../admin/includes/connection.php'); 

$file = $_FILES['data_email']['name']; 
$file_temp = $_FILES['data_email']['tmp_name']; 
move_uploaded_file($file_temp, '../admin/uploads/'.$file); 
// path where your CSV file is located 
define('CSV_PATH','http://wintroninformatics.com/admin/uploads/'); 
// Name of your CSV file 
$csv_file = CSV_PATH . $file; 

$data = mysqli_query($connection, 'SELECT * FROM users WHERE uid = "'.$_SESSION['uid'].'"'); 
$user = mysqli_fetch_array($data); 
if (($handle = fopen($csv_file, "r")) !== FALSE) { 
    fgetcsv($handle); 
    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { 
     $num = count($data); 
     for ($c=0; $c < $num; $c++) { 
      $col[$c] = $data[$c]; 
     } 

    $col2 = $col[1]; 

// SQL Query to insert data into DataBase 
$query = "INSERT INTO email_data(date_uploaded, email_id, username, status) VALUES('".date('d-m-Y')"','".$col2."','".$user['username']."', 'Approved')"; 
$s  = mysqli_query($connection, $query); 
} 
    fclose($handle); 
} 

echo "File data successfully imported to database!!"; 

Answer 1

不能调试这种方式。 500内部服务器错误意味着您没有启用错误报告。

添加下面一行在你的代码的顶部发现在你的代码

error_reporting(E_ALL);