PHP Query::Query方法代码示例

 /**
  * bool Query_Theme(array $dsn = null)
  *
  * Constructor function
  *
  * @param array $dsn (optional) Data Source Name
  * @return boolean returns false, if error occurs
  * @access public
  */
 function Query_Theme($dsn = null)
 {
     $this->_table = "theme_tbl";
     $this->_primaryKey = array("id_theme");
     $this->_map = array('id_theme' => array('mutator' => 'setId'), 'theme_name' => array('mutator' => 'setName'), 'css_file' => array('mutator' => 'setCssFile'), 'row_count' => array('mutator' => 'setCount'));
     return parent::Query($dsn);
 }

 /**
  * bool Query_History(array $dsn = null)
  *
  * Constructor function
  *
  * @param array $dsn (optional) Data Source Name
  * @return boolean returns false, if error occurs
  * @access public
  */
 function Query_History($dsn = null)
 {
     $this->_table = "history_tbl";
     $this->_primaryKey = array("id_patient");
     $this->_map = array('id_patient' => array('mutator' => 'setIdPatient'), 'birth_growth' => array('mutator' => 'setBirthGrowth'), 'growth_sexuality' => array('mutator' => 'setGrowthSexuality'), 'feed' => array('mutator' => 'setFeed'), 'habits' => array('mutator' => 'setHabits'), 'peristaltic_conditions' => array('mutator' => 'setPeristalticConditions'), 'psychological' => array('mutator' => 'setPsychological'), 'children_complaint' => array('mutator' => 'setChildrenComplaint'), 'venereal_disease' => array('mutator' => 'setVenerealDisease'), 'accident_surgical_operation' => array('mutator' => 'setAccidentSurgicalOperation'), 'medicinal_intolerance' => array('mutator' => 'setMedicinalIntolerance'), 'mental_illness' => array('mutator' => 'setMentalIllness'), 'parents_status_health' => array('mutator' => 'setParentsStatusHealth'), 'brothers_status_health' => array('mutator' => 'setBrothersStatusHealth'), 'spouse_childs_status_health' => array('mutator' => 'setSpouseChildsStatusHealth'), 'family_illness' => array('mutator' => 'setFamilyIllness'));
     return parent::Query($dsn);
 }

 /**
  * bool Query_Staff(array $dsn = null)
  *
  * Constructor function
  *
  * @param array $dsn (optional) Data Source Name
  * @return boolean returns false, if error occurs
  * @access public
  */
 function Query_Staff($dsn = null)
 {
     $this->_table = "staff_tbl";
     $this->_primaryKey = array("id_member");
     $this->_map = array('id_member' => array('mutator' => 'setIdMember'), 'member_type' => array('mutator' => 'setMemberType'), 'collegiate_number' => array('mutator' => 'setCollegiateNumber'), 'nif' => array('mutator' => 'setNIF'), 'first_name' => array('mutator' => 'setFirstName'), 'surname1' => array('mutator' => 'setSurname1'), 'surname2' => array('mutator' => 'setSurname2'), 'address' => array('mutator' => 'setAddress'), 'phone_contact' => array('mutator' => 'setPhone'), 'login' => array('mutator' => 'setLogin'), 'id_user' => array('mutator' => 'setIdUser'));
     return parent::Query($dsn);
 }

 /**
  * bool Query_Test(array $dsn = null)
  *
  * Constructor function
  *
  * @param array $dsn (optional) Data Source Name
  * @return boolean returns false, if error occurs
  * @access public
  */
 function Query_Test($dsn = null)
 {
     $this->_table = "medical_test_tbl";
     $this->_primaryKey = array("id_test");
     $this->_map = array('id_test' => array('mutator' => 'setIdTest'), 'id_problem' => array('mutator' => 'setIdProblem'), 'document_type' => array('mutator' => 'setDocumentType'), 'path_filename' => array('mutator' => 'setPathFilename'));
     return parent::Query($dsn);
 }

 /**
  * bool Query_Setting(array $dsn = null)
  *
  * Constructor function
  *
  * @param array $dsn (optional) Data Source Name
  * @return boolean returns false, if error occurs
  * @access public
  */
 public function Query_Setting($dsn = null)
 {
     $this->_table = "setting_tbl";
     $this->_primaryKey = null;
     $this->_map = array('clinic_name' => array('mutator' => 'setClinicName'), 'clinic_hours' => array('mutator' => 'setClinicHours'), 'clinic_address' => array('mutator' => 'setClinicAddress'), 'clinic_phone' => array('mutator' => 'setClinicPhone'), 'clinic_url' => array('mutator' => 'setClinicUrl'), 'session_timeout' => array('mutator' => 'setSessionTimeout'), 'items_per_page' => array('mutator' => 'setItemsPerPage'), 'version' => array('mutator' => 'setVersion'), 'language' => array('mutator' => 'setLanguage'), 'id_theme' => array('mutator' => 'setIdTheme'));
     return parent::Query($dsn);
 }

 /**
  * bool Query_User(array $dsn = null)
  *
  * Constructor function
  *
  * @param array $dsn (optional) Data Source Name
  * @return boolean returns false, if error occurs
  * @access public
  */
 function Query_User($dsn = null)
 {
     $this->_table = "user_tbl";
     $this->_primaryKey = array("id_user");
     $this->_map = array('id_user' => array('mutator' => 'setIdUser'), 'id_member' => array('mutator' => 'setIdMember'), 'login' => array('mutator' => 'setLogin'), 'pwd' => array('mutator' => 'setPwd'), 'email' => array('mutator' => 'setEmail'), 'actived' => array('mutator' => 'setActived'), 'id_theme' => array('mutator' => 'setIdTheme'), 'id_profile' => array('mutator' => 'setIdProfile'));
     return parent::Query($dsn);
 }

 /**
  * bool Query_LogStats(string $table, array $dsn = null)
  *
  * Constructor function
  *
  * @param array $dsn (optional) Data Source Name
  * @return boolean returns false, if error occurs
  * @access public
  */
 function Query_LogStats($table, $dsn = null)
 {
     if ($table != 'access' && $table != 'record') {
         $table = 'access';
     }
     $this->_table = $table . '_log_tbl';
     return parent::Query($dsn);
 }

 /**
  * bool Query_DelPatient(array $dsn = null)
  *
  * Constructor function
  *
  * @param array $dsn (optional) Data Source Name
  * @return boolean returns false, if error occurs
  * @access public
  */
 function Query_DelPatient($dsn = null)
 {
     $this->_table = "deleted_patient_tbl";
     $this->_primaryKey = null;
     return parent::Query($dsn);
 }

 /**
  * Constructor method.
  * 
  * $sql is the SQL query you wish to execute with this object.
  * $conn is the database connection resource to be queried.
  * 
  * @access	public
  * @param	string	$sql
  * @param	resource	$conn
  * 
  */
 function PgSQL_Query($sql = '', &$conn, $cache = 0)
 {
     parent::Query($sql, $conn, $cache);
 }

 /**
  * bool Query_Connection(array $dsn = null)
  *
  * Constructor function
  *
  * @param array $dsn (optional) Data Source Name
  * @return boolean returns false, if error occurs
  * @access public
  */
 function Query_Connection($dsn = null)
 {
     $this->_table = "connection_problem_tbl";
     $this->_primaryKey = array("id_problem", "id_connection");
     return parent::Query($dsn);
 }

 /**
  * bool Query_Relative(array $dsn = null)
  *
  * Constructor function
  *
  * @param array $dsn (optional) Data Source Name
  * @return boolean returns false, if error occurs
  * @access public
  */
 function Query_Relative($dsn = null)
 {
     $this->_table = "relative_tbl";
     return parent::Query($dsn);
 }

 /**
  * bool Query_Session(array $dsn = null)
  *
  * Constructor function
  *
  * @param array $dsn (optional) Data Source Name
  * @return boolean returns false, if error occurs
  * @access public
  */
 function Query_Session($dsn = null)
 {
     $this->_table = "session_tbl";
     return parent::Query($dsn);
 }