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.