PHP Database connection

The collection of related data is called a database. XAMPP stands for cross-platform, Apache, MySQL, PHP, and Perl. It is among the simple light-weight local servers for website development.

Requirements: XAMPP web server procedure:

• Start XAMPP server by starting Apache and MySQL.
• Write PHP script for connecting to XAMPP.
• Run it in the local browser.
• Database is successfully created which is based on the PHP code.

In PHP, we can connect to the database using XAMPP web server by using the following path.

"localhost/phpmyadmin"

Steps in Detail:

• Open XAMPP and start running Apache, MySQL and FileZilla

• Now open your PHP file and write your PHP code to create database and a table in your database.

  PHP code to create a database:

  PHP

  <?php // Server name must be localhost $servername = "localhost"; // In my case, user name will be root $username = "root"; // Password is empty $password = ""; // Creating a connection $conn = new mysqli($servername, $username, $password); // Check connection if ($conn->connect_error) { die("Connection failure: " . $conn->connect_error); } // Creating a database named geekdata $sql = "CREATE DATABASE geekdata"; if ($conn->query($sql) === TRUE) { echo "Database with name geekdata"; } else { echo "Error: " . $conn->error; } // Closing connection $conn->close(); ?> 

• Save the file as "data.php" in htdocs folder under XAMPP folder.
• Then open your web browser and type localhost/data.php

Finally the database is created and connected to PHP.

If you want to see your database, just type localhost/phpmyadmin in the web browser and the database can be found.