php multi page order form with mysql database

Looking for volunteers to join your project? Need help with a script but can't afford to pay? Want to offer your services as a volunteer to build up your portfolio? This is the place for you...

Moderator: General Moderators

Post Reply
Andorphin
Forum Newbie
Posts: 7
Joined: Fri Oct 31, 2008 3:44 am

php multi page order form with mysql database

Post by Andorphin »

Hi All

Looking for some help on an issue I have come accross. Due to financial constraints I can't afford to pay someone to do this so I am trying myself...but with work, college and 3 kids, struggling to pick it up.

Background to problem;

I have a company that sells non-geographic phone numbers in the UK (0844, 0845, 0870), I need a form that allows a customer to search for a desired number. The search results displayed will show the 5 closest matches as clickable links.

when clicked on the customer is then taken to an order form. it also removes the selected number from the main numbers database and moves it to a pending allocation database.

page 1 - enter email address (this is then put through a database holding previous invoices, if a match is found the next page pre-populates with existing data, otherwise a blank page 2 appears)

page 2 - full user details, name, email, address, and services requested are selected.

page 3 - confirm order, send invoice to customers email account and a copy to me.

additional request: the invoice sent to the customer has option for payment through 2checkout, and once paid removes the number from the pending database and into an active database.


database names in place (changed for security):

db_available_number
--> field_one - Primary ID - auto increment, Primary Key
--> field_two - number, max length 13 chars, unique key

db_pending
--> field_one - Primary ID - auto increment, Primary Key
--> field_two - number, max length 13 chars, unique key
--> field_three - customer_name
.. user
.. details
.. filling
.. this
.. area
--> field_nine - invoice number, unique key

db_user
--> field_one - Primary ID - auto increment, Primary Key
.. name
.. email, unique key
.. address
.. previous purchases (for loyalty scheme TBA)

db_active
--> field_one - Primary ID - auto increment, Primary Key
--> field_two - number, max length 13 chars, unique key
--> field_three - customer_name
.. user
.. details
.. filling
.. this
.. area
--> field_nine - invoice number, unique key
--> active from - date of activation
--> expires

I do understand that I ask for a lot of help and that it is somewhat unrealistic to ask, but I really do need the help...I don't need it to be styled all I would ask is for it to perform the database actions and multi page form.

I am struggling most with the databse functions, even if someone can only help with that, that would be more than I expect.

many thanks in advnace to the kind person who helps me
and thank you for reading, sorry for asking for so much but I can't do it without this help, but please remember i cannot afford to pay this person but I could provide linkback to them from my 2 sites, mcivorweddinghire.co.uk & fifesouthern.co.uk if that is any kind of concilation?

again may thanks
User avatar
ashel
Forum Newbie
Posts: 4
Joined: Mon Jan 19, 2009 9:05 pm
Contact:

Re: php multi page order form with mysql database

Post by ashel »

I can help, but what is your timeline?

As this would be for free, it would be in my spare time. Let me know.
Andorphin
Forum Newbie
Posts: 7
Joined: Fri Oct 31, 2008 3:44 am

Re: php multi page order form with mysql database

Post by Andorphin »

I would be hoping to launch the form within the next 10 days if that helps.

thanks very much for your interest.
Post Reply