Does image Exist

[tinkywonk]

please can someone help me I am trying to code my website so that when it poulates the data from mysql server database it checks to see if an image exists from the information out of mysql dtabase it shows it but the bit i cannot code is if a picture does not exist i want it to look at a default image instead but when i use file_exists it completly messes whole thing up. I have posted all code from my site and I have put

---

code in middle here

---

where the code is to find the image please can you help as pulling my hair out over this code as follows

<?php
for ($i = $startrec; $i < $reccount; $i++)
{
$row = mysql_fetch_assoc($res);
$style = "bd";
if ($i % 2 != 0) {
$style = "hr";
}
?>

<tr>
<td class="<?php echo $style ?>"><a href="Redundent.php?a=view&recid=<?php echo $i ?>">View</a></td>

---

************this code works but when no image it shows an image placeholder*****************************************************
<td class="<?php echo $style ?>"><a href=<?php echo "http://naturanauk.co.uk/photos/"?><?php echo str_replace("/","",htmlspecialchars($row["PROD/COL"])) ?><?php echo ".jpg"?>><img src = <?php echo "http://naturanauk.co.uk/photos/"?><?php echo str_replace("/","",htmlspecialchars($row["PROD/COL"])) ?><?php echo ".jpg"?> height="50", width="50", border=0></a></td>

---

---

************this code does not work but what i expect to work**********************************************************
If file_exists(<?php echo "http://naturanauk.co.uk/photos/"?><?php echo str_replace("/","",htmlspecialchars($row["PROD/COL"])) ?><?php echo ".jpg"?>)[
<td class="<?php echo $style ?>"><a href=<?php echo "http://naturanauk.co.uk/photos/"?><?php echo str_replace("/","",htmlspecialchars($row["PROD/COL"])) ?><?php echo ".jpg"?>><img src = <?php echo "http://naturanauk.co.uk/photos/"?><?php echo str_replace("/","",htmlspecialchars($row["PROD/COL"])) ?><?php echo ".jpg"?> height="50", width="50", border=0></a></td>}
else {
<td class="<?php echo $style ?>"><?php echo <img src = <?php echo "http://naturanauk.co.uk/photos/noimage.jpg"?></td>}

---

<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["ARTICLE"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["Product"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["PROD/COL"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["DESC"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["Category"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["BRAND"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["Season (Thomas)"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["depr (Thomas)"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["MIN SELL (THOMAS)"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["COUNT SEASONS"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["MAX SEASON"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["MIN SEASON"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["CURRENT / REDUNDANT ?"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["SEASON 00"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["SIZE 00"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["AVAIL 00"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["SEASON 01"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["SIZE 01"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["AVAIL 01"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["SEASON 02"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["SIZE 02"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["AVAIL 02"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["SEASON 03"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["SIZE 03"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["AVAIL 03"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["SEASON 04"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["SIZE 04"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["AVAIL 04"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["SEASON 05"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["SIZE 05"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["AVAIL 05"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["SEASON 06"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["SIZE 06"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["AVAIL 06"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["SEASON 07"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["SIZE 07"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["AVAIL 07"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["SEASON 08"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["SIZE 08"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["AVAIL 08"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["SEASON 09"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["SIZE 09"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["AVAIL 09"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["SEASON 10"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["SIZE 10"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["AVAIL 10"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["SEASON 11"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["SIZE 11"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["AVAIL 11"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["Sum(<Available Quantity>)"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["COL TOTAL"]) ?></td>
</tr>
<?php
}
mysql_free_result($res);
?>
</table>

[garblar]

give this a try for the file exists part

<?PHP
if(file_exists("http://naturanauk.co.uk/photos/".str_replace("/","",htmlspecialchars($row["PROD/COL"])).".jpg")){
?>
	<td class="<?php echo $style; ?>"><a href="<?php echo "http://naturanauk.co.uk/photos/".str_replace("/","",htmlspecialchars($row["PROD/COL"])).".jpg"; ?>"><img src="<?php echo "http://naturanauk.co.uk/photos/".str_replace("/","",htmlspecialchars($row["PROD/COL"])).".jpg"; ?>" height="50" width="50" border=0></a></td>
<?PHP
}
else {
?>
	<td class="<?php echo $style ?>"><img src="<?php echo "http://naturanauk.co.uk/photos/noimage.jpg"; ?>" /></td>
<?PHP
}
?>

[tinkywonk]

its closer to fact not messing my table up now but for some strange reason it is only showing the noimage picture all the time evan if tere is a picture available any help would be gratefull asap as this is all rather new to me and have a lot of work to do probally going to be on these forums a lot getting itdone lol thanks all

[garblar]

can you post your latest code, in php tags so its easier to read plz.

[tinkywonk]

td class="<?php echo $style?>"><a href="Redundent.php?a=view&recid=<?php echo $i?>">View</a></td>
<?PHP
if(file_exists("http://naturanauk.co.uk/photos/".str_replace("/","",htmlspecialchars ($row["PROD/COL"])).".jpg"))
{
?>
<td class="<?php echo $style; ?>"><a href="<?php echo "http://naturanauk.co.uk/photos/".str_replace("/","",htmlspecialchars($row["PROD/COL"])).".jpg"; ?>"><img src="<?php echo "http://naturanauk.co.uk/photos/".str_replace("/","",htmlspecialchars($row["PROD/COL"])).".jpg"; ?>" height="50" width="50" border=0></a></td>
<?PHP
}
else
{
?>
<td class="<?php echo $style ?>"><img src="<?php echo "http://naturanauk.co.uk/photos/noimage.jpg"; ?>" height="50" width="50" border=0></td>
<?PHP
}
?>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["ARTICLE"]) ?></td>

not too sure how i am suppose to lay this out as raher new to me and I am originaly a cside programer so trying to get to grips with this php stuff only been doing it a few weeks as you can probally tell

thanks for your patience

the problem now is it will only show the noimage all the time.

[garblar]

when you post your code, put [ PHP ][ /PHP ] with no spaces between the brackets around it to make it easier to read

td class="<?php echo $style?>"><a href="Redundent.php?a=view&recid=<?php echo $i?>">View</a></td>
<?PHP
if(file_exists("http://naturanauk.co.uk/photos/".str_replace("/","",htmlspecialchars ($row["PROD/COL"])).".jpg"))
{
?>
<td class="<?php echo $style; ?>"><a href="<?php echo "http://naturanauk.co.uk/photos/".str_replace("/","",htmlspecialchars($row["PROD/COL"])).".jpg"; ?>"><img src="<?php echo "http://naturanauk.co.uk/photos/".str_replace("/","",htmlspecialchars($row["PROD/COL"])).".jpg"; ?>" height="50" width="50" border=0></a></td>
<?PHP
}
else
{
?>
<td class="<?php echo $style ?>"><img src="<?php echo "http://naturanauk.co.uk/photos/noimage.jpg"; ?>" height="50" width="50" border=0></td>
<?PHP
}
?>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["ARTICLE"]) ?></td>

[tinkywonk]

Can you help me sort this then i understand that php bit now like i said with this code it is now just giving me noimage.jpg evan if an image exists

check sight previous without the if file_exists statment can be seen at http://naturana.110mb.com/Redundent.php

new code you gave me with the if file_exists
http://naturana.110mb.com/Redundent2.php

as you will see the old site has pics but the new does not show them only noimage.jpg

code used on current is

<?PHP
if(file_exists("http://naturanauk.co.uk/photos/".str_replace("/","",htmlspecialchars($row["PROD/COL"])).".jpg")){
?>
    <td class="<?php echo $style; ?>"><a href="<?php echo "http://naturanauk.co.uk/photos/".str_replace("/","",htmlspecialchars($row["PROD/COL"])).".jpg"; ?>"><img src="<?php echo "http://naturanauk.co.uk/photos/".str_replace("/","",htmlspecialchars($row["PROD/COL"])).".jpg"; ?>" height="50" width="50" border=0></a></td>
<?PHP
}
else {
?>
    <td class="<?php echo $style ?>"><img src="<?php echo "http://naturanauk.co.uk/photos/noimage.jpg"; ?>" height="50" width="50" border=0></td>
<?PHP
}
?>

thanks for your time

[garblar]

put in a command to echo out the url it is checking for the photos

echo "http://naturanauk.co.uk/photos/".str_replace("/", "", htmlspecialchars($row["PROD/COL"])).".jpg";

and see if there is a problem with the url

[tinkywonk]

I have put that command in just above if you check http://naturana.110mb.com/Redundent2.php

<?php echo "http://naturanauk.co.uk/photos/".str_replace("/","",htmlspecialchars($row["PROD/COL"])).".jpg"?>

the site shows the filenames fine like that so dont understand why does not find image if you copy and past url from site image is there although it thinks its not

[garblar]

ok, problem is that file_exists doesn't work for checking non-local files. so you need a different function that will check if that url is valid.

[tinkywonk]

ok any chance you or someone can tell me what that function is please

[garblar]

try this

<?PHP
$exists = false;
$url = "http://naturanauk.co.uk/photos/".str_replace("/","",htmlspecialchars($row["PROD/COL"])).".jpg"
$file_headers = @get_headers($url);
if($file_headers[0] == 'HTTP/1.1 404 Not Found') {
	//file does not exist
}
else {
    $exists = true;
}

if($exists){
?>
    <td class="<?php echo $style; ?>"><a href="<?php echo "http://naturanauk.co.uk/photos/".str_replace("/","",htmlspecialchars($row["PROD/COL"])).".jpg"; ?>"><img src="<?php echo "http://naturanauk.co.uk/photos/".str_replace("/","",htmlspecialchars($row["PROD/COL"])).".jpg"; ?>" height="50" width="50" border=0></a></td>
<?PHP
}
else {
?>
    <td class="<?php echo $style ?>"><img src="<?php echo "http://naturanauk.co.uk/photos/noimage.jpg"; ?>" height="50" width="50" border=0></td>
<?PHP
}
?> 

[Horizon88]

Are these files located on your same server, or are you linking to ones off-site? Because if you're on the same server you could use something like basename() or pathinfo() to get the filenames from the URI, then a simple file_exists() would work, saving you the overhead of making additional HTTP requests for each of your images.

[tinkywonk]

no these files are on a seperate foleder and the last piece of code does not work at $file_headers is returning nohing so $exists = true all the time problem not solved any other idea's

[Horizon88]

I didn't ask if they were in the same folder; I asked if they were on the same server.

[tinkywonk]

sorry thats what i meant there not on he same server sorry again

[tinkywonk]

anyone help me please😕