PHP DBConnection::closeConnection方法代码示例

 public static function getEvents()
 {
     $db = new DBConnection();
     $link = $db->connect();
     if ($link != null) {
         $query = "SELECT event_name,start_date,end_date,start_time FROM event";
         $result = $link->query($query);
         $result_array = array();
         $index = 0;
         while ($row = mysqli_fetch_assoc($result)) {
             $result_array[$index] = $row;
             $index = $index + 1;
         }
         $db->closeConnection();
         return $result_array;
     }
     $db->closeConnection();
     return null;
 }

 /**
  * Metodo para almacenar la informacion de los errores en los querys ejecutados.
  * 
  * @param string $queryOperation
  * @param string $result
  */
 private static function storeError($queryOperation, $result)
 {
     if (DBUtil::$STORE_LOGS) {
         $idUsuario = "NULL";
         $time0 = time();
         if (isset($_SESSION["usuario"])) {
             $idUsuario = $_SESSION["usuario"]->getId();
         }
         $query = "INSERT INTO system_log (fecha, query, result, was_error, query_time, id_usuario)" . " VALUES(now(),'" . str_replace("'", "\\'", $queryOperation) . "','" . str_replace("'", "\\'", $result) . "','1'," . (time() - $time0) . "," . $idUsuario . ")";
         $dbConObj = new DBConnection();
         mysql_query($query, $dbConObj->getConnection());
         $dbConObj->closeConnection();
     } else {
         echo $result;
     }
 }

 public function restore()
 {
     // we need root database access to re-create tables
     $rconn = DBConnection::getRootConnection();
     if ($rconn->connect_error) {
         throw new Exception("Cannot perform upgrade process: database::dbConnect()");
     }
     session_start();
     unset($_SESSION['progress']);
     session_write_close();
     // phase 1: retrieve file from http request
     $data = $this->retrieveDBFile();
     // phase 2: verify received file
     if (strpos(substr($data, 0, 25), "-- AgilityContest") === FALSE) {
         throw new Exception("Provided file is not an AgilityContest backup file");
     }
     // phase 3: delete all tables and structures from database
     $this->dropAllTables($rconn);
     // phase 4: parse sql file and populate tables into database
     $this->readIntoDB($rconn, $data);
     // phase 5 final tests
     DBConnection::closeConnection($rconn);
     return "";
 }

 public static function getMemberDetail($id)
 {
     $db = new DBConnection();
     $link = $db->connect();
     if ($link != null) {
         $query = "SELECT concat(first_name,\" \",last_name) AS name  , gender , email ,mobile   FROM member WHERE id ='" . $id . "'";
         $result = $link->query($query);
         $db->closeConnection();
         return $result;
     }
     $db->closeConnection();
     return null;
 }

 /**
  * Metodo para almacenar la informacion de los errores en los querys ejecutados.
  * 
  * @param string $queryOperation
  * @param string $result
  */
 private static function storeError($queryOperation, $result)
 {
     if (DBUtil::$storeErrors == true) {
         $idUsuario = "NULL";
         $time0 = time();
         if (isset($_SESSION["usuario"])) {
             $idUsuario = $_SESSION["usuario"]->getId();
         }
         $dbConObj = new DBConnection();
         $query = "INSERT INTO system_log (fecha, query, result, was_error, query_time, id_usuario)" . " VALUES(now(),'" . mysql_real_escape_string($queryOperation, $dbConObj->getConnection()) . "','" . mysql_real_escape_string($result, $dbConObj->getConnection()) . "','1'," . (time() - $time0) . "," . $idUsuario . ")";
         mysql_query($query, $dbConObj->getConnection());
         $dbConObj->closeConnection();
     }
 }

$query .= "(SELECT vd1.idventa FROM vista_ventas_detalles vd1 WHERE vd1.fecha_venta='" . $_GET["date"] . "' GROUP BY vd1.idventa) vd2 ";
$query .= "WHERE vd.anulado = 0  AND vd.idventa = vd2.idventa ORDER BY vd.idventa, vd.idventa_detalle";
echo "En VentasDAO::calcularTicketGanador -> iniciando '" . $query . "'<br /><br />";
$resultArray = array();
$time0 = time();
$dbConObj = new DBConnection();
echo "Fecha: " . $_GET["date"] . "<br /><br />";
ini_set('memory_limit', '1024M');
try {
    $result = mysql_query($query, $dbConObj->getConnectionV2());
    if (!mysql_error()) {
        while ($r = mysql_fetch_array($result)) {
            $resultArray[] = $r;
        }
        echo "count(resultArray)= " . count($resultArray) . "<br /><br />";
    } else {
        echo "mysql_error(): " . mysql_error() . "<br /><br />";
    }
} catch (Exception $e) {
    echo "Error ejecutando consulta en base de datos" . $e . "<br /><br />";
}
$dbConObj->closeConnection();
echo mysql_error() . "<br />";
echo "En VentasDAO::calcularTicketGanador -> ejecutado '" . $query . "<br /><br />";
if (count($result) > 0) {
    foreach ($result as $venta) {
        print_r($venta);
    }
} else {
    echo "result esta vacio";
}