Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

The Database Forum


You are currently viewing our The Database Forum as a guest. Please register to participate.
Login



Reply
How can one user account have access to another part of the website?
Old 12-28-2009, 09:50 AM How can one user account have access to another part of the website?
Junior Talker

Posts: 4
Name: Kamoga Chris
Trades: 0
I have a website that has two databases because that is what my hosting account provides. One database has got Classified Ads installed on it. The other has got Jokes and Dating installed on it. That makes it three(3) sections of the website. When a user signs up at one section of the website, he/she doesn't have access to other sections of the website.

I want to make it possible for someone to sign up at one section and still be able to access the other two(2) sections of the website. It appears, apparently, that these there sections are not connected at all.

I have MySql, phpMyAdmin.

I will be very grateful for your response as this has turned out to be a very stressing thing.
__________________
KwataDeal.com

Please login or register to view this content. Registration is FREE
KwataDeal.com is offline
Reply With Quote
View Public Profile Visit KwataDeal.com's homepage!
 
 
Register now for full access!
Old 12-28-2009, 10:36 AM Re: How can one user account have access to another part of the website?
chrishirst's Avatar
Missing! presumed drunk.

Posts: 42,385
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
you will have more chance if everything was in a single database, that way a linking relationship could be set up between the tables. And the user tables could be integrated.
__________________
Chris. ->>
Please login or register to view this content. Registration is FREE
<<-

A foolish consistency is the hobgoblin of little minds
Thought for today:- Is SEO the only industry where all the cowboys are Indians?
chrishirst is online now
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 12-29-2009, 05:30 AM Re: How can one user account have access to another part of the website?
Junior Talker

Posts: 4
Name: Kamoga Chris
Trades: 0
Alright, most of the data is in a single database, then how should I go about it. How can a linking relationship be set up between the tables? And how can the user tables be integrated?
__________________
KwataDeal.com

Please login or register to view this content. Registration is FREE
KwataDeal.com is offline
Reply With Quote
View Public Profile Visit KwataDeal.com's homepage!
 
Old 12-29-2009, 07:03 AM Re: How can one user account have access to another part of the website?
chrishirst's Avatar
Missing! presumed drunk.

Posts: 42,385
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
You need to recode the sign up and login routines to use a single user table OR code the signup routines and user management routines to synchronise the various user tables.
__________________
Chris. ->>
Please login or register to view this content. Registration is FREE
<<-

A foolish consistency is the hobgoblin of little minds
Thought for today:- Is SEO the only industry where all the cowboys are Indians?
chrishirst is online now
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 12-30-2009, 12:53 PM Re: How can one user account have access to another part of the website?
Junior Talker

Posts: 4
Name: Kamoga Chris
Trades: 0
Thank you very much for your assistance. I have already tried to do that. But the problem is that I cant figure out how to do it using phpMyAdmin. It is my favourite tool.
__________________
KwataDeal.com

Please login or register to view this content. Registration is FREE
KwataDeal.com is offline
Reply With Quote
View Public Profile Visit KwataDeal.com's homepage!
 
Old 12-30-2009, 01:26 PM Re: How can one user account have access to another part of the website?
chrishirst's Avatar
Missing! presumed drunk.

Posts: 42,385
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
You are not going to accomplish it all with PhpMyAdmin, creating the tables will be ok but you will have to delve into the code of the applications and rewrite parts of it.
__________________
Chris. ->>
Please login or register to view this content. Registration is FREE
<<-

A foolish consistency is the hobgoblin of little minds
Thought for today:- Is SEO the only industry where all the cowboys are Indians?
chrishirst is online now
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Reply     « Reply to How can one user account have access to another part of the website?
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.28878 seconds with 12 queries