تنظیم سرور Apache با PHP و SSH در Linux

sudo apt update && sudo apt upgrade -y
sudo apt install apache2 mysql-server php libapache2-mod-php php-mysql -y

sudo systemctl start apache2
sudo systemctl enable apache2

sudo systemctl start mysql
sudo systemctl enable mysql

sudo mysql_secure_installation

sudo mysql -u root -p

CREATE DATABASE mydatabase;
CREATE USER 'abdessamad'@'%' IDENTIFIED BY '123456789';

# Creates a new MySQL user myuser with the password mypassword.
# The @'%' part allows the user to connect from any host (% is a wildcard representing any IP address).
GRANT ALL PRIVILEGES ON mydatabase.* TO 'abdessamad'@'%';

# Refreshes the MySQL server's internal cache of user privileges. This is necessary after creating users or changing privileges to apply the changes.
FLUSH PRIVILEGES;
EXIT;

sudo rm -rf /var/www/html/*
sudo nano /var/www/html/index.php

echo "its finaly working ..."
?>

# Change ownership of all files and directories in /var/www/html recursively
# The user and group ownership is set to 'www-data' which is the default user/group for web servers (Nginx/Apache)
sudo chown -R www-data:www-data /var/www/html

# - Owner (www-data) has read, write, and execute permissions (7)
# - Group (www-data) and Others have read and execute permissions, but no write permissions
sudo chmod -R 755 /var/www/html

sudo systemctl restart apache2

sudo nano /etc/apache2/sites-available/000-default.conf

    DocumentRoot /var/www/html
    
        AllowOverride All
        Require all granted
    

sudo ufw allow 80/tcp
sudo ufw allow 3306/tcp
sudo ufw reload

sudo a2enmod rewrite
sudo systemctl restart apache2

ip a

sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf

bind-address = 0.0.0.0

sudo systemctl restart mysql

sudo mysql -u root -p

CREATE DATABASE mydatabase;
USE mydatabase;

CREATE TABLE books (
id INT AUTO_INCREMENT PRIMARY KEY,
title VARCHAR(255) NOT NULL,
author VARCHAR(255) NOT NULL,
genre VARCHAR(100),
published_date DATE,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

$servername = "localhost";
$username = "myuser";
$password = "mypassword";
$dbname = "mydatabase";

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

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

if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $title = $_POST['title'];
    $author = $_POST['author'];
    $genre = $_POST['genre'];
    $published_date = $_POST['published_date'];

    $sql = "INSERT INTO books (title, author, genre, published_date) 
            VALUES ('$title', '$author', '$genre', '$published_date')";

    if ($conn->query($sql) === TRUE) {
        echo "New book added successfully";
    } else {
        echo "Error: " . $sql . "
" . $conn->error;
    }
}

// Fetching all books
$sql = "SELECT id, title, author, genre, published_date FROM books";
$result = $conn->query($sql);

$conn->close();
?>


 lang="en">

     charset="UTF-8">
     name="viewport" content="width=device-width, initial-scale=1.0">