}
         }
         $cellmax = $cols[$i] . "" . $num[$j];
         foreach ($sheet1->getMergeCells() as $range) {
             if ($sheet1->getCell($cellmax)->isInRange($range)) {
                 $Subject = $sheet1->getCell($cellmax)->getValue();
                 if (preg_match("/(?i)lab/", $Subject)) {
                     $hasLab = true;
                 }
                 $isMergedCell = true;
                 break;
             } else {
                 $isMergedCell = false;
             }
         }
         get_multiple_values($cellmax, $hasLab, $isMergedCell);
     }
 }
 //insert into database
 $query = "select c1.sem,c1.s_initial,c1.start_time,c1.end_time,c1.day,c2.start_time as start,c2.end_time as end from class as c1,class as c2 where c1.sem=c2.sem and c1.s_initial=c2.s_initial and c1.start_time=c2.end_time and c1.day=c2.day;";
 $result1 = mysqli_query($con, $query);
 if ($result1 === FALSE) {
     ///echo "<font color=green>(".mysqli_error($con).")</font>";
 }
 //combine values in case of seperate hours placed next to each other
 if (isset($result1) and $result1 != FALSE) {
     $num_rows = $result1->num_rows;
     if ($num_rows > 0) {
         while ($row = mysqli_fetch_assoc($result1)) {
             $sem = $row['sem'];
             $sub = $row['s_initial'];
コード例 #2
0
         $ext = pathinfo($fname, PATHINFO_EXTENSION);
         $temp = $sem . "sem_tt" . "." . $ext;
         $lab_true = false;
         $objReader = PHPExcel_IOFactory::createReader($inputFileType);
         $objPHPExcel = $objReader->load("uploads/" . $temp);
         $cellmax = $cols[$i] . "" . $num[$j];
         foreach ($objPHPExcel->setActiveSheetIndex(0)->getMergeCells() as $range) {
             if ($objPHPExcel->setActiveSheetIndex(0)->getCell($cellmax)->isInRange($range)) {
                 $lab_true = true;
                 $first = true;
                 break;
             } else {
                 $first = false;
             }
         }
         get_multiple_values($cellmax, $lab_true, $first);
     }
 }
 //function to upload teacher entries into handles table from second sheet of Excel
 function teacher_uploads($num)
 {
     //set values and get uplaoded file from the stored location in server
     $inputFileType = 'Excel2007';
     $sem = $_POST["sem"];
     $fname = $_FILES['file']['name'];
     $ext = pathinfo($fname, PATHINFO_EXTENSION);
     $temp = $sem . "sem_tt" . "." . $ext;
     $objReader = PHPExcel_IOFactory::createReader($inputFileType);
     $objPHPExcel = $objReader->load("uploads/" . $temp);
     //get subject and teacher values from the file
     $sub = "A" . $num;