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();
}
?>
$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.
$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