[RESOLVED] Calling multiple images from a folder instead of a database

[TitusBass]

I've been working on a script that pulls info from mySQL. It writes a new table with the next DB entry. (See script below) What I'd like to do is pull all of the images from a particular folder based on the folder ID instead of adding all of the image paths. I really don't want to add the image paths into the database... Is there a simpler way of doing this?

<?php
// Make a MySQL Connection
		mysql_connect("localhost", "username", "password") or die(mysql_error());
		mysql_select_db("test001") or die(mysql_error());

// Get all the data from the "example" table
		$result = mysql_query("SELECT * FROM my_test_db ORDER BY name ASC") 
		or die(mysql_error());

// beginning of table	
echo "<table width='720' border='0' cellspacing='5' cellpadding='5' align='center'>";

// keeps getting the next row until there are no more to get
		while($row = mysql_fetch_array( $result )) {

// photos pulled from photo folder NOTE: This is where I get stuck... I don't want to list every photo in the folder in order for it to appear on the page
  		echo "<tr><td colspan='2' align='center'>"; 
		echo ("<img width=\"340\" height=\"255\"src=\"http://localhost:8888/green/images/diy/09-2010/{$row['mls']}a.jpg\">");
		echo "</td><td align='center'>";
		echo ("<img width=\"340\" height=\"255\"src=\"http://localhost:8888/green/images/diy/09-2010/{$row['mls']}b.jpg\">");
		echo "</td></tr>";

// Spacer	
		echo "<tr height='10'></tr>";

// begin writing row info
  		echo "<tr><td colspan='5' class=\"listing\" align='center'>";
		echo $row['mls'];
		echo ("&nbsp;&nbsp;—&nbsp;&nbsp;");
		echo $row['dollar'];
		echo number_format ($row['price']);
		echo ("&nbsp;&nbsp;—&nbsp;&nbsp;");
		echo $row['name'];
		echo ("&nbsp;&nbsp;—&nbsp;&nbsp;");
		echo $row['city'];
		echo (",&nbsp;");
		echo $row['state'];
		echo ("&nbsp;&nbsp;—&nbsp;&nbsp;");
		echo $row['email'];
		echo "</td></tr>";

// Spacer	
		echo "<tr height='10'></tr>";

// disclaimer
		echo "<tr><td colspan='5'>";
		echo $row['disclaimer'];	
		echo "</td></tr>";

// spacer
		echo "<tr height='10'></tr>";

// top of page
		echo "<tr><td colspan='5' align='center'>";
		echo $row['top'];
		echo "</td></tr>";

// spacer
		echo "<tr height='10'></tr>";

// image divider
		echo "<tr><td colspan='5' align='center'>";
		echo $row['divider'];
		echo "</td></tr>";
// spacer
	echo "<tr height='10'></tr>";
} 
// end of table
	echo "</table>";
?>

[dalecosp]

Hi Titus!

Welcome to PHPBuilder!

It'd be nice if you would put your code in [php][/php] tags ... if helps us see errors due to syntax highlighting, and would allow your code to scroll in its own box.

As to your issue, perhaps you've found a good use for [man]readdir/man?

[TitusBass]

Hi dalecosp... sorry about not putting my code in

tags...:o
I most certainly will next time.
I'll look into the use of readdir(). Thanks for the suggestion and feedback.

[bradgrafelman]

Rather than using the various *dir() functions, I would instead suggest you look into using [man]glob/man, especially since it offers more functionality in a much more compact form (one function call versus three or more).

[TitusBass]

bradgrafelman;10972185 wrote:

Rather than using the various *dir() functions, I would instead suggest you look into using [man]glob/man, especially since it offers more functionality in a much more compact form (one function call versus three or more).

Thanks Brad, glob is now my friend. I know I have only scratched the surface in learning PHP these past few years; because there's always something I haven't used before, or knew existed. But I will add this to my list. Here is what worked for me.

<?php
$files = glob("images/diy/09-2010/*.*");
for ($i=1; $i<count($files); $i++)
{
	$num = $files[$i];
	echo '<img src="'.$num.'" alt="random image">'."&nbsp;&nbsp;";
	}
?>

Not I have to look at my PHP manual and find how to resize the images and arrange them to be side-by-side.

But at least I've stepped over this precipice at the moment. Thanks to all for your excellent suggestions.