PHP(PDO)与Google App Engine上的Cloud SQL的连接不起作用 [英] PHP (PDO) Connection to Cloud SQL on Google App Engine Not Working
本文介绍了PHP(PDO)与Google App Engine上的Cloud SQL的连接不起作用的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我在连接到共享相同项目的App Engine灵活环境中托管的Cloud SQL实例时遇到问题.我正在使用PHP数据对象(PDO)创建连接.我继续收到此错误:
I am experiencing issues connecting to a Cloud SQL instance hosted in an App engine flexible environment which shares same project. I am using PHP Data Object (PDO) to create the connection. I Kept getting this error:
SQLSTATE [HY000] [2002]没有这样的文件或目录
SQLSTATE[HY000] [2002] No such file or directory
即使我已经完成了有关授权应用程序的所有设置,等等.
Even when I had done all the settings as to authorizing the app, etc.
这是我的示例代码:
public function __construct() {
try {
$this->datab = new PDO('mysql:unix_socket=/cloudsql/<MY INSTANCE CONNECTION NAME>;dbname=MY_DATABASE', 'USERNAME', 'PASSWORD');
$this->datab->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$this->datab->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
} catch (PDOException $e) {
$this->isConnected = false;
throw new Exception($e->getMessage());
}
}
请,我需要做些什么才能使其正常工作?我现在的库存真的很大,我确实需要帮助.
Please, is there anything I need do for it to work? I'm really stock now and I do need help.
谢谢.
推荐答案
尝试这个
in app.yaml
env_variables:
MYSQL_USER: username
MYSQL_PASSWORD: password
MYSQL_DSN: mysql:unix_socket=/cloudsql/instancename;dbname=yourdbname
in your script:
$dsn=getenv('MYSQL_DSN');
$user=getenv('MYSQL_USER');
$pass=getenv('MYSQL_PASSWORD');
$dbh = new PDO($dsn, $user, $pass);
这篇关于PHP(PDO)与Google App Engine上的Cloud SQL的连接不起作用的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文