Show Bid Request PHP mySQL Survey Database Bid Request Id: 26192 Bookmark in my 'To Do' list Posted by: markrose (3 ratings) (Software buyer rating 10) Non-action Ratio: Very Good - 22.22% Buyer Security Verifications: Good Approved on: Sep 3, 2002 1:32:26 AM EDT Bidding Closes: Sep 4, 2002 2:20:31 AM EDT Viewed (by coders): 841 times Deadline: 9/6/2002 TIME EXPIRED Phase: 100% of work completed and accepted. Coder has been paid. Max Accepted Bid: Bidding is closed Project Type: Small Business Project: $100 (USD) + Bidding Type: Open Auction Categories: Database, PHP Enter chat room for this bid request (0 active users at Aug 17, 2003 7:35:18 AM EDT) Description: I'm part of a group doing some educational research and we're gathering the questionnaire results using face to face interviews. The interviewer's notes will be used to enter data into the database. Some of the survey questions will be yes/no/don't know, some will be a numerical values, some will be multiple choice, and some will be open-ended. The important thing is that we must be able to pull up and sort any combination of the data from all the records and all the survey questions. We must be able to sort as follows: 1) By survey record (a numeric ID we will assign to each survey) 2) By name of interviewee (last name, first) 3) By letter-code assigned position of interviewee (a letter code we will come up with) 4) By ACTUAL position of interviewee (a text-based description) 5) By individual conducting the interview (last name, first name) 6) By date of interview (00/00/00) 7) By district name (text field, ie., East River School District) 8) sort by survey question Each survey question will need two fields. One will be a field for a coded answer - either numeric or text answer (ie., Y for yes, N for no and D for Don't Know). The other field required for each survey question will be a "comments" field to record ACTUAL interviewee answers/comments for that question, for later study, if necessary. For Yes/No questions, a simple Y, N or D (Don't Know) will do. In cases where a numeric answer is expected a whole number might not be used, we need to allow for fractions (ie., "How long have you had an building plan in place?") If the response is 1.5 years, we need to be able to add that to other responses and divide by the total to get an average for that question. We'll also need to generate a current overview for the database, something like this... =========================== Survey Database (Currently 9 Records, latest entry August 12, 2002) QUESTION 1 YES(3/30%) NO(3/33%) DON'T KNOW(3/33%) QUESTION 2 LOW(1.5) HIGH(5.5) AVE(3.5) DATA = 1.5, 2, 2, 1, 1, 4, 4, 4, 5.5 QUESTION 3 A(1/11%) B(3/33%) C(5/55%) D(0) E(0) ====================================================== We'll also need to be able to export data to a CSV file, tab delimmted file, or a text file and either show it on the screen save it to disk, or email it as an attachment. see http://www.whirligig.com/survey.pdf for the survey questions and http://www.whirligig.com/survey for a mockup of what I wznt. Deliverables: Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased. Platform: The platform is PHP / mySQL running on NT server. see http://www.whirligig.com/survey.pdf for the survey questions and http://www.whirligig.com/survey for a mockup of what I want. Must be 100% finished and received by buyer on: Sep 6, 2002 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. Special Conditions / Other: Need ASAP 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   Anuj Gakhar (60 ratings) in Ludhiana, Punjab India Bid id: 297,026 N/A Sep 3, 2002 7:34:18 AM EDT  9.97 (Excellent)     Thanks for inviting. But $100 is too less for me to take over this project. Thanks Anuj           See 12 private reply(ies) to/from Anuj Gakhar.