Support Forums
How to use the same data base for 2 things - Printable Version

+- Support Forums (https://www.supportforums.net)
+-- Forum: Categories (https://www.supportforums.net/forumdisplay.php?fid=87)
+--- Forum: Coding Support Forums (https://www.supportforums.net/forumdisplay.php?fid=18)
+---- Forum: Database Programming (https://www.supportforums.net/forumdisplay.php?fid=28)
+---- Thread: How to use the same data base for 2 things (/showthread.php?tid=522)

Pages: 1 2


How to use the same data base for 2 things - BrainDeadFreak - 10-07-2009

Hey i wanted to know. Is there a way that i can use my DB for two things.

Such as an SMF forum and a Wordpress blog. So that when they register to either one of them, they don't have to register on the other one. So that they can log in on both of them with the same login information? Big Grin


RE: How to use the same data base for 2 things - Code King - 10-08-2009

If the blog and the forum have the same table name for users then maybe. May require some customisation but not a heck of a lot.


RE: How to use the same data base for 2 things - h1r0n - 10-08-2009

sure you can but... make it manageable


RE: How to use the same data base for 2 things - BrainDeadFreak - 10-08-2009

Ok thank you guys for your input.

Im going to have to put them under the same DB User right?


RE: How to use the same data base for 2 things - Legion - 10-09-2009

(10-08-2009, 11:22 PM)BrainDeadFreak Wrote: Ok thank you guys for your input.

Im going to have to put them under the same DB User right?
If both use the same users yes.

Remember that there might be other columns in the database like age and location that are named differently in both, In that case you need to join those as well if you use the same database for both as stated above.

If not and both is meant for different members it is still possible just make sure that no table columns will hold the same name then.


RE: How to use the same data base for 2 things - BrainDeadFreak - 10-10-2009

(10-09-2009, 02:16 PM)Legion Wrote: If both use the same users yes.

Remember that there might be other columns in the database like age and location that are named differently in both, In that case you need to join those as well if you use the same database for both as stated above.

If not and both is meant for different members it is still possible just make sure that no table columns will hold the same name then.

So i just have to make sure that the tables don't overwrite each other and it should work right?


RE: How to use the same data base for 2 things - Legion - 10-10-2009

(10-10-2009, 12:27 AM)BrainDeadFreak Wrote: So i just have to make sure that the tables don't overwrite each other and it should work right?

Yes.

You might need to change parts of the code as well in which the columns are used.


RE: How to use the same data base for 2 things - Akshay* - 10-10-2009

just create 2 oobjecs


RE: How to use the same data base for 2 things - BrainDeadFreak - 10-10-2009

Ok thank you guys. You guys are great help!


RE: How to use the same data base for 2 things - Akshay* - 10-12-2009

You are always welcome