Is this possible? If one file assigned to an ID...

Posted on 16th Feb 2014 07:03 pm by admin

I have a page that lists property listings assigned to a specific user (a manage page), with brief text details and a picture.

Each of these listings has several images with it, that aren't seen unless they click on the listing itself to edit/view it.

I'd like to put a warning next to the listing on this manage page if one or more of the images assigned to that listing id are over a certain size. I'm not quite sure how to do this. When I put in the code, I get an error at the top giving an filesize stat warning, listing all of the files run together:

Code: Warning: filesize() [function.filesize]: stat failed for re_images/1263001649_offer_christmasstory.jpg|1263001038_offer_TEST.jpg in
Here is the code I've got that has the problem:

Code: if($rows > '0')
{
$ListingTable .= "<table align=center width=510 border=1 bordercolor=black frame=hsides rules=rows cellspacing=0>n";

while($a1 = mysql_fetch_array($r1))
{
$size = filesize('re_images/'.$a1[image]);
if( $size > 153600 )
{
echo '<p align=center><img src="images/warning.gif" border="0"></p>';
$warning="<font color=#FF0000 size=5>!!</font></b>";
}

$ListingTable .= "<tr onMouseOver="this.style.background='#E2E2E2'; this.style.cursor='hand'" onMouseOut="this.style.background='white'" onClick="window.open('info.php?id=$a1[ListingID]', '_top')">nt";

if($a1[PriorityLevel] > '1')
{
//get the priority level name
$qp = "select PriorityName from re2_priority where PriorityLevel = '$a1[PriorityLevel]' ";
$rp = mysql_query($qp) or die(mysql_error());
$ap = mysql_fetch_array($rp);

$sub = "<span class=RedLink>^$ap[0]</span>";
}
else
{
$sub = "";
}

$ListingTable .= "nt<td width=15>";

if(!empty($a1[image]))
{
$ListingTable .= "<img src="myimages/camera.jpg" width=15 height=15>$warning";
}

$ListingTable .= "</td>nt";
$ListingTable .= "<td width=305>$a1[city], $a1[state], $a1[address] $sub</td>nt";
$ListingTable .= "<td width=80>$a1[rooms] br, $a1[bathrooms] ba";
$MyPrice = number_format($a1[Price], 2, ".", ",");
$ListingTable .= "</td>nt<td align=center width=100><b>$$MyPrice</td>n";
$ListingTable .= "</tr>n";

}

$ListingTable .= "</table>";
}
I've coded this on the next page that shows all of the image, and it worked good. This one, I just couldn't figure out how to tell the server to look in the folder to see if any of the image associated with an id are a certain size

Your Answer:

Login to answer

Other forums

Get ID from Database when Posting with a HTML Form
I have a form I am submitting to a MySql database. Each product has an ID # attached to it that auto

Quick fix: Conditional statement with an array
Hi, I'm getting the temperature value off of the Environment Canada website along with the icon file

User feedback after MySQL query has been executed
Hi all, I've just registered on PHPFreaks because I've got a question that I simply can't work out b

Will an XHTML DOCTYPE interfere with my PHP if I'm not experienced enough?
I've read this article here: http://friendlybit.com/html/why-xhtml-is-a-bad-idea/

In a nutshe

How to implement HTTP connection timeout
Hi All,I would like to implement an HTTP connection timeout.

I am working on a application wh

column name cancatenation within PL/SQL
I have a PLSQL store procedure, and the following statement is part of a subquery
fname||lnam

SQL query not working well
Hi,
I made a small table with 5 rows and want to make them an sql consult using rownum

Keeping track of php uploads
Hello all.

I was looking at the way PHP handles file uploads.
It seems that PHP uses a tem

Target costs on Process orders not calculating
Hi All,

We have released standard costs for all the materials. We have also done Goods r

Is this Safe or Unsafe?
Hi i made a few pages with lots of peoples help now i just want to know if they are safe or not can