The below simple php function is used to insert data into MySql database with out manually filling the insert mysql query with input filed names. Function: function insert_Defined($table, $array,$ins=''){ // insert('table', array_map('trim',$_POST)); global $db; $query = "INSERT INTO" . ' ' . $table; $fis = array(); $vas = array(); foreach ($array as $field => $val) { $fis[] = "`$field`"; $vas[] = ($val != "NOW()") ? "'" . mysqli_real_escape_string($db,$val) . "'" : "NOW()"; } $query .= "(" . implode(",", $fis) . ") VALUES (" . implode(",", $vas) . ")"; //echo $query;exit; Query($query);if(!empty($ins)){$ins_id=mysqli_insert_id($db);return $ins_id;} } Form: <form action="" method="post" name="designation&