Jump to content
xisto Community
Sign in to follow this  
zvohra1

Merging Database Php Mysql

Recommended Posts

Hii i need help margning script. i have coppermine gallery, AzDGDating Site, Noah's Classifiedsthey all have user sign-up login. but they have different like i need to have 3 seperate account for each script is there any way like mergning one user name and password would work for 3 section.if you don't get my question please tell me i will try to explain more in detailthank you for your time and help

Share this post


Link to post
Share on other sites

Ok, you have three sites and you want to use one login for all of them?If yes, you want all the users to be able to do that or only you?And did you code them yourself or are they some kind of CMS's?

Share this post


Link to post
Share on other sites

do u have any step for it or any thing that can help me thank you


U may have to re-edit the entire source to use a common database. As far as I know is, all the three uses different database structure to store information. It's a critical task re-editing the source.
I suggest to learn the database structure, using phpMyAdmin or something like that.
Once done, try to edit the code to use the same table for atleast username and password fields.

And, there's no definite solution ...unless u experiment with it.

Share this post


Link to post
Share on other sites

I would really like to learn how to do it. Can you tell me how to start it off like I am ready to do everything over again remove my current user database and have new 3 in one. do i have do change settings in config.php or something.thank you

Share this post


Link to post
Share on other sites

U may have to re-edit the entire source to use a common database. As far as I know is, all the three uses different database structure to store information. It's a critical task re-editing the source

I think that would be the way to do it. The thing is though is that all three systems will use a different database, and the likelihood is that all three databases will have a slightly different name for things, eg in one system the persons name might be called "username" but in another it might be called "user" so that would need a lot more effort. Also if there are say 4 fields in one database table and if one has 6 then there will be more effort needed!

Its definately possible, i dont think i would have the time to do it myself as ive got college exams up and coming, but im sure either someone here can do it or you can find yourself a freelance coder on the internet somewhere, that would cost though.

The first thing to do is find out how the databases work, make a list of the database and then the table name and then the fields in that table and that will be the starting point, if youre lucky all three systems will use similar field names. That will get you the login/logout and register parts, the next part will be keeping the user logged in untill they choose to log out, depending on what the variables are called within the code that might be a bigger job to do as it might mean that every ".php" file will need to be edited. But the database structure is the first thing to think about!

You can post the structure of the database, not the content, on the forums and someone might be able to help, if you need help on finding ut the structure then just ask!

Unfortunately i havent much experience with any kind of modifying so i dont think ill be a lot of help! Though i belive sme guys/girls on these forums have got experience in big modifying jobs so they might be able to help!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.