"; // make the database work. include_once ('dbConnect.php'); include_once ('includes/dbh.inc.php'); session_start(); #print_r($_SESSION); //Get required Session variables $session_id = $_SESSION['LoginMemberID']; $LoginAccessLevel = $_SESSION['LoginAccessLevel']; $strDate = $_SESSION['strDate']; $ViewID = $_SESSION['ViewID']; // get the 'id' value from the URL (if it exists), making sure that it is valid (checking that it is numeric/larger than 0) if (isset($_GET['user_id']) && is_numeric($_GET['user_id']) && $_GET['user_id'] > 0) { if ($_SESSION['member_view']!=0 or $session_id==$_GET['user_id']) {} else { header("location:Access-denied.php");} $user_id = $_GET['user_id']; $user_name = $mysqli->query("SELECT COUNT(*) AS NumRows FROM Inspectors where user_id='$user_id'") or die ($mysqli->error); $row4 = $user_name->fetch_array(); if ($row4['NumRows'] == 0) { // query db user $result = $mysqli->query("SELECT * FROM user WHERE user_id='$user_id'") or die($mysqli->error); $row = $result->fetch_array(MYSQLI_ASSOC); foreach ($row as $key => $value) { $output[$key] = $value; } } else { // query db user $user_id = $_GET['user_id']; $result = $mysqli->query("SELECT * FROM user JOIN Inspectors ON user.user_id = Inspectors.user_id WHERE user.user_id='$user_id'") or die($mysqli->error); $row = $result->fetch_array(MYSQLI_ASSOC); foreach ($row as $key => $value) { $output[$key] = $value; } } // now we get the user information and add it to the $output array. $result = $mysqli->query("SELECT data_type,data_value FROM user_data WHERE data_user_id='$user_id'") or die($mysqli->error); while($row = $result->fetch_array(MYSQLI_ASSOC)) { $output['user_data'][$row['data_type']] = $row['data_value']; } $full_name = $output['user_first']." ".$output['user_surname']; //print_r($output); } if (isset($_POST['submit-record'])) { if ($_SESSION['system_admin']=='0' or $session_id=$user_id){ // get form data, making sure it is valid $user_id = $_POST['user_id']; $user_first = ucwords($_POST['user_first']); $user_surname = ucwords($_POST['user_surname']); $user_first = htmlspecialchars($user_first,ENT_QUOTES); $user_surname =htmlentities($user_surname,ENT_QUOTES); $user_email = strtolower($_POST['user_email']); $user_access_level = $_POST['user_access_level']; $user_active = $_POST['user_active']; $date_joined = $_POST['date_joined']; $membertype = $_POST['membertype']; $inspector = $_POST['inspector']; $notice_type1=$_POST['notice_type1']; $notice_type2=$_POST['notice_type2']; $notice_type3=$_POST['notice_type3']; $edit_data=$_POST['edit_data']; $fsrtrainer=$_POST['fsrtrainer']; $news=$_POST['news']; $member_view=$_POST['member_view']; $eng_admin=$_POST['eng_admin']; $purchase_order=$_POST['purchase_order']; $add_users=$_POST['add_users']; $menu=$_POST['menu']; $mute=$_POST['mute']; $gender=$_POST['gender']; $session_id=$_SESSION['LoginMemberID']; if (!isset($_POST['user_first']) OR empty($_POST['user_first'])) { $_error[] = 'no_firstname'; } if (!isset($_POST['user_surname']) OR empty($_POST['user_surname'])) { $_error[] = 'no_surname'; } if (isset($_GET['user_id']) && is_numeric($_GET['user_id']) && $_GET['user_id'] > 0) { } else { //check it member exists $sql = "SELECT * FROM user WHERE user_first='$user_first' AND user_surname='$user_surname'"; $result = mysqli_query($mysqli, $sql); if (mysqli_num_rows($result) > 0) { $_error[] = 'Member exists'; } } if (!isset($_error)) { if (isset($_GET['user_id']) && is_numeric($_GET['user_id']) && $_GET['user_id'] > 0) { // update the data to the database if ($LoginAccessLevel >='6' ) { $insert_sql="UPDATE user SET user_first='$user_first', user_surname='$user_surname', user_email='$user_email', user_access_level='$user_access_level', user_active='$user_active', date_joined='$date_joined', inspector='$inspector', trainer='$fsrtrainer', notice_type1='$notice_type1', notice_type2='$notice_type2', notice_type3='$notice_type3', user_updated_date=NOW(), edit_data='$edit_data', news='$news', member_view='$member_view', membertype='$membertype' , eng_admin='$eng_admin', mute='$mute', gender='$gender', purchase_order='$purchase_order', last_saved_by='$session_id', add_users='$add_users', menu='$menu' WHERE user_id='$user_id'"; if ($_SESSION['LoginMemberID']==$user_id ){ $_SESSION['menu'] = $menu; $_SESSION['edit_data'] = $edit_data; $_SESSION['purchase_order'] = $purchase_order; } } else { $insert_sql="UPDATE user SET user_first='$user_first', user_surname='$user_surname', user_email='$user_email', user_active='$user_active', date_joined='$date_joined', news='$news', gender='$gender', last_saved_by='$session_id', membertype='$membertype' , user_updated_date=NOW() WHERE user_id='$user_id'"; } $mysqli->query($insert_sql) or die ($mysqli->error); #echo $insert_sql; $push_data['profile_Spouse'] = htmlentities($_POST ['Spouse'],ENT_QUOTES); $push_data['spouse_contact_num'] = $_POST ['spouse_contact_num']; $push_data['profile_Street'] = ucwords($_POST ['Street']); $push_data['profile_Suburb'] = ucwords($_POST ['Suburb']); $push_data['profile_City'] = $_POST ['City']; $push_data['profile_Post_code'] = $_POST ['Post_code']; $push_data['profile_Phone_no'] = $_POST ['landline']; if ($_POST ['date_of_birth']!='1970-01-01'){ $push_data['profile_date_of_birth'] = $_POST ['date_of_birth'];} else { $push_data['profile_date_of_birth']='0000-00-00';} $push_data['profile_Cell'] = $_POST ['Cell']; $push_data['profile_DRlic'] = strtoupper($_POST ['DRlic']); $push_data['profile_DRlic_date'] = $_POST ['DRlic_date']; $push_data['profile_occupation'] = ucwords($_POST ['occupation']); $push_data['profile_membertype'] = $_POST ['membertype']; $push_data['profile_comments'] = mysqli_real_escape_string($mysqli, $_POST ['comments']); $push_data['profile_payment'] = $_POST ['payment']; foreach ($push_data as $key => $value) $mysqli->query("UPDATE user_data SET data_value = '".$value."' WHERE data_user_id = '".$user_id."' AND data_type = '".$key."'") or die($mysqli->error); $user_spouse = $mysqli->query("SELECT COUNT(*) AS NumRows FROM user_data where data_user_id='".$user_id."' and data_type='spouse_contact_num'") or die ($mysqli->error); $row3sp = $user_spouse->fetch_array(); if ($row3sp['NumRows'] == 0) { $push_data2['spouse_contact_num'] = $_POST ['spouse_contact_num']; foreach ($push_data2 as $key => $value) $mysqli->query("INSERT user_data SET data_user_id = '".$user_id."', data_type = '".$key."', data_value = '".$value."'") or die($mysqli->error); } if ($LoginAccessLevel >='6' ) { //adding user to the trainers table $fullname=$_POST['fullname']; $user_name = $mysqli->query("SELECT COUNT(*) AS NumRows FROM trainers where user_id='$user_id'") or die ($mysqli->error); $row3 = $user_name->fetch_array(); if ($_POST['fsrtrainer']==1) { // echo('post = yes '); if ($row3['NumRows'] == 0) { echo('inserting data now '); $mysqli->query("INSERT trainers SET user_name='$fullname', user_id='$user_id', insertedby='".$session_id."'") or die ($mysqli->error); }//END of NUMrows else { $name = $_POST['user_first']." ".$_POST['user_surname']; $mysqli->query("UPDATE trainers SET user_name='$name', removed='0' WHERE user_id='$user_id' ") or die ($mysqli->error); } } /*else { $name = $_POST['user_first']." ".$_POST['user_surname']; echo ('removing trainer'); $mysqli->query("UPDATE trainers SET removed='1' WHERE user_id='$user_id' ") or die ($mysqli->error); }*/ //adding user to the Inspectors table if ($_POST['inspector']==1) { // echo('inserting'); if ($row4['NumRows'] == 0) { // echo('inserting data'); $mysqli->query("INSERT Inspectors SET user_name='$fullname', user_id='$user_id', insertedby='".$session_id."'") or die ($mysqli->error); }else { $name = $_POST['user_first']." ".$_POST['user_surname']; $mysqli->query("UPDATE Inspectors SET user_name='$name', removed='0' WHERE user_id='$user_id' ") or die ($mysqli->error); } } /*else { $name = $_POST['user_first']." ".$_POST['user_surname']; $mysqli->query("UPDATE Inspectors SET removed='1' WHERE user_id='$user_id' ") or die ($mysqli->error); }*/ }//if a admin to insert data } else { if (!isset($user_email)) { $user_email ='no@email.com';} // Insert into the database. $user_pass = md5($user_pass_1);//encrypt the user_pass before saving in the database code for insert statment user_pass='md5($user_pass)', $mysqli->query("INSERT user SET membertype='$membertype',user_first='$user_first', user_surname='$user_surname',user_pass='md5($user_pass)', date_joined='$date_joined', user_email='$user_email', inserted_by='$session_id'") or die($mysqli->error); $user_id = $mysqli->insert_id; $push_data['profile_Spouse'] = $mysqli->real_escape_string(htmlspecialchars(ucwords($_POST['Spouse']))); $push_data['profile_Street'] = ucwords($_POST ['Street']); $push_data['profile_Suburb'] = ucwords($_POST ['Suburb']); $push_data['profile_City'] = $_POST ['City']; $push_data['profile_Post_code'] = $_POST ['Post_code']; $push_data['profile_Phone_no'] = $_POST ['Phone']; if ($_POST ['date_of_birth']!='1970-01-01'){ $push_data['profile_date_of_birth'] = $_POST ['date_of_birth'];} else { $push_data['profile_date_of_birth']='0000-00-00';} $push_data['profile_Cell'] = $_POST ['Cell']; $push_data['profile_DRlic'] = strtoupper($_POST ['DRlic']); $push_data['profile_DRlic_date'] = $_POST ['DRlic_date']; $push_data['Cert_First Aid'] = $_POST ['FAid_date']; $push_data['profile_occupation'] = ucwords($_POST ['occupation']); $push_data['profile_comments'] = htmlspecialchars($_POST ['comments'],ENT_QUOTES); $push_data['profile_payment'] = $_POST ['payment']; foreach ($push_data as $key => $value) $mysqli->query("INSERT user_data SET data_user_id = '".$user_id."', data_type = '".$key."', data_value = '".$value."'") or die($mysqli->error); echo "
"; echo ""; echo "

