php connect database phpmyadmin code example

Example 1: mysql connection phpmyadmin

<?php
  // This is for checking if your file is linked in your page or game or whatever
  echo "IT WORKS"; // My File is successfuly Linked

  //Remember to create a Database in phpmyadmin or any Online Database
  // the values passed in this parameters are:  the host, the user, user password and the database Name
  $con = mysqli_connect('localhost', 'root', 'root', 'unityaccess');

  // check that connection happen
  if(mysqli_connect_errno()) {
    echo "1: Connection Failed"; //error code #1 = connection Failed
    exit();
  }
?>

Example 2: using mysql database with php

<?php
$servername = "localhost";
$username = "yourusername"; // For MYSQL the predifined username is root
$password = "yourpassword"; // For MYSQL the predifined password is " "(blank)

// Create connection
$conn = new mysqli($servername, $username, $password);

 
// Check connection

 if ($conn->connect_error) {

    die("Connection failed: " . $conn->connect_error);
}

echo "Connected successfully";

?>