how to define charset UTF-8

gilgalbiblewheel · January 25th, 2018, 10:21 PM

I've seen many ways of defining and might have created a mix of defining things on php. Can you help me edit thingws together:

PHP Code:


			
<?php 
// for display
ob_start();
//header("Content-Type: text/html; charset=utf-8");
//header("Content-Type: text/html; charset=utf-8_general_ci");
//error_reporting(E_ALL);
ini_set('display_errors', true);
set_time_limit(480);
//define("DSN", "mysql:host=localhost;dbname=biblewheel;charset=utf-8");
define("DSN", "mysql:host=localhost;dbname=biblewheel;charset=utf-8_general_ci");

define("USERNAME", "root");

define("PASSWORD", "");

/*$pdo = new PDO('mysql:host=hostname;dbname=database', 'username', 'password',
    array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8")
);
*/

$options = array(PDO::ATTR_PERSISTENT =>true);

try{
    $conn = new PDO(DSN, USERNAME, PASSWORD, $options);
    //array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf-8_general_ci COLLATE utf8"); utf8mb4_bin
    //$conn = new PDO("mysql:host=localhost; dbname=biblewheel;charset=UTF8","root","",array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"))or die("no connection"); $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    
    //echo "connection successful<br /><br />\n";
}catch (PDOException $ex){
    echo "A database error occurred ".$ex->getMessage();    
}