A B C D E F G H I J K L M N O P Q R S T U V W X Y Z Snippets Functions Classes
Home | PHP Resources | MySQL Zipbase | Forums
<?php
//Get all the images in the database (use a WHERE clause to limit what it finds)
$sql = mysql_query("SELECT * FROM database_name");
//Start A counter we will start at 1
$i = 1;
//Get all the returned results, save them in an array, and loop throught the array
//to display all the returned results
while($row = mysql_fetch_array($sql)){
//Create a list from the returned image file, and make a $width and $height variable
list($width, $height) = getimagesize("url/to/large/image/".$row['img_file_name']);
//Add 30 to the returned width and height so it will fit in the popup window
//If it still doesn't fit, change the two thirtys to a larger number.
$width += 30;
$height += 30;
//Use javascript to make the popup
//Everytime the script runs through, $i will change so we can have dynamic popup window sizes
echo "
<script type="text/javascript">
function load".$i."(){
var load = window.open('url/to/large/image/".$row['img_file_name']."', ' ', 'scrollbars=no,menubar=no,height=".$height.",width=".$width.",resizable=no,toolbar=no,location=no,status=no');
}
</script>";
//This will display our thumbnail on the screen and make a link to the popup function
//that was just created in the above javascript.
echo'
<p>
<a href="javascript:load'.$i.'()">
<img src="url/to/thumb/image/'.$row['img_file_name'].'" />
</a>
</p>';
//Add one to $i
$i++;
}
?>
Suggested Difficulty Level: Novice
Current Score: 3.04
Total votes: 229
Total Views: 5687
Other top snippets by admin:
1. JPG to ASCII Converter
2. Add (th, st, nd, rd, th) to the end of a number
3. Dynamic Page Content From Links
4. AJAX Quickie
5. Simple Image CAPTCHA
1. Auth Class with (2.83 of 87)
2. Test Please Delete (2.83 of 30)
3. Return all repeated (3.64 of 72)
4. Convert an integer (3.3 of 71)
5. URL Shortening for (2.75 of 52)
6. Monthly Content Sorting (3 of 45)
7. Show String Trimmed (2.97 of 65)
8. Human readable file (2.01 of 70)
9. Randomize array values (2.8 of 82)
10. Create a recursive (3.35 of 55)
1. Parse RFC822 date (4 of 1)
2. Dynamic Image Uploading (5 of 1)
3. Spam Filter (0 of 0)
4. Is Multiple (0 of 0)
5. Base64 Encode / (0 of 0)
6. URL Encode / (0 of 0)
7. temp openbills (0 of 0)
8. Php Iban Validator (0 of 0)
9. Mysql Table Builder (0 of 0)
10. File size of (1.75 of 4)
11. Mail from your (1 of 1)
12. OddEven Class (0 of 0)
13. Detect if a (1 of 1)
14. MB CopyMCF-DIR :: (5 of 1)
15. Upper/Lower Case Accented (0 of 0)
16. Zodiac Signs (3 of 1)
17. Really useful code (2.5 of 2)
18. Calculate Central European (0 of 0)
19. Email Attachment (4 of 1)
20. ImageMagick Image Upload (0 of 0)
21. convert plain html (2 of 2)
22. Tag Builder (3.25 of 4)
23. Get Inserted ID (4.33 of 3)
24. Watermark An Image (3.33 of 3)
25. Check Prime Numbers (1.5 of 8)
2010-05-09 00:00:00