SQLSTATE [HY000] [2002] php_network_getaddresses:getaddrinfo失败:提供了节点名或服务名,或者未知 [英] SQLSTATE[HY000][2002] php_network_getaddresses: getaddrinfo failed: nodename nor servname provided, or not known
问题描述
我使用MAMP和Git在Mac上通过SQL数据库连接查看和编辑PHP文件,然后将其推送到Web服务器.我最近添加了一个文件目录.这是具有SQl数据库连接的文件:
I use MAMP and Git to view and edit my PHP files with SQL database connection on my mac and then push it to the web server. I recently added a file directory. Here is the file with the SQl database connection:
<?php
ob_start();
session_start();
//set timezone
date_default_timezone_set('America/New_York');
//database credentials
define('DBHOST','mysql.hostinger.co.uk');
define('DBUSER','u536535282_evan7');
define('DBPASS','...');
define('DBNAME','u536535282_dbsql');
//application address
define('DIR','http://w-o-l.ml/');
define('SITEEMAIL','it@w-o-l.ml');
try {
//create PDO connection
$db = new PDO("mysql:host='.DBHOST.';port=8889;dbname='.DBNAME, DBUSER, DBPASS.'");
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch(PDOException $e) {
//show error
echo '<p>'.$e->getMessage().'</p>';
exit;
}
//include the user class, pass in the database connection
include('classes/user.php');
$user = new User($db);
?>
但是它在页面上返回以下错误:
But yet it returns the following error on the page:
SQLSTATE [HY000] [2002] php_network_getaddresses:getaddrinfo失败:提供了节点名或服务名,或者未知
SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: nodename nor servname provided, or not known
我该如何解决?
我看不到我的错误,所以如果有人指出来,那将会很有帮助.
How do i fix it?
I cannot see my error so if someone could point it out, that would be helpful.
推荐答案
您的报价都被弄乱了.
$db = new PDO('mysql:host='.DBHOST.';port=8889;dbname='.DBNAME, DBUSER, DBPASS);
这篇关于SQLSTATE [HY000] [2002] php_network_getaddresses:getaddrinfo失败:提供了节点名或服务名,或者未知的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!