使用MySQL和PHP，图像名称具有“+”符号时无法保存图像名称

Question

I need one help.i need to save one image name inside database which contains + sysmbol in its name but after saving its creating space at the place of +. I am explaining below the image name.

fmfvweoujrm_G+G image is the image i need to store into data database but after storing i found fmfvweoujrm_G G image.jpg inside database.I am explaining the code below.

$image=$_POST['image'];
$sql=mysqli_query($connect,'INSERT INTO db_restaurant_basic (date,image) values ("'.$date.'","'.$image.'",)');

Here i need whatever the original image name that should store inside database.Please help me.

Answer 1

It is not necessary to escape + in the database. Instead, most likely, the problem occurs when showing the data from the database.

Check the content of your database if it really contains the blank or the plus character by using mysql command line utility or some tool like phpMyAdmin.

If my assumption is true, you are creating an image tag and use the string from the database as the src attribute. When the browser reads the attribute, it converts the + into the blank.

If so, you need to escape it for the browser when creating the attribute:

echo '<img src="' . urlencode($imgage) . '">';