需要帮助显示数据库中的数据

Question

I have a table[info] like this

+---+-------+---------------+
|id | cost  | place         |
+---+-------+---------------+
|1  | 2000  | Dhaka         | 
|2  | 1000  | Cox's Bazar   |
+---+-------+---------------+

Now I'm using this query to show these data

$a_place = $_POST['place'];
query = "SELECT * FROM info WHERE place = '$a_place'";

It works fine when I am searching for Dhaka, but it is not working for Cox's Bazar. Maybe for this > '

Now what can I do? Please help!

Answer 1

try this

$a_place = str_replace($_POST['place'],"'","''");

query = "SELECT * from info WHERE place = '".$a_place."'";

Edit

creating table and insert data

as you see the data ise like yours.

and If I select like mine the output is true