•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 397,590 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,898 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:
Views: 1544 | Replies: 3
![]() |
•
•
Join Date: Jun 2004
Location: H4x0rville
Posts: 2,105
Reputation:
Rep Power: 9
Solved Threads: 18
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.
•
•
Join Date: Jan 2005
Location: Sheffield, UK
Posts: 294
Reputation:
Rep Power: 4
Solved Threads: 6
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.
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.
•
•
Join Date: Jun 2004
Location: H4x0rville
Posts: 2,105
Reputation:
Rep Power: 9
Solved Threads: 18
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.
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.
•
•
Join Date: Jan 2005
Location: Sheffield, UK
Posts: 294
Reputation:
Rep Power: 4
Solved Threads: 6
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.
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.
![]() |
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
- Upgrade phpBB to vBulletin? (Growing an Online Community)
- registration (ASP)
- help wif uploading My sql database into Phpmyadmin.com (MySQL)
- how to retrieve the Microsoft Access DAtabase from the INternet using web services (VB.NET)
- IPB Help and advice (Existing Scripts)
- Backing up a MySQL database (MySQL)
Other Threads in the MySQL Forum
- Previous Thread: problem with autogenerated mysql query
- Next Thread: SELECT statement question



Linear Mode