Docs For Class mysqlAES

[line 59]
mysqlAES 패키지는 MySQL의 AES_EMCRYPT, AES_DECRYPT, HEX, UNHEX 함수를 php에서 호환되게 사용할 수 있도록 하는 기능을 제공한다.

encrypt method와 decrypt method의 경우, key 길이가 128bit(16byte)이면 MySQL과 MariaDB의 AES_ENCRYPT/AES_DECRYPT 함수와 완벽하게 호환이 된다.

key 길이가 192또는 256bit일 경우에는 oops에서 제공하는 lib_mysqludf_aes256 UDF에서 제공하는 AES256_ENCRYPT, AES256_DECRYPT와 완변하게 호환이 된다.

예제:

<?php
require_once 'mysqlAES.php';
use oops\Encrypt\mysqlAES as myAES;
$cipher = '123123 궁중 떡뽁이';
$keys = array (
'128' => '0123456789012345',
'192' => '012345678901234567890123',
'256' => '01234567890123456789012345678901'
);
try {
printf ('Original Data : %s' . PHP_EOL, $cipher);
printf ("Expected Data :\n");
printf (" 128bit : E788F1C5FB172B546DA83BAE78D2E07863263129FA8539C443B35512CF8447E4\n");
printf (" 192bit : 08DBCABD2875EAC628630EF2033CABBE72C8E13D7197B9EE8F6845336A9C0806\n");
printf (" 256bit : DAE591EE85369CBFF489FBB2E791934ACD14329CC94D756D3A26B119AC7C9DC5\n");
foreach ( $keys as $key => $enckey) {
echo "------------------------------------------------------------------------------------\n";
$enc = myAES::hex (myAES::encrypt ($cipher, $enckey));
printf ('%d bit encryption: %s' . PHP_EOL, $key, $enc);
printf ('%d bit key length: %d' . PHP_EOL, $key, strlen ($enckey));
printf ('%d bit hex length: %d' . PHP_EOL, $key, strlen ($enc));
$dec = myAES::decrypt (myAES::unhex ($enc), $enckey);
printf ('%d bit revoke : %s' . PHP_EOL, $key, $dec);
}
} catch ( Exception $e ) {
fprintf (STDERR, "%s\n", $e->getMessage ());
print_r ($e->getTrace ()) . "\n";
}
?>

static method decrypt [line 212]

static string decrypt(
string
?$cipher, string
?$key)

Decrypt using AES

This method is compatible AES_DECRYPT function of mysql, if key is 128 bit And then, If key is 192 or 256 bit, this method is compatible follow APIS:

Example:

<?php
require_once 'mysqlAES.php';
use oops\Encrypt\mysqlAES as myAES;
$cipher = '123123 궁중 떡뽁이';
$keys = array (
'128' => '0123456789012345',
'192' => '012345678901234567890123',
'256' => '01234567890123456789012345678901'
);
try {
printf ('Original Data : %s' . PHP_EOL, $cipher);
printf ("Expected Data :\n");
printf (" 128bit : E788F1C5FB172B546DA83BAE78D2E07863263129FA8539C443B35512CF8447E4\n");
printf (" 192bit : 08DBCABD2875EAC628630EF2033CABBE72C8E13D7197B9EE8F6845336A9C0806\n");
printf (" 256bit : DAE591EE85369CBFF489FBB2E791934ACD14329CC94D756D3A26B119AC7C9DC5\n");
foreach ( $keys as $key => $enckey) {
echo "------------------------------------------------------------------------------------\n";
$enc = myAES::hex (myAES::encrypt ($cipher, $enckey));
printf ('%d bit encryption: %s' . PHP_EOL, $key, $enc);
printf ('%d bit key length: %d' . PHP_EOL, $key, strlen ($enckey));
printf ('%d bit hex length: %d' . PHP_EOL, $key, strlen ($enc));
$dec = myAES::decrypt (myAES::unhex ($enc), $enckey);
printf ('%d bit revoke : %s' . PHP_EOL, $key, $dec);
}
} catch ( Exception $e ) {
fprintf (STDERR, "%s\n", $e->getMessage ());
print_r ($e->getTrace ()) . "\n";
}
?>

