Database Connection in PHP with MySQL in Xampp Code

Database Connection in PHP with MySQL in Xampp Code

Connect MySQL database using a PHP script. In this tutorial, you will learn how to connect the MySQL database using PHP in Xampp code with the MySQL database connection function.

Database Connection in PHP with MySQL in Xampp Code

Before you create a phpmyadmin database connection using a PHP script, you must know about the PHP MySQL connection function:

mysqli_connect

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

Syntax

mysqli_connect(host,username,password,new_link,client_flag);

Host

The hostname that runs the database server If not specified, the default value will be localhost.

username

Username accessing the database If not specified, the default will be the name of the user who is the owner of the server process.

password

The default value is defined by MySQL default password. In SQL secure mode, this parameter is ignored and a blank password is used.

new_link

If mysqli_connect () is called with other arguments, no new connection will be established. Instead, the identifier of the already open connection will be returned.

client_flags

  • MYSQL_CLIENT_SSL – Use SSL encryption.
  • MYSQL_CLIENT_COMPRESS – Use Compression Protocol.
  • MYSQL_CLIENT_IGNORE_SPACE – Allow the location after the function names.
  • MYSQL_CLIENT_INTERACTIVE – Allow passive seconds of idle time before closing connection.
  • Example For MySQL Connection

How to connect to database with MySQL using PHP Xampp

Use the following php program to connect phpmyadmin database in php with xampp.

So, you can create a db.php file and update the below code in your file for connecting a MySQL database:

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

// Create connection
$conn = mysqli_connect($host, $username, $password);

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

mysqli_close($conn);
?>

Conclusion

In this tutorial, you have learned how you can easily connect the database using PHP script.

Recommended PHP Tutorials

AuthorAdmin

My name is Devendra Dode. I am a full-stack developer, entrepreneur, and owner of Tutsmake.com. I like writing tutorials and tips that can help other developers. I share tutorials of PHP, Python, Javascript, JQuery, Laravel, Livewire, Codeigniter, Node JS, Express JS, Vue JS, Angular JS, React Js, MySQL, MongoDB, REST APIs, Windows, Xampp, Linux, Ubuntu, Amazon AWS, Composer, SEO, WordPress, SSL and Bootstrap from a starting stage. As well as demo example.

Leave a Reply

Your email address will not be published. Required fields are marked *