function load_profile($user_id, $fname, $mname, $lname, $dob, $gender, $father, $mother, $preadd, $peradd) { if (getuserfield_profile('first_name', $user_id) == NULL) { $query = "INSERT INTO user_personal_info VALUES(" . mysql_real_escape_string($user_id) . ", '" . mysql_real_escape_string($fname) . "', '" . mysql_real_escape_string($mname) . "', \n '" . mysql_real_escape_string($lname) . "', '" . mysql_real_escape_string($dob) . "','" . mysql_real_escape_string($gender) . "',\n '" . mysql_real_escape_string($father) . "', '" . mysql_real_escape_string($mother) . "', \n '" . mysql_real_escape_string($preadd) . "', '" . mysql_real_escape_string($peradd) . "', '')"; $query_run = mysql_query($query); if ($query_run) { return TRUE; } else { return FALSE; } } else { $query = "UPDATE user_personal_info SET first_name='" . mysql_real_escape_string($fname) . "', mid_name='" . mysql_real_escape_string($mname) . "', \n last_name='" . mysql_real_escape_string($lname) . "', dob='" . mysql_real_escape_string($dob) . "',gender='" . mysql_real_escape_string($gender) . "',\n father_name='" . mysql_real_escape_string($father) . "', mother_name='" . mysql_real_escape_string($mother) . "', \n present_add='" . mysql_real_escape_string($preadd) . "', permanent_add='" . mysql_real_escape_string($peradd) . "' WHERE id={$user_id}"; $query_run = mysql_query($query); if ($query_run) { return TRUE; } else { return FALSE; } } }
echo getuserfield_profile('present_add', $user_id); ?> </textarea> </div> </div> <div class="form-group"> <label class="col-sm-2 control-label">Same as Permanent Address</label> <div class="col-sm-10"> <input type="checkbox" id="sameaddr"> </div> </div> <div class="form-group"> <label for="permanentaddress" class="col-sm-2 control-label">Permanent Address</label> <div class="col-sm-10"> <textarea class="form-control" id="permanentaddress" name="permanentaddress" placeholder="Permanent Address" required><?php echo getuserfield_profile('permanent_add', $user_id); ?> </textarea> </div> </div> <div class="form-group"> <div class="col-sm-offset-2 col-sm-10"> <button type="submit" class="btn btn-primary btn-flat" onclick="return validate()">Submit</button> <button type="reset" class="btn btn-danger btn-flat">Cancel</button> </div> </div> <br> </form> </div><!-- /.tab-pane --> </div><!-- /.tab-content --> </div><!-- /.nav-tabs-custom -->