What is the correct way to store Pictures and Hyperlinks within a MySQL database so they can be displayed when the user searches for what the pictures & hyperlinks relate to? For example:
If I'm designing a shopping cart for the products I sell that are books on tape then what do I have to do to allow customers to search through the database for the book they want and if it's in stock to show a picture of the book (along with description and so forth) plus a hyperlink which refers to a real audio file which is an audio sample of what the book on tape they are interested in sounds like.
What is the correct way to store Pictures and Hyperlinks within a MySQL database so they can be displayed when the user searches for what the pictures & hyperlinks relate to? For example:
If I'm designing a shopping cart for the products I sell that are books on tape then what do I have to do to allow customers to search through the database for the book they want and if it's in stock to show a picture of the book (along with description and so forth) plus a hyperlink which refers to a real audio file which is an audio sample of what the book on tape they are interested in sounds like.
I'm not actually making a shopping cart, I'm using it as an example to learn how to write such scripts and so forth. I would prefer to learn how to do it all myself, because the knowledge gained from such an application would benefit other scripts I may one day decide to write.
Store the path to the picture filename. Somewhere store the ImageDirectoryPath so when you move to another domain name you still have control over the display of the pictures
picture varchar(50) NOT NULL default '',
url varchar(128) NOT NULL default '',
Linear Mode
