엑셀 CSV(쉼표분리, Excel) --> MySQL 저장하기

$t = file("../회원명단.csv");
$cnt=0;

    for($i=0;$i< sizeof($t);$i++){
        $s = explode(",",$t[$i]);

        $name  = $s[0];
        $lic_num = $s[1];
        $office  = $s[2];
        $phone = $s[3];
        $hp = $s[4];
        $email = $s[5];


        $sql = "insert into member (lic_num,name,office,phone,hp,email) values
            ($lic_num,'$name','$office','$phone','$hp','$email')";
        mysql_query($sql);


        $cnt++;

    }

    echo $cnt .'건 처리';