Tech

Delete is a little tricky, two variables needed. One is the existing $eduIdDb obtained from database, second is during POST($eduIDpost) to find out which row is being removed. Hence a…

Continue from Insert, adding and else statement   else { //update $query = "UPDATE education SET Startyear ='$Startyearinput_esc', Endyear='$Endyearinput_esc', School='$Schoolinput_esc', Course='$Courseinput_esc', Qualification='$Qualificationinput_esc', member_Member_id='$memberId' WHERE Education_id='$Educationinput_esc'"; $queryResult = $db->writeQuery($query); if (!empty($queryResult)){…

First find out how many rows has been submitted and removed - $repeatTimes //find out the max number of database rows $dbRow; //find out the max number of submitted rows…

Process the submitted forms through PHP         if(!empty($_POST['spprofile'])) { //echo '', print_r($_POST, true), ''; $eduIDpost = $_POST['spprofile']['eduID']; $eduID = $_POST['spprofile']['eduID']; $Startyear = $_POST['spprofile']['Startyear']; $Endyear = $_POST['spprofile']['Endyear']; $School…

   

The add and remove button is added in front of the table:   <p> <input type="button" class="btn btn-success" value="Add a New Education History" onClick="addRow('eduTable')" /> <input type="button" class="btn btn-warning" value="Remove…

Prepare for two types of scenarios: When the form first open <tbody> <tr> <p> <td><input type="checkbox" required="required" name="chk[]" checked="checked" /> </td> <td> <label>Start Year</label> <input type="hidden" id="edu" style="width:100px" class="form-control" name="spprofile[eduID][]"…

Objective:     Create a form to update user's education history. User can create a new record (new row), then add a new row to create another new record. User…

  if(!empty($_SESSION)){ //echo '<pre>', print_r($_SESSION, true), '</pre>'; $memberId = $_SESSION['logged_in_Member_id']; if (isset($_SESSION['logged_in_Member_id'])){ $loggedin = "true"; } }

Task to translate 03-19-2015 into the format 19/03/2015 using Php     *be careful the m/d/Y not to be confused with d/m/Y     *be careful the / in the…