I am still learning my way around php and using it to connect to databases.
For the site I am building I wanted to include 360 view gallery for each of the products on the site.
However, I do not know how to store the product images in a database, along with product name etc. And then put these images into the gallery so the user can move round the product.
Is this even possible???
Here is a link to the gallery I will be using:http://www.ajax-zoom.com/examples/example15.php
Thank you :)
Have you read the documentation and reviewed the samples this ajax-zoom product refers to?
I generally discourage storing the actual image in the DB, as this puts an unnecessary strain on the DB connection (passing all that data around in query results). Typical usage is to store the image on the web server file system (it is just a file, after all), and store the file name (and directory if needed) in the database, along with any other data (title, description, date/time, etc.).
A database is an organized collection of data. The data are typically organized to model relevant aspects of reality in a way that supports processes requiring this information. For example, modeling the availability of rooms in hotels in a way that supports finding a hotel with vacancies.
Don't waste your time use EDFP library.
Now is very simple to display and edit ( in different ways: text , textarea, select , radio button, date , slider, checkbox, switch on/off button, map, video, colorpicker, password, image, file, html editor ) every field you want from mysql database with EDFF or EDFP library.
1 Include EDFF or EDFP ( Edit Database Field PRO ) library into your project.
2 Just generate code with WDH CodeGenerator.
You can download EDFF or EDFP library and find CodeGenerator here : http://codegenerator.wdh.im
You can find live demo here : http://labs.wdh.im/example.php
Hope that help you !