1.
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
2.
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
3.
//start connection
$query = "SELECT id, firstname, lastname FROM MyGuests";
$result = $conn->query($query);
4.
//Close the Connection
$conn->close();