Tags:

return:	decrypted data by AES. If $cipyer or $key has empty value, return null.
access:	public

Parameters:

string	?$cipher	cipher data for being decryption
string	?$key	decryption key 128bit : 16 byte string 192bit : 24 byte string 256bit : 32 byte string

[ Top ]

static method encrypt [line 160]

static string encrypt(
string
?$cipher, string
?$key)

Encrypt using AES

This method is compatible AES_ENCRYPT function of mysql, if key is 128 bit. And then, If key is 192 or 256 bit, this method is compatible follow APIS:

Example:

<?php
require_once 'mysqlAES.php';
use oops\Encrypt\mysqlAES as myAES;
$cipher = '123123 궁중 떡뽁이';
$keys = array (
'128' => '0123456789012345',
'192' => '012345678901234567890123',
'256' => '01234567890123456789012345678901'
);
try {
printf ('Original Data : %s' . PHP_EOL, $cipher);
printf ("Expected Data :\n");
printf (" 128bit : E788F1C5FB172B546DA83BAE78D2E07863263129FA8539C443B35512CF8447E4\n");
printf (" 192bit : 08DBCABD2875EAC628630EF2033CABBE72C8E13D7197B9EE8F6845336A9C0806\n");
printf (" 256bit : DAE591EE85369CBFF489FBB2E791934ACD14329CC94D756D3A26B119AC7C9DC5\n");
foreach ( $keys as $key => $enckey) {
echo "------------------------------------------------------------------------------------\n";
$enc = myAES::hex (myAES::encrypt ($cipher, $enckey));
printf ('%d bit encryption: %s' . PHP_EOL, $key, $enc);
printf ('%d bit key length: %d' . PHP_EOL, $key, strlen ($enckey));
printf ('%d bit hex length: %d' . PHP_EOL, $key, strlen ($enc));
$dec = myAES::decrypt (myAES::unhex ($enc), $enckey);
printf ('%d bit revoke : %s' . PHP_EOL, $key, $dec);
}
} catch ( Exception $e ) {
fprintf (STDERR, "%s\n", $e->getMessage ());
print_r ($e->getTrace ()) . "\n";
}
?>

Tags:

return:	encrypted data by AES. If $cipyer or $key has empty value, return null
access:	public

Parameters:

string	?$cipher	The plaintext message data to be encrypted.
string	?$key	encryption key 128bit : 16 byte string 192bit : 24 byte string 256bit : 32 byte string

[ Top ]

static method hex [line 89]

static string hex(
string
?$v)

Return a hexadecimal representation of a decimal or string value

This method is compatible HEX function of mysql

Example:

$enc = myAES::hex (myAES::encrypt ($cipher, $enckey));

Tags:

return:	hexadecimal data. If given parameter $v is empty, return null.
access:	public

Parameters:

string

?$v

original data

[ Top ]

static method unhex [line 111]

static string unhex(
string
?$v)

Return a string containing hex representation of a number

This method is compatible UNHEX function of mysql

Example:

$dec = myAES::decrypt (myAES::unhex ($enc), $enckey);

Tags:

return:	Returns an ASCII string containing the hexadecimal representation. If given parameter $v is empty, return null.
access:	public

Parameters:

string

?$v

hexadecimal data

[ Top ]

constructor __construct [line 73]

mysqlAES __construct(
)

oops\Encrypt\mysqlAES 초기화

Tags:

access:

public

[ Top ]

Class: mysqlAES

Class Overview

Constants

Methods

Class Details

Class Methods

static method decrypt [line 212]

Tags:

Parameters:

static method encrypt [line 160]

Tags:

Parameters:

static method hex [line 89]

Tags:

Parameters:

static method unhex [line 111]

Tags:

Parameters:

constructor __construct [line 73]

Tags:

Class Constants

AES_BLOCK_SIZE = 16