User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 426,336 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,406 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser: Programming Forums
Views: 1591 | Replies: 3
Reply
Join Date: Jun 2004
Location: H4x0rville
Posts: 2,105
Reputation: server_crash is on a distinguished road 
Rep Power: 9
Solved Threads: 18
server_crash's Avatar
server_crash server_crash is offline Offline
Postaholic

phpmyadmin --- several services to use one database

  #1  
Oct 18th, 2005
I know it's possible, but I'm not sure how. I need several services to use one database. For instance, I need blogs,chat, and a forum to share a database so that when you sign up at one place, you are automatically signed up at all of them.
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Jan 2005
Location: Sheffield, UK
Posts: 294
Reputation: zippee is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 6
zippee's Avatar
zippee zippee is offline Offline
Posting Whiz in Training

Re: phpmyadmin --- several services to use one database

  #2  
Oct 18th, 2005
To do this you need to design the database with one command table that handle all information required for diferent services. For example you will have a table_user to keep username, password, email, date etc for a user that can be used in blog, forum etc. You will then have one table for each of the feature, such as forum posts, forum topics, blog topic, chat etc.

It is not much special on the database side, but it is critical to program your script to query the databasea and table from different services. if you are using phpbb forum and xyz blog, then you can either modify the signup form of one of these to satisfy both services (one form for two services), or create a whole new registration form that cover the requirements of both services.
Ecommerce-Web-Store.com Building Your e-Business.
Reply With Quote  
Join Date: Jun 2004
Location: H4x0rville
Posts: 2,105
Reputation: server_crash is on a distinguished road 
Rep Power: 9
Solved Threads: 18
server_crash's Avatar
server_crash server_crash is offline Offline
Postaholic

Re: phpmyadmin --- several services to use one database

  #3  
Oct 19th, 2005
Thanks for the reply...


Ok, one more thing. If I have the forum database already going and really can't change anything in that, can I configure the tables for the blogs and chat since they haven't even been fooled with?


Also, is there a good tutorial that will show me some of the scripting and things I need to do?


Once again, thanks for the reply. I really do appreciate it.
Reply With Quote  
Join Date: Jan 2005
Location: Sheffield, UK
Posts: 294
Reputation: zippee is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 6
zippee's Avatar
zippee zippee is offline Offline
Posting Whiz in Training

Re: phpmyadmin --- several services to use one database

  #4  
Oct 20th, 2005
In the blog or chat script, you can point their database to the one store all forum's tables and change their table that hold account information to the forum one (so that account info is from one source). I not actually combine blog and forum together, but the concept should be the same.

I don't think there is any tutorial out there as this is a very customise 'project'. You may want to spend $100 or so to get a freelancer to do the job for you. Experience programer may take 3-5 days to complete the job. Try google 'freelancer'. Some site let you to accept bids from programmer that can do your job and may ended up very low cost.

All the best.
Ecommerce-Web-Store.com Building Your e-Business.
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

DaniWeb MySQL Marketplace
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes

Similar Threads
Other Threads in the MySQL Forum

All times are GMT -4. The time now is 11:35 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC