php mssql escape special characters

Asked Nov 03 '16 at 16:13

Active Nov 03 '16 at 16:17

Viewed 368 times

Trying to run the following query string (against MS SQL Server) which includes special characters. How do I do this?

select top 1 Contact_CustomData.CustomFields.value('(/CustomFields[1]/GiftCard)[1]', 'varchar(100)') from Contact_CustomData;

This query (when executed directly on the db) works fine. Just need to escape these characters somehow.

edited Nov 03 '16 at 16:17

simon

asked Nov 03 '16 at 16:13

user3389171

`these` ?? In your current query no char needs to be escaped. – JustOnUnderMillions Nov 03 '16 at 16:17
You have only to escape `'` like so `\'` or so `''` if these chars part of data/content. – JustOnUnderMillions Nov 03 '16 at 16:18
@JustOnUnderMillions I'm sorry I don't understand your comment. Would you please explain differently? – user3389171 Nov 03 '16 at 16:19
Normaly a query looks like `SELECT * FROM abc WHERE a='b'`, in case you have an single quote in it you have to do it like `SELECT * FROM abc WHERE a='b\'s'`. – JustOnUnderMillions Nov 03 '16 at 16:22
But check this http://www.aaronlrutledge.com/escaping-special-characters-in-php-for-mssql/ im not know so much about mssql, but single quote escaping i done mostly in the same way – JustOnUnderMillions Nov 03 '16 at 16:23
Possible duplicate of [How to escape strings in SQL Server using PHP?](http://stackoverflow.com/questions/574805/how-to-escape-strings-in-sql-server-using-php) – simon Nov 03 '16 at 16:24

0 Answers0