Example #1
0
function add_user($userInfo)
{
    if (!(isset($userInfo['username']) && isset($userInfo['email']) && isset($userInfo['password']))) {
        throw new Exception("Requires username, email, and password");
    }
    $dbh = new PDOConnection();
    CheckUsernameEmailExists($dbh, $userInfo);
    $user_id = AddToUsers($dbh, $userInfo);
    return array('user_id' => $user_id);
}
 $inputFileName = $UploadDirectory . $NewFileName;
 try {
     $inputFileType = PHPExcel_IOFactory::identify($inputFileName);
     $objReader = PHPExcel_IOFactory::createReader($inputFileType);
     $objPHPExcel = $objReader->load($inputFileName);
     //  Get worksheet dimensions
     $sheet = $objPHPExcel->getSheet(0);
     $highestRow = $sheet->getHighestRow();
     $highestColumn = $sheet->getHighestColumn();
     //  Loop through each row of the worksheet in turn
     for ($row = 1; $row <= $highestRow; $row++) {
         //  Read a row of data into an array
         $rowData = $sheet->rangeToArray('A' . $row . ':' . $highestColumn . $row, NULL, TRUE, FALSE);
         foreach ($rowData[0] as $k => $v) {
             //$resp .= "Row: ".$row."- Col: ".($k+1)." = ".$v."<br />";
             $res = AddToUsers($v, "D");
             if ($res == "1") {
                 $i = $i + 1;
             } else {
                 $j = $j + 1;
                 $userDefault .= $v . ", ";
             }
             $resp = AddToTable($v, $organ, $course, "Mentee");
             if ($resp == "1") {
                 $k = $k + 1;
             } else {
                 $l = $l + 1;
                 $menteeDefault .= $v . ", ";
             }
         }
         // end of foreach
 $inputFileName = $UploadDirectory . $NewFileName;
 try {
     $inputFileType = PHPExcel_IOFactory::identify($inputFileName);
     $objReader = PHPExcel_IOFactory::createReader($inputFileType);
     $objPHPExcel = $objReader->load($inputFileName);
     //  Get worksheet dimensions
     $sheet = $objPHPExcel->getSheet(0);
     $highestRow = $sheet->getHighestRow();
     $highestColumn = $sheet->getHighestColumn();
     //  Loop through each row of the worksheet in turn
     for ($row = 1; $row <= $highestRow; $row++) {
         //  Read a row of data into an array
         $rowData = $sheet->rangeToArray('A' . $row . ':' . $highestColumn . $row, NULL, TRUE, FALSE);
         foreach ($rowData[0] as $k => $v) {
             //$resp .= "Row: ".$row."- Col: ".($k+1)." = ".$v."<br />";
             $res = AddToUsers($v, "C");
             if ($res == "1") {
                 $i = $i + 1;
             } else {
                 $j = $j + 1;
                 $userDefault .= $v . ", ";
             }
             $resp = AddToTable($v, $organ, $course, "Mentor");
             if ($resp == "1") {
                 $k = $k + 1;
             } else {
                 $l = $l + 1;
                 $menteeDefault .= $v . ", ";
             }
         }
         // end of foreach