Do you really need to use stripslashes when retrieving the data?
Wouldnt stripslashes only affect magic quotes or already added slashes,
I mean when you addslashes to the SQL the slashes are indeed removed
when inserted in the table.

--
--
Kim Steinhaug
----------------------------------------------------------------------
There are 10 types of people when it comes to binary numbers:
those who understand them, and those who don't.
----------------------------------------------------------------------
www.steinhaug.com - www.easywebshop.no - www.webkitpro.com
----------------------------------------------------------------------

"Justin Patrin" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Jay Blanchard wrote:
>
> > Good morning gurus!
> >
> > I am encrypting some data on one server and now I am attempting to
decrypt on another server using mcrypt_encrypt and mycrypt_decrypt (using
same key and initialzation vector). It is almost working but I seem to still
have a little problem, that data is missing the last character which still
seems to be encrypted. I am putting the data in the database with
addslashes, and retrieving with stripslashes, but I get things like this;
> >
> > 45221141¤Þ,]¹9Ñ
> > 77777775ÿåZ|z
> >
> > while($arrEncInfo = mysql_fetch_array($dbGetSub)){
> > $stripDataA = stripslashes($arrEncInfo['dataA']);
> > $stripIV = stripslashes($arrEncInfo['iv']);
> > $dataA = mcrypt_decrypt($encAlg, $encKey, $stripDataA, $encMode,
$stripIV);
> > echo $dataA . "\n";
> > }
> >
> > Has anyone seen this? Could there be a difference between the PHP
installs? Both are version 4.3.7.
> >
> > Thanks!
> >
> > Jay
>
> You should probably use mysql_escape_string or mysql_real_escape_string
> instead of addslashes and stripslashes. IMHO addslashes and stripslashes
> are pretty much useless.
>
> --
> paperCrane <Justin Patrin>

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to