我正在创建一个查询,当字符串查询连在一起时,我将传入参数和,其中有反斜杠添加了,这使得查询不值得运行。
$searchQuery = "Select * from <table_name> where Department like
'".$department. "' and Purchaser_Name like '%".$purchaser. "%' and
Vendor_Name like '%".$vendor. "%' and User_Name like '%".$requester.
"%' and PS_Account like '%".$psaccount. "%' ;";上面的字符串被转换。
"Select * from [dbo].[Unicard_Transactions] where Department like \'%staff%\' and Purchaser_Name like \'%mordica%\' and Vendor_Name like \'%crucial%\' and User_Name like \'%reeves%\' and PS_Account like \'%739000%\' "想知道如何在没有斜杠的情况下创建搜索字符串。
发布于 2016-06-21 21:53:55
我传入的参数值没有结果集。虽然我没有答案,但我有答案。非常感谢你的回复。这个社区太棒了!
https://stackoverflow.com/questions/37887360
复制相似问题