Hi all
I have written following code works when i import first time, i wrote a condition to check the values are exists in the page before insert so it is stopped working, otherwise inserting the duplicate rows
please correct my code
if(isset($_GET['module']) && !empty($_GET['module']))
{
$module = $_GET['module'];
$currenttime=time();
$filename="CSVFiles/Tempfile".$currenttime."xls";
$tmpfile = $_FILES['MemberCSV']['tmp_name'];
$upok = move_uploaded_file($tmpfile,$filename);
$target_path = '';
$csvfilename=$_FILES['MemberCSV']['name'];
$fp = fopen($_FILES['MemberCSV']['tmp_name'], 'r') or die('Could not open file!');
$target_path = "temp/". basename( $_FILES['MemberCSV']['name']);
$ext = substr(strrchr($target_path, '.\.'), 1);
$row = 1;
$handle = fopen ($csvfilename,"r");
$username="";
if($ext == "xls")
{
//while ($data = fgetcsv($fp, 1024))
{
//$x=0;
$file_content = file($_FILES['MemberCSV']['tmp_name']);
for($i=1; $i<count($file_content); $i++)
{
$varia= explode("\t", $file_content[$i]);
if(sizeof($varia) > 1)
{
foreach($varia as $k=>$v)
{
$v = trim($v,"\x7f..\xff\x0..\x1f");
}
// insert new record into database
if( ($varia[0]=="") && ($varia[1]=="") && ($varia[2]=="") && ($varia[3]=="") && ($varia[4]=="") && ($varia[5]=="") && ($varia[6]=="") && ($varia[8]=="") && ($varia[7]=="") )
{
$errcnt++;
$username.=$varia[0]."<br>";
}
else{
// required data else
$username=$varia[0];
$email=$varia[4];
if($varia[0]!="")
{
$users="select * from ".$tablename['TBL_MEMBERS']." where es_username='".$varia[0]."'";
$user=mysql_query($users);
$row=mysql_fetch_row($user);
$uname= $row["1"];
$pass=$row["2"];
$email_tbl=$row["5"];
$city_tbl = $row["8"];
$country = $row["11"];
$rs_t_query=mysql_query ("select * from ".$tablename['TBL_COUNTRY']." where id=".$country." order by country");
$row1=mysql_fetch_row($rs_t_query);
$countryname= $row1["0"];
if(mysql_num_rows($user)==0)
{
$errcnt++;
$username.=$varia[0]."<br>";
}
echo "hello ".$uname." ".$pass. " ".$email_tbl." ".$city_tbl." ". $countryname;
// echo "<br>";
echo $varia["0"]." ".$varia["1"]." ".$varia["4"]." ".$varia["6"]." ".$varia["9"]." " ;
$errcnt=0;
if(($uname!=$varia[0] ) || ($pass != $varia[1] )|| ($email_tbl != $varia["4"]) || ($city_tbl != $varia["6"]) || ($countryname != $varia["9"]))
{
echo "error";
$rs_t_query=mysql_query ("select * from ".$tablename['TBL_COUNTRY']." where country= '".$varia["9"]."' order by country");
while ($rs_t=mysql_fetch_array($rs_t_query))
{
$countryid=$rs_t["id"];
if ($country== $rs_t["id"] )
{
// echo " selected ";
}
echo $rs_t["country"] ."<br>";
echo $countryid;
}
}
}
else
{
$insert = "INSERT INTO ". $tablename['TBL_MEMBERS'] ." ( es_username, es_password, es_firstname, es_lastname,es_email, es_street, es_city, es_state, es_zip, es_country, es_phone, es_fax, es_mobile, es_memtype)
VALUES('".trim($varia[0],"\x7f..\xff\x0..\x1f")."','".trim($varia[1],"\x7f..\xff\x0..\x1f")."','".trim($varia[2],"\x7f..\xff\x0..\x1f")."','".trim($varia[3],"\x7f..\xff\x0..\x1f")."','".trim($varia[4],"\x7f..\xff\x0..\x1f")."','".trim($varia[5],"\x7f..\xff\x0..\x1f")."','".trim($varia[6],"\x7f..\xff\x0..\x1f")."','".trim($varia[7],"\x7f..\xff\x0..\x1f")."','".trim($varia[8],"\x7f..\xff\x0..\x1f")."','".trim($varia[9],"\x7f..\xff\x0..\x1f")."','".trim($varia[10],"\x7f..\xff\x0..\x1f")."','".trim($varia[11],"\x7f..\xff\x0..\x1f")."','".trim($varia[12],"\x7f..\xff\x0..\x1f")."','".trim($varia[13],"\x7f..\xff\x0..\x1f")."')";
$res_insert = mysql_query($insert); }
}
}
}
// $i++;
//if($x>0){$x++;}
}//close while loop
}
$_SESSION['errMessage'] = "upload failed";