GetACoder.com

 
 

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

 

PHP Auction Interface

 
 
Download the Free Step-by-Step Guide
     
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:
NealHolts  
Feedback Score: 8.50/108.50/108.50/108.50/108.50/108.50/108.50/108.50/108.50/108.50/10 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)
Place Bid | Post Similar Job | Send Request | Contact NealHolts

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.
 

 
 


 
Get the Free Step-by-Step Guide on How to Use GetACoder
The act of outsourcing jobs has become easy in the past few years thanks to GetACoder. However, our team aims at making the whole process even easier. So, it has now come the time to provide you with a step-by-step guidance on how to use this service and succeed in the outsourcing world totally for FREE.

It doesn't matter if you are a more experienced user or a novice; using GetACoder will become even simpler with the help of this E-book. There are two major sections: a Buyers section and a Coders section.

Buyers will learn:
  • How to outsource safely
  • How to pick the best freelancers
  • How to manage time and money

Coders will learn:

  • How to get the best jobs
  • How to secure their payments
  • How to build a long-lasting relationship with buyers

    ...and MUCH MORE
Clear examples and pictures illustrating key situations, great tips and real testimonies of some of our best users... all in this Outsourcing Guide.  So don't loose the outstanding opportunity to download GetACoder FREE E-book.
The Outsourcing Revolution: Why It Makes Sense and How to Do It Right
The Outsourcing Revolution: Why It Makes Sense and How to Do It Right
What is GetACoder?

GetACoder.comGetACoder is a leading Global Services Marketplace doing business in more than 200 countries. Our unique system accelerates your time to market and provides your business with key competitive advantages. When you use GetACoder you are stretching your budget and saving as much as 60% over traditional outsourcing. GetACoder is changing business, now it's no longer about what you own or build but which resources and talent you can access. With GetACoder you reduce expenses, increase efficiencies, aggressively grow your business, and create a sustainable competitive advantage. GetACoder makes outsourcing to any part of the world an easy task! With GetACoder it's simple to outsource any business request, gain access to global talent and manage jobs online.

One of the main advantages of GetACoder is the low labor cost. The typically rates are about seven times lower than the ones in the US or Europe. Posting a request at GetACoder allows the right professional or company to find you and to bid for your work. We are building a reputation for exceeding our customers' expectations and for becoming an extremely cost effective way to outsource work. Use GetACoder when you want to save money, increase efficiency or accelerate the development of your request. With GetACoder you focus on growing your business and let others do the tedious work. Post your request on GetACoder for free. Find out why people outsource jobs with us day after day.

Thousands of Satisfied Customers - Submit/View Quotes


-It’s a wonderful site. I'm really happy to know about this site. - pritesh
-Getacoder is a good income source for me! - ravian
-I'm still amazed about the quality of the customers in GetACoder.com. It's not usual to see such serious customers in freelancer's sites; that's definitely the key feature of GetACoder. The "projects bid"/"projects won" is definitely the best around the internet. - codigodelsur
Report Violation    Privacy Policy     Affiliate Program    Terms of Use    Contact Us    Help      GetACoder.com on Facebook      Follow GetACoder on Twitter      GetACoder.com Latest Requests RSS Feed
© 2004-2012 GetACoder. All rights reserved.