PHP Student::setConnector方法代码示例

 public function insert()
 {
     if (!$this->title) {
         return "Inserire il titolo dell'avviso";
     }
     if (!$this->text) {
         return "Inserire il testo dell'avviso";
     }
     if (!is_array($this->id_dest)) {
         return "Selezionare almeno un destinatario";
     }
     $tabella = "avvisi";
     $campi = array("titolo", "testo", "id_studente", "invio_mail");
     $valori = array($this->title, $this->text, implode(";", $this->id_dest), $this->mail_send);
     $auth = $this->connector->insert($tabella, $campi, $valori);
     if (mysql_errno() == 1062) {
         return "Avviso già presente";
     } else {
         if (mysql_errno() > 0) {
             return "Errore interno numero: " . mysql_errno();
         }
     }
     if ($this->mail_send) {
         $student = new Student();
         $student->setConnector($this->connector);
         $lista = array();
         if (in_array(0, $this->id_dest)) {
             $lista = $student->getList();
         } else {
             foreach ($this->id_dest as $id_dest) {
                 $tmp_stud = $student->getById($id_dest);
                 $lista[] = $tmp_stud;
             }
         }
         $errore = "";
         foreach ($lista as $student) {
             $student->setConnector($this->connector);
             $destinatario = $student->email;
             $mittente_mail = "";
             $oggetto = "";
             $messaggio = "";
             $intestazioni = "MIME-Version: 1.0\r\nContent-type: text/html; charset=iso-8859-1\r\nFrom: {$mittente_mail}";
             //invio la mail
             $risultato = mail($destinatario, $oggetto, $messaggio, $intestazioni);
             //reindirizzamento
             if (!$risultato) {
                 $errore .= "Problema nell'inoltro dell'email all'indirizzo {$destinatario}. L'avviso è stato comunque registrato sul portale<br>";
             }
         }
         if ($errore != "") {
             return $errore;
         }
     }
 }

 public function getBookedList($student_id = null, $order = "data_prenotazione")
 {
     $order = trim(filter_var($order, FILTER_SANITIZE_STRING));
     $id = (int) $student_id;
     //interrogazione tabella
     if ($id) {
         $sql = "SELECT * FROM prenotazioni WHERE id_studente='{$id}' ORDER BY {$order}";
     } else {
         $sql = "SELECT * FROM prenotazioni ORDER BY {$order}";
     }
     $auth = $this->connector->query($sql);
     $list = array();
     $student = new Student();
     $student->setConnector($this->connector);
     // controllo sul risultato dell'interrogazione
     if (mysql_num_rows($auth) > 0) {
         while ($res = $this->connector->getObjectResult($auth)) {
             $book = $this->getById($res->id_appello);
             $book->book_date = $res->data_prenotazione;
             $book->student_id = $res->id_studente;
             $book->book_id = $res->id_prenotazione;
             $book->student = $student->getById($book->student_id);
             $list[] = $book;
         }
     }
     return $list;
 }

/**
 * @author Christian Rizza
 * www.crizza.com
 * email: christian@crizza.com
 */
session_start();
define('BASE_PATH', "./");
include BASE_PATH . "config.php";
if (!isset($_SESSION['admin'])) {
    header("Location: index.php");
}
$conn = new MysqlConnector();
$conn->connect();
$student = new Student();
$student->setConnector($conn);
$lista = $student->getList();
foreach ($lista as $entry) {
    echo "Email: " . $entry->email . " ";
    $entry->setConnector($conn);
    if ($entry->generatePassword()) {
        echo "[Errore di invio] <br>";
    } else {
        echo "[OK] <br>";
    }
    $counter++;
}
$conn->disconnect();
?>

