Programming Languages

PHP MySQL Connection (MySQLi)

Connect to MySQL database using MySQLi extension

Procedural Connection

$conn = mysqli_connect("localhost", "username", "password", "database"); # create connection
if (!$conn) { # check connection
    die("Connection failed: " . mysqli_connect_error()); # show error
}
mysqli_close($conn); # close connection

Object-Oriented Connection

$conn = new mysqli("localhost", "user", "pass", "dbname"); # create object
if ($conn->connect_error) { # check for errors
    die("Failed: " . $conn->connect_error); # display error
}
$conn->close(); # close connection

Set Character Set

mysqli_set_charset($conn, "utf8"); # procedural style
$conn->set_charset("utf8mb4"); # OOP style