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 Feb 23 '13 at 14:10 — Daryl Gill, Feb 23 '13 at 14:10

score 1 · Accepted Answer · edited Nov 04 '20 at 10:34

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 04 '20 at 10:34

Dharman

answered Dec 14 '19 at 14:17

Mina Roger

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? – Sometowngeek Dec 14 '19 at 14:39
1

Yes,he can by placing this block inside an php file, and just in each php file use #Require(connection.php); – Mina Roger Dec 21 '19 at 11:43

1 Answers1