import csv file into database

[learner001]

I have a code through which i want to import csv file into databse. But i am getting an error:
fopen() [function.fopen]: Filename cannot be empty and points on line 36(have marked in the code
Would appreciate if anyone could help me

<?php
if ($_FILES["file"]["error"] > 0)
{
    echo "Error: " . $_FILES["file"]["error"] . "<br>";
}
else
{
    echo "Upload: " . $_FILES["file"]["name"] . "<br>";
    echo "Type: " . $_FILES["file"]["type"] . "<br>";
    echo "Size: " . ($_FILES["file"]["size"] / 1024) . " Kb<br>";
    //echo "Stored in: " . $_FILES["file"]["tmp_name"];
    $a=$_FILES["file"]["tmp_name"];
    //echo $a;
 
    $connect = mysql_connect('example.com','employee','172');
if (!$connect) {
die('Could not connect to MySQL: ' . mysql_error());
}    
//your database name
$cid =mysql_select_db('employeemgt',$connect);
 
// path where your CSV file is located
//define('CSV_PATH','C:/xampp/htdocs/');
//<!-- C:\xampp\htdocs -->
// Name of your CSV file
$file = $a; 
 
if (($getfile = fopen($file, "r")) !== FALSE) { //line36
         $data = fgetcsv($getfile, 1000, ",");
   while (($data = fgetcsv($getfile, 1000, ",")) !== FALSE) {
     //$num = count($data);
       //echo $num;
        //for ($c=0; $c < $num; $c++) {
            $result = $data;
            $str = implode(",", $result);
            $slice = explode(",", $str);
 
            $col1 = $slice[0];
            $col2 = $slice[1];
            $col3 = $slice[2];
            $col4 = $slice[3];
            $col5 = $slice[4];
            $col6 = $slice[5];
            $col7 = $slice[6];
            $col8 = $slice[7];
            $col9 = $slice[8];
            $col10 = $slice[9];
            $col11 = $slice[10];
            $col12 = $slice[11];
            $col13 = $slice[12];
            $col14 = $slice[13];
            $col15 = $slice[14];
            $col16 = $slice[15];
            $col17 = $slice[16];
            $col18 = $slice[17];
            $col19 = $slice[18];
            $col20= $slice[19];
            $col21= $slice[20];
            $col22 = $slice[21];
            $col23 = $slice[22];
            $col24 = $slice[23];
            $col25 = $slice[24];
            $col26 = $slice[25];
            $col27 = $slice[26];
            $col28 = $slice[27];
            $col29 = $slice[28];
            $col30 = $slice[29];
            $col31 = $slice[30];
            $col32 = $slice[31];
 
 
$query = "INSERT INTO temp(id,firstname,lastname,displayname,nickname,email,email2,homephone,busnphone,fax,pager,mobphone,homestreet,homeaddress2,homecity,homestate,home,postalcode,homecountry,busadrs,busadrs2,buscity,busstate,buspostalcode,busicountry,jobtitle,deptt,orgnztn,notes,bday,webpage,webpage2,categories) VALUES('".$col1."','".$col2."','".$col3."','".$col4."','".$col5."','".$col6."','".$col7."','".$col8."','".$col9."','".$col10."','".$col11."','".$col12."','".$col13."','".$col4."','".$col15."','".$col16."','".$col17."','".$col18."','".$col9."','".$col20."','".$col21."','".$col22."','".$col23."','".$col24."','".$col25."','".$col26."','".$col27."','".$col28."','".$col29."','".$col30."','".$col31."','".$col32."')";
$s=mysql_query($query, $connect );
}
}
 
echo "File data successfully imported to database!!";
mysql_close($connect);
}
?>
 

[Dormilich]

hm, what do you think

Filename cannot be empty

means?

besides that, MySQL can import CSV directly.