connection.php

<?php

// Database credentials
$_servername = "localhost";
$_username = "root";
$_password = "";
$_dbname = "location_db";

// Create connection
$_conn = @new mysqli($_servername, $_username, $_password, $_dbname);

// Check connection
if ($_conn->connect_error) {
	die("Connection failed: " . $conn->connect_error);
}

// For getting multiple records from database
function get_records($query = "") {
	global $_conn;
	$result = $_conn->query($query);

	if (!$result) {
		die("Error: " . $_conn->error);
	}

	$query_result = [];
	while ($row = $result->fetch_assoc()) {
		$query_result[] = $row;
	}

	return $query_result;
}

// For getting single record from database
function get_record($query = "") {
	global $_conn;
	$result = $_conn->query($query);

	if (!$result) {
		die("Error: " . $_conn->error);
	}

	return $result->fetch_assoc();
}

// For fireing query from database
function fire_query($query = "") {
	global $_conn;

	$result = $_conn->query($query);

	if (!$result) {
		die("Error: " . $_conn->error);
	}

	return $_conn->affected_rows;
}

$_conn->close();