mikawhat wrote:i've got the following javascript and i'd like to know if it's possible to get the images from my db.
<!--- THIS IS THE BIT OF CODE FOR THE BIG PICTURE --->
<div align="center"><img src="image1.jpg" align="middle" border="1" width="708" height="403" name="large">
</div>
<p align="center">
<!--- THESE 4 BLOCKS OF CODE ARE FOR THE THUMBNAILS ---->
<a href="javascript:image_click(0)"> <img src= width="150" height="110" name="pimage0" border=1></a>
<a href="javascript:image_click(1)"> <img src= width="150" height="110" name="pimage1" border=1></a>
<a href="javascript:image_click(2)"> <img src= width="150" height="110" name="pimage2" border=1></a>
<a href="javascript:image_click(3)"> <img src= width="150" height="110" name="pimage3" border=1></a>
<!---- THESE BLOCKS OF CODE CONTROL HOW THE IMAGES ARE DISPLAYED-->
<script language="JavaScript"><!--
//thumbnail script
image0 =new Image();
image1 =new Image();
image2 =new Image();
image3 =new Image();
// These 4 lines define the source of the displayed images
[COLOR=Red]image0.src ="image1.jpg"
image1.src ="image2.jpg"
image2.src ="image3.jpg"
image3.src ="image4.jpg"[/COLOR]
// This defines the source of the preview image
document.images['pimage0'].src=image0.src;
document.images['pimage1'].src=image1.src;
document.images['pimage2'].src=image2.src;
document.images['pimage3'].src=image3.src;
// This defines what to do when an image is clicked on
function image_click(clicks)
{
if(clicks==0){document.images['large'].src=image0.src;}
if(clicks==1){document.images['large'].src=image1.src;}
if(clicks==2){document.images['large'].src=image2.src;}
if(clicks==3){document.images['large'].src=image3.src;}
}
// --></script>
Wow, that's alot of useless code..
-- HEAD --
<SCRIPT LANGUAGE="JavaScript">
<!--
var Images = new array();
<?php
$q=mysql_query("SELECT * FROM myimages");
$nr=@mysql_num_rows($q)-1;
?>
for (i=0;i<=<?php echo $nr ?>;i++){
Images=new image();
Images.src="image"+i+".jpg";
}
function image_click(clicks){
for (i=0;i<=<?php echo $nr ?>;i++){
if ( clicks==i ) document.images['large'].src=Images.src;
}
}
//-->
</SCRIPT>
--- BODY --
<?php
$i=0;
$q=mysql_query("SELECT * FROM myimages");
while ($ImgInfo=mysql_fetch_object($q)) {
echo '<a href="javascript:image_click('.$i.')"> <img src="'.$ImgInfo->IMAGENAME.'" width="150" height="110" name="pimage'.$i.'" border="1"></a>';
$i++;
} #end while
?>
-- END
That Should do it..
