Display category results - php & mySQL

IN PROGRESS
Bids
17
Avg Bid (USD)
$185
Project Budget (USD)
$100 - $500

Project Description:
Overview

This php web page will display a list of links for a selected category.? Depending on the number of records returned, you may have to page the results.? You will also need to display a dropdown list of categories that enables the user to select a different category.? You will also need to record which records were displayed, and in which position.

This? is a php and mySQL application.?


















## Deliverables

Overview

This php web page will display a list of links for a selected category.? Depending on the number of records returned, you may have to page the results.? You will also need to display a dropdown list of categories that enables the user to select a different category.

?

Details

The php page will be called via the following URL:

<http://www.mysite.com/getlist.php?PID=____&CID=____&SID=_____&StartNum=_____>

?

where [www.mysite.com][1] is a site I host and I’ll upload the getlist.php file that you’ll write.

?

If any of the 4 values in the URL are missing/blank or if the link is improperly formatted, return an error message.? Otherwise continue.

?

If SID=1, set Num to 2, if SID=2, set Num to 3, else set Num to 4 (Num is the number of records to display in the list)

?

Then query the List table (see definition below) and get all records where CID (Category ID) equals the CID in the URL above, and where Active equals true.? Sort the results by Rank, and store the Position of each record in the resulting array.? For example, if 8 Active records are retrieved, associate Position 1 with the first record in the array, Position 2 with the second record, etc.? Also count the total number of records retrieved, and determine how many pages of results you have, based on dividing the record count by Num.

?

Then, for records retrieved from the query, display up to Num records, starting at StartNum.? Specifically, for each record, display its Name, and hyperlink each Name using a URL formatted as follows: http://www.mysite.com/result.php?SID=_____&PID=______&AID=________&CID=______&Position=_______.? StartNum is the pointer, or offset, that tells you which record in the list to start with when displaying a page.? For example, if StartNum is 1, and Num is 3, and the count of records returned is 10, you will display 3 records (because Num=3) starting with the first record (because StartNum=1), and you will not display the remaining 7.? If StartNum is 4 (and still assuming Num=3 and count=10), you would start with the 4th record and display 3 records.? If StartNum=10, you would only display one record (i.e., record #10) because there are only 10 records.

?

As you display each record, create a new record in a mySQL table to record which records were displayed.? That is, record the date/time, PID, SID, CID, AID and the Position.

?

Next, show paging if required.? That is, if Num is less than count, there are more records to display, so you need to paginate.? Show page numbers (1 2 3 or however many there are ??" we probably won’t exceed 10) along with Prev and Next.? Do not show a page number or the Prev and Next links if there is just one page of results.? Do not link the current page number, but link all other page numbers.? Only link Prev and Next to its corresponding page if that page is currently not being display.? For example, if you’re displaying page 1, do not link Prev, just show Prev in grey. ? ? Note that each page link is the same as the URL that originally called the php page, with the only change being StartNum.? StartNum is simply the starting record number for that page.? For example, if Num=3 and count=10, there would be 4 pages, and StartNum for page 1 is 1, StartNum for page 2 is 4, StartNum for page 3 is 7, and StartNum for page 4 is 10.

?

Finally, show a dropdown list of all categories.? Selecting a new category simply redisplays this same php page with a list for that category.? To generate the dropdown list of categories, query the List table for all Active records, and then generate a list of all unique CIDs.? Then query the Category table (see definition below) to get the CatName and Order for each category.? Display the resulting CatNames in a select dropdown, sorted by Order.? Each select option in the dropdown should be linked to the same URL that calls this page, where CID is the CID of the specific category option, PID and SID are from the original URL, and StartNum=1 (that is, when a new category is selected, we want to display from the top of the list for that category).? Execute upon selecting of a new category (i.e., do not require the user to click a submit button).

?

List Table

-? ? ? ? ? ? ? ? CID (char)

-? ? ? ? ? ? ? ? AID (char)

-? ? ? ? ? ? ? ? URL (char)

-? ? ? ? ? ? ? ? Name (char)

-? ? ? ? ? ? ? ? Active (true/false field)

-? ? ? ? ? ? ? ? Rank (numeric field)

?

Category

-? ? ? ? ? ? ? ? CID

-? ? ? ? ? ? ? ? CatName

-? ? ? ? ? ? ? ? Order

Skills required:
Engineering, MySQL, PHP, Software Architecture, Software Testing
Hire backupvw
Project posted by:
backupvw United States
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.