PHP script to connect to MySQL database. An example of a script in a PHP to connect to a MySQL database and explain individual functions and parts:
<?php
// Připojení k MySQL serveru
$host = "localhost"; // název hostitele
$username = "username"; // uživatelské jméno
$password = "password"; // heslo
$dbname = "database_name"; // název databáze
// Vytvoření připojení
$conn = mysqli_connect($host, $username, $password, $dbname);
// Kontrola připojení
if (!$conn) {
die("Připojení selhalo: " . mysqli_connect_error());
}
echo "Úspěšné připojení k MySQL serveru";
// Ukončení připojení
mysqli_close($conn);
?>
This script connects to a MySQL database using PHP’s mysqli extension and performs some basic operations. Here is a breakdown of the code:
- Define connection parameters:
$host = "localhost";
$username = "username";
$password = "password";
$dbname = "database_name";
The script defines four variables, namely the database host name, username, password, and database name.
- Create connection:
$conn = mysqli_connect($host, $username, $password, $dbname);
This line creates a connection to the database using the mysqli_connect() function. The function takes four parameters: host, username, password, and database name. It returns a connection object which is stored in the $conn variable.
- Check the connection:
if (!$conn) {
die("Připojení selhalo: " . mysqli_connect_error());
}
This line checks if the connection was successful. If the connection failed, the script will exit with a message that shows the error that occurred during the connection attempt.
- Print success message:
echo "Úspěšné připojení k MySQL serveru";
If the connection is successful, this line will print a success message.
- Close the connection
mysqli_close($conn);
Finally, this line closes the connection to the database using the mysqli_close() function. This is an optional step but is recommended to release resources used by the connection.
