Allow single quote in sql query

Question

I want to update my sql table , but in my case I am getting error look like this

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ivision '' at line 1

$name = "A'nme";

$this->db->update("users",["name" => $name]);

My project based on Codeigniter

How can I solve this problem ?

Possible duplicate of [How to insert a value that contains an apostrophe (single quote)?](https://stackoverflow.com/questions/1912095/how-to-insert-a-value-that-contains-an-apostrophe-single-quote) — OLIVER.KOO, Jul 07 '17 at 19:46

score 2 · Accepted Answer · answered Jul 07 '17 at 19:43

2

Double up and use single quotes to see it better: How to insert a value that contains an apostrophe (single quote)?

$name = 'A''nme';

answered Jul 07 '17 at 19:43

Flynn

269
2
12

I dont want to save second quote in my db, I only want 1 quote – Yur Gasparyan Jul 07 '17 at 19:57
This will output A'nme ... is that not what you want? – Flynn Jul 07 '17 at 20:00
Not. in my db its saving as A''nme – Yur Gasparyan Jul 07 '17 at 20:03
Are you sure everything is in single quotes ' ? – Flynn Jul 07 '17 at 20:09

Allow single quote in sql query

1 Answers1