See how much easier your code is to read now?
if (isset($_POST['submit'])) {
if (is_uploaded_file($_FILES['filename']['tmp_name'])) {
echo "<h1>" . "File ". $_FILES['filename']['name'] ." uploaded successfully." . "</h1>";
echo "<h2>Displaying contents:</h2>";
readfile($_FILES['filename']['tmp_name']);
}
//Import uploaded file to Database
$handle = fopen($_FILES['filename']['tmp_name'], "r");
while (($data = fgetcsv($handle, 2000, ",")) !== FALSE){
$Sql=mysql_query("select * from test where id ='$id'");
if(mysql_num_rows($Sql) > 0) {
$import="update test set `name`='$data[1]', `gender`='$data[2]', `designation`='$data[3]' where id='$data[0]'";
mysql_query($import) or die(mysql_error());
} else {
$import="insert into test set `name`='$data[1]', `gender`='$data[2]', `designation`='$data[3]', `id`='$data[0]'";
mysql_query($import) or die(mysql_error());
}
}
fclose($handle);
print "Update done";