C:/Develope/SVN/upload/framework/classes/lepton_secure_database.php

Public "shortcut" for executing a single mySql-query without passing values.

Parameters

string	$aQuery	A valid mySQL query.
bool	$bFetch	Fetch the result - default is false.
array	$aStorage	A storage array for the fetched results. Pass by reference!
bool	$bFetchAll	Try to get all entries. Default is true.
array	$aListOfFields	A linear array with the fieldnames to de-crypt.

Returns

bool False if fails, otherwise true.

$results_array = array();
$this->db_handle->execute_query( "SELECT * from ".TABLE_PREFIX."pages WHERE page_id = ".$page_id." ", true, $results_array, false, array('modify_by') );

<?php
 
declare(strict_types=1);
 
trait LEPTON_secure_database
{
    
    static private string $db_key = "";
    
    static private string $default_openssl_method = "";
    
    static private string $default_openssl_iv = "";
    
    static private string $default_openssl_ivlen = "";
    
    static private int $default_openssl_options = 0;
    
    private bool $bOpenSslInstalled = false;
    
    protected function cryptString(string $sSource=""): string|bool
    {
        if( false === $this->bOpenSslInstalled )
        {
            return $sSource;
        }
        return openssl_encrypt(
            $sSource,
            self::$default_openssl_method,
            self::$db_key,
            self::$default_openssl_options,
            self::$default_openssl_iv
        );
    }
 
    protected function decryptString(string $sSource): string|bool
    {
        if ((false === $this->bOpenSslInstalled) || ("" === $sSource))
        {
            return $sSource;
        }
        
        return openssl_decrypt(
            $sSource,
            self::$default_openssl_method,
            self::$db_key,
            self::$default_openssl_options,
            self::$default_openssl_iv
        );
    }
 
    public function setOpenSSLMethod(string $sMethodName): void
    {
        self::$default_openssl_method = $sMethodName;
    }
 
    public function setOpenSSLIv(string $sNewIV): void
    {
        self::$default_openssl_iv = $sNewIV;
    }
 
    
    public function secure_get_one(string $SQL): string|null
    {
        $result = $this->get_one($SQL);
        return (is_null($result))
            ? NULL
            : $this->decryptString( (string)$result )
            ;
    }
 
    public function secure_execute_query(
        string $aQuery = "",
        bool $bFetch = false,
        array &$aStorage = array(),
        bool $bFetchAll = true,
        array $aListOfFields = array()
    ): bool
    {
        if (!is_array($aListOfFields))
        {
            LEPTON_tools::display("REQUIRED list of fieldnames must be an array!", "div", "ui message red");
            return false;
        }
        
        $result = $this->execute_query(
            $aQuery,
            $bFetch,
            $aStorage,
            $bFetchAll
        );
 
        if (false === $result)
        {
            LEPTON_tools::display($this->get_error(), "div", "ui message red");
            return false;
        }
 
        if (true === $bFetchAll)
        {
            foreach ($aStorage as &$ref)
            {
                foreach ($aListOfFields as $sFieldname)
                {
                    if (isset($ref[$sFieldname]))
                    {
                        $ref[$sFieldname] = $this->decryptString( (string)$ref[$sFieldname]);
                    }
                }
            }
        } else {
            foreach ($aListOfFields as $sFieldname)
            {
                if (isset($aStorage[$sFieldname]))
                {
                    $aStorage[$sFieldname] = $this->decryptString( (string)$aStorage[$sFieldname]);
                }
            }
        }
        
        return true;
    }
 
    public function secure_build_and_execute(
        string $type,
        string $table_name,
        array $table_values = [] ,
        string $condition = "",
        array $aListOfFields = [],
        bool $display_query = false
    ): int
    {
 
        if (!is_array($aListOfFields))
        {
            LEPTON_tools::display("REQUIRED list of fieldnames must be an array!", "div", "ui message red");
            return 0;
        }
 
        foreach ($aListOfFields as $sName)
        {
            if (isset($table_values[$sName]))
            {
                $table_values[ $sName ] = $this->cryptString( (string)$table_values[$sName]);
            }
        }
        
        return $this->build_and_execute(
            $type,
            $table_name,
            $table_values,
            $condition,
            $display_query
        ); 
    }
    
    public static function __callStatic($method, $args)
    {
        switch (strtolower($method))
        {
            case 'cryptstring':
                return self::$instance->cryptString((string)$args[0]);
                break;
                
            case 'decryptstring':
                return self::$instance->decryptString((string)$args[0]);
                break;
                
            default:
                echo LEPTON_tools::display("Static call to unknown method!", "pre", "ui message red");
                return NULL;
                break;
        }
    }   
}