Enclosing prepared statement placeholders in single quotes

Question

When creating a prepared statement in mysqli, should I enclose string value placeholders in single quotes?

I.e. should I write:

 INSERT INTO Person (Name) VALUES ('?')

or

 INSERT INTO Person (Name) VALUES (?)

Related PDO question [PDO Update not replacing the placeholders in a prepared statement](https://stackoverflow.com/q/11332987/2943403) — mickmackusa, Feb 07 '23 at 03:17

score 1 · Accepted Answer · edited Nov 08 '20 at 16:00

1

INSERT INTO Person (Name) VALUES (?)

will work perfectly

edited Nov 08 '20 at 16:00

Dharman

answered Oct 14 '12 at 17:56

StaticVariable

1 Answers1