Hello everyone,
Think this is my first post on here, although I have been playing with Zenphoto and reading the forums for sometime now :-)
I have just got my first non-messabout Zenphoto gallery online at:
http://zenphoto.co.uk/gallery/and wished to integrate the gallery into my site
http://dtm.org.uk like I did with my old coppermine gallery, so i wrote some simple code to do this and it all seems to be working and looks pretty good. The only bad thing at the moment is the fact that it is sometimes slow, but this is only due to my Zenphoto gallery running on another server.
Anyway I thought i'd share my code to everyone to do this. To use it simple copy and paste the following and fill in the config details:
(Note: The commented bit inherits the default thumbnail for the album instead of a random one)
`
Zenphoto Galley Albums:
<?</p>
//Config Start
$mysql_host="";
$mysql_username="";
$mysql_password="";
$mysql_db="";
$base_gallery_url='http://zenphoto.co.uk/gallery/';
$albums_table='v101albums';
$images_table='v101images';
//Config End
$connection=mysql_connect($mysql_host,$mysql_username,$mysql_password);
mysql_select_db($mysql_db,$connection);
$a_query="SELECT * FROM $albums_table ORDER BY sort_order ASC";
$a_result=mysql_query($a_query);
$t=0;
?>
<?</p>
while($album=mysql_fetch_array($a_result)){
$album_id=$album['id'];
$album_title=$album['title'];
$album_title_text=$album_title;
$album_title=str_replace(" ","+",$album_title);
$album_thumb=$album['thumb'];
//if($album_thumb==""){
$q="SELECT * FROM $images_table WHERE `albumid` = '$album_id' ORDER BY Rand() LIMIT 1";
$r=mysql_query($q) or die('Query failed: ' . mysql_error());
$picture=mysql_fetch_array($r);
$picture=$picture['filename'];
$picture=str_replace(" ","+",$picture);
//}else{
//$picture=$album_thumb;
//}
$thumb=$base_gallery_url."$album_title/image/thumb/$picture";
if($t==0){
echo "";
}
if($t==1){
echo " | ";
}
?>
<?<br />
if($t==0){
echo " | ";
}
if($t==1){
echo "";
$t=0;
}else{
$t=1;
}
}
if($t==1){
echo " ";
$t=0;
}
mysql_close($connection);
?>
`
Zenphoto
Comments
Oh, and, nice domain ;-)
;-) If you want any A Records for the domain just ask
I've been messing about with zenphoto some more this morning, even though I have my driving theory test in two hours and should really learn that :P but anyway.... I've made 'Photocards' it basically puts all your photos in order of album and looks like a deck of cards.
When you click the thumbnail it goes and gets the full image, click that and it goes back to the thumbnail.
Check it out here:
http://zenphoto.co.uk/photocards.php
Code (Has the same config as above):
'
<html>
<head>
<title>DTM's Photo Gallery Photocard Deck</title>
<script type="text/javascript">
function display_full(full_url,thumb_url,view_id,box_id){
if(document[view_id].src==thumb_url){
document[view_id].src=full_url;
}else{
document[view_id].src=thumb_url;
}
}
</script>
<style type="text/css">
<!--
.photocard {
position: relative;
}
-->
</style>
</head>
<body>
<?
//Config Start
$mysql_host="";
$mysql_username="";
$mysql_password="";
$mysql_db="";
$base_gallery_url='http://zenphoto.co.uk/gallery/';
$albums_table='v101albums';
$images_table='v101images';
//Config End
$connection=mysql_connect($mysql_host,$mysql_username,$mysql_password);
mysql_select_db($mysql_db,$connection);
$a_query="SELECT * FROM $albums_table ORDER BY sort_order ASC";
$a_result=mysql_query($a_query);
$t=0;
?>
<?
$top=100;
$left=0;
while($album=mysql_fetch_array($a_result)){
$album_id=$album['id'];
$album_title=$album['title'];
$album_title_text=$album_title;
$album_title=str_replace(" ","+",$album_title);
$q="SELECT * FROM $images_table WHERE `albumid` = '$album_id' ORDER BY Rand()";
$r=mysql_query($q) or die('Query failed: ' . mysql_error());
while($picture=mysql_fetch_array($r)){
$picture=$picture['filename'];
$picture=str_replace(" ","+",$picture);
$thumb=$base_gallery_url."$album_title/image/thumb/$picture";
$full=$base_gallery_url."$album_title/image/595/$picture";
$left=$left+5;
$top=$top-70;
?>
<div id="box<? echo $left; ?>" class="photocard" style="left:<? echo $left; ?>px;top:<? echo $top; ?>px;width:100px;"
onmousedown="display_full('<? echo $full; ?>','<? echo $thumb; ?>','view<? echo $left; ?>','box<? echo $left; ?>')">
<img name='view<? echo $left; ?>' src="<? echo $thumb; ?>" border="0">
</div>
<?
}
}
mysql_close($connection);
?>
</body>
'