Apostrphe's in Mysql

  • Denysia
  • Born
  • Born
  • Denysia
  • Posts: 2

Post 3+ Months Ago

I have developed a simple php application using mysql as the database. The problem I am having is when a user enters data that has an apostrophe(') it doesn not store the infomration in the table correctly and all fields after that are not stored at all. How do I allow a user to be able to enter the apostrophe in their text field but it not be treated like an apostrophe in the insert statement for Mysql.

Thank you for any assistance, I am real new at this and anm getting frustrated.
  • Axe
  • Genius
  • Genius
  • User avatar
  • Posts: 5738
  • Loc: Sub-level 28

Post 3+ Months Ago

have a look at these...

http://www.php.net/addslashes
http://www.php.net/stripslashes

:)
  • Denysia
  • Born
  • Born
  • Denysia
  • Posts: 2

Post 3+ Months Ago

Thank you so much for your quick response. I am going to give it a try

Post Information

  • Total Posts in this topic: 3 posts
  • Users browsing this forum: No registered users and 22 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.