PHP dbConnection函数代码示例

	 public function setMiembro($nombre, $apellido, $direccion, $cedula, $email, $casa, $movil, $pin, $categoria, $desc){
	 	
	 	dbConnection(); //Funcion que conecta a la base de datos
	 	
	 	$this->nombre = $nombre;
	 	$this->apellido = $apellido;
	 	$this->cedula = $cedula;
	 	$this->email = $email;
	 	$this->direccion = $direccion;
	 	$this->telefonoCasa = $casa;
	 	$this->telefonoMobil = $movil;
	 	$this->pin = $pin;
	 	$this->categoriaMiembro = $categoria;
	 	$this->desc = $desc;
	 	
	 	$query = "INSERT INTO miembro (codigo, nombre, apellido, direccion, cedula, email, telefono_casa, telefono_mobil, pin, categoria, descripcion)";
	 	$query.= " VALUES (NULL,'$this->nombre','$this->apellido','$this->direccion','$this->cedula','$this->email','$this->telefonoCasa','$this->telefonoMobil','$this->pin','$this->categoriaMiembro','$this->desc')";
	 	
	 	if(mysql_query($query)){
	 		echo "<script type='text/javascript'>
	 				alert('Datos Guardados Correctamente');
	 				window.location.href= 'frmMiembro.php';
	 			 </script>";
	 	};
	 	
	 }

 static function deleteMovie($id)
 {
     $sql = 'DELETE FROM Movie WHERE mov_id=:id;';
     $sth = dbConnection()->prepare($sql);
     $sth->execute(array(':id' => $id));
     $fetch = $sth->fetch();
     return $fetch;
 }

 static function insertUser($u)
 {
     if ($u->firstname != '' && $u->lastname != '' && $u->login != '' && $u->password != '') {
         $sql = 'INSERT INTO User(use_login,use_password,use_firstname,use_lastname) VALUES (:login,:password,:firstname,:lastname)';
         $sth = dbConnection()->prepare($sql);
         $sth->execute(array(':login' => $u->login, ':password' => $u->password, ':firstname' => $u->firstname, ':lastname' => $u->lastname));
         $fetch = $sth->fetch();
         return $fetch;
     } else {
         return false;
     }
 }

function checkuser($fuid)
{
    $conn = dbConnection();
    $sql = "select * from voting where fbID='{$fuid}'";
    $result = $conn->query($sql);
    if ($result->num_rows > 0) {
        session_start();
        session_unset();
        return true;
    }
    return false;
}

function dbResultFromQuery($query)
{
    $connection = dbConnection();
    if (!$connection) {
        die("MySQL Connection failed : " . mysqli_connect_error());
    }
    $result = 0;
    if (!empty($query)) {
        $result = mysqli_query($connection, $query) or die("<p>" . mysqli_error($connection) . "</p>");
    }
    mysqli_close($connection);
    return $result;
}

 /**
  * Function that queries the database for a specific Game and 
  * then returns the result.
  * 
  * @param int $title
  * @return Game
  */
 public function getGame($title)
 {
     $db = dbConnection();
     //Establish database connection
     //Prepare &execute the select statement to query the database.
     $stmt = $db->prepare("select * from Game where gme_id = ?");
     $result = $stmt->execute($title);
     //Return the Game if the query is successful.
     if ($result === true) {
         $game = $stmt->fetch();
         return new Game($game['gme_id'], $game['gme_title'], $game['gme_developer'], $game['gme_console'], $game['gme_price'], $game['gme_rating'], $game['gme_comments']);
     } else {
         throw new Exception("Could not find the game!");
     }
 }

function insertHash($user, $pass)
{
    $pass = password_hash($pass, PASSWORD_DEFAULT);
    $db = dbConnection();
    try {
        $sql = 'INSERT INTO users(username, password) VALUES(:user, :pass)';
        $stmt = $db->prepare($sql);
        $stmt->bindValue(':user', $user, PDO::PARAM_STR);
        $stmt->bindValue(':pass', $pass, PDO::PARAM_STR);
        $stmt->execute();
        $stmt->closeCursor();
    } catch (PDOException $exc) {
        return FALSE;
    }
}

