如何读取.csv文件并将记录插入MySQL [关闭]

Question

I am looking for PHP script that capable of imports my 3 column data into my table which has 5 fields.

Is this possible?

Answer 1

I think you need something like this

$file = fopen("airport 123.csv","r ");
$i = 0;
while(!feof($file))
  {
    $file_data = fgetcsv($file);
    //print_r($file_data);
    $select = "select count(*) from airport_pricing";
    $result = mysql_num_rows($select);
    if($result>0)
    {
        echo $sql = "UPDATE airport_pricing SET pickup ='$file_data[0]',dropoff='$file_data[1]', price='$file_data[2]' ";
    }
    else{
        echo $sql = "INSERT INTO airport_pricing values(NUll,'$file_data[0]','$file_data[1]','$file_data[2]',1)";
    }
    $query = mysql_query($sql);
    if(!$query)
    {
        $error = "Record is not inserted !";
    }
    else
    {
        $error = "Record is inserted Successfully !";
    }
    echo "<br />";
  }

fclose($file);

    echo $error;

?>