D:\host\scoreman.in\kldistricts2025\micro.php
<?php
if(!empty($_POST))
{
//database settings
include "config.php";
// var_dump($_POST);
foreach($_POST as $field_name => $val)
{
//clean post values
$field_userid = strip_tags(trim($field_name));
$val = strip_tags(trim($con->real_escape_string($val)));
//from the fieldname:user_id we need to get user_id
$split_data = explode(':', $field_userid);
$appno = $split_data[1];
$field_name = $split_data[0];
if(!empty($appno) && !empty($field_name) && !empty($val))
{
//update the values
$qtext='UPDATE applications SET '.$field_name.'="'.$val.'" WHERE appno = "'.$appno.'"';
// echo $qtext;
mysqli_query($con,$qtext) or mysqli_error();
echo "Updated";
} else {
// echo "Invalid Requests";
}
}
} else {
echo "Invalid Requests";
}
?>