Ignoring the file extension?challenging one for me!!

[divadiva]

Experts ,

 

I am struggling with it for quite some time.I anyone can help me out of my misery ,I will appreciate that.

 

How can I ignore the file extension.So that if in database the extension is JPG and in filesystem it is jpg .It should work.

 

Database:abc.JPG

Filesystem:abc.jpg.(All images are inside IMAGE folder )

 

The database is not consistent I am aware of it as well.Also,Changing option will screw up my website.As I have tried and it got screwed.Now I have fixed that.

 

Here is my code for viewing image:

 

<TR>

					  <TD WIDTH="180" STYLE="background-color:#B6DAF2;"><B>Image 1</B></TD>
					  
					  <TD>
						<% if($i_row['image1'] && ! substr_count($i_row['image1'],'unavailable.')) { %><IMG
						 BORDER="0" SRC="<%= '../files/' .$i_row['image1']; %>" ALT=" " WIDTH="300"><% } %></TD> 
					</TR> 
					<TR> 
					  <TD WIDTH="180" STYLE="background-color:#B6DAF2;"><B>Image 2</B></TD>
					  
					  <TD><% if($i_row['image2'] && ! substr_count($i_row['image2'],'unavailable.')) { %><IMG
						 BORDER="0" SRC="<%= '../files/' . $i_row['image2']; %>" ALT=" " WIDTH="300"><% } %></TD> 
					</TR> 
					<TR> 

 

Thankyou in advance.

 

Best Regards,

Divya

 

[genericnumber1]

It would be best to correct it in the database, as any php solutions would just be messy bandaids that could explode in the future (and no one likes exploding bandaids).

 

Also, why are you using asp style tags?

[divadiva]

Thanks for replying.

 

Is there any other solution ?

 

But  I have not written this code I am modifying this code.Dont have the rightsto change it anyway.

[Maq]

I don't think there's a way, unless they are all lower case extensions in the directory then you could just do strtolower().

 

The best but longest way would be changing the names to be consistent in the DB and server but if you can't touch it then we have to go a different route.

 

You have to:

 

-take the extension by exploding it by the dot.

-do a strtoupper and string to lower on it

-check if either the lower case or upper case exists in the directory

-which ever one exists, display it.

 

Example (from another forum):

 

if(file_exists($housepicJPG)) {
    $thumbpiccode="";
    $thumbJPG="(Found it)";
} elseif (file_exists($housepicJPG2)) {
    $thumbpiccode="";
    $thumbJPG="(Found it)";
}

 

 

 

[divadiva]

Thanks Maq!!

 

I am going with what you all have suggested "be consistent with the database".

[Maq]

Wherever you it is being entered just do a trim() and strtolower() on it, along with the all the cleansing functions of course.

[premiso]

Well, you could do this:

 

<?php
function getImageName($name) {
    $name = pathinfo($name, PATHINFO_FILENAME);
    foreach (glob(strtolower($name)) as $name) {
           return $name;
    }

    return "Unable to find";
}
?>


<TR>
                  
                    <TD WIDTH="180" STYLE="background-color:#B6DAF2;"><B>Image 1</B></TD>
                   
                    <TD>
                     <% if($i_row['image1'] && ! substr_count($i_row['image1'],'unavailable.')) { %><IMG
                      BORDER="0" SRC="<%= '../files/' .getImageName($i_row['image1']); %>" ALT=" " WIDTH="300"><% } %></TD>
                  </TR>
                  <TR>
                    <TD WIDTH="180" STYLE="background-color:#B6DAF2;"><B>Image 2</B></TD>
                   
                    <TD><% if($i_row['image2'] && ! substr_count($i_row['image2'],'unavailable.')) { %><IMG
                      BORDER="0" SRC="<%= '../files/' . getImageName($i_row['image2']); %>" ALT=" " WIDTH="300"><% } %></TD>
                  </TR>
                  <TR>

 

See if that will work for you.