What is best way to deal with single quotes & double quotes insert into mysql database

Question

What is best way to deal with single quotes & double quotes insert into Mysql database.? I have tried with many cases. For example:

I need to store Paesano's Temple

1. I have store same but there is problem of sting break

2. I have tried with addslashes then store in database but there is problem at a time of showing in front-end (it's showing slashes-need stripslashes on fron-end)

What @FranzGleichmann said, because reasons : http://stackoverflow.com/questions/60174/how-can-i-prevent-sql-injection-in-php — CD001, Oct 26 '16 at 11:54

score 0 · Answer 1 · edited May 23 '17 at 12:33

0

Best way to use PDO for database operation it will take care regarding this type of query

try this link

How can I use PDO in CodeIgniter 2?

edited May 23 '17 at 12:33

Community

1
1

answered Oct 26 '16 at 11:58

Nandit

91
7

What is best way to deal with single quotes & double quotes insert into mysql database

1 Answers1