checkout page for cart script

Hello. I am new to PHP and I love it! I just got a shopping cart script working (from the php/mysql cart tutorial on this site).

My problem now is that I need a checkout page that displays the final cost, asks for customer details (name, email, phone, address, cc number etc) and then emails all that info to me.

I know I can do it but I just need someone to jump start me. I'm good at adapting existing scripts to suit my needs.

I'd really appreciate any help on this as this is my first php/mysql project and I would love to see it in action soon!

Thanks for all your help.

Inas

Hi!
Give me the table name and the table columns of the shopping cart and if you have an users table, give me the name and the columns that I'll help you build the checkout.

Thanks Ramz,

I don't have a users table...but here are the tables for the cart:

cartId
cookieId
itemId
qty

Thanks again. Also, do you know how I can add a set shipping charge to the total cost of any order?

I know this is all probably very easy but I'm very new to all this

Take care

Inas

Hi!
I need a little bit information.

1.) Are you using a database class or connecting it in every .php file?
2.) I need the name of the columns of the item table.
3.) You'll need to create a users table (I'm sending here an attached file with a SQL for this - I suppose that you're using MySQL)
4.) You'll need a checkout table too (it's with the SQL file either)
5.) If a person is going to buy something from you through the internet, this person might be from your city, other city/state or even other country. So I need to know the shipping prices for these kind of situations. For example: If I live in your city, how much does it cost for the shipping. If I live in another state, what's the price for the shipping and if there's more than one shipping method (Like Fedex, UPS...). I live in Brazil, so for Brazil I know how things works, but for where you living in I don't =)
6.) Does your server offers you SSL?! It's called Secure Socket Layer, this makes sure that the information about the credit card is typed in a secure mode.

I guess that is all by now... If I need anything else I post another message.

Here's the SQL:

Type it at the MySQL prompt...

create table user (
user_id int(11) not null auto_increment,
user_name varchar(50) not null,
user_email varchar(100) not null,
user_address varchar(120) not null,
user_city varchar(60) not null,
user_nhood varchar(60) not null,
user_zip varchar(5) not null,
user_country varchar(60) not null,
user_pass varchar(30) not null,
user_phone varchar(14) not null,
primary key(user_id));

create table order (
order_id int(11) not null auto_increment,
order_date date not null,
order_qty tinyint(3) not null,
order_price decimal(4,2) not null,
user_id int(11) not null,
itemId int(11) not null,
primary key(order_id));

Hello Ramiro,

Thanks again for all your help. I once knew the daughter of the Brazilian ambassador to

Cairo so I already know that Brazilians are very kind people!

Here's the info you want:

1. I am using a database class (db.php)

2. The items table has the following columns:

itemId
itemName
itemDesc
itemPrice
itemPic

3. Orders coming from within Egypt should be payable cash on delivery with an added

delivery charge of LE5.00. All items on the site are sold in US dollars so users who want

to order in Egypt have to convert the total cost to Egyptian pounds before adding the

LE5.00 delivery charge.

Orders outside Cairo, Egypt should be payed for in US dollars by credit card with an added

shipping charge of $10.00.

4. My remote server does not offer ssl for now.


I hope all this helps, and thanks again for your support and time.

Take care

Inas

Ok Inash...
I'll do something here today and post tomorrow for you to do or change... but, I don't know if you're new to this stuff (php, servers, programming)... but passing credit card numbers without ssl is too dangerous. Malicious persons (hackers/crackers) can discover this information by a lot of techniques. I can still help you with this process, but I can't guarantee a security against it, ok?!

Thanks Ramz,

In the meantime I'll talk to my provider about upgrading to a hosting package with ssl.

Take care


Inas