I need to encrypt the data in a mysql database so that:
1. PHP encrypts it
2. PHp decrypts it
3. Delphi on windows encrypts it
4. Delphi on windows decrypts it
and I need the two to be able to work together and understand the data!
I think this may be difficult (understatement?) can anyone help me?
The reason for this is that we want to bring the data from mysql from an internet server to a local client machine, work on it, and then load it back up. To do that we currently use Zeos components in Delphi which effectively connect to the mysql server and do some SQL to bring the data down.
We cannot afford financially to use SSH or VPN, since this requires a dedicated server. SSL doesn't work because we're not on html pages.
1. PHP encrypts it
2. PHp decrypts it
3. Delphi on windows encrypts it
4. Delphi on windows decrypts it
and I need the two to be able to work together and understand the data!
I think this may be difficult (understatement?) can anyone help me?
The reason for this is that we want to bring the data from mysql from an internet server to a local client machine, work on it, and then load it back up. To do that we currently use Zeos components in Delphi which effectively connect to the mysql server and do some SQL to bring the data down.
We cannot afford financially to use SSH or VPN, since this requires a dedicated server. SSL doesn't work because we're not on html pages.