public function getList($order = "didascalia") { $order = trim(filter_var($order, FILTER_SANITIZE_STRING)); //interrogazione tabella $sql = "SELECT * FROM upload ORDER BY {$order}"; $auth = $this->connector->query($sql); $list = array(); // controllo sul risultato dell'interrogazione if (mysql_num_rows($auth) > 0) { $doc = new Document(); $doc->setConnector($this->connector); $course = new Course(); $course->setConnector($this->connector); while ($res = $this->connector->getObjectResult($auth)) { $doc = new Document($res->id, $res->path, $res->tipo, $res->didascalia); //Calcolo le informazioni di servizio if ($res->tipo == 1) { $doc->course_name = "TUTTI"; } else { $doc->course_name = $course->getById($res->tipo)->name; } $list[] = $doc; } } return $list; }
public function getById($id) { $id = (int) $id; $sql = "SELECT * FROM piani WHERE id_piano='{$id}' LIMIT 1"; $auth = $this->connector->query($sql); if (mysql_num_rows($auth) > 0) { //Inializzo le classi di servizio $course = new Course(); $course->setConnector($this->connector); $subjectPlan = new SubjectPlan(); $subjectPlan->setConnector($this->connector); $res = $this->connector->getObjectResult($auth); //Recupero la lista delle entries $sub_list = $subjectPlan->getList($res->id_piano, "anno"); $plan = new Plan($res->id_piano, $res->codice, $res->id_corso, $sub_list); //Calcolo le informazioni di servizio $plan->course_name = $course->getById($plan->course_id)->name; //ritorno il piano cercato return $plan; } return false; }
public function getById($id) { // interrogazione della tabella $sql = "SELECT * FROM studenti WHERE id_studente='{$id}'"; $auth = $this->connector->query($sql); $student = null; if (mysql_num_rows($auth) > 0) { $res = $this->connector->getObjectResult($auth); $student = new Student(get_object_vars($res)); } //Gestisco i dati di servizio $plan = new Plan(); $plan->setConnector($this->connector); $student_plan = $plan->getById($student->id_plan); $student->course_id = $student_plan->course_id; $course = new Course(); $course->setConnector($this->connector); $student_course = $course->getById($student->course_id); $student->course_name = $student_course->name; $student->course_year = $student_course->years; return $student; }
function showCourse() { global $connector; $page = "course.php"; $course = new Course(); $course->setConnector($connector); if ($_POST['operation']) { list($operation, $params) = explode("#", $_POST['operation']); switch ($operation) { case 'saveChanges': $course->storeFormValues($_POST); $error_msg = $course->insert(); if ($error_msg) { $result['edit'] = $course; } break; case 'delete': $error_msg = $course->delete($params); break; case 'edit': $result['edit'] = $course->getById($params); break; case 'editChanges': $course->storeFormValues($_POST); $error_msg = $course->update(); break; default: $error_msg = "Operazione non valida"; } if ($error_msg != "") { $result["errorMessage"] = $error_msg; } elseif ($operation != 'edit') { $result["statusMessage"] = "Operazione completata!"; } } if (isset($_POST['search'])) { $result["courses"] = $course->search($_POST['search']); } else { $result["courses"] = $course->getList(); } $page = "course.php"; include_once BASE_PATH . "template.php"; }