<?php

// database connecion

$host = 'localhost';
$user = 'root';
$pass = '';
$db_name = 'xxxxx';

$db = new mysqli($host, $user, $pass, $db_name) or die("Connection error: ".mysqli_connect_error());
echo "Success."

// do something in an existing db

$sql_insert = "INSERT INTO employees (fname, lname) VALUES('John', 'Smith')";


$result_insert = mysqli_query($db, $sql_insert) or die ("Bad Query:\n$sql_insert\nTry this query in PhpMyAdmin for better debugging feedback.");
echo "Success.";


$sql_query = "SELECT * FROM employees";

$result_query = mysqli_query($db, $sql_query) or die ("Bad Query:\n$sql_query\nTry this query in PhpMyAdmin for better debugging feedback.");
//print_r($result_query);


while ($row = mysqli_fetch_assoc($result_query)) {
	print_r($row);
	// echo "{$row['fname']} ";
	// echo "{$row['lname']}";
	echo "<br>";
}





?>