encrypting data

Believe it or not, I RTFM but could not find this info which I'm sure is well known to many of you.

For obvious security reasons, I want to encrypt credit card data when entering it into a mysql table using PHP.

I also want to be able to view the credit card info so it is usable.

Any pointers?

Thanks
Bill

the mysql function encode() should work fine.

insert into table set ccNum = encode('$ccNum', '$encodeKey')

The encodeKey variable (of course) being your encoding/decoding key. To decode, it would be the same, just decode()

select decode(ccNum, '$encodeKey') as ccNum from table

Hope this helps.

-Travis

Thank you. I'll try it out!