";
}
if ($db->error) {
printf("Could not insert record into table: %s
";
} else{
$updateData = ("UPDATE facilitators SET
estate = IF(estate != '$estate' and '$estate' != '', '$estate', estate),
municipality = IF(municipality != '$municipality' and '$municipality' != '', '$municipality', municipality),
parish = IF(parish != '$parish' and '$parish' != '', '$parish', parish),
name = IF(name != '$name' and '$name' != '', '$name', name),
lastname = IF(lastname != '$lastname' and '$lastname' != '', '$lastname', lastname),
document_number = IF(document_number != '$document_number' and '$document_number' != '', '$document_number', document_number),
phone_number = IF(phone_number != '$phone_number' and '$phone_number' != '', '$phone_number', phone_number),
email = IF(email != '$email' and '$email' != '', '$email', email),
gender = IF(gender != '$gender' and '$gender' != '', '$gender', gender),
birthdate = IF(birthdate != '$birthdate' and '$birthdate' != '', '$birthdate', birthdate),
date_admission = IF(date_admission != '$date_admission' and '$date_admission' != '', '$date_admission', date_admission),
info_cod = IF(info_cod != '$info_cod' and '$info_cod' != '', '$info_cod', info_cod),
status_nom = IF(status_nom != '$status_nom' and '$status_nom' != '', '$status_nom', status_nom),
personal_type = IF(personal_type != '$personal_type' and '$personal_type' != '', '$personal_type', personal_type),
observations =IF(observations != '$observations' and '$observations' != '', '$observations', observations)
WHERE document_number='$document_number'
");
$resultadoUpdate = $db->query($updateData);
echo '
'. $i. '
';
echo "ACTUALIZADO: ".$document_number."
";
}
} //Cierre de mi 2 If
} //Cierre de mi 1 If
// echo '
'. $i. '
';
$i++;
}
// echo $updateData;
// echo '
Total de Registros: '. $cantidad_regist_agregados .'
';
echo "
Datos subidos con éxito | Puedes volver";
?>