CSS Image Gallery Support Product Page
This topic was archived
CSS Image Gallery & PHP/MySql??
Asked 01 Apr 2009 21:05:45
1
has this question
01 Apr 2009 21:05:45 mike zuffoletto posted:
I already have PHPPureUpload and was wondering if CSS Image Gallery will allow you to pull images from a database dynamically instead of from a static folder on the server and will the function of resizing images still work with this? Does one have to us PurePHP Upload in conjunction with this extension? Replies
Replied 01 Apr 2009 21:43:44
01 Apr 2009 21:43:44 George Petrov replied:
Hi Mike,
This should be indeed easy possible. I will see if we can make a video in the next few days of how it can be done so it is easies to understand.
Greetings,
George
This should be indeed easy possible. I will see if we can make a video in the next few days of how it can be done so it is easies to understand.
Greetings,
George
Replied 15 Apr 2009 16:33:24
15 Apr 2009 16:33:24 mike zuffoletto replied:
George, did you ever create that video to show how one can build a dynamic image gallery with CSS Image Gallery using photos in a Database (php/mysql).
Best regards,
Mike
Best regards,
Mike
Replied 15 Apr 2009 16:39:46
15 Apr 2009 16:39:46 George Petrov replied:
You are fast! We just publish it 5 minutes ago!
here is it: www.dmxzone.com/go?16610
Greetings,
George
here is it: www.dmxzone.com/go?16610
Greetings,
George
Replied 23 Apr 2009 09:46:16
23 Apr 2009 09:46:16 Denis Hoffmann replied:
Am I right, that the thumbs always have to be in the folder "thumbs"?
Cheers
Denis
Cheers
Denis
Replied 29 Apr 2009 15:17:56
29 Apr 2009 15:17:56 Miroslav Zografski replied:
Hi Denis,
Yes, that is correct.
Regards,
Yes, that is correct.
Regards,
Replied 05 Jul 2009 13:30:48
05 Jul 2009 13:30:48 Jeff Spijkers replied:
I hav tried the tutorial and followed the video to the letter... IT DOES NOT WORK AT ALL!
!]
Please help! I'm going nuts![xx(]
I wish this could be done in PHP!!
Thanks!
!]Please help! I'm going nuts![xx(]
I wish this could be done in PHP!!
Thanks!
Edited by - Jeff Spijkers on 05 Jul 2009 13:47:25
Replied 06 Jul 2009 10:04:06
06 Jul 2009 10:04:06 Teodor Kuduschiev replied:
Hello Jeff,
Could you please be more specific? What do you mean with "It does not work at all"? Are there any error messages? We need to know what are you trying to do and how are you doing it in order to help you.
Could you please be more specific? What do you mean with "It does not work at all"? Are there any error messages? We need to know what are you trying to do and how are you doing it in order to help you.
Replied 12 Jul 2009 10:59:29
12 Jul 2009 10:59:29 Jeff Spijkers replied:
Well, I am trying to trying to populate the image gallery dynamically from a database table containing the file names of all the images. I want to do this so the end user can simply upload new images to the gallery and have them automatically added to the CSS Image Gallery.
I have followed the video tutorial mentioned in George Petrov's post above and have follwed it to the letter, but It just won't work.
I get no error messages of any kind, just a blank gallery when I preview.
I did notice however that the tutorial was done using asp, and I believe that this is where the problem lies.
Please help. I'm really getting frustrated...
Thanks a million!
I would like to make an amendment... I am now getting a single error which I was kind of expecting...
Dreamweaver does not support nested regions in the PHP/MySQL server model.
I look forward to your ideas.
Edited by - Jeff Spijkers on 15 Jul 2009 15:51:57
Replied 11 Aug 2009 01:28:06
11 Aug 2009 01:28:06 Heather V replied:
Has this problem been resolved? I would like to do the same thing, but I want to make sure that the product will work before purchasing it.
Replied 11 Aug 2009 09:21:56
11 Aug 2009 09:21:56 Teodor Kuduschiev replied:
Hello Heather,
Could you please be a little more specific, what exactly you want to do with the product?
Could you please be a little more specific, what exactly you want to do with the product?
Replied 15 Aug 2009 00:48:20
15 Aug 2009 00:48:20 Heather V replied:
I would have to say that I'm experiencing the same problem as the previous poster (I also am using MySQL/PHP).
The problem lies when applying the FIRST Repeat Region Server Behavior. When DW8 applies it, instead of wrapper the Repeat Region Behavior around the Thumbnail <ul> section, it posts the first part of the Repeat Region directly after the <body> tag and the second part of the Repeat Region Server Behavior before the </body> tag---this is not where the Repeat Region should be placed--I've developed lots of sites and this is not a nice quirk. I don't thing DW8 knows what to do with the Extension.
#2 DW8 doesn't allow a Repeat Region Server Behavior from the same Recordset under the same name. Thus, apply a Repeat Region for the thumbnails is not possible (unless I have not done something correctly).
I've attached my code and would appreciate some help in figuring this out. I would like to take advantage of this product, since I bought it for its Dynamic usefulness and would like for the user to be able to just upload their pics and the Extension to do the rest of the job:
This code only contains the FIRST Repeat Region for the originating Recordset:
The problem lies when applying the FIRST Repeat Region Server Behavior. When DW8 applies it, instead of wrapper the Repeat Region Behavior around the Thumbnail <ul> section, it posts the first part of the Repeat Region directly after the <body> tag and the second part of the Repeat Region Server Behavior before the </body> tag---this is not where the Repeat Region should be placed--I've developed lots of sites and this is not a nice quirk. I don't thing DW8 knows what to do with the Extension.
#2 DW8 doesn't allow a Repeat Region Server Behavior from the same Recordset under the same name. Thus, apply a Repeat Region for the thumbnails is not possible (unless I have not done something correctly).
I've attached my code and would appreciate some help in figuring this out. I would like to take advantage of this product, since I bought it for its Dynamic usefulness and would like for the user to be able to just upload their pics and the Extension to do the rest of the job:
This code only contains the FIRST Repeat Region for the originating Recordset:
<?php require_once('Connections/....php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
mysql_select_db($database_user, $user);
$query_getGallery = "SELECT * FROM gallery";
$getGallery = mysql_query($query_getGallery, $user) or die(mysql_error());
$row_getGallery = mysql_fetch_assoc($getGallery);
$totalRows_getGallery = mysql_num_rows($getGallery);
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<script src="ScriptLibrary/jquery-latest.pack.js" type="text/javascript"></script>
<script src="ScriptLibrary/jquery.mousewheel.pack.js" type="text/javascript"></script>
<script src="ScriptLibrary/dmxgallery.js" type="text/javascript"></script>
<link href="styles/dmxgallery.css" rel="stylesheet" type="text/css" />
</head>
<body><?php do { ?>
<div class="dmxGallery" id="cssGallery1">
<ul>
<p><?php echo $row_getGallery['caption']; ?></p>
<li><img src="photogallery/thumbs/<?php echo $row_getGallery['filename']; ?>" width="500" height="380" class="image" alt="" /></li>
</ul>
</div>
<div class="dmxThumbList" id="cssGallery1_thumb">
<ul>
<li><img src="photogallery/thumbs/thumbs/<?php echo $row_getGallery['filename']; ?>" width="160" height="121" alt="" /></li>
</ul>
</div>
<script type="text/javascript">
// <![CDATA[
jQuery(document).ready(
function()
{
jQuery("#cssGallery1").dmxGallery(
{
width: 555,
height: 338,
thumbWidth: 95,
thumbHeight: 80,
thumbPadding: 5,
thumbHolderHeight: 80,
thumbHolderPosition: 'right',
thumbShowOnHover: false,
captionPosition: 'top',
playerDelay: 3,
autoPlay: false,
autosize: true,
captionOpacity: 40,
imgIndex: 0,
preloadTreshold: 2,
currentImage: 0
}
);
}
);
// ]]>
</script>
<?php } while ($row_getGallery = mysql_fetch_assoc($getGallery)); ?>
</body>
</html>
<?php
mysql_free_result($getGallery);
?>
Replied 15 Aug 2009 20:13:09
15 Aug 2009 20:13:09 Patrick Julicher replied:
Jeff, Heather,
Did you already have a look at the following FAQ: www.dmxzone.com/go?14023.
Maybe this could be what you need?
Kind regards, Patrick
Did you already have a look at the following FAQ: www.dmxzone.com/go?14023.
Maybe this could be what you need?
Kind regards, Patrick