How to connect php to mysql database

Before connecting to the MySQL database, you must specify the following information:

MySQL data source name or DSN: Specify the address of the MySQL database server. You can use an IP address or server name, for example, 127.0.0.1 or localhost

MySQL database name: Indicates the name of the database to connect to.

Username and Password: Specify the username and password of the MySQL user used to connect to the MySQL database server. This account must have sufficient permissions to access the database specified above.

We will use:

Local MySQL database server, so that the DSN is localhost.

In classicmodels as a sample database.

Root account with blank password, just for demonstration.

Connecting to MySQL Steps

First, for convenience, we will create a new PHP file for database configuration, dbconfig.php. This file contains all configured parameters:

<?php
    $host = &#39;localhost&#39;;
    $dbname = &#39;classicmodels&#39;;
    $username = &#39;root&#39;;
    $password = &#39;&#39;;

Second, we create a new PHP file called phpmysqlconnect.php:

<?php
require_once &#39;dbconfig.php&#39;;
  
try {
    $conn = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);
    echo "Connected to $dbname at $host successfully.";
} catch (PDOException $pe) {
    die("Could not connect to the database $dbname :" . $pe->getMessage());
}

How the script works

dbconfig.php uses the require_once function to include the file in the script.

In the try block, we create a new PDO object with three parameters: connection string, username and password. The connection string consists of the variables $host and $dbname in the file dbconfig.php.

If the connection to the MySQL database is successfully established, we will display a success message. If there are any errors or exceptions, PHP will issue a PDOException

containing a detailed error message. We call the object's getMesage() method PDOException to get the detailed message to be displayed.

The above is the detailed content of How to connect php to mysql database. For more information, please follow other related articles on the PHP Chinese website!