PHP Connection::close_connection方法代码示例

 public function load($iUserID)
 {
     $connection = new Connection();
     $sSQL = "SELECT UserID, FirstName, LastName, Username, Address, Email, Telephone, Password, Admin\n                     FROM tbuser\n                     WHERE UserID=" . $iUserID;
     $resultSet = $connection->query($sSQL);
     $row = $connection->fetch_array($resultSet);
     //store data into attributes:
     $this->iUserID = $row['UserID'];
     $this->sFirstName = $row['FirstName'];
     $this->sLastName = $row['LastName'];
     $this->sUsername = $row['Username'];
     $this->sAddress = $row['Address'];
     $this->sEmail = $row['Email'];
     $this->iTelephone = $row['Telephone'];
     $this->sPassword = $row['Password'];
     $this->iAdmin = $row['Admin'];
     // get all recipe ids of each user:
     $sSQL = "SELECT RecipeID\n                     FROM tbrecipe\n                     WHERE UserID=" . $iUserID;
     $resultSet = $connection->query($sSQL);
     while ($row = $connection->fetch_array($resultSet)) {
         $iRecipeID = $row["RecipeID"];
         $oRecipe = new Recipe();
         $oRecipe->load($iRecipeID);
         $this->aRecipes[] = $oRecipe;
     }
     $connection->close_connection();
 }

 public static function get_makes()
 {
     //open connection to MySql
     parent::open_connection();
     //initialize arrays
     $ids = array();
     //array for ids
     $list = array();
     //array for objects
     //query
     $query = "select mak_id from makes";
     //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 Make($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();
         }
     }
 }

 public function load($iOrderID)
 {
     $connection = new Connection();
     $sSQL = "SELECT OrderID, OrderDate, OrderStatus, RecipientName, DeliveryAddress, BillingAddress, Payment, AccountName, CardNumber, ExpiryDate, Security, UserID\n                     FROM tborder\n                     WHERE OrderID=" . $iOrderID;
     $resultSet = $connection->query($sSQL);
     $row = $connection->fetch_array($resultSet);
     //store data in attributes:
     $this->iOrderID = $row["OrderID"];
     $this->tOrderDate = $row["OrderDate"];
     $this->sOrderStatus = $row["OrderStatus"];
     $this->sRecipientName = $row["RecipientName"];
     $this->sDelivery = $row["DeliveryAddress"];
     $this->sBilling = $row["BillingAddress"];
     $this->sPayment = $row["Payment"];
     $this->sAccountName = $row["AccountName"];
     $this->iCardNumber = $row["CardNumber"];
     $this->sExpiry = $row["ExpiryDate"];
     $this->iSecurity = $row["Security"];
     $this->iUserID = $row["UserID"];
     $connection->close_connection();
 }

 public function load($iSubscriberID)
 {
     $connection = new Connection();
     $sSQL = "SELECT SubscriberID, Email\n                     FROM tbnewsletter\n                     WHERE SubscriberID=" . $iSubscriberID;
     $resultSet = $connection->query($sSQL);
     $row = $connection->fetch_array($resultSet);
     //store data into attributes:
     $this->iSubscriberID = $row['SubscriberID'];
     $this->sEmail = $row['Email'];
     $connection->close_connection();
 }

 public function load($iLikeID)
 {
     $connection = new Connection();
     $sSQL = "SELECT LikeID, UserID, RecipeID\n\t\t\t         FROM tblike\n\t\t\t         WHERE LikeID = " . $iLikeID;
     $resultSet = $connection->query($sSQL);
     $row = $connection->fetch_array($resultSet);
     // store into attributes:
     $this->iLikeID = $row["LikeID"];
     $this->iUserID = $row["UserID"];
     $this->iRecipeID = $row["RecipeID"];
     $connection->close_connection();
 }

 public static function listAllTypes()
 {
     // creates associative array
     $aRecipeTypes = array();
     $connection = new Connection();
     $sSQL = "SELECT RecipeTypeID,TypeName\n                     FROM tbrecipetype\n                     ";
     $resultSet = $connection->query($sSQL);
     while ($row = $connection->fetch_array($resultSet)) {
         $iRecipeTypeID = $row['RecipeTypeID'];
         $aRecipeTypes[$iRecipeTypeID] = $row['TypeName'];
     }
     $connection->close_connection();
     return $aRecipeTypes;
 }

 public static function getAllProducts()
 {
     $aAllProducts = array();
     $connection = new Connection();
     $sSQL = "SELECT ProductID\n                     FROM tbproduct\n                     ORDER BY CreatedAt DESC\n                     ";
     $resultSet = $connection->query($sSQL);
     while ($row = $connection->fetch_array($resultSet)) {
         $iProductID = $row['ProductID'];
         $oProduct = new Product();
         $oProduct->load($iProductID);
         $aAllProducts[] = $oProduct;
     }
     $connection->close_connection();
     return $aAllProducts;
 }

 public static function getAllRecipes()
 {
     $aAllRecipes = array();
     $connection = new Connection();
     $sSQL = "SELECT RecipeID\n                     FROM tbrecipe\n                     ORDER BY CreatedAt DESC\n                     ";
     $resultSet = $connection->query($sSQL);
     while ($row = $connection->fetch_array($resultSet)) {
         $iRecipeID = $row['RecipeID'];
         $oRecipe = new Recipe();
         $oRecipe->load($iRecipeID);
         $aAllRecipes[] = $oRecipe;
     }
     $connection->close_connection();
     return $aAllRecipes;
 }

 public function load($iProductID)
 {
     $connection = new Connection();
     $sSQL = "SELECT ProductID, ProductName, Description, Price, Size, Ingredients, StockLevel, ImagePath, CreatedAt\n                     FROM tbproduct\n                     WHERE ProductID=" . $iProductID;
     $resultSet = $connection->query($sSQL);
     $row = $connection->fetch_array($resultSet);
     //store into attributes:
     $this->iProductID = $row["ProductID"];
     $this->sProductName = $row["ProductName"];
     $this->sDescription = $row["Description"];
     $this->fPrice = $row["Price"];
     $this->sSize = $row["Size"];
     $this->sIngredients = $row["Ingredients"];
     $this->iStockLevel = $row["StockLevel"];
     $this->sImagePath = $row["ImagePath"];
     $this->tCreatedAt = $row["CreatedAt"];
     $connection->close_connection();
 }

 public function load($iID)
 {
     // Open
     $oConnection = new Connection();
     // Extract
     $sSQL = "SELECT ProductID, ProductName, Description, Price, TypeID, PhotoPath\n\t\tFROM tbproduct\n\t\tWHERE ProductID =" . $iID;
     $oResult = $oConnection->query($sSQL);
     // fetch
     $aProduct = $oConnection->fetch_array($oResult);
     $this->iProductID = $aProduct["ProductID"];
     $this->sProductName = $aProduct["ProductName"];
     $this->sDescription = $aProduct["Description"];
     $this->iCost = $aProduct["Price"];
     $this->iTypeID = $aProduct["TypeID"];
     $this->sPhotoPath = $aProduct["PhotoPath"];
     // close
     $oConnection->close_connection();
 }

 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 save()
 {
     $oConnection = new Connection();
     if ($this->bExisting == false) {
         $sSQL = "INSERT INTO tbcustomer(FirstName, LastName, Address, Telephone, Email, UserName, Password\n\t\t\t\t)\n\t\t\tVALUES (\n\t\t\t\t'" . $oConnection->escape_value($this->sFirstName) . "',\n\t\t\t\t'" . $oConnection->escape_value($this->sLastName) . "',\n\t\t\t\t'" . $oConnection->escape_value($this->sAddress) . "',\n\t\t\t\t'" . $oConnection->escape_value($this->sTelephone) . "',\n\t\t\t\t'" . $oConnection->escape_value($this->sEmail) . "',\n\t\t\t\t'" . $oConnection->escape_value($this->sUserName) . "',\n\t\t\t\t'" . $oConnection->escape_value($this->sPassword) . "'\n\t\t\t\t)";
         $bResult = $oConnection->query($sSQL);
         if ($bResult == true) {
             $this->iCustomerID = $oConnection->get_insert_id();
             $this->bExisting = true;
         } else {
             die($sSQL . "failed");
         }
     } else {
         // updating current customer
         $sSQL = "UPDATE tbcustomer\n\t\t\tSET FirstName = '" . $oConnection->escape_value($this->sFirstName) . "', \n\t\t\tLastName = '" . $oConnection->escape_value($this->sLastName) . "',\n\t\t\tAddress = '" . $oConnection->escape_value($this->sAddress) . "', \n\t\t\tTelephone = '" . $oConnection->escape_value($this->sTelephone) . "',\n\t\t\tEmail = '" . $oConnection->escape_value($this->sEmail) . "',\n\t\t\tUserName = '" . $oConnection->escape_value($this->sUserName) . "',\n\t\t\tPassword = '" . $oConnection->escape_value($this->sPassword) . "'\n\t\t\tWHERE tbcustomer.CustomerID =" . $oConnection->escape_value($this->iCustomerID);
         $bResult = $oConnection->query($sSQL);
         if ($bResult == false) {
             die($sSQL . "fails");
         }
     }
     $oConnection->close_connection();
 }

 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();
         }
     }
 }

 public function load($iRecipeTypeID)
 {
     $connection = new Connection();
     $sSQL = "SELECT RecipeTypeID, TypeName, Description, DisplayOrder\n                     FROM tbrecipetype\n                     WHERE RecipeTypeID=" . $iRecipeTypeID;
     $resultSet = $connection->query($sSQL);
     $row = $connection->fetch_array($resultSet);
     //store into data attribues:
     $this->iRecipeTypeID = $row["RecipeTypeID"];
     $this->sTypeName = $row["TypeName"];
     $this->sDescription = $row["Description"];
     $this->iDisplayOrder = $row["DisplayOrder"];
     // get all recipe IDs of type:
     $sSQL = "SELECT RecipeID\n                     FROM tbrecipe\n                     WHERE RecipeTypeID=" . $iRecipeTypeID . "\n                     ORDER BY CreatedAt DESC";
     $resultSet = $connection->query($sSQL);
     while ($row = $connection->fetch_array($resultSet)) {
         $iRecipeID = $row['RecipeID'];
         $oRecipe = new Recipe();
         $oRecipe->load($iRecipeID);
         $this->aRecipes[] = $oRecipe;
     }
     $connection->close_connection();
 }