Hello,
> insert into table_name (describe) values('" . $check . "')
I think it work:
$data = addslashes ($_POST ['data']) //adding slashes before special chars
// take a look on manual to get info about get_magic_quotes_gpc () to do not
add slashes in a string with slashes
$query = "INSERT INTO table_name (field) VALUES ('$data')";
//exec query
[]'s
Luiz Miguel Axcar
lmaxcar AT yahoo DOT com DOT br
((( i ))) Campinas, São Paulo, Brasil
http://www.geocities.com/lmaxcar
PHP [enguin] never sleeps.
----- Original Message -----
From: Sudeep Sarath <sudeepfiles@xxxxxxxxxxx>
To: Php-windows mailing list <php-windows@xxxxxxxxxxxxx>
Sent: Friday, April 02, 2004 6:16 AM
Subject: quotes in mysql
> Hi friends,
>
> I have a 'textarea' in my php page and i need to put the details typed in
that textarea box to my MySQL database. The content in the textarea box
is(for example) : I'm a good boy.
>
> and insert string is:
>
> insert into table_name (describe) values('" . $check . "')
>
> where check is the variable that stores the POST data of textarea. Also
the field "describe" is of a text datatype.
>
> what happens is that i can't take the content string to the database.
B'cause it contains I'm (a single quote in between I and m) which confuses
mySql that string terminates after I. Is there any solution for this problem
as we cannot tell the users "dont put quotes in textarea".
>
> ....SuDeEp...
>
> Win an evening with the Indian cricket captain: Yahoo! India Promos.
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
