在php中测试数据库连接失败
问题描述:
I've set up a database using MAMP. When I try the following test, I only receive a blank page. Fairly new to this, and I've tried different suggestions found on the web with no luck. Tried using both port and socket.
<?php
$user = 'root';
$password = 'root';
$db = 'test';
$host = 'localhost';
$port = 3306;
$socket = "/Applications/MAMP/tmp/mysql/mysql.sock";
$link = mysql_connect(
"$host:$socket",
$user,
$password
);
$db_selected = mysql_select_db(
$db,
$link
);
if (!$link){
echo "ERROR";
}
else {
echo "Success";
}
mysql_close($link);
?>
我使用MAMP设置了一个数据库。 当我尝试以下测试时,我只收到一个空白页面。 相当新的,我尝试了在网上找到的不同的建议没有运气。 使用端口和套接字。 p>
&lt;?php
$ user ='root';
$ password ='root';
$ db =' test';
$ host ='localhost';
$ port = 3306;
$ socket =“/ Applications / MAMP / tmp / mysql / mysql.sock”;
nnnlink = mysql_connect(
“$ host:$ socket”,
$ user,
$ password
);
$ db_selected = mysql_select_db(
$ db,
$ link
);
if(!$ link) {
echo“ERROR”;
}
else {
echo“Success”;
}
mysql_close($ link);
?&gt;
code> pre>
DIV>
答
Would you like to try PDO ?!
<?php
$dsn = "mysql:host=localhost;dbname=databasenamehere";
$user = 'root';
$pass = '';
$option = array(
PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8',
);
try {
$connect = new PDO($dsn, $user, $pass,$option);
$connect->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
}
catch (PDOException $r) {
echo 'Failed' . $r->getMessage();
}
答
<?php
$servername = "localhost";
$username = "root";
$password = "root";
try {
$conn = new PDO("mysql:host=$servername;test", $username, $password);
// set the PDO error mode to exception
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
echo "Connected successfully";
}
catch(PDOException $e)
{
echo "Connection failed: " . $e->getMessage();
}
?>