How to hide URL's in MYSQL but readable with curl and PHP? E.g. Obfucation or anything to hide those URL's.
+1
A:
You'll have to make difference between two terms:
- Encoding
- Encryption
Encoding is the process of converting data with purposes as: transmitting, smaller size, standards and so on. Encryption is the process of making your information only understandable for the receiver.
For those goals you can use either PHP functionality or build-in MySQL functions. Prefer MySQL if you're sure you'll stick with MySQL. You'd better prefer PHP if you want your application be more database-independent.
For PHP have a look here: http://php.net/manual/en/book.mcrypt.php
For MySQL functions have a look here: http://dev.mysql.com/doc/refman/5.1/en/encryption-functions.html