PHP MySQL Connect
PHP 5 рд░ рддреНрдпрд╕рднрдиреНрджрд╛ рдорд╛рдерд┐рдХрд╛ рд╕рдВрд╕реНрдХрд░рдгрд╣рд░реВрдорд╛ MySQL database рд╕рдБрдЧ рдХрд╛рдо рдЧрд░реНрдирдХрд╛ рд▓рд╛рдЧрд┐ рдирд┐рдореНрди рддрд░рд┐рдХрд╛рд╣рд░реВ рдЫрдиреН:
- MySQLi extension (the "i" stands for improved)
- PDO (PHP Data Objects)
Open a Connection to MySQL
MySQL database рдкрд╣реБрдБрдЪ (access) рдЧрд░реНрдиреБ рдЕрдШрд┐, рд╣рд╛рдореАрд▓реЗ database рд╕рдБрдЧ connection рдЦреЛрд▓реНрдиреБ рдкрд░реНрдЫред
Example (MySQLi Object-Oriented)
<?php
$servername = "localhost";
$username = "username";
$password = "password";
// Create connection
$conn = new mysqli($servername, $username, $password);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully";
?>
$servername = "localhost";
$username = "username";
$password = "password";
// Create connection
$conn = new mysqli($servername, $username, $password);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully";
?>
Close the Connection
Database рд╕рдБрдЧрдХреЛ рдХрд╛рдо рд╕рдХрд┐рдПрдкрдЫрд┐ connection рдмрдиреНрдж рдЧрд░реНрдиреБ рд░рд╛рдореНрд░реЛ рдмрд╛рдиреА рд╣реЛред
$conn->close();