sudo hostnamectl set-hostname db0x-benji

sudo nano /etc/netplan/00-installer-config.yaml
sudo netplan apply

sudo apt clean
sudo apt install mariadb-server
sudo apt install galera-4
sudo nano /etc/mysql/mariadb.conf.d/60-galera.cnf

sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf

systemctl stop mariadb

sudo galera_new_cluster
sudo systemctl status mariadb

sudo systemctl start mariadb

sudo nano /etc/haproxy/haproxy.cfg

sudo systemctl restart haproxy

setsebool -P httpd_can_network_connect_db on
sudo yum install php php-mysql
sudo systemctl restart httpd.service
sudo mysql_secure_installation

sudo nano /var/www/html/info.php

<?php
phpinfo();
    ?>

sudo mysql
CREATE DATABASE shark_species;
USE shark_species;

CREATE TABLE sharks (
    id INT AUTO_INCREMENT PRIMARY KEY,
    species VARCHAR(100) NOT NULL,
    scientific_name VARCHAR(255) NOT NULL,
    average_size VARCHAR(50),
    habitat VARCHAR(100),
    description TEXT
);

INSERT INTO sharks (species, scientific_name, average_size, habitat, description)
VALUES
    ('Great White Shark', 'Carcharodon carcharias', 'Up to 6 meters', 'Oceans worldwide', 'The great white shark is notable for its size, with mature individuals growing up to 6.4 m in length and 3,324 kg in weight.'),
    ('Hammerhead Shark', 'Sphyrnidae', 'Up to 6 meters', 'Tropical and warm temperate waters worldwide', 'Hammerhead sharks are known for their distinctive, flattened heads, which are shaped like a double-sided mallet, called a cephalofoil.'),
    ('Whale Shark', 'Rhincodon typus', 'Up to 18 meters', 'Tropical and warm oceans', 'The whale shark is the largest known extant fish species, reaching up to 12.65 m (41.5 ft) in length. Despite its size, the whale shark feeds only on plankton and small fish through filter feeding.');

<?php
$servername = "10.0.5.201"; 
$username = "benji";
$password = "password";
$dbname = "shark_species";

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

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

// Fetch data from the database
$sql = "SELECT * FROM sharks";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // Output data of each row
    while($row = $result->fetch_assoc()) {
        echo "Species: " . $row["species"]. "<br>";
        echo "Scientific Name: " . $row["scientific_name"]. "<br>";
        echo "Average Size: " . $row["average_size"]. "<br>";
        echo "Habitat: " . $row["habitat"]. "<br>";
        echo "Description: " . $row["description"]. "<br><br>";
    }
} else {
    echo "0 results";
}
$conn->close();
?>

GRANT ALL PRIVILEGES ON *.* TO 'benji'@'10.0.5.100' IDENTIFIED BY 'password' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'benji'@'10.0.5.101' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;

<form action="search.php" method="post">
    <label for="species">Select a shark species:</label>
    <select name="species" id="species">
        <option value="Great White Shark">Great White Shark</option>
        <option value="Hammerhead Shark">Hammerhead Shark</option>
        <option value="Whale Shark">Whale Shark</option>
    </select>
    <button type="submit">Search</button>
</form>

<?php
// Connect to the MySQL database
$servername = "localhost"; // Replace with your MySQL server hostname or IP address
$username = "your_mysql_username";
$password = "your_mysql_password";
$dbname = "shark_species"; // Replace with your database name
$conn = new mysqli($servername, $username, $password, $dbname);

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

// Get the selected shark species from the form
$species = $_POST['species'];

// Prepare and execute the SQL query
$stmt = $conn->prepare("SELECT * FROM sharks WHERE species = ?");
$stmt->bind_param("s", $species);
$stmt->execute();
$result = $stmt->get_result();

// Display the search results
if ($result->num_rows > 0) {
    $row = $result->fetch_assoc();
    echo "<h2>" . $row["species"] . "</h2>";
    echo "<p><strong>Scientific Name:</strong> " . $row["scientific_name"] . "</p>";
    echo "<p><strong>Average Size:</strong> " . $row["average_size"] . "</p>";
    echo "<p><strong>Habitat:</strong> " . $row["habitat"] . "</p>";
    echo "<p><strong>Description:</strong> " . $row["description"] . "</p>";
} else {
    echo "No results found for the selected species.";
}

// Close the database connection
$conn->close();
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Shark Information</title>
</head>
<body>
    <h1>Welcome to Sharkipedia</h1>
    <p>Click the button below to get shark information:</p>
    <form action="sharks.php">
        <button type="submit">Click here to get shark info</button>
    </form>
</body>
</html>