PHP Connection::closeConnection方法代码示例

 /**
  *
  * @param <Inventory> $inventory
  * @return <Inventory>
  * @SQL Insert into inventory values (NULL,1,1,1)
  */
 public function addToInventory($inventory)
 {
     $con = Connection::createConnection();
     $artifact = $inventory->artifact;
     $user = $inventory->user;
     $result = mysql_query("Insert into inventory values (NULL,{$inventory->artifactLvl},{$artifact->id},{$user->id})");
     $inventory->id = mysql_insert_id();
     mysql_query("commit");
     Connection::closeConnection($con);
     return $inventory;
 }

 /**
  *
  * @param <User> $username
  * @return <User>
  * @SQL Select * From user Where username = 1
  */
 public function isUsernameAvailable($username)
 {
     $con = Connection::createConnection();
     $result = mysql_query("Select * From user Where username = '{$username}'");
     $loginid = -1;
     $tempArray = mysql_fetch_array($result);
     if (mysql_num_rows($result) == 1) {
         $user = new User();
         $user->id = $tempArray['id'];
         $user->username = $tempArray['username'];
     }
     Connection::closeConnection($con);
     return $user;
 }

 /** constructor **/
 public function __construct()
 {
     // validate arguments
     $num = func_num_args();
     $argumments = func_get_args();
     // create an empty object
     if ($num == 0) {
         $this->id = 0;
         $this->description = '';
         $this->ip = '';
     }
     // 1 values received
     if ($num == 1) {
         // pass the value to the id
         $id = $argumments[0];
         // create the instruction
         $instruction = 'SELECT station_description, station_ip_address FROM station WHERE station_id = ?';
         // open the connection
         parent::openConnection();
         // create the command
         $command = parent::$connection->prepare($instruction);
         // parameters
         $command->bind_param('i', $id);
         // execute command
         $command->execute();
         // link the results to local values
         $command->bind_result($description, $ip);
         // read data
         $found = $command->fetch();
         // close command
         mysqli_stmt_close($command);
         // close the connection
         parent::closeConnection();
         if ($found) {
             $this->id = $id;
             $this->description = $description;
             $this->ip = $ip;
         } else {
             $this->id = 0;
             $this->description = 'asdasd';
             $this->ip = 'asdasd';
         }
     }
 }

 function getStationReadings($i)
 {
     $ids = array();
     $readings = array();
     $instruction = 'SELECT reading_id FROM readings WHERE date(reading_date)= curdate() AND reading_id_station=? ORDER BY reading_id DESC LIMIT 10';
     parent::openConnection();
     $command = parent::$connection->prepare($instruction);
     $command->bind_param('i', $i);
     $command->execute();
     $command->bind_result($id);
     while ($command->fetch()) {
         array_push($ids, $id);
     }
     mysqli_stmt_close($command);
     parent::closeConnection();
     foreach ($ids as $id) {
         array_push($readings, new Reading($id));
     }
     return $readings;
 }

 public function getWeekAverages()
 {
     $instruction = 'SELECT 
         avg(case when `reading_id_station` = 1 then `reading_temperature` else null end) as Station1,
         avg(case when `reading_id_station` = 2 then `reading_temperature` else null end) as Station2,
         avg(case when `reading_id_station` = 3 then `reading_temperature` else null end) as Station3
         FROM readings 
         Where YEARWEEK (`reading_date`) = YEARWEEK(current_date)';
     parent::openConnection();
     $command = parent::$connection->prepare($instruction);
     $command->execute();
     $command->bind_result($s1, $s2, $s3);
     $found = $command->fetch();
     mysqli_stmt_close($command);
     parent::closeConnection();
     $averages = new ArrayObject();
     if ($found) {
         $averages['station1'] = $s1;
         $averages['station2'] = $s2;
         $averages['station3'] = $s3;
     } else {
         $averages['station1'] = 0;
         $averages['station2'] = 0;
         $averages['station3'] = 0;
     }
     return $averages;
 }

 /**
  *
  * @param <Inventory> $inventory
  * @param <int> $artifactPrice
  * @param <GameProfile> $updatedGameProfile
  * @return <Boolean>
  * @SQL update gameprofile set gold = 100 where userid = 1
  * @SQL delete from inventory where id=1 AND userid=1
  *
  */
 public function sellArtifact($inventory, $artifactPrice, $updatedGameProfile)
 {
     $con = Connection::createConnection();
     $user = $updatedGameProfile->user;
     $updateGameProfile = mysql_query("update gameprofile set gold = {$updatedGameProfile->gold} where userid = {$user->id}");
     //delete from inventory
     $deleteInventory = mysql_query("delete from inventory where id={$inventory->id} AND userid={$user->id}");
     mysql_query("commit");
     Connection::closeConnection($con);
     return true;
 }

 /**
  *
  * @param <String> $columnName
  * @param <GameProfile> $gameProfile
  * @return <Boolean>
  * @SQL update gameprofile set spylvl=spylvl+1 where globallvl > spylvl+scoutlvl+buylvl+sharelvl AND userid =1
  */
 public function addSkill($columnName, $gameProfile)
 {
     $con = Connection::createConnection();
     $user = $gameProfile->user;
     $addPoints = mysql_query("update gameprofile set {$columnName}={$columnName}+1 where globallvl > spylvl+scoutlvl+buylvl+sharelvl AND userid ={$user->id}");
     if (mysql_affected_rows() < 1) {
         Connection::closeConnection($con);
         return false;
     } else {
         return true;
     }
 }

 public function getShareProgress($gameProfile, $gameProgress)
 {
     $con = Connection::createConnection();
     $share = ServerConstants::SHARE;
     $csp = $gameProgress->csp;
     $friendUser = $gameProgress->friend->user;
     $count = mysql_query("SELECT count(*) as count FROM gameprogress,progresstype where gameprogress.progresstypeid = progresstype.id AND progresstype.progresstype = '{$share}' AND gameprogress.cspid = {$csp->id} AND gameprogress.friendid = {$friendUser->id}");
     while ($row = mysql_fetch_array($count)) {
         $rowcount = $row['count'];
     }
     $base = 0.5;
     $rowcount = $rowcount + 1;
     $progress = pow($base, $rowcount) * $gameProfile->shareLvl * 5;
     $progressType = $this->giveProgressTypeObj(ServerConstants::SHARE);
     $insert = mysql_query("insert into gameprogress values (NULL,{$csp->id},{$friendUser->id},{$progressType->id})");
     mysql_query("commit");
     Connection::closeConnection($con);
     return $progress;
 }

