[SQL] pobierz, plaintext 
"SELECT AES_DECRYPT(credit_card,'asd') FROM users WHERE ID='1'
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT AES_DECRYPT(credit_card,'asd') AS credit FROM users WHERE ID='1'
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
AS credits
[SQL] pobierz, plaintext 

[PHP] pobierz, plaintext 
$zapytanie = mysql_query('twoje zapytanie');
while( $row = mysql_fetch_assoc($zapytanie) )
{
      echo $row['komorka_pobrana_z_tabeli'];
}
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
		$r=$dbc->query("SELECT AES_DECRYPT(IMIE,'asd') AS imie FROM users WHERE ID='1'");
		$row=$r->fetch_assoc();
                $imie=$row['IMIE'];
		echo"$imie<br>";
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
define('MY_KEY','Ralf_S_Engelschall__trainofthoughts');
 
// Group 1
$a = $this->User->aes_encrypt('test');
echo base64_encode($a).'';
 
$result = $this->User->query("SELECT AES_ENCRYPT('test', '".MY_KEY."') AS enc");
$b = $result[0][0]['enc'];
echo base64_encode($b).'';
 
// Group 2
$result = $this->User->query("SELECT AES_DECRYPT('".$a."', '".MY_KEY."') AS decc");
$c = $result[0][0]['decc'];
echo $c."
";
 
$d = $this->User->aes_decrypt($b);
echo $d."
";
 
// Comparison
var_dump($a===$b);
var_dump($c===$d);
[PHP] pobierz, plaintext