在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();
}
?>

在php中测试数据库连接失败

相关推荐