PHP Database connection

0 0 1 minute read

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(); 
?> 