在PHP中连接我的MYSQL数据库 [英] Connecting my MYSQL database in php

问题描述

我有我的php代码连接我的服务器数据库

I have my php code like this to connect my server database

 <?php
    $con=mysqli_connect("","username" ,"password","databasename");
    if (mysqli_connect_errno())
     {
      echo "Failed to connect to MySQL: " . mysqli_connect_error();
     }
     ?>

但它显示无法连接到MYSQL，这是什么错误？我试图在Web服务器，而我的本地主机工作完美。任何人都有一些建议？

But it displayed "Failed to connect to MYSQL", what is wrong with this code?, first time i am trying it in web server, whereas my localhost worked perfectly. Anyone has some suggestion?

推荐答案

mysqli_connect（，username，password databasename）; //服务器名不能为NULL

使用loaclhost作为服务器名（在Loacl中）

use loaclhost for server name(In Loacl)

<?php
    $con = mysqli_connect("localhost","username" ,"password","databasename");

    if (mysqli_connect_errno())
    {
        echo "Failed to connect to MySQL: " . mysqli_connect_error();
    }
?>

或可以使用MySQLi程序

Or can use MySQLi Procedural

<?php
    $servername = "localhost";
    $username = "username";
    $password = "password";

    // Create connection
    $con = mysqli_connect($servername, $username, $password);

    // Check connection
    if (!$con) {
        die("Connection failed: " . mysqli_connect_error());
    }
    echo "Connected successfully";
?>

EDIT 01

$servername = "localhost";
$username = "root";
$password = "";

这篇关于在PHP中连接我的MYSQL数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！