"; echo ""; echo "

".$user_first." ".$user_surname." has been added to the Database
"; } if ($_POST['submit-record']=='Submit Changes + add town') { header("location:Add-town.php?user_id='$user_id'"); } else { echo ""; } } // END if $_error. }else { echo "

Sorry can not edit System Admin account

";} } // END if $_POST /* if ($LoginAccessLevel > '9' ) { print_r($_POST); echo "
"; echo $insert_sql; #echo $output['spouse_contact_num']; } */ if (isset($_GET['user_id']) && is_numeric($_GET['user_id']) && $_GET['user_id'] > 0) { $title = $output['user_first'].' '.$output['user_surname']."'s Staff Record"; } else { $title ="New Staff Record";} ?> <?php echo $title; ?>
='4'){ echo "Created by:"; $inserted_by=$output['inserted_by']; if (is_numeric($output['inserted_by'])) { $sqlType_12 = "SELECT * FROM user where user_id='$inserted_by'"; $resultType_12 = $mysqli->query($sqlType_12) or die ("Error in Query: $sqlType" . Mysql_error()); while ($row_12 = $resultType_12->fetch_array(MYSQLI_ASSOC)) { echo $row_12['user_first'].' '.$row_12['user_surname']; echo " - ".date('d-M-Y h:ia',strtotime($output['user_registered'])); } } else { echo $output['inserted_by']; } } ?>
0) { if($LoginAccessLevel>='3') { echo "View printer version ";}}?>
='4'){ $saved_by=$output['last_saved_by']; $sqlType_1 = "SELECT * FROM user where user_id='$saved_by'"; $resultType_1 = $mysqli->query($sqlType_1) or die ("Error in Query: $sqlType" . Mysql_error()); while ($row_1 = $resultType_1->fetch_array(MYSQLI_ASSOC)) { echo $row_1['user_first'].' '.$row_1['user_surname'].' - '.date('d-M-Y h:ia',strtotime($output['last_save'])); } } } ?>

