From: Daniel Struck <struck.d@retrovirology.lu>
To: pgsql-php@postgresql.org
Subject: pgcrypto & php
Date: Mon, 12 Jan 2004 11:34:21 +0100
Message-ID: <20040112113421.02427893.struck.d@retrovirology.lu> (raw)
Hello,
I am storing certain data encrypted by pgcrypto in my database.
Here are the commands I use to test the functionality:
CREATE TABLE crypto (
id SERIAL PRIMARY KEY,
title VARCHAR(50),
crypted_content BYTEA
);
INSERT INTO crypto VALUES (1,'test1',encrypt('daniel', 'fooz', 'aes'));
INSERT INTO crypto VALUES (2,'test2',encrypt('struck', 'fooz', 'aes'));
INSERT INTO crypto VALUES (3,'test3',encrypt('konz', 'fooz', 'aes'));
SELECT * FROM crypto;
SELECT *,decrypt(crypted_content, 'fooz', 'aes') FROM crypto;
SELECT *,decrypt(crypted_content, 'fooz', 'aes') FROM crypto WHERE decrypt(crypted_content, 'fooz', 'aes')='struck';
There are certain occasions where I would like to be able to decrypt/ encrypt the data in PHP itself. Is this possible with the "Mcrypt Encryption Functions" of PHP?
I have already tried it, by as I am no expert in cryptography, I have difficulties finding the right syntax.
This is the code I used to try it out:
$test=new db_sql_user;
$test->query("select crypted_content from crypto WHERE id=1;");
$crypt=$test->result();
echo "<br />";
echo "crypted content from postgresql: " .$crypt;
$array = unpack("c2chars/nint", $crypt);
echo $array;
echo "<br />";
echo mcrypt_decrypt ( MCRYPT_RIJNDAEL_128 , "fooz", $crypt, cbc);
echo "<br />";
echo mcrypt_cbc (MCRYPT_RIJNDAEL_128, "fooz", $crypt , MCRYPT_DECRYPT);
This is the output:
crypted content from postgresql: g°ñ\220399ùû¹qyg®Û~Array
5*X]Nl\x{2022}u
5*X]Nl\x{2022}u
Best regards,
Daniel Struck
--
Retrovirology Laboratory Luxembourg
Centre Hospitalier de Luxembourg
4, rue E. Barblé
L-1210 Luxembourg
phone: +352-44116105
fax: +352-44116113
web: http://www.retrovirology.lu
e-mail: struck.d@retrovirology.lu
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: struck.d@retrovirology.lu
Subject: Re: pgcrypto & php
In-Reply-To: <20040112113421.02427893.struck.d@retrovirology.lu>
References: <20040112113421.02427893.struck.d@retrovirology.lu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox