Simple Machines Community Forum

I have found while testing a search system, If I use a single quote with the below I get a error.

is there another way of doing the below so I can use single quotes

$record = $smcFunc['htmlspecialchars']($_REQUEST['search'],ENT_QUOTES);


switch ($_REQUEST['Search_by'])
{
case '1':
$searchby = ' LIKE "' . $record . '%"';
break;

default:
$searchby = ' LIKE "%' . $record . '%"';
break;
}
mick

Quote from: mickjav on September 28, 2022, 02:44:33 PMIf I use a single quote with the below I get a error.

What error are you getting?

Quote from: Doug Heffernan on September 28, 2022, 03:53:25 PM

Quote from: mickjav on September 28, 2022, 02:44:33 PMIf I use a single quote with the below I get a error.

What error are you getting?

No direct access...

You can see for yourself using below on my test forum
https://www.databasedreams.co.uk/testing/index.php?action=music;area=artists;sa=recsearch