PHP Auction Interface (Javascript, MySQL, PHP, Programming, Web Design / Development)

Home | My Account | Post Job | Browse Jobs | RSS Feeds New!

PHP Auction Interface

Job Summary:

Job Type:	Project
Budget:	$ 20-100
Required Skills:	Javascript, MySQL, PHP, Programming, Web Design / Development
Attached Files:	(None)

Status:	Work Performed (selected user NewWeb)

Buyer Summary:

Username:

Feedback Score:

2 reviews

Award Reliability:

3 posted 3 paid

Location:

Culver, IN, United States

Member Since:

January 3, 2007

Invited Users:

There are no invited users

Description

Create a simple auction interface using PHP, javascript, and mySQL.

No log-in or security is required, just clean, commented, modular, php scripts. I will be adding to this and fitting it within other scripts I�ve already written.

A brief testing period is required before escrow will be released.

It�s basically how you would think of an auction. Here are the details. If something seems amiss, it�s probably my mistake. Use your best judgment and/or ask me about it.

3 Screens/pages:

Bidding screen for showing auction items, previous bids, HTML form elements for submitting a new bid, and form elements for removing an old bid. Include the name of the poster and each bidder�s name or �anonymous�. Also display current user�s money. Disallow (through javascript) any bids greater than the user�s current money.

Auction item posting screen: display user�s items that have not already been posted to the auction. Provide HTML form input for posting these items.

Bid accepting screen: display user�s posted auction items and all associated bids sorted from highest to lowest. Include bidders� names or �anonymous�. Include �accept� buttons for selecting individual bids.

Functions:

Bid � recheck that the bidder has enough money to make the bid. If not, abort. If so, decrement the bidders money by the amount of the bid. If the bidder has bid on the selected item before, delete the previous bid. Insert a row into the auction table with all the columns filled in.

AcceptBid - Transfer ownership of the item to the accepted bidder. Set the item�s �up_for_auction� column to zero. Auction poster gets the money of the accepted bid. All other money bid on this item is returned to the bidders. Remove all bids associated with this auction item from the auction table.

AcceptHighestBid - Transfer ownership of the item to the highest bidder. Set the item�s �up_for_auction� column to zero. Auction poster gets the money of the accepted bid. All other money bid on this item is returned to the bidders. Remove all bids associated with this auction item from the auction table.

PostItem � Set selected item�s �up_for_auction� column to one, indicating the item is available for bidding.

RemoveItem � Set the item�s �up_for_auction� column to zero. All money bid on this item gets returned to bidders. Remove all bids associated with this auction item from the auction table.

RemoveBid � User takes back his money and the bid is deleted from the auction table.

Assumptions:

Current user id and table are stored in a php array $user and the following tables are in the database:

CREATE TABLE `auction` (
`id` MEDIUMINT( 9 ) NOT NULL AUTO_INCREMENT ,
`bid` MEDIUMINT( 9 ) NOT NULL ,
`bidder_id` TEXT NOT NULL ,
`bidder_table` MEDIUMINT( 9 ) NOT NULL ,
`item_id` TEXT NOT NULL ,
`item_table` MEDIUMINT( 9 ) NOT NULL ,
`secret` tinyint(1) NOT NULL default '0' ,
`date` BIGINT NOT NULL ,
PRIMARY KEY ( `id` )
);

CREATE TABLE `buyers` (
`id` MEDIUMINT( 9 ) NOT NULL AUTO_INCREMENT ,
`name` TEXT NOT NULL ,
`money` MEDIUMINT( 9 ) NOT NULL ,
PRIMARY KEY ( `id` )
);

CREATE TABLE `items` (
`id` MEDIUMINT( 9 ) NOT NULL AUTO_INCREMENT ,
`name` TEXT NOT NULL ,
`owner_id` TEXT NOT NULL ,
`owner_table` MEDIUMINT( 9 ) NOT NULL ,
`up_for_auction` tinyint(1) NOT NULL default '0' ,
PRIMARY KEY ( `id` )
);

Reminder

You may not start working in this and any request before your bid is accepted. Users who violate this policy may have their accounts permanently suspended.

Bids Received (24)

Shortlist (0)

Declined Bids (0)

Average bid amount:

$160.04

Average delivery time:

7 Day(s)

| | |

Order by:

Remember that contacting the other party outside the site (by email, phone, etc.) on all business jobs (before the request is awarded) is a violation of our terms of use. We supervise all site activity for such infringements and can immediately expel transgressors on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thank you for your help.