function queryMysqli($query, array $params)
{
    $conPDO = dbConnection();
    try {
        //prepare the query
        $result = $conPDO->prepare($query);
        //execute the query with the passed parameters
        $result->execute($params);
        //close the database connection
        $conPDO = null;
        return $result;
    } catch (PDOException $e) {
        trigger_error('Error: ' . $e->getMessage(), E_USER_ERROR);
    }
}

function getAlldetails($id, $lat, $lng)
{
    //! Message Loggin
    comment_message_log('Start of Function : ' . __FUNCTION__);
    //! Data base connection
    $rConnection = dbConnection();
    /*!
     * Check if the database Connection is failed
     */
    if (!$rConnection) {
        //! Message Loggin
        comment_message_log('End of Function : ' . __FUNCTION__);
        return E00010;
    }
    //! Query
    $sQuery = "SELECT * FROM `servicesubcatrelation` a,`ownerservice` b,`servicebranch` c WHERE a.sub_category_id={$id} and a.service_id=b.service_id and b.service_id=c.service_id ";
    //! Executing the query
    $res = mysqli_query($rConnection, $sQuery);
    /*!
     * Check If the Query executed properly
     */
    if ($res) {
        $data = array();
        //! retrieve the result from the result set
        while ($aRow = mysqli_fetch_assoc($res)) {
            if (distance($lat, $aRow['branch_lat'], $lng, $aRow['branch_lng']) < 300) {
                $data[] = $aRow;
            }
        }
        //! Closing the connections
        dbConnectionClose($rConnection);
        //! Message Login
        comment_message_log('Query Executed Successfully.::: ' . $sQuery);
        comment_message_log('End of Function : ' . __FUNCTION__);
        return $data;
    } else {
        comment_message_log('Query Execution failed. ::: ' . $sQuery . ' ::: ' . @mysqli_error($rConnection));
        comment_message_log('End of Function : ' . __FUNCTION__);
        //! Closing the connections
        dbConnectionClose($rConnection);
        return E00100;
    }
}

function aGetAllTags()
{
    //! Message Loggin
    comment_message_log('Start of Function : ' . __FUNCTION__);
    //! Data base connection
    $rConnection = dbConnection();
    /*!
     * Check if the database Connection is failed
     */
    if (!$rConnection) {
        //! Message Loggin
        comment_message_log('End of Function : ' . __FUNCTION__);
        return E00010;
    }
    //! Query
    $sQuery = "SELECT * FROM `interests` ORDER BY `id` DESC;";
    //! Executing the query
    $rResultSet = mysqli_query($rConnection, $sQuery);
    //! Closing the connections
    dbConnectionClose($rConnection);
    /*!
     *  Check If the Query executed properly
     */
    if ($rResultSet != '') {
        //! Message Login
        comment_message_log('Query Executed Successfully. ::: ' . $sQuery);
        $aData = array();
        //! retrieve the result from the result set
        while ($aRow = mysqli_fetch_assoc($rResultSet)) {
            $aData[] = $aRow;
        }
        comment_message_log('End of Function : ' . __FUNCTION__);
        return $aData;
    } else {
        //! Message Loggin
        comment_message_log('Query Execution failed. ::: ' . $sQuery . ' ::: ' . @mysqli_error($rConnection));
        comment_message_log('End of Function : ' . __FUNCTION__);
        return E00100;
    }
}

