HowTo: Connect to MySQL from PHP Using Different Files

Question

Ok so I did a search to see if there other posts that explain this completely...

Well i'm here now :)

SCENARIO:

I want to connect to your mysql database via html.
I DO NOT want to set the parameters explicitly everytime I wish to perform a query
I have multiple users and (ofcourse) you want their login details available throughout the application

You cannot connect to a database by using a .html file

Daryl Gill
– Daryl Gill

2013-02-23 14:10:47 +00:00
Commented Feb 23, 2013 at 14:10 — Daryl Gill
– Daryl Gill, Commented Feb 23, 2013 at 14:10

Dharman · Accepted Answer · 2020-11-04 10:34:01Z

1

You'll need PHP to make connection inside connection.php file
```
<?php

$conn= mysqli_connect("localhost","ID","Password","Database_name");
```
Then in each file you put require('connection.php'); and there is no way than that for making a connection to MySQL database.
Set queries as functions and send the thing you want to search for as a variable.
Use $_Session or $_Cookie once the user enter his email/password.

edited Nov 4, 2020 at 10:34

Dharman♦

34k27 gold badges106 silver badges158 bronze badges

answered Dec 14, 2019 at 14:17

Mina Roger

1094 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Sometowngeek Over a year ago

Mina, he said he didn't want to explicitly make the connection, which is exactly what your answer is doing. Is there any way he can make the connection without having to make that block every time?

Mina Roger Over a year ago

Yes,he can by placing this block inside an php file, and just in each php file use #Require(connection.php);

Collectives™ on Stack Overflow

HowTo: Connect to MySQL from PHP Using Different Files

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related