MySQL Forums
Forum List  »  PHP

Re:Please HELP
Posted by: Reham G
Date: July 25, 2005 04:00PM

hi.....
i don't know exactly ur problem but it may be that in the text (which u want to insert)there exist quotes ' which make the insert statment wrong
...if so replace ' with any special pattern and then reverse this step when u fetch from database
ex:

here i put the patter &ltr& instead of '

$text=$_REQUEST["Textfield name"];
$text=str_replace("'","&ltr&,$text);

then insert into db

when u fetch u do the reverse..

$text=str_replace("&ltr&,"'",$text")

wish it works with u....:-)

Options: ReplyQuote


Subject
Written By
Posted
July 25, 2005 07:17AM
July 25, 2005 08:42AM
Re:Please HELP
July 25, 2005 04:00PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.