Esempio n. 1
0
 public function verification()
 {
     $query = "SELECT `id` FROM `appoinment` WHERE `patient_user`='" . $this->getPatientUser() . "' AND `doctor`='" . $this->getDoctor() . "' AND `date`='" . $this->getDate() . "' AND `time`='" . $this->getTime() . "' AND `is_approved`='1'";
     $result = $this->db->query(" SELECT * FROM `appointment` ");
     if ($result->num_rows >= 0) {
         self::$message = "Appointment registered you will inform soon";
         return true;
         //is empty
     } else {
         self::$message = 'An appointment with this doctor of same time has been already registred!';
         return false;
     }
 }