$value) { if ($value == 'no_firstname') { ?>
You need to add a first name.
You need to add a last name.
You need to add a Landline number.
You need to add a Cell contact number (if you don't have one just put -).
You need to add your Date of Birth.
You need to add a email.
Please select Membership type.
Please enter password in password.
Please enter password in confirm password.
Please reenter passwords, they don't match.
Please select payment type
Member already exists

='3') {?> 0) { if ($LoginAccessLevel >= '2' ) { if (($Access_edit !=0) or ($session_id ==$user_id)) { ?> ' class="btn btn-success btn-xs " >
0) { include_once ('family-members.php'); } else { $output['user_photo']='NA.JPG'; }?>
'8' ) { ?> ='3') or ($session_id ==$_GET['user_id'])) {?> '9' ) { ?> ='3') or ($session_id ==$user_id)) {?> '2' ) { ?> ='3') or ($session_id ==$_GET['user_id'])) {?> '2' ) { ?> ";?>

0) { echo $output['user_first'];?>'s  Staff Record

Access level: query($sqlType) or die ("Error in Query: $sqlType" . Mysql_error()); echo ""; } else { ?> 0) { $privilege_id=$output['user_access_level']; $sqlType = "SELECT * FROM privileges where privilege_id=$privilege_id "; $resultType = $mysqli->query($sqlType) or die ("Error in Query: $sqlType" . Mysql_error()); while ($row = $resultType->fetch_array(MYSQLI_NUM)) { echo "".$row[0]." ". $row[1] .""; } } } if($output['user_access_level']>='2' && $output['eng_admin']=='1') { ?> - Engineering Admin ID:
BORDER=1 WIDTH=320 >

'8' ) { ?> " class="btn btn-warning">
Last updated:
Name: Aged: format('%y'); } ?>
D.O.B: Gender:
Land line: Cell Phone:
Emergency Contact: Contact number:
Address:
Suburb:
City:
query($sqlType) or die ("Error in Query: $sqlType" . Mysql_error()); echo ""?>
Post Code:
Occupation:
Email:
Years of service: format('%y'); ?> Sub status: query("SELECT * FROM Subscription WHERE user_id='$user_id' and MemberPaid ='Y' AND SubscriptionYear = '$SubYear' AND MemberType !='Family Membership'") or die($mysqli->error); $row = $result->fetch_array(MYSQLI_ASSOC); foreach ($row as $key => $value) { $sub[$key] = $value; } $result1 =$mysqli->query("SELECT * FROM Subscription INNER JOIN Family_members ON Subscription.user_id = Family_members.Fam_id where Subscription.MemberPaid ='Y' AND Subscription.MemberType='Family Membership'and (Family_members.Adult_1 ='$user_id' or Family_members.Adult_2 ='$user_id' or Family_members.Kid_1 ='$user_id' or Family_members.Kid_2 ='$user_id') AND SubscriptionYear = '$SubYear' ") or die($mysqli->error); $row = $result1->fetch_array(MYSQLI_ASSOC); foreach ($row as $key => $value) { $sub[$key] = $value; } #print_r($sub); if ($sub['paid_date']>'0') { echo "Paid:"; echo date('d-m-Y',strtotime($sub['paid_date'])); } else { echo "not financial ";} ?>
Active member at the depot: Member since:
Driver Licence: Expiry Date:
Member Type: query($sqlType) or die ("Error in Query: $sqlType" . Mysql_error()); echo " Newsletter sent by:
'4' ) { ?>
Inspector: Trainer: Mute expiry items
'8' ) { ?>

  • Site settings

  • Alert Notices

Notes:
'3' ) && ($Access_edit !=0) or ($session_id ==$user_id) ) { ?> 0) { // get the items from the database. $Sqlyear=$mysqli->query("SELECT current_year FROM site_details WHERE MessageID = 1"); $Year = $Sqlyear->fetch_array(MYSQLI_ASSOC); $SubscriptionYear = $Year['current_year']; $result = $mysqli->query("SELECT * FROM Club_Positions WHERE user_id=$user_id and SubscriptionYear='$SubscriptionYear'AND resigned!='1'") or die($mysqli->error); if ($result->num_rows > 0) { ?>
Club Current positon: fetch_array()) { $row = str_replace("_"," ",$row); // echo out the contents of each row into a table echo ""; echo ''; }?>
' . $row['RoleType'] . '
query("SELECT * FROM Club_Positions WHERE user_id=$user_id ORDER BY `SubscriptionYear` DESC ") or die($mysqli->error); if ($result_club_role->num_rows > 0) { ?>
Club Roles: fetch_array()) { $row = str_replace("_"," ",$row); // echo out the contents of each row into a table echo ""; echo ''; echo "'; if($row['resigned']=='1'){ echo ""; } echo ""; if ($numRows > 1) { if ($rowCount % $maxRows == 0 && $rowCount != $numRows) { echo "
' . $row['RoleType'] . '" . $row['SubscriptionYear'] . 'Resigned (". date('d-m-Y',strtotime($row['resigned_date'])).")
"; } } $rowCount ++; } }?>

Internal records

query("SELECT * FROM training_data LEFT JOIN training ON training_data.training_type = training.id WHERE user_id=$user_id AND training LIKE '$like' and superseded!=1 and training_data.removed!=1 ORDER BY training.training ASC ") or die($mysqli->error); if ($result->num_rows > 0) { // loop through results of database query, displaying them in the table while($row = $result ->fetch_array()) { // echo out the contents of each row into a table //echo ""; if ($row['learning']=='1') { echo ""; } elseif ($row['archive']=='1') { echo ""; } elseif ($row['training_value_expiry'] <=$today && $row['life']!="on") { echo ""; $expired='1';} else { echo ""; } if ($LoginAccessLevel >'8'){ echo "' ;} if ($row['doc']!='') { ?>';} echo "'; if ($row['learning']=='0') { if (($row['training_value_expiry']!='1970-01-01') && ($row['life']!='on')){ echo "';} else { echo "";} } echo ''; if (($row['archive']=='1') or ($row['flagged']!='0') && ($row['life']!='on')) { echo ""; } else { echo "';} echo "'; } ?>
id Name Initial date Expiry Date Status
" . $row['data_id'] ." "; } else { echo "" . $row['data_id'].' ';} if ($row['learning']=='1') { ?> '; if ($row['learning']=='0') { echo ''.$row['training']; if (!empty($row['conditions'])) { ?> - Conditions apply ';} else { echo ''.$row['training_name'] .'"; if ($row['learning']=='0') { echo date('d-m-Y',strtotime($row['training_value'])); } echo '". date('d-m-Y',strtotime($row['training_value_expiry'])). ' - ". $row['status2']. "". $row['status']. '"; if ($row['learning']=='0') { ?>
No data
query("SELECT * FROM training_data LEFT JOIN training ON training_data.training_type = training.id WHERE user_id=$user_id AND training LIKE '%Unit%' and superseded!=1 and training_data.removed!=1 ORDER BY training.training DESC ") or die($mysqli->error); if ($result->num_rows > 0) { // loop through results of database query, displaying them in the table while($row = $result ->fetch_array()) { // echo out the contents of each row into a table if ($row['learning']=='1') { echo ""; } else { echo "";} if ($LoginAccessLevel >'8'){ echo "';} else { echo '';} echo "'; echo "'; } }else { // No pages to Display echo ''; } ?>
Unit standards records
id Name Initial date Status
" . $row['data_id'] .""; } else { echo "" . $row['data_id'] ;} if ($row['doc']!='') { ?> ';} if ($row['learning']=='1') { ?> '; if ($row['learning']=='0') { echo ''.$row['training'] .''.$row['training_name'] .'"; if ($row['learning']=='0') { echo date('d-m-Y',strtotime($row['training_value'])); } echo '". $row['status']. '
No data
query("SELECT * FROM training_data LEFT JOIN training ON training_data.training_type = training.id WHERE user_id=$user_id AND training NOT LIKE '%Unit%' and training NOT LIKE '%FDSRS%' and training NOT LIKE '%NRS -%' and training NOT LIKE '%Loco%' and training NOT LIKE '%Carriage%' and superseded!=1 and training_data.removed!=1 ORDER BY training_type DESC ") or die($mysqli->error); if ($result_other->num_rows > 0) { // loop through results of database query, displaying them in the table while($row_other = $result_other ->fetch_array()) { if ($row_other['archive']=='1') { echo ""; } elseif ($row_other['training_value_expiry'] <=$today && $row_other['life']!="1" && $row_other['training_value_expiry']!='1970-01-01') { echo ""; } else { echo ""; } if ($LoginAccessLevel >'8'){ echo "'; echo ''; echo "'; if ($row_other['training_value_expiry']!='1970-01-01'){ echo "';} else { echo "";} if (($row_other['archive']!='0') or ($row_other['flagged']!='0') && ($row_other['life']!='on')) { echo ""; } else { echo "';} echo""; } }else { // No pages to Display echo ''; } ?>
Other Certificates
id Name Initial date Expiry Date Status
" . $row_other['data_id'] .""; } else { echo "" . $row_other['data_id'] ;} if ($row_other['doc']!='') { ?> ';} echo ''. $row_other['training'] .'" . date('d-m-Y',strtotime($row_other['training_value'])) .'". date('d-m-Y',strtotime($row_other['training_value_expiry'])). ' - ". $row_other['status2']. "". $row_other['status']. '
No data

Mainline Crewing info

query("SELECT * FROM training_data LEFT JOIN training ON training_data.training_type = training.id WHERE user_id=$user_id AND training LIKE '%Loco -%' and superseded!=1 and training_data.removed!=1 ORDER BY training_type DESC ") or die($mysqli->error); if ($result->num_rows > 0) { // loop through results of database query, displaying them in the table while($row = $result ->fetch_array()) { // echo out the contents of each row into a table echo ""; if ($LoginAccessLevel >'8'){ echo ""; } else { echo "';} echo ''; echo "'; } }else { // No pages to Display echo ''; } ?>
Locomotive
id Name Status
" . $row['data_id'] ."" . $row['data_id'] .'' . $row['training'] .'" . $row['status'] .'
No data
 query("SELECT * FROM training_data LEFT JOIN training ON training_data.training_type = training.id WHERE user_id=$user_id AND training LIKE '%Carriage -%' and superseded!=1 and training_data.removed!=1 ORDER BY training_type DESC ") or die($mysqli->error); if ($result->num_rows > 0) { // loop through results of database query, displaying them in the table while($row = $result ->fetch_array()) { // echo out the contents of each row into a table echo ""; if ($LoginAccessLevel >'8'){ echo ""; } else { echo "';} echo ''; echo "'; } }else { // No pages to Display echo ''; } ?>
Carriage
id Name Status
" . $row['data_id'] ."" . $row['data_id'] .'' . $row['training'] .'" . $row['status'] .'
No data
 query("SELECT * FROM training_data LEFT JOIN training ON training_data.training_type = training.id WHERE user_id=$user_id AND training LIKE '%team Leader%' and superseded!=1 and training_data.removed!=1 ORDER BY training_type DESC ") or die($mysqli->error); if ($result->num_rows > 0) { // loop through results of database query, displaying them in the table while($row = $result ->fetch_array()) { // echo out the contents of each row into a table echo ""; if ($LoginAccessLevel >'8'){ echo ""; } else { echo "';} echo ''; echo "'; } }else { // No pages to Display echo ''; } ?>
Team leaders
id Name Status
" . $row['data_id'] ."" . $row['data_id'] .'' . $row['training'] .'" . $row['status'] .'
No data

NRS training

query("SELECT * FROM training_data LEFT JOIN training ON training_data.training_type = training.id WHERE user_id=$user_id AND training LIKE '%NRS%' and superseded!=1 and training_data.removed!=1 ORDER BY training.training ASC, training_value ASC ") or die($mysqli->error); if ($result->num_rows > 0) { // loop through results of database query, displaying them in the table while($row = $result ->fetch_array()) { // echo out the contents of each row into a table if ($row['learning']=='1') { echo ""; } elseif ($row['archive']!='0') { echo ""; } elseif ($row['training_value_expiry'] <=$today && $row['life']!="on") { echo ""; $expired='1';} else { echo ""; } if ($LoginAccessLevel >'8'){ echo "';} if ($row['learning']=='1') { ?> '; if ($row['learning']=='0') { echo '';} else { echo '';} echo "'; echo "'; if (($row['archive']!='0') or ($row['flagged']!='0') && ($row['life']!='on')) { echo ""; } else { echo "';} } }else { // No pages to Display echo ''; } ?>
id Name Initial date Expiry Date Status
" . $row['data_id'] .""; } else { echo "" . $row['data_id'] ;} if ($row['doc']!='') { ?> '.$row['training'] .''.$row['training_name'] .'"; if ($row['learning']=='0') { echo date('d-m-Y',strtotime($row['training_value'])); } echo '"; if ($row['life']!="on") { if ($row['learning']=='0') { echo date('d-m-Y',strtotime($row['training_value_expiry'])); } } echo '". $row['status2']. "". $row['status']. '
No data
' class="btn btn-secondary"> ' class="btn btn-success">