Prev | Current Page 202 | Next

Emilian Balanescu and Cristian Darie

"Beginning PHP and MySQL E-Commerce: From Novice to Professional, Second Edition"

You could keep the picture
directly in the table, but in most cases, it??™s much more
efficient to store the picture files in the file system and
have only their names stored into the database. If you
have a high-traffic web site, you might even want to
place the image files in a separate physical location (for
example, another hard disk) to increase site
performance. This field allows NULLs.
image_2 varchar(150) Stores the name of a second picture of the product, which
gets displayed on the product details page. It allows NULLs.
Field Name Data Type Description
thumbnail varchar(150) Stores the name of the product??™s thumbnail picture.
This image gets displayed in product lists when
browsing the catalog.
display smallint Stores a value specifying in what areas of the catalog
this product should be displayed. The possible values
are 0 (default), meaning the product is listed only in
the page of the category it??™s a part of ); 1, which indicates
that the product is also featured on the front
catalog page; 2, indicating the product is also featured
in the departments it??™s a part of; and 3, which means
the product is also featured on both the front and the
department pages. With the help of this field, the site
administrators can highlight a set of products that will
be of particular interest to visitors at a specific season,
holiday, and so on.


Pages:
190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214