Re: [PHP-DB] Data split: web local machine
There was a thread a while ago about credit cards Storing Credit Cards, Passwords, Securely, two-way encryption http://beeblex.com/lists/index.php/php.db/40981?s=l:php.db The part that really gives me the willys is: The procedure I initially thought of, was generating a file on the web side, emailing it to the client, then merging it with the cc_file to ¿emailing a file with cc numbers? I would never use a service if I knew that my cc number would go in an excel file via email, but thats just me. Check the thread for some sobering remarks about cc security. Martin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Data split: web local machine
I have to generate a comma-separated(CSV) file of amounts and credit card numbers for secure transmittal to the bank. The CSV file is read by a bank-endorsed program, encrypted and transmitted. Most of the billing information: amount, period date, name, billing number is stored on the web server. The billing number and credit card type and credit card number are stored locally, call it the cc_file. The local storage format has not been decided on, the client is leaning towards Excel, but is well aware of how easily data can be damaged or destroyed in a spreadsheet. The procedure I initially thought of, was generating a file on the web side, emailing it to the client, then merging it with the cc_file to generate the payment file for the bank. I foresee a very messy, and fragile, macro in Excel to generate the merge. Now I'm thinking more along the lines of having a local MySQL database. The web side file will be created using SELECT fields INTO OUTFILE filename, and that would be mailed to the client. That file would be imported into the local MySQL database. A script / function would then generate the payment file. This local app I would write in PHP, using the PHP-GTK toolkit. The other possibility would be to access the web database from the local app, fetch the data directly and generate the file. That would involve having two databases open at the same time, but should be ok - $db_local and $db_remote. Opinions and suggestions will be welcomed. Regards - Miles Thompson -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.1.375 / Virus Database: 267.15.11/264 - Release Date: 2/17/2006 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Data split: web local machine
do the last one, but have another empty db on the machine that only accepts the data from the web serverprotect and hide the cc data as long as possible...then run a query behind the firewall to merge the data and send it bastien From: Miles Thompson [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Data split: web local machine Date: Mon, 20 Feb 2006 16:04:20 -0400 I have to generate a comma-separated(CSV) file of amounts and credit card numbers for secure transmittal to the bank. The CSV file is read by a bank-endorsed program, encrypted and transmitted. Most of the billing information: amount, period date, name, billing number is stored on the web server. The billing number and credit card type and credit card number are stored locally, call it the cc_file. The local storage format has not been decided on, the client is leaning towards Excel, but is well aware of how easily data can be damaged or destroyed in a spreadsheet. The procedure I initially thought of, was generating a file on the web side, emailing it to the client, then merging it with the cc_file to generate the payment file for the bank. I foresee a very messy, and fragile, macro in Excel to generate the merge. Now I'm thinking more along the lines of having a local MySQL database. The web side file will be created using SELECT fields INTO OUTFILE filename, and that would be mailed to the client. That file would be imported into the local MySQL database. A script / function would then generate the payment file. This local app I would write in PHP, using the PHP-GTK toolkit. The other possibility would be to access the web database from the local app, fetch the data directly and generate the file. That would involve having two databases open at the same time, but should be ok - $db_local and $db_remote. Opinions and suggestions will be welcomed. Regards - Miles Thompson -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.1.375 / Virus Database: 267.15.11/264 - Release Date: 2/17/2006 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
