Skip to content

Instantly share code, notes, and snippets.

@riteshhota2008

riteshhota2008/mysql_pdo_connect.php

Forked from nasirkhan/mysql_pdo_connect.php
Created June 30, 2018 07:00
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save riteshhota2008/c83af1d7923cd653eded4143eb04671f to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save riteshhota2008/c83af1d7923cd653eded4143eb04671f to your computer and use it in GitHub Desktop.
Download ZIP
MySQL PDO Unicode Issue fix
Raw
mysql_pdo_connect.php
<?php
/*
* The following function will create a PDO connection form PHP.
* It sovles the issue of inserting the Unicode Characters.
*/
function connect_db() {
$servername = "localhost";
$db_username = "root";
$db_password = "root";
$db_name = "DATABASE_NAME";
try {
$conn = new PDO("mysql:host=$servername;dbname=$db_name;charset=utf8", $db_username, $db_password);
// set the PDO error mode to exception
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$conn->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
$conn->setAttribute(PDO::MYSQL_ATTR_INIT_COMMAND, "SET NAME'utf8'");
echo "\nPDO connection object created\n";
return $conn;
} catch (PDOException $e) {
echo "Error: " . $e->getMessage();
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment