[RESOLVED] case sensitivity problem

[yahyac]

I don't know if the following issue is related to php, mysql, or perhaps even the appache server that my site resides on.

Years ago when i made my original STATIC website, which had hundreds of pages, and therefore products, and therefore pictures, i saved ALL my pictures with the naming convention of itemnumber.jpg.

This saved me TONS of time when i converted my site recently to a dynamic mysql/php site, as on the product.php page, i was able to code the php to tell it to use the image with the EXACT file name as the item number. An example is below:

echo '<img border="0" src="/images/prod_cat/';
echo $prodID;
echo '.jpg" alt="';
echo $myrow["name"];
echo '"><br>';

This worked perfectly on my local machine.

However, once i uploaded everything to the server, the images were no longer showing. The reason? Because for whatever crazy reasons, when i saved these pictures years ago, sometimes i saved them with uppercase letters, and sometimes with lowercase letters, and sometimes, with both!

Now, in my database, i use ALL uppercase letters.

So after running the php code for product PL568, i get the following html:
<img src border="0" src="/images/prod_cat/PL568.jpg" alt="blah")

This file will not pull up anything even when i put the absolute path into the address bar as:
www.mydomain.com/images/prod_cat/PL568.jpg

Now, if i simply go change the P and the L to a lowercase p and l, then the image pops right up (www.mydomain.com/images/prod_cat/pl568.jpg)

What is causing this "problem", other than the fact that i named the files in such an idiotic pattern?

And is there anything i can do to help this cause, other than having to sit down and rename thousands of files?

Thanks much.
Jonathan

[yahyac]

The more i think about it, the more it seems that the logical answer is that this is a server "issue".

Again, take php/mysql out of the question, and the fact remains that my server cannot find the picture when given an absolute path with uppercase filename, but it CAN find it when i change the filename to lowercase.

So if this is the reality, is this just how an appache server is?

Thanks.

[NogDog]

I would guess that you originally built this on a Windows system, which is case-insensitive when it comes to file names; but the UNIX/Linux OS is case-sensitive with regard to file names. Perhaps could use the strtolower() function to convert the DB value to all lower-case?

[yahyac]

Hey NogDog,

Thanks for that advice. Actually, almost immediately after I posted, i did indeed think of that option and we're okay now.

Thanks again.
Jonathan