How to remove slash \ before save in database in mysqli?

Asked Mar 20 '16 at 00:41

Active Mar 20 '16 at 00:58

Viewed 20 times

I am using this script .

$category_name = filter_input(INPUT_GET, 'category', FILTER_SANITIZE_STRING);
$db->query("INSERT INTO `category` (name,sort) VALUES ('$category','0') ");

But if end of value of $_GET['category'] be slash fo e.g hello \ OR \ OR \ hello \ All of value dosnt save and query dosn't insert .

It's not imprtant to me save slash in database . I want just save in database whithout \ for e.g (Hello \ ) save (Hello). There are any filter_input for this ?

edited Mar 20 '16 at 00:58

asked Mar 20 '16 at 00:41

mrjohn

Ever heard of SQL escaping or parameter binding? – mario Mar 20 '16 at 00:42
No i don't @mario . – mrjohn Mar 20 '16 at 00:44
See also [How can I prevent SQL-injection in PHP?](http://stackoverflow.com/a/60496) – mario Mar 20 '16 at 00:46
It's not imprtant to me save slash in database . I want just save in database whithout \ for e.g (Hello \ ) save (Hello). There are any filter_input for this ?@mario – mrjohn Mar 20 '16 at 00:50
That's not what the filter_* functions are for. – mario Mar 20 '16 at 00:52
I edit this question please remove This question already has an answer here ..... becuse its not my question . @mario – mrjohn Mar 20 '16 at 00:55
Yep, it's not your question. It's your answer though. Whether you bother to read it or not. – mario Mar 20 '16 at 00:56
@mario yes i read it but it's not my answer to . please remove :) please – mrjohn Mar 20 '16 at 00:59
Then see the long list of results on [how to remove a backslash](https://www.google.de/search?q=site:stackoverflow.com+php+remove+backslash+from+string) – mario Mar 20 '16 at 01:11

How to remove slash \ before save in database in mysqli?

0 Answers0