Show Bid Request Add Forms To 2 Pages W/ MySQL DB Access Bid Request Id: 70361 Bookmark in my 'To Do' list Posted by: jhobuss (2 ratings) (Software buyer rating 9.5) Non-action Ratio: Very Good - 0.00% Buyer Security Verifications: Excellent Approved on: Jun 27, 2003 12:08:39 AM EDT Bidding Closes: Jun 28, 2003 7:18:47 PM EDT Viewed (by coders): 57 times Deadline: 7/1/2003 TIME EXPIRED Phase: 100% of work was accepted by buyer. Coder account has been credited. Max Accepted Bid: Bidding is closed Project Type: Very Small Business Project: under $100 (USD) Bidding Type: Open Auction Categories: ASP, UNIX, MySQL Enter chat room for this bid request (0 active users at Jul 12, 2003 5:44:33 AM EDT) Description: I need some minor changes made to an existing website. The pages are in html, and I have MySQL. I need the following built: 1) Contact Us page with form that sends email to me. The page is there -- I need the form added to it with sending of the email. 2) Creation of a MySQL database, with 2 tables: subscribers and removelist 3) Subscribe to newsletter page with a form added to it to add an email address to the subscribers table. The page is there now -- I need the form added to it that will validate the email address entered, and then insert a row in a table. 4) Remove page with a form that adds a row to the removelist table. The Remove page is currentlly there -- I need the form added to it that will insert a row in the DB when a valid email address is entered. Maximum bid accepted is $20. If you have a good rating, and offer a good price, this one is yours. Deliverables: 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Complete ownership and distribution copyrights to all work purchased. Platform: Unix html asp MySQL Sendmail Must be 100% finished and received by buyer on: Jul 1, 2003 EDT Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date. Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements. We monitor all site activity for such violations and can instantly expel transgressers 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. Thanks for your help.   Bidding/Comments: All monetary amounts on the site are in United States dollars. Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. See all rejected bids (and all comments) Name   Bid Amount    Date   Coder Rating   This bid was accepted by the buyer! Luiz Guilherme (1 ratings) in Rio de Janeiro, Rio de Janeiro Brazil Bid id: 753,888   $10 (USD) Jun 27, 2003 12:38:54 AM EDT  10 (Excellent)     As you already have the pages designed and I still don't have a rating, my bid is $10. The project includes: - Install phpMyAdmin for maintaince of the MySQL database (it's free, opensource and it's the best software for it). a gift ;) - Setup your new database with tables subscribers and remove-list - Make a PHP script to add a new subscriber - Make a PHP script to move a subscriber from the subscribers table to the remove-list table (don't simply add a second record) - Add a form to pages subscribe and removelist to get the subscriber data and call those scripts Questions: - What you mean by validating the e-mail address? Do you mean the e-mail syntax or do you want to send the new subscriber a check message that he needs to answer back to validate his address? It would cost more and is not recommended for a opt-in page. I just need to be sure of what you really want... Regards, Luiz Guilherme M. Kímel dos Santos RJ - Brazil           See 27 private reply(ies) to/from Luiz Guilherme.