[Question] What happens if same MySQL database is used for multiple scripts?

The question is mentioned as above. Please let me know if you've answer to it.

One more Question!

Supposing that I'm using a video script(clip-art or phpmotion) and a myBB forum, both using different MySQL databases on my website.

What would I've to do if I would like to have my forum members (registered ones) to access the video site(on another subdomain on the same website) without having to register there again. (assuming my website will offer both the services!--- myBB forum and Video broadcating)

I'm a learner. Kindly help me out.

Thank you!

 

How you identify that a members is already registered? Do you have a login protected area?

 

The title question could have two possible rationales. As long as the 2 scripts have different table, procedure, function etc names then there is no real problem having 2 scripts off of 1 database but as these could change in the future it is generally sensible to have them on 2 different databases (could be on same sql server) to avoid conflicts.

If you want to use a universal log in (the subdomain issue aside) you need a developer to look at the two scripts processes of authentication and align them (generally by making one match the other).

Subdomains are a bad idea on so many levels but if you insist on using one then whilst someone can be easily registered once to log into both subdomains it is more complex to make it such that logging into one logs them into all subdomains (but is possible). The standard effect would be that they would need to log into each subdomain individually even though using the same credentials

 

@ mysqlxpert
Yes it's a login protected area.

@ AstarothSolutions
Thank you very much for shedding some light on the issue. Probably, I get the idea now.

 

Ethical Geek,

I would recommend at least checking out phpBBmotion...it's a free integration for PHPmotion and phpBB, that uses one phpBB authentication for both systems.

http://moulincreatif.com/blog/phpmotion/phpbbmotion-is-now-available-for-free/

 

there is no issue running 1 database with multiple scripts or even hundreds of scripts for that matter. The data will still be passed you just need to make sure your connection string is working for each script and that your data is being processed into your variables correctly and that they are not overlapping.

 

although you will have to declare separate variables names in many cases to avoid overlapping your variable from one query to another

 

I've had no problems running multiple scripts using the same database so it's not a problem.

 

You have sessions to look after as well, this is, if you wish to have the users only login once.