Re: [PHP] Entering data into MySQL

[Jason Wong]

On Monday 25 February 2002 15:39, Tim Thorburn wrote:
 Hi,

 I'm having troubles entering information from a form into a MySQL
 database.  Specifically if the user enters an apostrophe anywhere in the
 form, all the information is rejected and nothing is entered into the
 database.

 After researching a little on php.net I found the addslashes() command -
 this did help briefly and I was able to use apostrophe's in the form ...
 but it seems as the problem has resurfaced.

 To make matters more frustrating, the addslashes() command works perfectly
 well on my local test machine (Win2k Pro, PHP 4.1.1, MySQL 3.23.44, Apache
 1.3.23) but not at all on the server which is hosted by another company
 (Sun Solaris, PHP 3.0.16, MySQL 3.22.32, Apache 1.3.12).

 Does anyone have any suggestions as to why the addslashes() command worked
 for a short time on the webserver and why it stopped?  Or better yet, is
 there a variation of addslashes() that will work on an older version of PHP
 such as 3.0.16?

It could be that the configuration of your local and remote servers are 
different. Specifically check out the setting magic_quotes_gpc. Run phpinfo() 
on both to find out their settings.

-- 
Jason Wong - Gremlins Associates - www.gremlins.com.hk

/*
grep me no patterns and I'll tell you no lines.
*/

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Entering data into MySQL

[Andrey Hristov]

Try doing it by yourself.
$the_str = str_replace('','\',$the_str);
$the_str = str_replace(',\\',$the_str);

This is a little hack until you find what is the problem with addslashes();

Best regards,
Andrey Hristov
IcyGEN Corporation
http://www.icygen.com
BALANCED SOLUTIONS

- Original Message - 
From: Tim Thorburn [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, February 25, 2002 9:39 AM
Subject: [PHP] Entering data into MySQL


 Hi,
 
 I'm having troubles entering information from a form into a MySQL 
 database.  Specifically if the user enters an apostrophe anywhere in the 
 form, all the information is rejected and nothing is entered into the database.
 
 After researching a little on php.net I found the addslashes() command - 
 this did help briefly and I was able to use apostrophe's in the form ... 
 but it seems as the problem has resurfaced.
 
 To make matters more frustrating, the addslashes() command works perfectly 
 well on my local test machine (Win2k Pro, PHP 4.1.1, MySQL 3.23.44, Apache 
 1.3.23) but not at all on the server which is hosted by another company 
 (Sun Solaris, PHP 3.0.16, MySQL 3.22.32, Apache 1.3.12).
 
 Does anyone have any suggestions as to why the addslashes() command worked 
 for a short time on the webserver and why it stopped?  Or better yet, is 
 there a variation of addslashes() that will work on an older version of PHP 
 such as 3.0.16?
 
 I'd be eternally grateful for any prompt replies as its already 2.38am and 
 my deadline is 9am :P
 
 Thank you
 -Tim Thorburn
 
 
 
 -- 
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 
 


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php