PHP中没有错误[重复]

Question

This question already has an answer here:

• PHP parse/syntax errors; and how to solve them? 17 answers
• Reference - What does this error mean in PHP? 34 answers
• Can I mix MySQL APIs in PHP? 4 answers
• When to use single quotes, double quotes, and backticks in MySQL 12 answers

I want to import data from CSV to database so I am using PHP and WAMP server and I have a code which is:

<?php
include_once("C:\wamp64\www\db_connect.php");
if(isset($_POST['import_data'])){
// validate to check uploaded file is a valid csv file
    $file_mimes = array('text/x-comma-separated-values', 'text/comma-separated-values', 'application/octet-stream', 'application/vnd.ms-excel', 'application/x-csv', 'text/x-csv', 'text/csv', 'application/csv', 'application/excel', 'application/vnd.msexcel', 'text/plain');
    if(!empty($_FILES['file']['name']) && in_array($_FILES['file']['type'],$file_mimes)){
        if(is_uploaded_file($_FILES['file']['tmp_name'])){
            $csv_file = fopen($_FILES['file']['tmp_name'], 'r');
//fgetcsv($csv_file);
// get data records from csv file
            while(($emp_record = fgetcsv($csv_file)) !== FALSE){
// Check if employee already exists with same email
                $sql_query = "SELECT Date, Time, Alias, Machine_Name, Build_Name, Build_version, WinDBG, .NET_Framework FROM testbad_information WHERE Machine_Name = '".$emp_record[3]."';
                $resultset = mysql_query($conn, $sql_query) or die("database error:". mysqli_error($conn));
// if employee already exist then update details otherwise insert new record
                if(mysqli_num_rows($resultset)) {
                    $sql_update = "UPDATE testbad_information set Date='".$emp_record[1]."', Time='".$emp_record[2]."', Alias='".$emp_record[3]."', Build_Name='".$emp_record[5]."', Build_version='".$emp_record[6]."', WinDBG='".$emp_record[7]."', .NET_Framework='".$emp_record[8]."' WHERE Machine_Name = '".$emp_record[4]."'";
                    mysqli_query($conn, $sql_update) or die("database error:". mysqli_error($conn));
                } else{
                    $mysql_insert = "INSERT INTO testbad_information (Date, Time, Alias, Machine_Name, Build_Name, Build_version, WinDBG, .NET_Framework )VALUES('".$emp_record[1]."', '".$emp_record[2]."', '".$emp_record[3]."', '".$emp_record[4]."', '".$emp_record[5]."', '".$emp_record[6]."', '".$emp_record[7]."', '".$emp_record[8]."')";
                    mysqli_query($conn, $mysql_insert) or die("database error:". mysqli_error($conn));
                }
            }
            fclose($csv_file);
            $import_status = '?import_status=success';
        } else {
            $import_status = '?import_status=error';
        }
    } else {
        $import_status = '?import_status=invalid_file';
    }
}
header("Location: index.php".$import_status);
?>

And it is showing a error like this:

Parse error: syntax error, unexpected 'database' (T_STRING) in C:\wamp64\www\import.php on line 14

I don't understand the problem. Can anyone please help me to solve this?

</div>

Answer 1

in this line you have missed a double quote

$sql_query = "SELECT Date, Time, Alias, Machine_Name, Build_Name, Build_version, WinDBG, .NET_Framework FROM testbad_information WHERE Machine_Name = '".$emp_record[3]."';

to

$sql_query = "SELECT `Date`, `Time`, `Alias`, `Machine_Name`, `Build_Name`, `Build_version`, `WinDBG`, `.NET_Framework` FROM testbad_information WHERE Machine_Name = '".$emp_record[3]."'";