PHP retreiveMeetingTypeForMeetingの例

コード例 #1

ファイル: include.index.db.dropdown.php プロジェクト: remlex/student-council-attendance

function retreiveAttendanceMemberValues($meeting)
{
    $meeting_type = retreiveMeetingTypeForMeeting($meeting);
    $query = "SELECT `member`, `name` FROM v_member_dd WHERE member NOT IN (SELECT `member` FROM attendance WHERE `meeting` = " . $meeting . ") AND `meeting_type` = " . $meeting_type . ";";
    $result = mysql_query($query);
    $val = array();
    while ($row = mysql_fetch_row($result)) {
        $val[$row[0]] = $row[1];
    }
    return $val;
}

コード例 #2

ファイル: include.index.db.read.php プロジェクト: remlex/student-council-attendance

function retreiveAdditionalAttendanceMemberCount($meeting)
{
    $meeting_type = retreiveMeetingTypeForMeeting($meeting);
    $query = "SELECT COUNT(*) num FROM v_member_dd WHERE member NOT IN (SELECT `member` FROM attendance WHERE `meeting` = " . $meeting . ") AND `meeting_type` = " . $meeting_type . ";";
    $result = mysql_query($query);
    $row = mysql_fetch_row($result);
    return $row[0];
}