<?php

/* 
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
require_once '../scriptsPHP/DAO/Connection.php';
require_once './utilidades/Authenticator.php';
header("Content-Type: text/html");
$authenticator = new Authenticator("Tirate una autenticacion papa", "No vas a pasar ni en pedo, puto");
$authenticator->setUser("jose");
$authenticator->setPassword("1234");
$authenticator->authenticate(TRUE, TRUE);
$conexionObject = new Connection("localhost", "matias", "", "diccionario");
$conexion = $conexionObject->getConnection();
$conexion = $conexionObject->getConnection();
$query = "select * from palabra";
$resultSet = $conexion->query($query);
while ($currentRow = mysqli_fetch_assoc($resultSet)) {
    echo $currentRow["palabra"] . " - ";
    echo "<br><br>";
}
$conexionObject->closeConnection();

 /**
  *
  * @param <CurrentSearchParty> $currentSearchParty
  * @return <CurrentSearchParty>
  * @SQL update  currentsearchparty,artifactinfo  set progress = 10 where currentsearchparty.id = 1 AND (select isactive from artifactinfo where artifactinfo.id= currentsearchparty.artifactid) = 1
  */
 public function updateCurrentSearchPartyProgress($currentSearchParty)
 {
     $con = Connection::createConnection();
     $result = mysql_query("update  currentsearchparty,artifactinfo  set progress = '{$currentSearchParty->progress}' where currentsearchparty.id = '{$currentSearchParty->id}' AND (select isactive from artifactinfo where artifactinfo.id= currentsearchparty.artifactid) = 1");
     if (mysql_affected_rows() < 1) {
         //means the current search party we want to update the artifact of that party is not active
         Connection::closeConnection($con);
         return null;
     }
     Connection::closeConnection($con);
     return $currentSearchParty;
 }

    $reference = $_POST['check_tel'];
}
if (isset($_POST['check_email'])) {
    $reference = $_POST['check_email'];
}
echo "<h1>Recuperation variables</h1>";
echo "Nom : {$nom} <br />";
echo "Prénom : {$prenom} <br />";
echo "Adresse : {$adresse} <br />";
echo "Type : {$type} <br />";
echo "Description : {$description} <br />";
echo "severite : {$severite} <br />";
echo "Référence : {$reference} <br />";
if (isset($_FILES['photo'])) {
    echo "Photo : " . $_FILES['photo']['name'];
}
$incident = new Incident($description, $type, $adresse, $severite, $reference, $target);
/*** La connection à la DB ***/
$database = new Connection("localhost", "root", "root");
/*** L'insertion dans la table incident ***/
$count = $database->insertIntoIncident($incident);
echo $count;
/*** Déconnexion de la DB ***/
$database->closeConnection();
$html = "<br/><br/><button class=\"btn btn-success\" type=\"button\" onclick=\"window.location.href='Display.php'\">Montrer les plaintes</button>";
echo $html;
?>

</body>
</HTML>