Member Avatar for LRNPHP

Hi Everyone.

I have MySQL db with images in(MEDIUMBLOB); I would to display the images in a gallery fashion with a MySQL select command.

Any help would be appreciated.

Regards

  • 3 Contributors
  • 2 Replies
  • 103 Views
  • 22 Hours Discussion Span
  • Latest Post Latest Post by vibhaJ
Member Avatar for theighost

put the paths in the database, put the a column for ordering the images in the gallery, the id of the image for example, or the day the image was added.

then in the slide show select from the database by ordering according the column (the id, or the adding date).

you can use ajax to swithc between images, or a function that returns the next image and another one that returns the previous image (php, or other server side language).

you have to use your imagination to make these things, when you're stuck in a point write here and people can answer your questions easily, a general question is hard to be answered :)

Member Avatar for vibhaJ

use any good jquery gallery.
check this : Jquery Lists

Once you download script and demo is working in you pc,
replace static images to dynamic images.

Dynamic images will comes from select query results.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.