function homepage()
{
    global $connector;
    global $result;
    if (isset($_SESSION['admin'])) {
        header("Location: admin/");
    }
    if (isset($_SESSION['login'])) {
        include_once "classes/Student.php";
        include_once "classes/Exam.php";
        include_once "classes/Plan.php";
        include_once "classes/Payment.php";
        include_once "classes/Notice.php";
        include_once "classes/Booking.php";
        include_once "classes/Document.php";
        $student = new Student();
        $student->setConnector($connector);
        $student = $student->getById($_SESSION['id_student']);
        $student->setConnector($connector);
        $exam = new Exam();
        $plan = new Plan();
        $payment = new Payment();
        $notice = new Notice();
        $booking = new Booking();
        $document = new Document();
        $exam->setConnector($connector);
        $plan->setConnector($connector);
        $payment->setConnector($connector);
        $notice->setConnector($connector);
        $booking->setConnector($connector);
        $document->setConnector($connector);
        if (isset($_POST['operation'])) {
            list($operation, $params) = explode("#", $_POST['operation']);
            switch ($operation) {
                case 'editChanges':
                    $student->storeFormValues($_POST);
                    $student->id = $params;
                    if (isset($_POST['password']) && $_POST['password'] != '') {
                        $student->generatePassword($_POST['password']);
                    }
                    $error_msg = $student->update();
                    break;
                case 'saveBook':
                    $error_msg = $booking->saveBooking($student->id, $params);
                    break;
                case 'sendMail':
                    $error_msg = sendMail();
                    break;
                default:
                    $error_msg = $operation . "#" . $params;
                    break;
            }
            if ($error_msg != "") {
                $result["errorMessage"] = $error_msg;
            } elseif ($operation != 'edit' && $operation != "nextPage") {
                $result["statusMessage"] = "Operazione completata!";
            }
        }
        if ($student) {
            $result["edit"] = $student;
            $result["edit"]->exam = $exam->getList($student);
            $result["edit"]->plan = $plan->getById($student->id_plan);
            $result['edit']->payment = $payment->getById($student->id);
            $result['edit']->notice = $notice->getList();
            $result['edit']->booking = $booking->getListForStudent($student);
            $result['edit']->booked = $booking->getBookedList($student->id);
            $result['edit']->document = $document->getList();
        }
        $page = "home.php";
        include_once BASE_PATH . "/template.php";
    } else {
        $page = "login.php";
        include_once BASE_PATH . "/template.php";
    }
}

function showStudent()
{
    global $connector;
    global $result;
    $student = new Student();
    $course = new Course();
    $plan = new Plan();
    $student->setConnector($connector);
    $course->setConnector($connector);
    $plan->setConnector($connector);
    if (isset($_POST['operation'])) {
        list($operation, $params) = explode("#", $_POST['operation']);
        switch ($operation) {
            case 'delete':
                $error_msg = $student->delete($params);
                break;
            case 'edit':
                $stud = $student->getById($params);
                $result['edit'] = $stud;
                $result['edit']->student = $stud;
                $exam = new Exam();
                $exam->setConnector($connector);
                $result['edit']->exam = $exam->getList($result['edit']->student);
                break;
            case 'editChanges':
                $student->storeFormValues($_POST);
                $error_msg = $student->update();
                break;
            case 'saveChanges':
                $student->storeFormValues($_POST);
                $error_msg = $student->insert();
                if ($error_msg) {
                    $result['edit'] = $student;
                }
                break;
            case 'nextPage':
                $student->storeFormValues($_POST);
                $result['edit'] = $student;
                break;
            case 'createPassword':
                $stud = $student->getById($params);
                $stud->setConnector($connector);
                $error_msg = $stud->generatePassword();
                $result['edit'] = $stud;
                break;
            default:
                $error_msg = "Operazione non valida";
        }
        if ($error_msg != "") {
            $result["errorMessage"] = $error_msg;
        } elseif ($operation != 'edit' && $operation != "nextPage") {
            $result["statusMessage"] = "Operazione completata!";
        }
    }
    if (isset($_POST['search'])) {
        $result["students"] = $student->search($_POST['search']);
    } else {
        $result["students"] = $student->getList();
    }
    $result["plans"] = $plan->getList("id_piano");
    $result["courses"] = $course->getList("nome");
    $page = "student.php";
    include_once BASE_PATH . "template.php";
}