Creating a user account for a retailer on my site.

[heartdesign]

Hi, I need a bit help of please.

I am trying to create a section on my website for retailers so that they can create an account with username and password that will have there information, shop details, details of there last order saved and allow them to place another order.

I understand that this will require php and mysql? I think at least.

I have tried creating a mysql a couple of times but have never managed it.

If people could please decribe in real lamens terms what it is i need to do that would be great. I'm not so hot with coding or trying to work out mysql.

All help appreciated.

Thank you, i look forward to hearing your ideas.

[pipesportugal]

Re: Creating a user account for a retailer on my site.

Hi,

Please watch the form tutorials:

http://www.vodahost.com/vodatalk/forms/9349-bluevoda-forms-tutorial-part-1-a.html

http://www.vodahost.com/vodatalk/forms/9350-bluevoda-forms-tutorial-part-2-a.html

Even though I am sure that You would eventually learn how to do it in php/mySQL, I would recommend You to register at vodabids and place an add there so that a programmer could do it for You with a professional aspect, I mean.

The other choice is to slowly move one foot after the other and when the doubts arise, to place them here.

I am sure that You will have many people willing to help/teach You at this forum.

pipesportugal

[heartdesign]

Re: Creating a user account for a retailer on my site.

Hi, thanks for the reply but I already know how to make a form.

I now understand what I'm after is a little bit tricky so I want to make it simpler.

I understand that if i create a very simple login for users that they will all be directed to the same page, but how can I make it so that they are each directed to there own personal page, eg, so the page says welcome joe bloggs.

any ideas? i've been trauling php sites for days c'mon help a bluevoda user out here.

Many thanks.

[pipesportugal]

Re: Creating a user account for a retailer on my site.

Ok !
Let's give it a shot:
Step 1: Create the mySQL database
a) Go to cpanel (place a "/cpanel" in front of Your website name at the browser line)
b) Choose Option mySQL Databases
c) Write the name You want to give the database, for example "heartdesign" and then hit the button "Create Database"
d) Next screen will tell You "Database Created" - Choose "Go Back"
e) Now You are able to see Your database created VodaHost allways adds at the begining of database heartdesign a prefix that is Your login name at cpanel followed by a _.
For example if You login name is abcdef and You have choosen as database name the word "heartdesign", the database name will be "abcdef_heartdesign".
Are You following so far?
f) Now Choose a username for You database and a password for accessing the database:
For example You choose "peter" as username and "peters" as password, again Vodahost will create a user with name "abcdef_peter".
g) Next screen will tell You "Account Created" - Choose "Go Back"
h) Now You must add users to the database, choose the user "abcdef_peter" for the database "abcdef_heartdesign" and then hit the "Add User to database" Button.
g) Next screen will tell You "Account added to access list" - Choose "Go Back"
And that's it the database has been created.
Let's start from here ?
pipesportugal

[auntiebebs]

Cannot add records to table in mysql

hi there.
i am new to this forum. this is my first posting. dont know if i am in the right topic. pls.excuse if i am not.

here's my case.
1. i have finished the forms
2. i have finished creating the database then tables in mysql.
3. i cannot use the tables on the forms.
4. i have successfully installed abvfp, and still cannot make it work. i mean it worked only on the sample, but not on the forms i created.

need help. appreciate any response. thanks.

[navaldesign]

Re: Creating a user account for a retailer on my site.

Can you please provide links to your forms ? I will have a look.

[galoup]

Re: Creating a user account for a retailer on my site.

I'm sorry for being so slow. But after creating the user accounts in mysql. Where do these users go to login. And what are they able to access?

[davidundalicia]

Re: Creating a user account for a retailer on my site.

Ok !
Let's give it a shot:
Step 1: Create the mySQL database
a) Go to cpanel (place a "/cpanel" in front of Your website name at the browser line)
b) Choose Option mySQL Databases
c) Write the name You want to give the database, for example "heartdesign" and then hit the button "Create Database"
d) Next screen will tell You "Database Created" - Choose "Go Back"
e) Now You are able to see Your database created VodaHost allways adds at the begining of database heartdesign a prefix that is Your login name at cpanel followed by a _.
For example if You login name is abcdef and You have choosen as database name the word "heartdesign", the database name will be "abcdef_heartdesign".
Are You following so far?
f) Now Choose a username for You database and a password for accessing the database:
For example You choose "peter" as username and "peters" as password, again Vodahost will create a user with name "abcdef_peter".
g) Next screen will tell You "Account Created" - Choose "Go Back"
h) Now You must add users to the database, choose the user "abcdef_peter" for the database "abcdef_heartdesign" and then hit the "Add User to database" Button.
g) Next screen will tell You "Account added to access list" - Choose "Go Back"
And that's it the database has been created.
Let's start from here ?
pipesportugal

Just to add to pipesportugal's well written description...........watch the "creating a database" video as well

[davidundalicia]

Re: Creating a user account for a retailer on my site.

I'm sorry for being so slow. But after creating the user accounts in mysql. Where do these users go to login. And what are they able to access?

The original opener of this thread (and other members) have to realize that this is not a simple thing to achieve.

This is more a job for a PHP expert than for someone new to PHP and simply cannot be explained/taught through these forums.

[galoup]

Re: Creating a user account for a retailer on my site.

Understood. But in pipe's case, where do his people go to log in? I mean after he creates the users in mysql. Is it on his website somewhere?, in cpanel? He's created this account for this user. Now. Where does this user log in. after piper creates this access?

[Karen Mac]

Re: Creating a user account for a retailer on my site.

The user gains access via a page with a login form. He types in his name and password and is given access to certain pages associated with this form or account.

Karen

[davidundalicia]

Re: Creating a user account for a retailer on my site.

Understood. But in pipe's case, where do his people go to log in? I mean after he creates the users in mysql. Is it on his website somewhere?, in cpanel? He's created this account for this user. Now. Where does this user log in. after piper creates this access?

galoup

see this page for the type of registration, login, change password, and logout database forms required.