W.I.P. - All in one gallery

[FraXTC]

Okay, I'm starting this topic becoz I want to create a program and it's easier to put all the questions in one topic 🙂. The program should be able to uploads pictures, creates thumbnails from them and places them in a gallery. This all fully automated.. This way you only have to upload it to a specific gallery and the code does the rest (easy when you'want to share holiday-photo's and stuff

First ofcourse I want to start with planning how I'm going to do this stuff

I Thought up the following system:

Create a seperate php file for :

Uploading
creating thumbs
The Gallery
Settings (just full of variable declarations)

And one file (index.php?) that connects the bits together

All the info will be located in a MYSQL database

The idea is that the index.php will clearly show how the program works, using include keeps the bits easy to read, and makes it easier to adjust the code (is my guess)

So to get this thing working I need info (I'm not asking you for this info right away, I'm just summing up) about:

• Uploading
• Paginating
• Creating / altering images

Is this a good approach to go and program? If I'm missing anything plz tell me 🙂

[bad76]

Hi,
not so bad.

I think it's easy to start with show the img from mysql.
Put the images by hand, with phpadmin or other, then try to put it in an html page (such as <img src="getimg.php?imgID">..).

• connect mysql
• do any sql query
• show the image in blob

When is right, loop for more than one image.

Then if all is right, try to paginating.

• limit the query
• put nextpage,prevpage link at the bottom.

At end upload.

• make a form and put file on db.

good luck

[edit]
i forgive... first at all you must do a good design for the db.

[FraXTC]

I am wondering .. I could try to define functions instead of including??? What's best u think?

[bad76]

...mhhh...
i use 4 file .php for any db:

p1: the first is the form to create/update/cancel any entry, in this case any image.

p2: the second is a form to do any search.

p3: do the SELECT with any search parameter , if exists. This is paginated

p4: the last do the insert, update and delete.

My index are usually a menu of 3 link: create, search, list

create call p1 with no param (=> the from is empty) that call p4 for an insert.

search call p2 that call p3 with search param, that call p1 with selected id (=> the form is full) that call p4 for a delete or update. May be cool to switch directly to p4 if found=1...

list call p3 with no param that call p1 with selected id (=> the form is full) that call p4 for a delete or update.

This will reduce to min the code shared from more file...

Use of include it's usefull but must be care because sometime we have to send param with get & post together. (but if you look my www it's made with include...)

The function is usefull if any work must be done in more place.
e.g. the connection to db that is done by every page...

I hope this answer to you...

see you