尝试这个简单的方法。

  if（（$ handle = fopen（google.csv，r））！== FALSE）{
 while（（$ data = fgetcsv ，1000，））！== FALSE）{
 $ db-> conn-> query（INSERT INTO values（'。implode（'\'，\'数据）'）;）; 
} 
 fclose（$ handle）; 
} 
 

您的脚本也可能需要为CSV值添加引号， t已经有引号。如果您需要处理CSV文件中的引号和所有内容，我们建议您查看我的博文： http://www.fusionswift.com/2012/07/php-import-csv-to-mysql/

Possible Duplicate:
Import CSV to mysql

Right I need some help with this:

I am trying to import a .csv file into a mysql database using php, rather than doing it manually through phpmyadmin.

This is the code I have at the moment:

if($_REQUEST['func'] == "iid"){
    $db->conn = new mysqli(DB_SERVER, DB_USER, DB_PASSWORD, DB_NAME) or 
                      die('There was a problem connecting to the database.');
    $csv = $_POST['csv-file'];
    $path = $csv;
    $row = 1;
    if (($handle = fopen($path, "r")) !== FALSE) {
        while (($data = fgetcsv($handle, 1000, ";")) !== FALSE) {
            $row++;
            $data_entries[] = $data ;

        }
        fclose($handle);
    }
    // this you'll have to expand
    foreach($data_entries as $line){
        $sql = $db->conn->prepare('INSERT INTO `bd_results`');

        $db->execute($line);
    }
}

However I get the following error:

Fatal error: Call to undefined method stdClass::execute() in /homepages/19/d372249701/htdocs/business-sites/bowlplex-doubles-new/admin/scores.php on line 44

For reference I am using this code taken from: Here

I am not well versed in the $db->conn business I'm used to mysql_connect!! so any help would be appreciated.

Try this simple one.

if (($handle = fopen("google.csv", "r")) !== FALSE) {
    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
        $db->conn->query("INSERT INTO values('" . implode('\',\'', $data) . "');");
    }
    fclose($handle);
}

Your script might also need to add quotes to the CSV values if they don't have quotes already. If you'll be needing to deal with quotes and all in your CSV files, I recommend you look at my blog post at http://www.fusionswift.com/2012/07/php-import-csv-to-mysql/