How to Connect to MySQL Database in PHP Using MySQLi Extension

How to connect to MySQL database in PHP using mysqli extension?

mysqli_connect("","username" ,"password","databasename");//Server name cannot be NULL

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

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 = "";

The best way to connect MySQL database in PHP

Connecting using the mysqli extension gives you the ability to use newer MySQL features such as transactional queries and parameterised queries which aren't available using the older mysql extension.

Have a look at http://www.php.net/manual/en/book.mysqli.php

Connect to database php

$mysqli = new mysqli(localhost, root, password, user);

You need to define those or put them in quotes.

like:

$servername = 'localhost';
$username = 'user123';
$password = 'helloworld';
$dbname ="testdatabase";

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$conn = mysqli_connect($servername, $username, $password, $dbname);
$conn->set_charset($charset);

Could not connect to my sql using php ,undefined function mysql_connect()

You need to change your function name from mysql_connect to mysqli_connect as mysql_ is not supported in PHP7.x

further, you need to use all functions having mysqli_ instead of mysql_

For more guidance: https://www.php.net/manual/en/book.mysqli.php

Cannot connect to database with MySQLi but can with MySQL

The mysqli version of mysql_connect() is mysqli_connect(). If you look over here you can see that mysqli_connect() is an alias of the constructor of an mysqli object instead of one of it's methods. I hope this clears things up for you. Good luck!

How can I enable the MySQLi extension in PHP 7?

I got the solution. I am able to enable MySQLi extension in php.ini. I just uncommented this line in php.ini:

extension=php_mysqli.dll

Now MySQLi is working well. Here is the php.ini file path in an Apache 2, PHP 7, and Ubuntu 14.04 environment:

/etc/php/7.0/apache2/php.ini

By default, the MySQLi extension is disabled in PHP 7.

---

Related Topics