if(isset($_GET['center_id']))
{
$get = $con->query("SELECT * FROM students where center_id = '".$_GET['center_id']."' AND status = 1");
if($get->num_rows)
{
?>
| Date |
Photo |
Enrollment No. |
Name |
Father's Name |
Center |
Course |
Details |
while($g = $get->fetch_assoc())
{
$c = $con->query("SELECT * FROM courses where id = '".$g['course_id']."'")->fetch_assoc();
$ce = $con->query("SELECT * FROM centers where id = '".$g['center_id']."'")->fetch_assoc();
echo '
| '.date('d-M-y',strtotime($g['timestamp'])).' |
 |
'.$g['enrollment_no'].' |
'.$g['name'].' |
'.$g['father'].' |
'.$ce['institute_name'].' |
'.$c['course_name'].' |
|
';
}
?>
}
else
{
echo '
Record Not Found.
';
}
}
?>