PHP class_mysql_base::select_excel2 예제들

예제 #1

파일: stat.php 프로젝트: semteacher/tdmu-vidomosti2

 <script type="text/javascript" src="datepicker/jquery.js"></script> 
 <script type="text/javascript" src="https://www.google.com/jsapi"></script>
 <script type="text/javascript" src="datepicker/graf.js"></script>
<?php 
require "auth.php";
if ($_SESSION['login_name'] && $_SESSION['role'] == "admin") {
    require "header.php";
    require "menu.php";
    require "class/class_firebird.php";
    require "class/mysql-class.php";
    $fac = new class_ibase();
    $test = new class_mysql_base();
    $excel_kil = $test->select_excel2("SELECT id FROM excel WHERE 1;");
    $kil = array();
    for ($i = 0; $i < count($excel_kil); $i++) {
        $kil[$i] = $excel_kil[$i]['id'];
    }
    $max = max($kil);
    $exel = array();
    $j = 0;
    for ($i = 0; $i < 100; $i++) {
        if ($_POST[$i] > 0) {
            $exel[$j] = $_POST[$i];
            $j++;
        }
    }
    echo "<CENTER><h3>Виберіть тип статистики</h3></CENTER>";
    //--------------------------------------------------------------------------------------------------------------------------------
    //                                 Загальна статистика
    //--------------------------------------------------------------------------------------------------------------------------------
    include "statistics/zag.php";

예제 #2

파일: students.php 프로젝트: semteacher/tdmu-vidomosti2

 if ($_GET['special'] && $_GET['faculty'] && $_GET['lang'] && $_GET['course'] && $_GET['group']) {
     $student = $test->select_table_ocinka("SELECT DISTINCT table_ocinka.student_id FROM table_ocinka,excel WHERE excel.semester='" . $_GET['course'] . "' AND table_ocinka.group='" . $_GET['group'] . "' AND excel.speciality_id=" . $_GET['special'] . " AND excel.id=table_ocinka.excel_id;");
     echo "<table width='70%' id='t'>";
     for ($i = 0; $i < count($student); $i++) {
         $student_contingent = $fac->select_idstyd_tocontingent($student[$i]['student_id']);
         echo "<tr><td style='border:solid 1px black;'><a style='float:right;color:black;display:block;width:100%;' href='students.php?student_id=" . $student[$i]['student_id'] . "&faculty=" . $_GET['faculty'] . "&year=" . $_GET['year'] . "&special=" . $_GET['special'] . "&lang=" . $_GET['lang'] . "&course=" . $_GET['course'] . "&group=" . $_GET['group'] . "'>" . $student_contingent['FIO'] . "</a></td></tr>";
     }
     echo "</table>";
 }
 if ($_GET['student_id']) {
     $student_contingent = $fac->select_idstyd_tocontingent($_GET['student_id']);
     echo "<br><b>Успішність студента<br><CENTER><h2>" . $student_contingent['FIO'] . "</h2></CENTER></b>";
     $get_ocinku_excel = $test->select_table_ocinka("SELECT DISTINCT excel_id FROM `table_ocinka`WHERE `student_id` ='" . $_GET['student_id'] . "';");
     echo "<table width='100%' bgcolor='#c5d9e5' font-color='white' id='table0' style='border: 1px solid blue;' >";
     for ($i = 0; $i < count($get_ocinku_excel); $i++) {
         $excel_stud = $test->select_excel2("SELECT * FROM excel WHERE id='" . $get_ocinku_excel[$i]['excel_id'] . "';");
         $type_session = $test->select_type_session("id=" . $excel_stud[0]['type_sesion']);
         echo "<tr><td><b>Тип здачі " . $type_session[0]['type'] . "</td><td><b>Семестер " . $excel_stud[0]['semester'] . "</td><td><b> Частина " . $excel_stud[0]['chastuna'] . "</td><td><b> Дата " . $excel_stud[0]['date'] . "</td></tr>";
         $predmet = $test->select_module("SELECT * FROM module WHERE id_excel=" . $excel_stud[0]['id'] . ";");
         echo "<tbody><tr><td colspan='4'>\n        <table width='100%' bgcolor='white'><tr><td>";
         for ($j = 0; $j < count($predmet); $j++) {
             $ocinku = $test->select_table_ocinka("SELECT DISTINCT potochna,examen,ostatochna,sort FROM table_ocinka WHERE student_id='" . $_GET['student_id'] . "' AND excel_id='" . $excel_stud[0]['id'] . "' AND discipline_id='" . $predmet[$j]['id_discipline'] . "' AND module_id='" . $predmet[$j]['id_module'] . "' AND sort='" . $predmet[$j]['sort'] . "';");
             if ($ocinku[0]['examen'] || $ocinku[0]['examen'] == '0') {
                 if ($ocinku[0]['examen'] == '0') {
                     echo "<div style='border-bottom: solid 1px gray;background-color:#feddbf;'>" . $ocinku[0]['sort'] . ":  " . $predmet[$j]['name_discipline'] . " <div style='padding-left:18px;'> " . $predmet[$j]['name_module'] . "  <b style='float:right;'>Поточна : " . $ocinku[0]['potochna'] . " Екзамен : " . $ocinku[0]['examen'] . " Підсумкова : " . $ocinku[0]['ostatochna'] . " </b></div></div>";
                 } else {
                     echo "<div style='border-bottom: solid 1px gray;background-color:#bffec4;'>" . $ocinku[0]['sort'] . ":  " . $predmet[$j]['name_discipline'] . " <div style='padding-left:18px;'> " . $predmet[$j]['name_module'] . "  <b style='float:right;'>Поточна : " . $ocinku[0]['potochna'] . " Екзамен : " . $ocinku[0]['examen'] . " Підсумкова : " . $ocinku[0]['ostatochna'] . " </b></div></div>";
                 }
             }
         }
         echo "</td></tr></table></td></tr></tbody>";

예제 #3

파일: reg_info_excel.php 프로젝트: semteacher/tdmu-vidomosti2

<link rel="stylesheet" href="datepicker/datepicker.css" type="text/css" /> 
<?php 
require "auth.php";
echo "\n<script type='text/javascript' src='datepicker/jquery.js'></script>\n<script type='text/javascript' src='datepicker/date.js'></script>\n<script type='text/javascript' src='datepicker/jquery.datePicker-2.1.2.js'></script>\n \n<script type='text/javascript'>\n\$(function()\n{\n\$('#inputDate4').datePicker({\ncreateButton:false,\nclickInput:true,\nendDate: (new Date()).addDays(365).asString()\n});\n});\n</script>";
if ($_SESSION['login_name'] && $_SESSION['role'] == "admin") {
    require "header.php";
    require "menu.php";
    require "class/potochna.php";
    require "class/mysql-class.php";
    require "class/class_firebird.php";
    $test = new class_mysql_base();
    $ibase = new class_ibase();
    $type_session = $test->select_type_session("1");
    if ($_GET['id']) {
        $excel_info = $test->select_excel2("SELECT * FROM excel WHERE id='" . (int) $_GET['id'] . "';");
        $year = $test->select_year("SELECT DISTINCT date,name,id FROM yearplan WHERE 1 ORDER BY id DESC;");
        echo " <center><h3>Редагування файла EXCEL </h3><br></center>\n    <form action='reg_graf.php?id=" . $_GET['id'] . "&faculty=" . $_GET['faculty'] . "&special=" . $_GET['special'] . "&lang=" . $_GET['lang'] . "&year=" . $_GET['year'] . "&course=" . $_GET['course'] . "' method='post' enctype='multipart/form-data'>\n    \t\n        \n    <div class='kvadrant'><br>\n\tКороткий опис\n\t<input  name='title' value='" . $excel_info[0]['title'] . "' />\n\t<br><br>\n\t</div>  \n\n    <div class='kvadrant'><br>\n\tТип здачі \n\t<select name='year'>\n    ";
        for ($i = 0; $i < count($year); $i++) {
            if ($year[$i]['id'] == $excel_info[0]['type_atemp']) {
                echo "<option value='" . $year[$i]['id'] . "' selected='SELECTED'>" . $year[$i]['date'] . "/" . $year[$i]['name'] . "</option>";
            } else {
                echo "<option value='" . $year[$i]['id'] . "'>" . $year[$i]['date'] . "/" . $year[$i]['name'] . "</option>";
            }
        }
        echo "\n\t</select>\n\t<br><br>\n\t</div>\n\n    <div class='kvadrant'><br>\n\tМова здачі \n\t<select name='lang'>";
        if ($excel_info[0]['lang'] == 'UA') {
            echo "<option value='UA' selected='SELECTED'>Українська</option>\n              <option value='ENG'>Іноземна</option>\n        ";
        } else {
            echo "<option value='UA'>Українська</option>\n              <option value='ENG' selected='SELECTED'>Іноземна</option>\n        ";
        }
        echo "</select>\n\t<br><br>\n\t</div>\n      \n    <div class='kvadrant'><br>    \n\tДата здачі\n\t<input  id='inputDate4' name='date' value='" . $excel_info[0]['date'] . "' />\n\t<br><br>\n\t</div>\n    \n\t<div class='kvadrant'><br>\n\tТип здачі \n\t<select name='zdacha'>\n    ";