[PHP-DB] Re: Cannot connect to a MySQL DB using a Class

2006-01-05 Thread Neil Smith [MVP, Digital media]
At 00:46 05/01/2006, you wrote: Message-ID: [EMAIL PROTECTED] To: php-db@lists.php.net Date: Wed, 04 Jan 2006 16:45:54 -0800 From: Todd Cary [EMAIL PROTECTED] MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Subject: CAnnot connect to

[PHP-DB] Re: Cannot connect to a MySQL DB using a Class

2006-01-05 Thread Todd Cary
Neil - Thank you for noticing my typo. The actual PHP code has both choices with one commented out. When I constructed the message for the forum I selected the wrong one - not the one I actually am using. Todd Neil Smith [MVP, Digital media] wrote: At 00:46 05/01/2006, you wrote:

[PHP-DB] Page Caching after DB Query

2006-01-05 Thread dpgirago
How can I force the browser to re-display the last dynamically created page when using the back button, for example, rather than re-issuing the query. Are there any complications because we are using the https protocol on Apache? David -- PHP Database Mailing List (http://www.php.net/) To

Re: [PHP-DB] Page Caching after DB Query

2006-01-05 Thread dpgirago
/* for the archives */ Ah, it's in the manual, isn't it? I was calling session_start() on the page, so the session.cache_limiter value of 'nocache' in php.ini was overriding all attempts to cache the page. Calling session_cache_limiter('private') before session_start() did the trick. David

[PHP-DB] var_dump and sizeof database entry?

2006-01-05 Thread Jordan Miller
Hello, This is stumping me something awful. I have searched the archive of this mailing list and google and the php and mysql websites with everything i can think of. I have a simple mysql table with some basic columns and a blob column that holds an image file. What I need to get is the

[PHP-DB] Re: mysql_fix_privilege_tables error

2006-01-05 Thread Doug Lipman
In article [EMAIL PROTECTED], [EMAIL PROTECTED] (Carson Au) wrote: Hi Guys, I am a newbie and having a lot of trouble with PHP/MySQL lately... We have a number of PHP/MYSQL solutions developed on our server and I have the pleasure to maintain them... The copy of MySQL 3.23 has started

RE: [PHP-DB] var_dump and sizeof database entry?

2006-01-05 Thread Bastien Koert
I would do one of two things here: 1. add a size column to the db and have the image size added when inserting the image 2. run a trash script (either sql if your version support subselects or a little page) to get the size of the image and enter it into the size field Another

Re: [PHP-DB] var_dump and sizeof database entry?

2006-01-05 Thread Jordan Miller
whoa, that was EXACTLY what I needed. Thanks!! Jordan On Jan 5, 2006, at 6:14 PM, Bastien Koert wrote: select *, (length(image_fiedl)/1024) as Kb from table [where clause] to get the size Bastien -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] Storing Credit Cards, Passwords, Securely, two-way encryption

2006-01-05 Thread Peter Beckman
So I'm thinking about how to save credit card numbers in the DB, for re-charging cards for subscriptions, new orders, etc. I'm also thinking about how to save passwords in the DB, not plaintext, but not one-way encrypted either. Any suggestions? How would I secure the database? I'm thinking

RE: [PHP-DB] Storing Credit Cards, Passwords, Securely, two-way encryption

2006-01-05 Thread Bastien Koert
CC saving is a bad idea on a web facing server...much better to let the user re-input the data each time. If your network allows it, store the data encrypted (using php's mcrypt/decrypt extension) on an separate extremely limited access, non-webfacing (ie internal) db/server that only allows

Re: [PHP-DB] Storing Credit Cards, Passwords, Securely, two-way encryption

2006-01-05 Thread John Meyer
Peter Beckman wrote: So I'm thinking about how to save credit card numbers in the DB, for re-charging cards for subscriptions, new orders, etc. Why, is the first question I would ask you. First off, on a new order, why wouldn't you just save the authorization code, instead of the credit

Re: [PHP-DB] Storing Credit Cards, Passwords, Securely, two-way encryption

2006-01-05 Thread Peter Beckman
On Thu, 5 Jan 2006, John Meyer wrote: Peter Beckman wrote: So I'm thinking about how to save credit card numbers in the DB, for re-charging cards for subscriptions, new orders, etc. Why, is the first question I would ask you. So I'm thinking about how to save credit card numbers in the

Re: [PHP-DB] Storing Credit Cards, Passwords, Securely, two-way encryption

2006-01-05 Thread Peter Beckman
On Fri, 6 Jan 2006, Julien Bonastre wrote: Any reason why you need to have reversible encryption on the password value?? No... I just prefer to assume that if someone gets my DB, they might try using user/pass pairs on banking sites, or paypal, or other ways, and if I can reversible

Re: [PHP-DB] Storing Credit Cards, Passwords, Securely, two-wayencryption

2006-01-05 Thread Bastien Koert
From: Peter Beckman [EMAIL PROTECTED] To: Julien Bonastre [EMAIL PROTECTED] CC: php-db@lists.php.net Subject: Re: [PHP-DB] Storing Credit Cards, Passwords, Securely, two-wayencryption Date: Thu, 5 Jan 2006 22:53:30 -0500 (EST) On Fri, 6 Jan 2006, Julien Bonastre wrote: Any reason why you

Re: [PHP-DB] Storing Credit Cards, Passwords, Securely, two-way encryption

2006-01-05 Thread Julien Bonastre
On Fri, 6 Jan 2006, Julien Bonastre wrote: Any reason why you need to have reversible encryption on the password value?? No... I just prefer to assume that if someone gets my DB, they might try using user/pass pairs on banking sites, or paypal, or other ways, and if I can reversible