if ($result->num_rows > 0) { echo '
'; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; $i = 1; while ($row = $result->fetch_assoc()) { $trainingDate = ''; if (!empty($row['training_date'])) { $trainingDate = date('d-m-Y', strtotime($row['training_date'])); } $createdDate = ''; if (!empty($row['created_date'])) { $createdDate = date('d-m-Y', strtotime($row['created_date'])); } echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; } echo '
S.NoBatch CodeDistrictDomainTraining DateCreated DateAction
'.$i++.''.htmlspecialchars($row['batch_code']).''.htmlspecialchars($row['district']).''.htmlspecialchars($row['domain_name']).''.$trainingDate.''.$createdDate.''; echo 'View'; echo 'Details'; echo '
'; echo '
'; } else { echo '
No Records Found
'; } /* ---------------- CSV EXPORT ---------------- */ echo ' '; echo '
'; $stmt->close(); $stmt1->close(); $link->close(); ?>