How to write MySQL DB single connection string for my website application

Question

I have a website built using HTML,JS,PHP. I use Linux OS and apache2 server and MySQL as a back end. To connect to the MySQL server I have created connection in each PHP page,But I want this connection string to be written in a single file(Like web.config in Visual studio),so that I can change the connection string easily whenever it is necessary.I have installed PHPMYADMIN and I can see couple of config files in that folder.But I do not know where I need to write this connection string?

Or shall I create a PHP file with the connection string and include() this file in every other PHP files and create the instance of the connection?

I am not using any IDE for building the website.

Any help is greatly appreciated.

Thanks a lot.

The usual way is the latter, make a separate PHP file with the config and include that where needed. — Joachim Isaksson
– Joachim Isaksson, Commented Jul 29, 2013 at 8:51

Hein Andre Grønnestad · Accepted Answer · 2013-07-29 08:53:56Z

2

Create a PHP file where you connect to the SQL server and save the connection in a variable. Include this file everywhere you need the connection.

Pseudo example

init.php

$db_connection = connect_to_db($server, $username, $password, $db);

other_files.php

include "init.php";
execute_query("query", $db_connection);

answered Jul 29, 2013 at 8:53

Hein Andre Grønnestad

7,0452 gold badges33 silver badges45 bronze badges

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

Comments

Shiv · Accepted Answer · 2013-07-29 08:52:22Z

2

Create a PHP file with connection setting and just include it in all pages at the top.

answered Jul 29, 2013 at 8:52

Shiv

693 bronze badges

Comments

Mihai · Accepted Answer · 2013-07-29 08:53:16Z

1

http://php.net/manual/en/pdo.connections.php Here is an exampe with PDO Just put that in a php file and include it where is needed.

answered Jul 29, 2013 at 8:53

Mihai

26.8k8 gold badges71 silver badges87 bronze badges

Collectives™ on Stack Overflow

How to write MySQL DB single connection string for my website application

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related