295923 db file display & template
N/A
Dibayar saat pengiriman
File db display & template
A client of mine sells paintings. I am now looking for an easy way to update the site. I do not require design, only example working templates. I am looking for a PHP / Flat text file solution as follows:
1. Painting details are stored in a text file that can be updated via a password-protected admin screen.
2. PHP templates that will display Artists paintings as thumbnails, with an option to click and enlarge.
3. Other options (functions?) to display other information contained in the database.
4. The creation of the template should be flexible. I will consider working with an existing template solution.
Please feel free to suggest improvements.
Flat Text File Summary
1. The file consists of an artist and a list of paintings ending with a blank line.
2. I did not have the artist's name on each line in order to save space.
3. The artist's name also has an abbreviated "index", used to access the records.
4. The files used | as a delimited, but another character might be better.
5a. The file includes fields for the thumbnail image, and the full-size image.
5b. The image width and height is used to [img src=[url removed, login to view] width=400 height=200].
a. It would be nice if the admin screen could retrieve this information from the images.
b. And if it could get the details for many selected items
6. "Type" is used to categorise the images. Values could include: Ltd | Something | [blank]
It is to let us display images whose type is "Ltd", or other.
7. "Status" is also used to categorise, and special values include:
Hide: Do not display this item
New: A new item, which may be displayed separately
8. All fields are text only.
9a. The price field include the currency symbol
9b. The price field may indicate "SOLD" which would be displayed in red.
10. The item Cat No is to specify each different image.
Flat Text File details
----------------------------------------------------------
Index | Artist's Name
Cat No | Painting Name | Media | Size | Price | Image name | Width | Height | Thumbnail | Width | Height | Type | Status
Cat No | Painting Name | Media | Size | Price | Image name | Width | Height | Thumbnail | Width | Height | Type | Status
Cat No | Painting Name | Media | Size | Price | Image name | Width | Height | Thumbnail | Width | Height | Type | Status
Index | Artist's Name
Cat No | Painting title | Media | Size | Price | Image name | Width | Height | Thumbnail | Width | Height | Type | Status
----------------------------------------------------------
Flat Text File example:
----------------------------------------------------------
Smith | John Smith
js01 | Nice Flowers | Oil | 27x27" | £25 | [url removed, login to view] | 476 | 256 | [url removed, login to view] | 96 | 80 | Ltd |
js02 | Red Apple | Oil | 20x20cm | £1000 | [url removed, login to view] | 400 | 196 | [url removed, login to view] | 160 | 80 | |
js03 | Blonde Girl | Silk | 10x20" | SOLD | [url removed, login to view] | 476 | 256 | [url removed, login to view] | 124 | 80 | | NEW
js04 | Red & Blue | Oil | 10x20" | £100 | [url removed, login to view] | 333 | 256 | [url removed, login to view] | 98 | 80 | | HIDE
Jones | Sally Anne Jones
sj01 | Elk and cat | Litho | 50x20cm | £125 | [url removed, login to view] | 400 | 228 | [url removed, login to view] | 96 | 80 | |
----------------------------------------------------------
Admin Screen Summary
1. Password access required.
2. Would like to display as much information as possible on the page, ie. all items by all artists, rather than just one item at a time.
3. Add / delete / edit artist
4. Add / delete / edit item
5. Browse... image filename
6. Get image Height/Width
7. View image (pop-up
8. Move item up/down
Template Summary
1. I would like to see separate functions that can be fairly easily copy and pasted to different pages. Perhaps an [include] file, or .js file for common libraries?
2. For example, if I want to display some information from the database, I would enter something like [? echo db(smith,js02,title)?]
3. PHP to generate more complex HTML to display image and item information (please excuse descriptive syntax):
eg. to generate a clickable thumbail with item information:
[a href="javascript:popup('[url removed, login to view]')"]
[img src=[url removed, login to view] width=124 height=80 alt="Blond Girl" title="Blond Girl (Click to enlarge)"][/a][br]
[p class="artist"]John Smith[/p][br]
[p class="title"]Blonde Girl[/p][br]
[p class="media"]Oil[/p] [p class="size"]10x20"[/p][br]
[p class="sold"]SOLD[/p]
3. As above, but only for items whose status is "New"
4. As above, but for ALL paintings by an artist (probably combined with '3', above). Of course I won't necessarily know how many paintings by an artist are in the database.
5. Note that some of the database fields have conditional information:
a. If the price is set to "Sold", then this is displayed in a different colour than the price.
b. If ALL the paintings by an artist are to be displayed, do not display thosed whose Status=Hide
c. It might be required to display all paintings, for example, whose type=Ltd.
6. I will need to be able to specify the maximum number of thumnails on a row (for example, 5).
7. Here are some practical examples of the sort of things I'd want to generate:
a. Show a specific thumbnail painting, and underneath showing the author, title, media, size and price. Clicking on the thumbnail shows the painting full size in a pop-up.
b. Show all the thumbnail paintings by a specific artist, selected from a list of artist names and links.
c. Show all the thumbnail paintings by a specific artist that are type=Ltd, selected from a list of artist names and links.
See Attached Files below to see a formated version of this file.
ID Proyek: #2042231
