 |
 |
 |
 |
|
|
Date: 05/29/01
- Next message: Gerald Howse: "Re: [phplib] [for Menu Bar] creation of GIF image buttons in PHP - won't accept more than one word"
- Previous message: Paul Campbell: "[phplib] Uploaded files, fail to show."
- In reply to: RPfeif123 <email protected>: "[phplib] pathnames instead of pictures in the database - who tried it?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
I did it using the following tables
describe PHOTOS;
+-------+----------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+----------------------+------+-----+---------+-------+
| PID | varchar(10) | | PRI | | | Photo ID
| DATE | date | YES | MUL | NULL | |
| TDATE | varchar(20) | YES | | NULL | |
| PDESC | text | YES | | NULL | |
Description
+-------+----------------------+------+-----+---------+-------+
describe IMAGES;
+-------+----------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+----------------------+------+-----+---------+-------+
| PID | varchar(10) | | MUL | | | Photo ID
| TYPE | smallint(4) | | | 0 | | Type
| HGT | smallint(4) unsigned | | | 0 | | height
| WID | smallint(4) unsigned | | | 0 | | width
| FILE | varchar(130) | | PRI | | | path
+-------+----------------------+------+-----+---------+-------+
This allows for multiple image files for a single photo, so you could
have a thumbnail, jpeg for the web and an original TIF. Then you only
need to convert the path from from filesystem to webserver unless you
store it as a web path.
-Steve
RPfeif123 <email protected> wrote:
>
> Hello,
>
> anybody knows a way for instead of putting pictures (.gif, jpg) directly in a
> database MYSQL (what ist a bad way for the database performance), only
> putting their pathnames, where you can find them in the directory on the
> server (...\images), in the database and after transferring the pictures
> over a php3 - skript and the select -order in a html-document?
>
> Thanks in advance Ralf
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: phplib-unsubscribe <email protected>
> For additional commands, e-mail: phplib-help <email protected>
---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-unsubscribe <email protected>
For additional commands, e-mail: phplib-help <email protected>
- Next message: Gerald Howse: "Re: [phplib] [for Menu Bar] creation of GIF image buttons in PHP - won't accept more than one word"
- Previous message: Paul Campbell: "[phplib] Uploaded files, fail to show."
- In reply to: RPfeif123 <email protected>: "[phplib] pathnames instead of pictures in the database - who tried it?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]