php and mysql script

regiemon · 02-21-2007, 06:18 AM

have a plan developing a website using php and mysql.
multiple users can logon in the website to enter some information thru the database.
but how can i make the database could accept multiple connection?
isn't it that when someone is currently using the database and another user would like to connect to the database, it will have an error saying that the database is currently in use?

thank you very much

Stormdev · 02-21-2007, 10:25 AM

regiemon,

MySQL is a multi user database, it will handle the connection requests and transactions for you so there is really not much for you to worry about in that respect... as your site grows you will be more concerned with the type and volume of transactions that may occur on your database server and this will influence how you setup your MySQL server.

Here is some info on MySQL:
http://en.wikipedia.org/wiki/MySQL#P...ming_languages
http://www.mysql.com/

02-21-2007, 06:18 AM	#1 (permalink)
regiemon True Techie Join Date: Jan 2006 Posts: 123	php and mysql script have a plan developing a website using php and mysql. multiple users can logon in the website to enter some information thru the database. but how can i make the database could accept multiple connection? isn't it that when someone is currently using the database and another user would like to connect to the database, it will have an error saying that the database is currently in use? thank you very much

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

02-21-2007, 10:25 AM	#2 (permalink)
Stormdev Newb Techie Join Date: Dec 2006 Posts: 21	regiemon, MySQL is a multi user database, it will handle the connection requests and transactions for you so there is really not much for you to worry about in that respect... as your site grows you will be more concerned with the type and volume of transactions that may occur on your database server and this will influence how you setup your MySQL server. Here is some info on MySQL: http://en.wikipedia.org/wiki/MySQL#P...ming_languages http://www.mysql.com/