Creating the config.php File

1. Create a new file named config.php in your project directory. This file will contain your database connection details.
2. Add the following code to config.php to define your database credentials:

<?php
// Database configuration
define('DBHOST', 'localhost'); // Database host
define('DBUSER', 'your_username'); // Database username
define('DBPWD', 'your_password'); // Database password
define('DBNAME', 'your_database'); // Database name
?>

Including the Configuration in Your PHP Scripts

<?php
include 'config.php'; // Include the configuration file
// Create a connection to the database
$conn = new mysqli(DBHOST, DBUSER, DBPWD, DBNAME);
// Check the connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully";
?>

Best Practices

• Keep your config.php file secure: Ensure that this file is not accessible from the web. You can place it outside the web root directory or use server configurations to restrict access.
• Use environment variables: For added security, consider using environment variables to store sensitive information instead of hardcoding them in your configuration file.
  By following these steps, you can effectively set up a database configuration in PHP and ensure secure access to your database.