使用PHP将TXT导入MYSQ

    <?php  
    $dbhost;  
    $username;  
    $passwd;  
    $database;  
    $table;  
    $conn = mysql_connect("$dbhost","$username","$passwd");  
    mysql_select_db("$database",$conn);  
    mysql_query("SET NAMES UTF8");  
      
    $handle = fopen('$filename', 'r');  
    while($data = fgetcsv($handle, 4096, "/t")) {  
        $str ="INSERT INTO $table  
                            VALUES ('$data[0]', '$data[1]', '$data[2]')";  
        mysql_query($str);  
    }  
    echo "导入成功";  
    ?>