MySQL database
connection file/Program is very impotent
to connect PHP with MySQL server. As a common
practice if you have same database connection on each PHP page, you can place PHP
MySQL connection file/Program in one common place for example in Root Directory.
After placing
connection file/ Program you can access connection on each page like below
I have
created PHP file with name config.php and
placed it in root directory.
<?php
|
$servername = "localhost"; // Your server host
name
|
$username = "admin"; // Your server
Login ID or Name
|
$password = "password"; // Your server
Login Password.
|
$dbname = "mySQLDB"; // Your MySQL
server database
|
// Create
connection
|
$con = new mysqli($servername, $username, $password, $dbname);
|
// Check connection
|
if ($con->connect_error) {
|
die("Connection failed: " . $con->connect_error);
|
}
|
return $con;
|
?>
|
Access config.php file from root directory:
To establish PHP and MySQL database connection
use below line of code.
<?php require_once($_SERVER['DOCUMENT_ROOT'] ."/config.php");?>
Note: $_SERVER['DOCUMENT_ROOT']
: This
variable used to access the root directory path.
Please do not include
file like below -
<?php require_once("http://www.yourdomain.com/config.php");?>
Its unsecured way to use files from server and this may not work as its required special permission from php.ini file. But, this is not recommended as
this can lead to attack on your server by means of viruses, hackers, malware, SQL injections etc., so please don’t use this option unless you are
not sure.
Final Code:
Index.php
<?php require_once($_SERVER['DOCUMENT_ROOT'] ."/config.php");?>
<!DOCTYPE html>
<html>
<head>
<title>Compamny Page</title>
</head>
<body>
<h1>This is my Profile Page</h1>
<div >
<?php // MySQL connection string
$query = "SELECT * FROM employee_table where employeeName='Michale Bode'";
//$query = "SELECT * FROM company_table where employeeName='".strtolower($empName)."'";
$result = mysqli_query($con, $query);
while($row = mysqli_fetch_array($result))
{
echo "<span> Employee Name :". $row['eFullName']. "<span><br>";
echo "<span> Employee ID :". $row['eID']. "<span><br>";
echo "<span> Employee Mobile :". $row['eMobile']. "<span><br>";
echo "<span> Employee Address :". $row['eAddress']. "<span><br>";
}
?>
</div>
</body>
</html>
Output :
This is my Profile Page
Employee Name: Michael S. Bode
Employee ID: A77199
Employee Mobile: +1 952-888-xxxx
Employee Address: 421 American Blvd E, Bloomington, MN 55425, USA
Comments