function aGetUserbyPass($user, $pass)
{
    //! Message Loggin
    comment_message_log('Start of Function : ' . __FUNCTION__);
    //! Data base connection
    $rConnection = dbConnection();
    /*!
     * Check if the database Connection is failed
     */
    if (!$rConnection) {
        //! Message Loggin
        comment_message_log('End of Function : ' . __FUNCTION__);
        return E00010;
    }
    //! Query
    $sQuery = "SELECT * FROM `admin` where `email` = '{$user}' AND `password` = '{$pass}';";
    //! Executing the query
    $rResultSet = mysqli_query($rConnection, $sQuery);
    //! Closing the connections
    dbConnectionClose($rConnection);
    /*!
     *  Check If the Query executed properly
     */
    if ($rResultSet != '') {
        //! Message Login
        comment_message_log('Query Executed Successfully. ::: ' . $sQuery);
        $aData = array();
        //! retrieve the result from the result set
        while ($aRow = mysqli_fetch_assoc($rResultSet)) {
            $aData = $aRow;
        }
        comment_message_log('End of Function : ' . __FUNCTION__);
        return $aData;
    } else {
        //! Message Loggin
        comment_message_log('Query Execution failed. ::: ' . $sQuery . ' ::: ' . @mysqli_error($rConnection));
        comment_message_log('End of Function : ' . __FUNCTION__);
        return E00100;
    }
}

function insertintoservicesused($user_id, $service_id, $single_id, $freeserivce_id, $created_at)
{
    //! Message Loggin
    comment_message_log('Start of Function : ' . __FUNCTION__);
    //! Data base connection
    $rConnection = dbConnection();
    /*!
     * Check if the database Connection is failed
     */
    if (!$rConnection) {
        //! Message Loggin
        comment_message_log('End of Function : ' . __FUNCTION__);
        return E00010;
    }
    //! Query
    $sQuery = "INSERT INTO `services_used` (`id`,`user_id`,`service_id`, `singleent_id`,`freeservice_id` `timeStamp`) VALUES (NULL, '{$user_id}','{$service_id}','{$single_id}','{$freeservice_id}' ,'{$created_at}');";
    //! Executing the query
    $res = mysqli_query($rConnection, $sQuery);
    /*!
     * Check If the Query executed properly
     */
    if ($res) {
        $user_id = mysqli_insert_id($rConnection);
        //! Closing the connections
        dbConnectionClose($rConnection);
        return $user_id;
        //! Message Login
        comment_message_log('Query Executed Successfully.::: owner_id = $owner_id ::: ' . $sQuery);
        comment_message_log('End of Function : ' . __FUNCTION__);
    } else {
        comment_message_log('Query Execution failed. ::: ' . $sQuery . ' ::: ' . @mysqli_error($rConnection));
        comment_message_log('End of Function : ' . __FUNCTION__);
        //! Closing the connections
        dbConnectionClose($rConnection);
        return E00100;
    }
}

function insertintoownerapp($owner_name, $owner_email, $service_mobile_num, $password, $created_at, $isActive, $type)
{
    //! Message Loggin
    comment_message_log('Start of Function : ' . __FUNCTION__);
    //! Data base connection
    $rConnection = dbConnection();
    /*!
     * Check if the database Connection is failed
     */
    if (!$rConnection) {
        //! Message Loggin
        comment_message_log('End of Function : ' . __FUNCTION__);
        return E00010;
    }
    //! Query
    $sQuery = "INSERT INTO `ownerapp` (`owner_id`,`owner_name`, `owner_email`, `service_mobile_number`, `password`, `timeStamp`,`isActive`,`type`) VALUES (NULL, '{$owner_name}','{$owner_email}','{$service_mobile_num}','{$password}','{$created_at}','{$isActive}','{$type}');";
    //! Executing the query
    $res = mysqli_query($rConnection, $sQuery);
    /*!
     * Check If the Query executed properly
     */
    if ($res) {
        $owner_id = mysqli_insert_id($rConnection);
        //! Closing the connections
        dbConnectionClose($rConnection);
        //! Message Login
        comment_message_log('Query Executed Successfully.::: owner_id = $owner_id ::: ' . $sQuery);
        comment_message_log('End of Function : ' . __FUNCTION__);
        return $owner_id;
    } else {
        comment_message_log('Query Execution failed. ::: ' . $sQuery . ' ::: ' . @mysqli_error($rConnection));
        comment_message_log('End of Function : ' . __FUNCTION__);
        //! Closing the connections
        dbConnectionClose($rConnection);
        return E00100;
    }
}

