예제 #1
0
    $department_id = $_SESSION['department_id'];
    $faculty_id = $_SESSION['faculty_id'];
    $campus_id = $_SESSION['campus_id'];
    $adm_yr = $_SESSION['adm_yr'];
    $query .= " AND `courses`.`school_course_code` = '{$pursuing_course}' AND `courses`.`department_id` = '{$department_id}'\n\tAND `courses`.`faculty_id` = '{$faculty_id}' AND `courses`.`campus_id` = '{$campus_id}' AND   `courses`.`student_adm_yr`= '{$adm_yr}'";
}
if ($result = mysqli_query($conn, $query)) {
    while ($lec_info = mysqli_fetch_assoc($result)) {
        $lec_name = $lec_info['lec_name'];
        $lec_email = $lec_info['lec_email'];
        $lec_phone = $lec_info['lec_phone'];
        $lec_avator = $lec_info['lec_avator_uri'];
        $lec_qualification = $lec_info['lec_qualification'];
        $course_name = $lec_info['course_name'];
        if ($_POST['client'] == 'desktop') {
            showLec($lec_name, $lec_email, $course_name, $lec_phone, $lec_avator, $lec_qualification);
        } else {
            echo json_encode(array_map("utf8_encode", $lec_info)) . ",";
        }
    }
}
function showLec($lec_name, $lec_email, $course_name, $lec_phone, $lec_avator, $lec_qualification)
{
    echo '<table>
			<tr>
				<td >
					<div>
						<img alt="lec_avator" src="' . $lec_avator . '" style="width:120px; height:150px; border:1px solid #ccc;border-radius:5px; padding:3px;">
					</div>
				</td><td>
					<div style="margin:0px 10px 10px 10px; ">
<?php

$lec_id = $_POST['lec_id'];
require 'db_auth.php';
$query = "SELECT  * FROM lecturer,courses where `lecturer`.`lec_id` =`courses`.`lec_id` ";
if ($result = mysqli_query($conn, $query)) {
    while ($lec_info = mysqli_fetch_assoc($result)) {
        $lec_id = $lec_info['lec_id'];
        $lec_name = $lec_info['lec_name'];
        $course_name = $lec_info['course_name'];
        showLec($lec_id, $lec_name, $course_name);
    }
}
function showLecInfo($lec_name, $lec_email, $lec_phone, $lec_qualifications)
{
    echo '<div><img alt="lec_avator" src="uploads/images/avators/lec/victor.jpg" style="width:120px; height:150px; border:1px solid #ccc;border-radius:5px; padding:3px;">
	<p style="float:right;"><label>Name : ' . $lec_name . '</label><br />
	<label>Email : ' . $lec_email . '</label><br />
	<label>Phonenumber : ' . $lec_phone . '</label></p></div>
	<br /><label>Qualifications<br />' . $lec_qualifications . '</label>';
}