PHP int_to_time Examples

Example #1

File: acessories.php Project: TeyimPila/attendance_system

function print_review($array)
{
    echo "<table border=\"1\" style=\"white-space: nowrap; border-collapse:collapse\">";
    foreach ($array as $row) {
        if (preg_match('[^A(0|1)00.{5}]i', $row['A'])) {
            $student_id = $row['A'];
            $query = "select `student_id` " . "FROM course_section, attendance " . "WHERE course_section.section_id = attendance.section_id " . "AND attendance.student_id = '" . $student_id . "'";
            if (mysql_num_rows(mysql_query($query)) === 0) {
                echo '<tr>';
                foreach ($row as $data) {
                    echo "<td bgcolor=\"#FF0000\">" . $data . "</td>";
                }
                echo '</tr>';
            } else {
                echo '<tr>';
                foreach ($row as $data) {
                    echo '<td >' . $data . '</td>';
                }
                echo '</tr>';
            }
        } else {
            echo '<tr>';
            foreach ($row as $data) {
                if (preg_match('/^\\d{5}$/', $data)) {
                    echo '<td >' . date("d/M", strtotime(int_to_time($data))) . '</td>';
                } else {
                    echo '<td >' . $data . '</td>';
                }
            }
            echo '</tr>';
        }
    }
    echo '</table>';
    echo '<br>';
    echo '<br>';
    echo '<br>';
}

Example #2

File: attendance_processor.php Project: TeyimPila/attendance_system

function insert_attendance($data_array)
{
    $dates = find_course_info($data_array)[1];
    $course_code = find_course_info($data_array)[0][0];
    $section = find_course_info($data_array)[0][1];
    $crn_query = "SELECT `CRN` FROM `course` " . "WHERE `course_code`='" . $course_code . "'";
    $crn = mysql_result(mysql_query($crn_query), 0);
    //the assumption here is that no two rows in Course_section have same values for course_crn
    $sec_query = "SELECT `section_id`, `instructor_id` FROM `Course_Section` " . "WHERE `course_CRN` = '" . $crn . "' AND `section` = '" . $section . "'";
    $section_id = mysql_result(mysql_query($sec_query), 0);
    //echo $section_id;
    $instructor_id = mysql_result(mysql_query($sec_query), 0, "instructor_id");
    $tot = 0;
    foreach (students_info($data_array) as $student) {
        $student_id = $student[0];
        for ($i = 3; $i < count($student); $i++) {
            $date = int_to_time($dates[$i - 3]);
            $status = mysql_real_escape_string($student[$i]);
            //print_r($student);
            $insert_attendance = "INSERT INTO `Attendance` (`attendance_id`, `student_id`, `section_id`, `course_CRN`, `instructor_id`, `status`, `date`, `timestamp`) " . "SELECT '',  '" . $student_id . "', '" . $section_id . "',  '" . $crn . "',  '" . $instructor_id . "',  NULLIF('" . $status . "', ' '), '" . $date . "', NOW() FROM dual " . "WHERE NOT EXISTS (" . " SELECT * FROM `Attendance` " . "WHERE " . "`student_id` = '" . $student_id . "' " . "AND `section_id` = '" . $section_id . "' " . "AND `course_CRN` = '" . $crn . "' " . "AND `instructor_id`='" . $instructor_id . "' " . "AND `date` = '" . $date . "' ) " . "LIMIT 1";
            mysql_query($insert_attendance);
            $tot = $tot + mysql_affected_rows();
            echo mysql_error();
        }
    }
    echo $tot . " new attendances added" . '<br>';
    echo mysql_error();
}