Sunset Rainbow's SQL Encoder protects your data before it reaches the database (DB). SQL Encoder uses a combination of high grade encryption and obfuscation. You can encode table names, field names, and data fields. Thieves will be unable to find your protected data in DB backup files, network traffic, server logs, etc.

SQL Encoder supports MySQL but comes with an API that will work with a wide variety of other databases.

The Encoder uses multiple encryption and obfuscation keys. It is capable of encoding these kinds of data:

Regual version - refer to the page you downloaded the product from.

If ionCube loader is not installed and you have followed the setup instructions included with your copy of the software, please refer to ioncube.com.

ionCube is a registered trademark of ionCube Ltd (ioncube.com)

// PHP 5 EXAMPLE ----------------------------------------------------------
require_once('sunsetrlib/sqlencoder/sqlencoder5.php');

/* Example of using the class object */
$sobj = new sqlencoder();
$data = $sobj->encode('Some secret information');
echo 'Decoded info is: '.$sobj->decode($data);

/* Connecting to the database here...  */

/* Example of Creating a table with encoded name and encoded field names */
$sql='CREATE TABLE `SRKEY(testsql)` (
`SRKEY(fielda)` INT UNSIGNED NOT NULL , `SRKEY(fieldb)` VARCHAR( 30 ) NOT NULL ,
PRIMARY KEY ( `SRKEY(fielda)` )  ) ENGINE = MYISAM ';
$result = $sobj->sql_query($sql);

/* Using sql query statement to encrypt/decrypt with SQL Encoder
   Be sure to read security note regarding sr_addslashes !
 */
$sql='INSERT INTO SRKEY(testsql) (SRKEY(fieldb)) VALUES ('SRENCODE(abcd)')';
$result = $sobj->sql_query($sql);

/* Retrieve from DB - decoding is automatic */
$sql='SELECT * from SRKEY(testsql)';
if (($result = $sobj->sql_query($sql)))
	if (($row = $sobj->sql_fetch_array($result, MYSQL_ASSOC)))
	{
		$plain_data=$row['fieldb'];   // plain_data is now 'abcd'
	}

/* Example of using SQL Encoder API directly to do all the work */
$sql='SELECT * from '.$sobj->fieldname_decode('testsql');
if (($result = mysql_query($sql)))
	if (($row = mysql_fetch_array($result, MYSQL_ASSOC)))
	{
		$plain_data = $sobj->decode($row[$sobj->fieldname('fieldb')])
	}

// -------------------------------------------------------------------------
// PHP 4 EXAMPLE ----------------------------------------------------------

require_once('sunsetrlib/sqlencoder/sqlencoder.php');

$sql='INSERT INTO SRKEY(testsql) (SRKEY(fieldb)) VALUES ('SRENCODE(abcd)')';
$result = sr_sql_query($sql);

/* Retrieve from DB - decoding is automatic */
$sql='SELECT * from SRKEY(testsql)';
if (($result = sr_sql_query($sql)))
	if (($row = sr_sql_fetch_array($result, MYSQL_ASSOC)))
	{
		$plain_data=$row['fieldb'];   // plain_data is now 'abcd'
	}

sqlencoder -- Class Object

All API functions can be accessed either as functions or as class methods via the sqlencoder class. To use class methods: remove the 'sr_' portion of the name from the API functions.

For example 'sr_decode' is an API function.
'decode' is the sqlencoder class method.

Example usage:

/* CLASS OBJECT USAGE */
require_once('sunsetrlib/sqlencoder/sqlencoder5.php');
$sobj = new sqlencoder();
$data = $sobj->encode('Some secret information');
echo 'Decoded info is: '.$sobj->decode($data);

----------- different script ----

/* NON-CLASS USAGE */
require_once('sunsetrlib/sqlencoder/sqlencoder.php');
$data = sr_encode('Some secret information');
echo 'Decoded info is: '.sr_decode($data);