MySQL + Linux + Filenames with spaces

[tombell]

Hi,

I store paths of images in MySQL and later query the database and display a thumbnail with a link to the original image.

The problem is with filenames that have spaces in them. Although they are stored fine in the database, when I reference the path the image is not displayed in the browser.
I know that this happens because linux does not like spaces in filenames and escapes them with a backslash.
I have no control on how the users save the images, in order not to allow spaces.
Additionally the images are not uploaded.
Is there a way around this problem?

Thanks

[UrNsO]

This helped me alot for leading and trailing spaces. There is info further down on how to remove spaces in the middle of text.. You should be able to use one of the replace funtions to make the spaces into underscores for your *nix filesystem. I am very new to php but I figured this could maybe get you pointed in the right direction.

http://www.php.net/manual/en/function.trim.php

[matt_4013]

Hi there,

IfI understand your question correctly, the image is not displayed in the browser because a URI cannot contain a space. To get around this, rather than escaping with a backslash like you do in a shell, you'll need to do a string replace, and replace all spaces in your path with %20

$newpath = str_replace(" ", "%20", $imgpath);

http://au.php.net/manual/en/function.str-replace.php