CSS Image Gallery Support Product Page

Gallery with comments

Shared 21 Apr 2010 22:17:04
1
likes this idea
21 Apr 2010 22:17:04 Denis Hoffmann posted:
Hi,

I created a dynamic gallery from my SQL database. how can i ad comments to the images? Like in Facebook etc.

I think, it must work with the unique ID of the image, take that as foreign key fot the comments table.

I dont know, how to mix both :-(

Any ideas?
Denis

ps. maybe with an other extension?

Replies

Replied 22 Apr 2010 11:08:19
22 Apr 2010 11:08:19 Miroslav Zografski replied:
Hello Denis,

You need to set an additional field in you table where the picture comments are which to contain an id to filter them. So each time someone adds a comment the id of the picture that comment is for to be set in that field.

Regards,
Replied 22 Apr 2010 19:11:29
22 Apr 2010 19:11:29 Denis Hoffmann replied:
Hey Miro,

I got two tables:
IMAGES:
imageID
imageName
imageTitle
imageDescription

COMMENTS:
commentID
imageID
commentDate
commentText

If I want to do it with the Gallery, how does the comments change, if the image changes?

Denis
Replied 23 Apr 2010 10:18:41
23 Apr 2010 10:18:41 Miroslav Zografski replied:
QuoteHey Miro,

I got two tables:
IMAGES:
imageID
imageName
imageTitle
imageDescription

COMMENTS:
commentID
imageID
commentDate
commentText

If I want to do it with the Gallery, how does the comments change, if the image changes?

Denis


Hello Denis,

well.. that will be a bit tricky. You need to have a behavior on image change that to trigger an AJAX call to a server page where to get the comments for that paricular image and then populate the returned results. This will be the best way. There is another possibility - set up an iFrame where to show the comments and when image is changed to call a function that will call a page in that iFrame where the comments are filtered by image id.
But my opinion is that the AJAX is needed here.

Regards,
Replied 23 Apr 2010 10:34:46
23 Apr 2010 10:34:46 Denis Hoffmann replied:
maybe it works Ajax DataGrid? and new comments with the lightbox?
Replied 23 Apr 2010 11:25:14
23 Apr 2010 11:25:14 Miroslav Zografski replied:
Hello Denis,

well that can do the job... there is a behavior for filtering the Ajax DataGrid. about adding new comment .. well you can use whatever you like.

Regards,
Replied 07 Jun 2022 16:41:29
07 Jun 2022 16:41:29 User  replied:
“What does it take for you to write my paper today?” All you need topswriting.com/review/payforessay to do is click the order button. If you don’t know how to do that, leave a message for our live support staff, and we’ll respond immediately. Our ordering process is super-fast and straightforward.
Replied 26 Oct 2022 09:08:45
26 Oct 2022 09:08:45 donna jane replied:
Thank you for sharing the drift hunters article. Good luck. I am also a blogger and I also hope that my article will be known by many people.
Replied 01 Feb 2023 04:31:42
01 Feb 2023 04:31:42 User  replied:
I had a lot of harvest after seeing this post of yours! Before, I used to play games run 3, this is a fun game for entertainment, but now I will follow you, read your articles will have more knowledge.
Replied 03 Feb 2023 10:25:25

Reply to this topic