How do i insert mysql query with single quote? [duplicate]

Question

I am trying to insert query with single qoute '.its break my query . e.g

INSERT INTO news (`Id`, `UserId`, `description`) VALUES (1,12,'Hello this descriptrion  and this single qoute ' in sentance');

It dose not insert and give error. so my question is whenever user enter description with single qoute e.g it's very hot today. how can i handle ' single quote in this way ?

You Answer highly Appreciate

From PHP you would use a prepared statement, then this will simply not be an issue: php.net/manual/en/mysqli.quickstart.prepared-statements.php — Alex K.
– Alex K., Commented Mar 20, 2018 at 13:25

Jenish · Accepted Answer · 2018-03-20 13:26:12Z

1

you can do something like that :

  INSERT INTO news (`Id`, `UserId`, `description`) VALUES (1,12,"Hello this descriptrion  and this single qoute ' in sentance");

answered Mar 20, 2018 at 13:26

Jenish

5334 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How do i insert mysql query with single quote? [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related