My Software Download Site Project
This would be a software download site which will be hosted on Linux server. So it should be programmed in PHP and MySQL. Given below is complete details of my requirements. I will provide the skeleton of the site once I approve a programmer.
Data base Requirement
Table1 for Software
Sub Category ID
Operating System: 95 98 ME NT 2000 XP
Description (2500 chars)
License: SHAREWARE FREEWARE TRIAL DEMO
Approved for Listing
Table2 for Subcategory
Sub category ID
Table3 for Category
Pages required and there functions:
1. Open the Category ID database with Title Sorted
2. Read the Category ID
3. Search the sub categories matching the category ID
4. Display Category Title and all Subcategory Title
5. Move to next category ID till EOF
Display title of 10 latest approved submissions.
Display title of 10 most downloaded software.
Validate and update the software database on the basis of submission form. Will add a new record to the Table 1 and update it in the format given above. It will confirm the user with a confirmation page that the update is done, this page will be provided by me.
Display the Software detail (only title, author name ad email, url, no. of downloads, date of submission etc) based on the sub category ID page wise. Of pages of 15 rows.
Display single software complete detail in the skeleton I will provide.
Based on the keyword user type a query will be done in software title and description and result is shown in tabular form like the display page- page wise of 15 records per page.
Allow me to play with the database, add, edit, and delete records.