我有一个使用PDO的箭头SET NAMES UTF8的连接:

$options = [ PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES UTF8" ];


但是我要添加SET time_zone='America/Sao_Paulo'。但是我尝试过的所有方式都得到了异常!

这是我的连接类:

//Conexãousando objeto PDO单例模式

/** @var PDO */
private static $connect = null;

/**
 * Conecta com o banco de dados com o pattern singleton
 * Retorna um objeto PDO!
 */
private static function Conectar(){

    try {

        Setup::checkLocal();

        if(self::$connect == null) {
            $dsn = 'mysql:host='.Setup::$host.';dbname='.Setup::$base;
            $options = [ PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES UTF8; SET time_zone='America/Sao_Paulo'" ];
            self::$connect = new PDO($dsn, Setup::$user, Setup::$pass, $options);
        }

    } catch (PDOException $e) {
        echo 'PDOException: erro ao conectar ao banco de dados.';
        //PHPErro($e->getCode(), $e->getMessage(), $e->getFile(), $e->getLine());
        die;
    }

    self::$connect->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    //self::$connect->setAttribute(PDO::ATTR_ORACLE_NULLS, PDO::NULL_EMPTY_STRING);

    return self::$connect;
}

/** Retorna um objeto PDO Singleton Pattern */
public static function getConn(){
    return self::Conectar();
}

public static function prepareQuery($query, $params){

    $preparedQuery = self::getConn()->prepare($query);
    foreach ($params as $key => $value) {
        $preparedQuery->bindValue($key, $value);
    }

    $preparedQuery->execute();
    $result = $preparedQuery->fetchAll(PDO::FETCH_OBJ);

    self::$connect = null;

    return $result;
}

最佳答案

这可能对您有帮助。尝试一下!

$pdo = new PDO('mysql:host=localhost;dbname=exampletable',
'exampleuser',
'examplepassw',
[PDO::MYSQL_ATTR_INIT_COMMAND =>"SET NAMES utf8;SET time_zone = 'Europe/London'"]);

关于php - 如何使用PDO设置time_zone,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/42447065/

10-09 08:15
查看更多