Saturday, July 4, 2020

Code Connect To MySQL in PHP Through PDO

<?php

$servername = "localhost";
$database = "mydb";
$username = "root";
$password = "";
$charset = "utf8mb4";

try {

$dsn = "mysql:host=$servername;dbname=$database;charset=$charset";
$pdo = new PDO($dsn, $username, $password);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

echo "Connection Okay";

return $pdo;

}

catch (PDOException $e)

{
echo "Connection failed: ". $e->getMessage();
}

?>

Explaination -

$servername - server name
$database - database name
$username - username of database
$password - password of database
$charset - The variable charset tells the database in which encoding it will be receiving and sending data. The recommended standard is utf8mb4.


0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home