PHP Connection::open_connection方法代碼示例

 public function get_models()
 {
     //open connection to MySql
     parent::open_connection();
     //initialize arrays
     $ids = array();
     //array for ids
     $list = array();
     //array for objects
     //query
     $query = "select mod_id from models where mod_id_make = ?";
     //prepare command
     $command = parent::$connection->prepare($query);
     //bind params
     $command->bind_param('i', $this->id);
     //execute command
     $command->execute();
     //link results
     $command->bind_result($id);
     //fill ids array
     while ($command->fetch()) {
         array_push($ids, $id);
     }
     //close command
     mysqli_stmt_close($command);
     //close connection
     parent::close_connection();
     //fill object array
     for ($i = 0; $i < count($ids); $i++) {
         array_push($list, new Model($ids[$i]));
     }
     //return array
     return $list;
 }

 function __construct()
 {
     if (func_num_args() == 0) {
         $this->id = '';
         $this->name = '';
         $this->description = '';
         $this->dosification = '';
         $this->peridiocity = "";
     }
     if (func_num_args() == 1) {
         $args = func_get_args();
         $id = $args[0];
         parent::open_connection();
         $query = "select schedule_id, schedule_name, schedule_note from Activities_Schedule where schedule_id = ?";
         $command = parent::$connection->prepare($query);
         $command->bind_param('s', $id);
         $command->execute();
         $command->bind_result($this->id, $this->name, $this->description);
         $found = $command->fetch();
         mysqli_stmt_close($command);
         parent::close_connection();
         if (!$found) {
             throw new RecordNotFoundException();
         }
     }
 }

 function get_teams()
 {
     //open connection to Mysql
     parent::open_connection();
     //initialize array_sum
     $ids = array();
     //array for ids
     $list = array();
     //array for objects
     //query
     $query = "select team_id from teams where team_id_div = ?";
     //prepare command
     $command = parent::$connection->prepare($query);
     //link parameters
     $command->bind_param('s', $this->id);
     //execute command
     $command->execute();
     //link results
     $command->bind_result($id);
     //fill ids array
     while ($command->fetch()) {
         array_push($ids, $id);
     }
     //close command
     mysqli_stmt_close($command);
     //close connection
     parent::close_connection();
     //fill object array
     for ($i = 0; $i < count($ids); $i++) {
         array_push($list, new Team($ids[$i]));
     }
     //return array
     return $list;
 }

 public static function get_tutors()
 {
     //open connection to MySql
     parent::open_connection();
     //initialize arrays
     $ids = array();
     //array for ids
     $list = array();
     //array for objects
     //query
     $query = "select person_id from Persons_Person";
     //prepare command
     $command = parent::$connection->prepare($query);
     //execute command
     $command->execute();
     //link results
     $command->bind_result($id);
     //fill ids array
     while ($command->fetch()) {
         array_push($ids, $id);
     }
     //close command
     mysqli_stmt_close($command);
     //close connection
     parent::close_connection();
     //fill object array
     for ($i = 0; $i < count($ids); $i++) {
         array_push($list, new Person($ids[$i]));
     }
     //return array
     return $list;
 }

 public function get_childs()
 {
     parent::open_connection();
     $ids = array();
     $list = array();
     $query = "select child_id from Therapies_Therapy_Child where therapy_id = ?";
     $command = parent::$connection->prepare($query);
     $command->bind_param('s', $this->id);
     $command->execute();
     $command->bind_result($id);
     while ($command->fetch()) {
         array_push($ids, $id);
     }
     mysqli_stmt_close($command);
     parent::close_connection();
     for ($i = 0; $i < count($ids); $i++) {
         array_push($list, new Child($ids[$i]));
     }
     return $list;
 }

 public function get_activities()
 {
     parent::open_connection();
     $ids = array();
     $list = array();
     $query = "select schedule_id from Activities_Schedule_Days where schedule_id = ?";
     $command = parent::$connection->prepare($query);
     $command->bind_param('i', $this->id);
     $command->execute();
     $command->bind_result($id);
     while ($command->fetch()) {
         array_push($ids, $id);
     }
     mysqli_stmt_close($command);
     parent::close_connection();
     for ($i = 0; $i < count($ids); $i++) {
         array_push($list, new Activity($ids[$i]));
     }
     return $list;
 }

 function __construct()
 {
     //if no arguments received, create empty object
     if (func_num_args() == 0) {
         $this->id = 0;
         $this->name = '';
         $this->number = '';
         $this->image = '';
         $this->pos_id = '';
     }
     //if one argument received create object with data
     if (func_num_args() == 1) {
         //receive arguments into an array
         $args = func_get_args();
         //id
         $id = $args[0];
         //open connection to Mysql
         parent::open_connection();
         //query
         $query = "select player_id, player_name, player_number,player_image, player_pos_id from players where player_id = ?";
         //prepare command
         $command = parent::$connection->prepare($query);
         //link parameters
         $command->bind_param('i', $id);
         //execute command
         $command->execute();
         //link results to class attributes
         $command->bind_result($this->id, $this->name, $this->number, $this->image, $this->pos_id);
         //fetch data
         $found = $command->fetch();
         //close command
         mysqli_stmt_close($command);
         //close connection
         parent::close_connection();
         //if not found throw exception
         if (!$found) {
             throw new RecordNotFoundException();
         }
     }
 }

 function __construct()
 {
     //if no arguments received, create empty object
     if (func_num_args() == 0) {
         $this->id = '';
         $this->name = '';
         $this->password = '';
     }
     //if two argument received create object with data
     if (func_num_args() == 2) {
         //receive arguments into an array
         $args = func_get_args();
         //get arguments
         $id = $args[0];
         $password = $args[1];
         //open connection to MySql
         parent::open_connection();
         //query
         $query = "select usr_id, usr_name from users\n\t\t\t\t\t\t\t\t\twhere usr_id = ? and usr_password = sha1(?);";
         //prepare command
         $command = parent::$connection->prepare($query);
         //link parameters
         $command->bind_param('ss', $id, $password);
         //execute command
         $command->execute();
         //link results to class attributes
         $command->bind_result($this->id, $this->name);
         //fetch data
         $found = $command->fetch();
         //close command
         mysqli_stmt_close($command);
         //close connection
         parent::close_connection();
         //if not found throw exception
         if (!$found) {
             throw new RecordNotFoundException();
         }
     }
 }

 function __construct()
 {
     if (func_num_args() == 0) {
         $this->id = '';
         $this->name = '';
     }
     if (func_num_args() == 1) {
         $args = func_get_args();
         $id = $args[0];
         parent::open_connection();
         $query = "select day_id, day_name from Activities_Days where day_id = ?";
         $command = parent::$connection->prepare($query);
         $command->bind_param('i', $id);
         $command->execute();
         $command->bind_result($this->id, $this->name);
         $found = $command->fetch();
         mysqli_stmt_close($command);
         parent::close_connection();
         if (!$found) {
             throw new RecordNotFoundException();
         }
     }
 }

 public function get_dosification()
 {
     parent::open_connection();
     $query = "select dosification from Medicines_Medicine_Child where medicine_id = ?";
     $command = parent::$connection->prepare($query);
     $command->bind_param('s', $this->id);
     $command->execute();
     $command->bind_result($id);
     $command->fetch();
     mysqli_stmt_close($command);
     parent::close_connection();
     return $id;
 }

 public function get_transporter()
 {
     parent::open_connection();
     $query = "select child_transporter_id from Persons_Child where child_tutor_id = ?";
     $command = parent::$connection->prepare($query);
     $command->bind_param('s', $this->id);
     $command->execute();
     $command->bind_result($id);
     $command->fetch();
     mysqli_stmt_close($command);
     parent::close_connection();
     return $id;
 }

 function get_car_count($min_year, $max_year, $min_price, $max_price)
 {
     //open connection to MySql
     parent::open_connection();
     //query
     $query = 'select count(*) from cars where car_id_model = ?';
     if ($min_year != null) {
         $query .= ' and car_year >= ' . $min_year;
     }
     if ($max_year != null) {
         $query .= ' and car_year <= ' . $max_year;
     }
     if ($min_price != null) {
         $query .= ' and car_price >= ' . $min_price;
     }
     if ($max_price != null) {
         $query .= ' and car_price <= ' . $max_price;
     }
     //prepare command
     $command = parent::$connection->prepare($query);
     //parameters
     $command->bind_param('s', $this->id);
     //execute command
     $command->execute();
     //link results
     $command->bind_result($count);
     //read count
     $command->fetch();
     //close command
     mysqli_stmt_close($command);
     //close connection
     parent::close_connection();
     //return count
     return $count;
 }