lepton_secure_database.php File Reference

Go to the source code of this file.

Functions
	cryptString (string $sSource="")
	decryptString (string $sSource)
	setOpenSSLMethod (string $sMethodName)
	setOpenSSLIv (string $sNewIV)
	secure_get_one (string $SQL)
	secure_execute_query (string $aQuery="", bool $bFetch=false, array &$aStorage=array(), bool $bFetchAll=true, array $aListOfFields=array())
	secure_build_and_execute (string $type, string $table_name, array $table_values=[], string $condition="", array $aListOfFields=[], string $key="")

Variables
trait	LEPTON_secure_database

Function Documentation

cryptString()

cryptString ( string  $sSource = "" )

protected

To encrypt any string.

Parameters

string

$sSource

Any string

Returns

string The encrypted string.

Examples

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

Definition at line 43 of file lepton_secure_database.php.

decryptString()

decryptString ( string  $sSource )

protected

To decrypt any string.

Parameters

string

$sSource

Any encrypted string.

Returns

string The decrypted string.

Examples

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

Definition at line 64 of file lepton_secure_database.php.

secure_build_and_execute()

secure_build_and_execute	(	string	$type,
		string	$table_name,
		array	$table_values = [],
		string	$condition = "",
		array	$aListOfFields = [],
		string	$key = ""
	)

Public function to build and execute a mySQL query direct. Use this function/method for update and insert values only. As for a simple select you can use "prepare_and_execute" above.

Parameters

string	$type	A "job"-type: this time only "update" and "insert" are supported.
string	$table_name	A valid tablename (incl. table-prefix).
array	$table_values	An array within the table-field-names and values. Pass by reference!
string	$condition	An optional condition for "update" - this time a simple string.
array	$aListOfFields	A linear array with the fieldnames to crypt.
string	$key	An optional "no update" key field to be excluded on update while "insert_on_duplicate_key_update" - a simple string containing 1 key field.

Returns

int False if fails, otherwise true.

Examples

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

Definition at line 247 of file lepton_secure_database.php.

secure_execute_query()

secure_execute_query	(	string	$aQuery = "",
		bool	$bFetch = false,
		array &	$aStorage = array(),
		bool	$bFetchAll = true,
		array	$aListOfFields = array()
	)

Examples

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

Definition at line 180 of file lepton_secure_database.php.

secure_get_one()

secure_get_one

(

string

$SQL

)

---

[2] New class methods Execute a SQL query and return the first row of the result array

Parameters

string

$SQL

Any SQL-Query or statement

Returns

string|null Value of the table-field or NULL for error

Examples

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

Definition at line 148 of file lepton_secure_database.php.

setOpenSSLIv()

setOpenSSLIv

(

string

$sNewIV

)

Set the iv

Parameters

string

$sNewIV

A valid iv (16 bytes!)

Returns

void

Examples

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

Definition at line 99 of file lepton_secure_database.php.

setOpenSSLMethod()

setOpenSSLMethod

(

string

$sMethodName

)

---

[1] Interface functions Set the method

Parameters

string

$sMethodName

A valid Method.

Returns

void

Examples

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

Definition at line 89 of file lepton_secure_database.php.

Variable Documentation

LEPTON_secure_database

trait LEPTON_secure_database

Initial value:

{
    
    static private  string $db_key = ""

This file is part of LEPTON Core, released under the GNU GPL Please see LICENSE and COPYING files in your package for details, specially for terms and warranties.

NOTICE:LEPTON CMS Package has several different licenses. Please see the individual license in the header of each single file or info.php of modules and templates.

Author

LEPTON Project

Copyright

2010-2023 LEPTON Project https://gnu.org/licenses/gpl.html please see LICENSE and COPYING files in your package Extended methods for LEPTON_database

Definition at line 24 of file lepton_secure_database.php.