Questions about databases?

F

Freckled

New member
Hello I have customer that has some questions about databases and carts.

Here is what she is requesting.
That site will be for free information.
What they can do is click on the information that they are interested in and they will either get a call or information in the mail.
So every person that advertises with me will only pay once someone puts their info in their shopping cart. So each advertiser has to have their own database. They will each have access to it anytime they want. Depending on what they want, if they just want name and home address they can have that. If they want name, address and phone they can have that too.
So that's why we need to be able to utilize the shopping cart and multiple databases.

What is the best way to handle something like this. My concern is the mulitple databases that the advertiser needs to access. Is there a great program for this already that will pass the shopping cart info to different databases all within the same account and at the same time create a database that is accessible to the advertiser that other advertisers can't access?
 
Why dont you not use multipile databases and store it all in one. Then give each of the sellers access to part of the database according to their username / password entered when loggin on. That seems to be the easier way to do that.

Have the person login to an admin area... then all sales revoving around their user ID will be looped and posted to a page so they can view it.

Just an idea
 
Hi Jon, thanks for the quick reply,
So what you are saying is in Mysql create the database for the cart, then assign multiple users with their own password.

Then I get kinda lost

Have the person login to an admin area...
Do you mean the carts admin?

then all sales revoving around their user ID will be looped and posted to a page so they can view it.

Not sure how this last part would be done. You know how something is right on the edge of the brain, just can't access it well that is how this feels. LOL
 
What about giving them their own table in the database so you do username_tblname so each have a unique username and then they can access information only within the username_ tables?

That would be better than each getting their own database
 
Why not simply have a customer_id in the customer & sales table, when the customer logs in then you can simply filter by customer_id

for example

customer table

customer_id, username, password

sales table

sales_id, customer_id, name, address, product

when the customer logs on and enters username / password, you can then obtian the customer_id and store it in a local variable, when they want to view their sales

select name, address, product from sales where customer_id = $customer_id
 
monaghan said:
Why not simply have a customer_id in the customer & sales table, when the customer logs in then you can simply filter by customer_id

for example

customer table

customer_id, username, password

sales table

sales_id, customer_id, name, address, product

when the customer logs on and enters username / password, you can then obtian the customer_id and store it in a local variable, when they want to view their sales

select name, address, product from sales where customer_id = $customer_id
Click to expand...

This would be the best route, I would think. Most of my PHP scripting does this in the database. It makes it so much easier that way.
 
Thanks everyone, all great ideas, only thing is these ladies are pretty new to all this and I need to keep it as uncomplicated as possible for them so will have to consider best way to do it for them, otherwise I will be called on to do all this for them and I don't mind setting stuff up but they have to be able to manage it afterwards. Will let you know how it turns out.
 
You must log in or register to reply here.

Supporters

Back
Top