Welcome Guest ( Log In | Register)



 
Reply to this topicStart new topic
> Merging Database Php Mysql
zvohra1
post Mar 18 2007, 08:10 PM
Post #1


Newbie
*

Group: Members
Posts: 4
Joined: 18-March 07
Member No.: 40,290



Hii
i need help margning script. i have coppermine gallery, AzDGDating Site, Noah's Classifieds
they 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 detail

thank you for your time and help
Go to the top of the page
 
+Quote Post
friiks
post Mar 18 2007, 08:32 PM
Post #2


Member [Level 1]
****

Group: Members
Posts: 53
Joined: 24-February 07
From: Latvia
Member No.: 39,133



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?
Go to the top of the page
 
+Quote Post
zvohra1
post Mar 18 2007, 08:42 PM
Post #3


Newbie
*

Group: Members
Posts: 4
Joined: 18-March 07
Member No.: 40,290



do u have any step for it or any thing that can help me
thank you
Go to the top of the page
 
+Quote Post
prashrb
post Mar 18 2007, 08:52 PM
Post #4


Newbie [Level 2]
**

Group: Members
Posts: 33
Joined: 17-March 07
From: Mumbai
Member No.: 40,231



QUOTE(zvohra1 @ Mar 19 2007, 02:12 AM) *
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.
Go to the top of the page
 
+Quote Post
zvohra1
post Mar 19 2007, 12:21 AM
Post #5


Newbie
*

Group: Members
Posts: 4
Joined: 18-March 07
Member No.: 40,290



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
Go to the top of the page
 
+Quote Post
shadowx
post Mar 19 2007, 10:12 PM
Post #6


A clever man learns from his own mistakes, a WISE man learns from those of OTHERS
*********

Group: [HOSTED]
Posts: 884
Joined: 12-April 06
From: Essex, UK
Member No.: 21,719



QUOTE
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!
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. Is The Database System Gone Again?(9)
  2. Complete Login System(56)
  3. Database Or Pdf(1)
  4. Qupis : Free Hosting With Php, Mysql, Cpanel. (one Line Text Ad At Bottom)(41)
  5. Database With Mysql++(7)
  6. Import From Excel File Into Mysql Database(7)
  7. Html Form!(4)
  8. Mysql Won't Update(4)
  9. How Do I Find My Mysql Password? [resolved](5)
  10. Mysql-essential-5.0.51 Installion Problem(2)
  11. Please Explain Me Mysql(4)
  12. Remote Access Mysql(8)
  13. Mysql Database Size(6)
  14. Is It Possible To Access The Mysql Remotely?(10)
  15. Phpmyadmin(6)
  1. Check Referrer To Prevent Linking Yours From Other Sites(8)
  2. Create Table - Mysql Code - Help(1)
  3. Tools Needed!(9)
  4. Mysql(2)
  5. Mysql Error(3)
  6. Connect To Remote Oracle Database With Toad(6)
  7. Mysql + Php Question(5)
  8. How To Manage The Database For E-books Website In My Sql?(3)
  9. Best Php And Mysql Editor For Noobs(6)
  10. I Need Help Transferring Sql Database?(3)
  11. Learning Mysql(3)
  12. Can You Add Images Into A Mysql Database?(20)
  13. Installing Apache, Mysql, Phpmyadmin Locally(5)
  14. Php And Mysql Programming(2)
  15. Ms-access Database Question(3)


 



- Lo-Fi Version Time is now: 20th July 2008 - 07:41 AM