PHP | mysqli_connect() Function

The mysqli_connect() function in PHP is used to connect you to the database. In the previous version of the connection mysql_connect() was used for connection and then there comes mysqli_connect() where i means improved version of connection and is more secure than mysql_connect().

Syntax:

mysqli_connect ( "host", "username", "password", "database_name" )

Parameters used:

  • host: It is optional and it specify the host name or IP address. In case of local server localhost is used as a genral keyword to connect local server and run the program.
  • username: It is optional and it specify mysql username. In local server username is root.
  • Password: It is optional and it specify mysql password.
  • database_name: It is database name where operation perform on data. It also optional.

Return values:

  • It returns an object which represent MySql connection. If connection failed then it return FALSE.

Program: Below is the implementation of mysqli_connect() function.

filter_none

edit
close

play_arrow

link
brightness_4
code

<?php
    mysqli_connect("localhost", "root", "", "GFG");
  
    if(mysqli_connect_error())
        echo "Connection Error.";
    else
        echo "Database Connection Successfully.";
?>

chevron_right


Output:

Database Connection Successfully.


My Personal Notes arrow_drop_up

Check out this Author's contributed articles.

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.




Article Tags :
Practice Tags :


Be the First to upvote.


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.