<?
//require_once'../config.inc.php';
$objConnect = mysql_connect("localhost","root","root") or die("Error Connect to Database"); // Conect to MySQL
$objDB = mysql_select_db("nannapas_london");
$objCSV = fopen("excel_import.csv", "r");
while (($objArr = fgetcsv($objCSV, 1000, ",")) !== FALSE) {
$strSQL = "INSERT INTO tb_members";
$strSQL .="(id,title,lastname,firstname,address,town,country,company_name,limited,postcode,city,telephone,company_no,email,fax,status,telephone1,telephone2, address_delivery,town_delivery,county_delivery,postcode_delivery,country_delivery,tel,year,date)";
$strSQL .="VALUES";
$strSQL .="('".$objArr[0]."','".$objArr[1]."','".$objArr[2]."','".$objArr[3]."','".$objArr[4]."','".$objArr[5]."','".$objArr[6]."','".$objArr[7]."' ";
$strSQL .=",'".$objArr[8]."','".$objArr[9]."','".$objArr[10]."','".$objArr[11]."','".$objArr[12]."','".$objArr[13]."','".$objArr[14]."','".$objArr[15]."' ";
$strSQL .=",'".$objArr[16]."','".$objArr[17]."','".$objArr[18]."','".$objArr[19]."','".$objArr[20]."','".$objArr[21]."','".$objArr[22]."','".$objArr[23]."' ";
$strSQL .=",'".$objArr[24]."','".$objArr[25]."','".$objArr[26]."') ";
$objQuery = mysql_query($strSQL);
}
fclose($objCSV);
echo "Import Done.";
?>
