Пример #1
0
    header("Content-Type: application/vnd.ms-excel");
    header("Content-Disposition: attachment; filename={$filename}.xls");
    header("Pragma: no-cache");
    header("Expires: 0");
    /*******Start of Formatting for Excel*******/
    //define separator (defines columns in excel & tabs in word)
    $sep = "\t";
    //tabbed character
    $schema_insert = "";
    echo 'S/N' . $sep;
    echo 'Application Number' . $sep;
    echo 'Fullname' . $sep;
    echo 'Programme' . $sep;
    echo 'Date of Application' . $sep;
    echo 'Admission Status' . $sep;
    print "\n";
    $serialno = 1;
    while ($row = $database->fetch_array($result)) {
        $schema_insert .= $serialno . $sep;
        $schema_insert .= $row["form_id"] . $sep;
        $schema_insert .= ucwords($row["surname"]) . ' ' . $row["first_name"] . ' ' . $row["middle_name"] . $sep;
        $schema_insert .= $row["department_name"] . $sep;
        $schema_insert .= date('Y-m-d', $row["time_completed_application"]) . $sep;
        $schema_insert .= admission_status($row["status"]) . $sep;
        $schema_insert .= "\n";
        $serialno++;
    }
    echo $schema_insert;
} else {
    redirect_to('view_applicant.php');
}
Пример #2
0
							<th>Admission Status</th>
						</tr>
					</thead>';
            echo '<tbody>';
        }
        echo '
		<tr>';
        if ($role == 1 || $role == 5) {
            echo '<td><input type="checkbox" name="applicant_id_' . $serialno . '" value="' . customEncrypt($result['applicant_id']) . '"> </td>';
        }
        echo '<td>' . $serialno . '</td>
			<td>' . $result["form_id"] . '</td>
			<td>' . ucwords($result["surname"]) . ' ' . $result["first_name"] . ' ' . $result["middle_name"] . '</td>
			<td>' . $result["department_name"] . '</td>
			<td>' . date('Y-m-d', $result["time_completed_application"]) . '</td>
			<td>' . admission_status($result["status"]) . '</td>
			<td>
				<a href="applicant_details.php?' . md5('applicant_id') . '=' . customEncrypt($result['applicant_id']) . '" class="btn btn-primary">View</a>
			</td>
			
		</tr>';
        if ($serialno % 10 == 0) {
            echo '</tbody>';
            echo '</table>';
            echo '</div>';
            $pagecounter++;
        } elseif ($serialno == $number_of_applicants) {
            echo '</tbody>';
            echo '</table>';
            echo '</div>';
        }