HOME | PHP Tutorial | CSS
facebook icon
HTML Tutorial

CSS Tutorial

PHP mysqli_connect() Function

PHP provides mysqli_connect() function to open a SQL database connection. This function takes five parameters and returns a MySQLi link identifier on success or FALSE on failure.

Parameters: 1 server, 2 user, 3 password, 4 new_link, 5 client_flags.

Connect to MySQL server useing mysqli_connect() Function - how to create - example

Here is a simple example to connect to MySQL server

Example 1: mysqli_connect() Function
$link = mysqli_connect("localhost", "myuser", "mypassword", "mydb");

if (!$link) {
    echo "Error: Unable to connect to MySQL." . PHP_EOL;

echo "Success: A proper connection to MySQL was made!" . PHP_EOL;
echo "Host information: " . mysqli_get_host_info($link) . PHP_EOL;


You can disconnect from MySQLi database anytime using another PHP function mysqli_close(). This function takes a single parameter, which is a connection returned by mysqli_connect() function.

php mysqli connect function PHP mysqli_connect () Function - sql tutorial

2598. SQL tutorial will teach you how to use SQL - Database, sql tutorial
SQL tutorial will teach you how to use SQL - Database sql tutorial

3283. Insert into SQL - Insert into table SQL - Insert data in sql, sql tutorial
Insert into SQL - Insert into table SQL - Insert data in sql sql tutorial

1942. Online SQL Server Tutorial, Examples, Software, Commands, Online Courses
Online SQL Tutorial pdf, what is SQL, Online Courses, Classes, Training, Tutorials for Beginners - agernic.com is a free interactive Code, Tags, Example

2560. Disclaimer - SQL Tutorial


2817. PL/SQL Tutorial
We provide you with a comprehensive PL/SQL tutorial to help you learn PL/SQL quick and fun.

913. MySQL Tutorial in PDF
MySQL Tutorial in PDF - Learn MySQL from basic to advanced covering database programming clauses command functions administration queries and usage along with PHP in simple steps. This tutorial takes you starting from basic to advance MySQL concepts.

Your add here
How to get PHP errors to display?
How to prevent sql injection in php mysqli
How do I get PHP errors to display - PHP error_reporting()
mysql_query(): The mysql extension is deprecated and will be removed i
Function eregi_replace() is deprecated in php - How to fix
PHP delete an element from an array
Uncaught Error: Call to undefined function MYSQL_NUM_ROWS() in
Deprecated: mysql_connect() mysql extension is deprecated and will be
mysqli_fetch_array() expects parameter 1 to be mysqli_result boolean g
SQL IN Operator - example
SQL like syntax and example
SQL WHERE AND & OR multiple conditions
SQL create table primary key autoincrement
PHP mysqli_connect () Function
SQL COUNT(), AVG() and SUM() Functions
Display data from SQL database with MySQLi into php - html table
SQL mysql order by columns, by date, by asc, by desc, random with PHP
PHP mysqli_query() Function - mysqli query
SQL delete row - SQL delete table
SQL update - SQL update select
Insert into SQL - Insert into table SQL - Insert data in sql
Login in PHP - simple login script with PHP MYSQL