getimagesize error

[BizBoy]

I'm doing a real estate site and im trying to get the images to fit in a popup window.

Heres the error;

Warning: getimagesize(photos/DSCF0010.jpg ) [function.getimagesize]: failed to open stream: No such file or directory in /home/name/public_html/props/view.php on line 110

<?php

/* Connect to the Database */
extract($_GET);
extract($_POST);
require("config.php");
include "header.php";
$homes_db = mysql_connect($mysql['host'], $mysql['user'], $mysql['pass']);
mysql_select_db($mysql['db']);

/* Get and Show Data (as well as get pages) */
$homes_query = "SELECT * FROM homes_database WHERE ID='" . $ID . "' LIMIT 1";
$result = @mysql_query($homes_query, $homes_db);

/* Show House or Not */
if (@mysql_num_rows($result) > 0)
{
	/* Get Data */

$homes = mysql_fetch_array($result);
/* Explode Images */

$homes['images'] = explode("\n", $homes['images']);
$directory = "photos";
/* Output Data */

if ($homes['images'][0] != "")
{
	echo '<table width="100%">
  <tr>
    <th>Photos</th>
  </tr>
  <tr>
    <td>';
		for ($images = 0; $images < count($homes['images']); $images++)
		{
      list($width, $height) = getimagesize($directory."/".$homes['images'][$images]);
      $newwidth = $width;
      $newheight = $height;

		echo '<a href="#" onclick="w(\''.$directory.'/' . $homes['images'][$images] . '\','.$newwidth.','.$newheight.');"><img border="0" width="100" height="100" hspace="5" src="'.$directory.'/' . $homes['images'][$images] . '"></a>';

	};
	echo "</td></tr>";
};
echo '
  <tr>
    <td></td>
  </tr>
</table>';
}
else
{
	echo "<b>The entry you have specified could not be found. It may have been removed.</b>";
};
@mysql_free_result($result);
mysql_close($homes_db);

?>

[leatherback]

Hey Bizz boy,

CHeck the paths you use. Basically, the script is telling you that he cannot find the file you want to know the size of, in the location you tell it to look.

If I am correct, it now looks for the file in:

/home/name/public_html/props/photos/DSCF0010.jpg

J.

[BizBoy]

photos/DSCF0010.jpg
the picture exists in /photos :bemused:

[Frederick]

Your javascript for your link has attributes missing
NOW:
onclick="w(

'.$newwidth.','.$newheight.'

SHOULD BE:
onclick="window.open(

width='.$newwidth.',height='.$newheight.'

View help here

Also, you should not mix single quotes with your PHP and the javascript.
Use the following:

$image = $homes['images'][$images];
echo "<a href=\"#\" onClick=\"window.open('$directory/$image','','width=$newwidth,height=$newheight,resizable,top=0,left=0');\"><img  src=\"$directory/$image\" border=\"0\" width=\"100\" height=\"100\"></a>";

[BizBoy]

Thanks but im still geting the same error,

<?php

/* Connect to the Database */
extract($_GET);
extract($_POST);
require("config.php");
include "header.php";
$homes_db = mysql_connect($mysql['host'], $mysql['user'], $mysql['pass']);
mysql_select_db($mysql['db']);

/* Get and Show Data (as well as get pages) */
$homes_query = "SELECT * FROM homes_database WHERE ID='" . $ID . "' LIMIT 1";
$result = @mysql_query($homes_query, $homes_db);

/* Show House or Not */
if (@mysql_num_rows($result) > 0)
{
	/* Get Data */
	$homes = mysql_fetch_array($result);

/* Explode Images */
$homes['images'] = explode("\n", $homes['images']);
$directory = "photos";
/* Output Data */

if ($homes['images'][0] != "")
{
	echo '<table width="100%">
  <tr>
    <th>Photos</th>
  </tr>
  <tr>
    <td>';
		for ($images = 0; $images < count($homes['images']); $images++)
		{
$image = $homes['images'][$images];
list($width, $height) = getimagesize($directory."/".$image);
$newwidth = $width;
$newheight = $height; 

echo "<a href=\"#\" onClick=\"window.open('$directory/$image','','width=$newwidth,height=$newheight,resi
zable,top=0,left=0');\"><img  src=\"$directory/$image\" border=\"0\" width=\"100\" height=\"100\"></a>";

	};
	echo "</td></tr>";
};
echo '
  <tr>
    <td></td>
  </tr>
</table>';
}
else
{
	echo "<b>The entry you have specified could not be found. It may have been removed.</b>";
};
@mysql_free_result($result);
mysql_close($homes_db);

?>

:queasy:

[Frederick]

You maybe having issues with the for loop, use a while loop.
Use a row for each image and then use a query.

while ($row = mysql_fetch_array($homes_query)) {
    $image = $row["image"];
    list($width, $height) = getimagesize("$directory/$image");
    echo "<a href=\"#\" onClick=\"window.open('$directory/ $image','','width=".($width+40).",height=$height,scrollbars=yes,resizable,top=0,left=0');\"><img  src=\"$directory/$image\" border=\"0\" width=\"100\" height=\"100\"></a>"; // added +40 for scrollbar and edge margin
}

[BizBoy]

where do I put "while ($row = mysql_fetch_array($homes_query)) { "?

i did this:

		for ($images = 0; $images < count($homes['images']); $images++)
		{
while ($row = mysql_fetch_array($homes_query)) { 
    $image = $row["image"];
    list($width, $height) = getimagesize("$directory/$image");
    echo "<a href=\"#\" onClick=\"window.open('$directory/ $image','','width=".($width+40)." ,height=$height,scrollbars=yes,resizable,top=0,lef
t=0');\"><img  src=\"$directory/$image\" border=\"0\" width=\"100\" height=\"100\"></a>"; // added +40 for scrollbar and edge margin
}

and it gave me this error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/squirrel/public_html/setch/view.php on line 110

🙂

[Frederick]

$homes_query = "SELECT * FROM homes_database WHERE ID='" . $ID . "' LIMIT 1"; 
$result = @mysql_query($homes_query, $homes_db);

while ($row = mysql_fetch_array($result)) { 
    $image = $row["image"]; 
    list($width, $height) = getimagesize("$directory/$image"); 
    echo "<a href=\"#\" onClick=\"window.open('$directory/ $image','','width=".($width+40)." ,height=$height,scrollbars=yes,resizable,top=0,lef
t=0');\"><img  src=\"$directory/$image\" border=\"0\" width=\"100\" height=\"100\"></a>"; // added +40 for scrollbar and edge margin 
}