function insertintofreeservicedb($owner_id, $branch_id, $frees_name, $free_description, $counter, $created_at, $validity)
{
    //! Message Loggin
    comment_message_log('Start of Function : ' . __FUNCTION__);
    //! Data base connection
    $rConnection = dbConnection();
    /*!
     * Check if the database Connection is failed
     */
    if (!$rConnection) {
        //! Message Loggin
        comment_message_log('End of Function : ' . __FUNCTION__);
        return E00010;
    }
    //! Query
    $sQuery = "INSERT INTO `freeservicedb` (`id`,`owner_id`, `branch_id`,`free_name` ,`free_description`,`counter`,`timestamp`,`validity`) VALUES (NULL, '{$owner_id}', '{$branch_id}','{$free_name}','{$free_description}','{$counter}', '{$created_at}','{$validity}');";
    //! Executing the query
    $res = mysqli_query($rConnection, $sQuery);
    /*!
     * Check If the Query executed properly
     */
    if ($res) {
        $id = mysqli_insert_id($rConnection);
        //! Closing the connections
        dbConnectionClose($rConnection);
        return $id;
        //! Message Login
        comment_message_log('Query Executed Successfully.::: owner_id = $owner_id ::: ' . $sQuery);
        comment_message_log('End of Function : ' . __FUNCTION__);
    } else {
        comment_message_log('Query Execution failed. ::: ' . $sQuery . ' ::: ' . @mysqli_error($rConnection));
        comment_message_log('End of Function : ' . __FUNCTION__);
        //! Closing the connections
        dbConnectionClose($rConnection);
        return E00100;
    }
}

function insertintosingleent($owner_id, $category_id, $ent_name, $ent_details, $ent_website, $isActive, $listingType, $ProvidesFreeSrvc, $premiumStartDate, $premiumEndDate, $amount_paid, $created_at)
{
    //! Message Loggin
    comment_message_log('Start of Function : ' . __FUNCTION__);
    //! Data base connection
    $rConnection = dbConnection();
    /*!
     * Check if the database Connection is failed
     */
    if (!$rConnection) {
        //! Message Loggin
        comment_message_log('End of Function : ' . __FUNCTION__);
        return E00010;
    }
    //! Query
    $sQuery = "INSERT INTO `servicebranch` (`ent_id`,`owner_id`,`category_id`,`ent_name`,`ent_details`,`ent_website`,`isActive` ,`listingType` ,`ProvidesFreeSrvc` ,`premiumStartDate` ,`premiumEndDate`,`amt_paid`,`timeStamp`) VALUES (NULL, '{$owner_id}', '{$category_id}','{$ent_name} ','{$ent_details}','{$ent_website}','{$isActive}' ,'{$listingType}' ,'{$ProvidesFreeSrvc}' ,'{$premiumStartDate}' ,'{$premiumEndDate}','{$amount_paid} ','{$created_at}');";
    //! Executing the query
    $res = mysqli_query($rConnection, $sQuery);
    /*!
     * Check If the Query executed properly
     */
    if ($res) {
        $ent_id = mysqli_insert_id($rConnection);
        //! Closing the connections
        dbConnectionClose($rConnection);
        return $ent_id;
        //! Message Login
        comment_message_log('Query Executed Successfully.::: owner_id = $owner_id ::: ' . $sQuery);
        comment_message_log('End of Function : ' . __FUNCTION__);
    } else {
        comment_message_log('Query Execution failed. ::: ' . $sQuery . ' ::: ' . @mysqli_error($rConnection));
        comment_message_log('End of Function : ' . __FUNCTION__);
        //! Closing the connections
        dbConnectionClose($rConnection);
        return E00100;
    }
}