Php when should I connect to the database?

Question

0.00/5 (No votes)

See more:

Hello all,

A very novice question...

I start to understand how PHP works...

I don't know if this is a mistake, but my idea was to connect to the MySQL database at the beginning and use that connection till the end.

I guess I should put the connection in a SESSION variable to get this behavior...

The other way would be to simply create a connection each time I want to make a query to the database and close it after doing the query... this makes things easier from the programming point of view...

How this should be done?

Thank you for your answer!

What I have tried:

Tried to create a class and make queries to that class, but this seems to work only sometimes...

Posted 23-Jul-19 7:34am

Joan M

Updated 23-Jul-19 7:40am

Add a Solution

Comments

Afzaal Ahmad Zeeshan 23-Jul-19 14:16pm

Consider looking out for connection pooling in this case.

Joan M 23-Jul-19 14:24pm

I'll do it only if I see the web page is slow... by now... a small database with 11 tables... don't think this will be needed...

But I'll check it... thank you Afzaal!

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard Deeming · Accepted Answer · 2019-07-23T07:41:00

Solution 1

Create the connection when you need it, and close it as soon as you're done.

The web is stateless. Clients make a request and get a response. They might never make another request again. Don't try to persist expensive things like database connections between requests.

Posted 23-Jul-19 7:41am

Richard Deeming

Comments

Joan M 23-Jul-19 13:46pm

THANK YOU VERY MUCH.

I had created a class with the connection as a member variable... too much things to get a simple thing done.

Tried it and worked like charm at the first attempt.