mysql_connect会创建多个连接对象吗？

Question

My Question -- If I use mysql_connect as many times to connect to database, will my application create those many connections?

For example : In my website(www.cricandcric.com), For populating the menu bar items from DB, I am using the database connection "mysql_connect', to connect and retrieve and display the items

and In the same page, I have a News Section, to populate the News, I am using the Mysql_connect to connect to the database and retrieve the news which is been updated and show it to the users

Similarly If a page has multiple sections, I am using separate mysql_connect object individually and connect to DB and display the data to Users.

Is this a Good practice? or for the complete website Do I need to maintain a SINGLE mysql_connect connection object for all the sections,

Please check, www.cricandcric.com, in the Home page, I have the following section, 1)Menu bar,

2)scorecard below the Logo

3)Cricket schedule..

4) India Cricket News

etc...

What is the best practice to use the MYSQL_CONNECT?

The problem which I am facing is, My server running out of Memory if suddenly 2000 users come at ONE shot, solution is I need to restart my server to fix this problem, so I am thinking what is the best way to fix this issue?

Answer 1

If you always use the same credentials and only 3 parameters for mysql_connect, it will use the same link to the database. For example, the second time you use it, PHP won't open a new link, it will juts use the resource that was created the 1st time. So your app is using one db connection for all the "sections" it loads, which is the best practice. You can change this and to open a new link each time mysql_connect is called by passing a 4th parameter as "true".