mysql_connection.php

<?php
// Start the session
session_start();
?>

<?php

/* Localhost MySQL server 
$db_hostname = "localhost";
$db_username = "root";
$db_password = "";
$db_name = "skywars";
/* */

/* Pebblehost MySQL server */
$db_config = parse_ini_file("protected/config.ini");
$db_hostname = $db_config['db_hostname'];
$db_username = $db_config['db_username'];
$db_password = $db_config['db_password'];
$db_name = $db_config['db_name'];
/* */


// Open connection to the MySQL DB server
$db_connection = mysqli_connect($db_hostname, $db_username, $db_password, $db_name);

// Check connection to the MySQL DB server
if (mysqli_connect_errno()) {
  echo "Failed to connect to the MySQL server: " . mysqli_connect_error();
  exit();
}



// Check if $_GET super global variable is not null
// Fixes "Undefined array key" error
if (isset($_GET['q'])) {
  // Get searched data with $_GET
  $search = $_GET['q'];
  $search = mysqli_real_escape_string($db_connection, $search);

  // Select searched data from the MySQL DB server
  mysqli_select_db($db_connection, "sw_player");
  $db_query = "SELECT * FROM sw_player WHERE player_name LIKE '" . $search . "'";
  $db_results = mysqli_query($db_connection, $db_query);
}



// Check if $_GET super global variable is not null
// Fixes "Undefined array key" error
if (isset($_GET['results'])) {
  // Get searched data with $_GET
  // Sent through ajax_search.js
  $livesearh = $_GET['results'];
  $livesearh = mysqli_real_escape_string($db_connection, $livesearh);

  // Select data from DB
  mysqli_select_db($db_connection, "sw_player");
  $db_query_livesearch = "SELECT player_name FROM sw_player WHERE player_name LIKE '%" . $livesearh . "%' LIMIT 10";
  $db_results_livesearch = mysqli_query($db_connection, $db_query_livesearch);

  // Check if at least 1 character is entered in the search bar
  if (strlen($livesearh) > 1) {
    while ($row = mysqli_fetch_array($db_results_livesearch)) {
      echo '<a href="search.php?q=' . $row["player_name"] . '">' . $row["player_name"] . '</a><br>';
    }
  }
}



// Close connection to the MySQL DB server
mysqli_close($db_connection);

?>