Example #1
0
 // SECTION: 2d Process Form - Passed Validation
 //
 // Process for when the form passes validation (the errorMsg array is empty)
 //
 $dataEntered = false;
 try {
     $thisDatabase->db->beginTransaction();
     $query = 'INSERT INTO tblTasks SET ';
     $query .= 'fnkStudentNetId = ? , ';
     $query .= 'fnkProjectId = ? , ';
     $query .= 'fldTaskName = ? , ';
     $query .= 'fldTaskDueDate = ? , ';
     $query .= 'fldCompleted = ? ';
     $data = array($AssignedNetId, $ProjectId, $TaskName, $TaskDueDate, $Complete);
     $results = $thisDatabase->insert($query, $data);
     $primaryKey = $thisDatabase->lastInsert();
     if ($debug) {
         print "<p>pmk= " . $primaryKey;
     }
     // all sql statements are done so lets commit to our changes
     //if($_SERVER["REMOTE_USER"]=='rerickso'){
     $dataEntered = $thisDatabase->db->commit();
     // }else{
     //     $thisDatabase->db->rollback();
     // }
     if ($debug) {
         print "<p>transaction complete ";
     }
 } catch (PDOExecption $e) {
     $thisDatabase->db->rollback();
     if ($debug) {