[Help]Php/mysql
- Thread starter pranay007
- Start date
Inquestor
Well-known member
- Joined
- Feb 1, 2013
- Messages
- 215
- Points
- 0
Alright,
So, I have gave this some thought, You could want to do the following. I do believe it will get you on the right track anyway.
1) You want to the an album as a category. Create an SQL table called "albums" with the following columns (id, name). Then create a second table called "images" (I do not know how much info you want to store ie, user who uploaded, size of image, moderated/approved etc...) As an example create the following columns (id, album, url)
"album" would store the (album id). This way we can create PHP MySQL query like so ("SELECT * FROM images WHERE album=12 ORDER BY id DESC").
Now that was a easy part, now for the PHP.
1) I would create a little script that inserts each day into albums tables (After script is created set it up as CRON JOB every day at zero hour)
2) Create image upload system in PHP
3) Using PHP's ZIP extension, zip up all images after day is over, store link into albums table (create another column called 'zip') This will hold the path to each album zip file in tmp directory or where ever.
4) Call out all variables you desire.
5) There we go
This is just the basic jist to it, If you require more assistance, PM me your code (files). I will see If I can be more help.
So, I have gave this some thought, You could want to do the following. I do believe it will get you on the right track anyway.
1) You want to the an album as a category. Create an SQL table called "albums" with the following columns (id, name). Then create a second table called "images" (I do not know how much info you want to store ie, user who uploaded, size of image, moderated/approved etc...) As an example create the following columns (id, album, url)
"album" would store the (album id). This way we can create PHP MySQL query like so ("SELECT * FROM images WHERE album=12 ORDER BY id DESC").
Now that was a easy part, now for the PHP.
1) I would create a little script that inserts each day into albums tables (After script is created set it up as CRON JOB every day at zero hour)
2) Create image upload system in PHP
3) Using PHP's ZIP extension, zip up all images after day is over, store link into albums table (create another column called 'zip') This will hold the path to each album zip file in tmp directory or where ever.
4) Call out all variables you desire.
5) There we go
This is just the basic jist to it, If you require more assistance, PM me your code (files). I will see If I can be more help.
Last edited:
Older Threads
Newer Threads
Latest Threads
Recommended Threads
Similar Threads
Latest postsNew threads
-
New threads
-
-
How much bandwidth is enough for a growing website?
- Started by Ridoy
- Replies: 1
-
-
Latest Hosting OffersNew Reviews
-
Latest hosting offers
-
Save an incredible 90% off! The Best HostPapa Deal so Far: Unlimited SSL, 50 GB NVMe, 24/7 supportEssentials Hosting provides reliable and affordable web hosting solutions!- cancan
- Updated:
-
Affordable Dedicated Servers - Raspberry Pi & Intel N95 | From €12.90/mo - Unlimited Traffic.Affordable Raspberry Pi & Intel N95 Dedicated Servers with SSD Storage and Unlimited Traffic.- Tinyservers.eu
- Updated:
-
SystemInPlace - Low cost Dual E5 384GB/512GB RAM DEDI. 30% OFF FIRST MONTH! 1gb/2.5gb/5gb/10gbAffordable enterprise grade dedicated servers at a price you can afford.- systeminplace
- Updated:
-
