PHP ?????? ????? ?????? ??? ????? ???? ?? ?????. CRUD(??, ??, ????, ??)? ?? ???? ?????? ?? ? ?????. ?? ?? ?????(OOP) ??? ???? ??? ? ???? ?? ????? ??? ? ????. PHP? ?? MySQL? ???? ??????? ??? ??? ????? ??? ? ????.

? ??? ?????? OOP ? MySQL? ???? PHP CRUD ??????? ???? ??? ?????. ??? ?? ??? ??? ??? ?? ??? ???? ????? ?????? ??? ?????? ??? ? ?? ?? ????? ? ????.

? ???? ?? ?? PHP?? OOP ??? ???? ?????? ??? ?? ??? ??? ?? ? ????.

??

1. PHP?? OOP? ???
2. ???? ??
3. ?????? ??
4. ?? ??
5. ??????? ??
6. CRUD ?? ??
   • ???
   • ??
   • ????
   • ??
7. ??

1. PHP?? OOP? ???

?? ?? ?????(OOP) ? "??"? ???? ??? ???? ????? ???????. PHP?? OOP? ???? ?? ???? ???? ???? ???? ??? ?? ?????, ?????, ???? ?? ?? ? ????.

?????? ?? ? OOP ??? ????? ?? ??? ?????.

• ???? ??: ?????? ??? ??? ?????? ??? ??? ???? ??????.
• ????: ??????? ?? ???? ?????? ???? ???? ? ????.
• ?????: ??????? ???? ?? ??? ?????? ????? ? ????.

2. ???? ??

??? ???? ?? ?? ??? ?? ?? ??? ??? ?????. ????? ??? ?? ????? ???.

<code>php-crud/
├── config/
│   └── Database.php
├── controllers/
│   └── UserController.php
├── models/
│   └── User.php
├── views/
│   └── user_list.php
├── public/
│   └── index.php
└── .gitignore</code>

• config/Database.php: ?????? ?? ??? ???? ????.
• controllers/UserController.php: CRUD ??? ???? ??? ?????.
• models/User.php: MySQL? ??? ???? ?? ???? ?? ??? ???? ????.
• views/user_list.php: ??? ???? ??? ???? ?????.
• public/index.php: ??????? ??????.

3. ?????? ??

MySQL?? ??????? ??? ???? ???? ??? ??? ?????. ?? SQL ??? ???? ??????? ??? ? ????.

CREATE DATABASE php_crud;

USE php_crud;

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    email VARCHAR(100) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

? ????? ??, ???, ?? ?? ? ?? ??? ??? ?????.

4. ?? ??

?? ?? ??? ??????. ? ??? ??? ??? ????.

• config/: ?????? ?? ? ?? ??? ???? ????.
• controllers/: ??? ???? ???? ?? ???? ?????.
• models/: ???? ??? ?????? ?? ??? ?????.
• views/: ????? ???? ?????.
• public/: public ???? ??????? ??? ??? ?? index.php ??? ???? ????.

5. ??????? ??

config/Database.php?? ?????? ?? ???? ???? ??? ??? ?????.

<code>php-crud/
├── config/
│   └── Database.php
├── controllers/
│   └── UserController.php
├── models/
│   └── User.php
├── views/
│   └── user_list.php
├── public/
│   └── index.php
└── .gitignore</code>

? ???? MySQL? ?? PDO ??? ???? ?????? ???? ? ????.

6. CRUD ?? ??

??? ???? ???? ?? ??? ??? ?????. ? ???? ??? ???? ?? ???? CRUD ??? ?????.

?? ??(User.php)

CREATE DATABASE php_crud;

USE php_crud;

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    email VARCHAR(100) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

???? ??(UserController.php)

<?php namespace Config;

use PDO;

class Database
{
    private $host = '127.0.0.1';
    private $dbName = 'php_crud';
    private $username = 'root';
    private $password = '';
    private $connection;

    public function connect()
    {
        try {
            $this->connection = new PDO(
                "mysql:host={$this->host};dbname={$this->dbName}",
                $this->username,
                $this->password
            );
            $this->connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
            return $this->connection;
        } catch (PDOException $e) {
            die("Database connection failed: " . $e->getMessage());
        }
    }
}

?? ???(user_list.php)

<?php namespace Models;

use Config\Database;

class User
{
    private $conn;

    public function __construct()
    {
        $database = new Database();
        $this->conn = $database->connect();
    }

    public function create($name, $email)
    {
        $sql = "INSERT INTO users (name, email) VALUES (:name, :email)";
        $stmt = $this->conn->prepare($sql);
        $stmt->bindParam(':name', $name);
        $stmt->bindParam(':email', $email);
        return $stmt->execute();
    }

    public function read()
    {
        $sql = "SELECT * FROM users";
        $stmt = $this->conn->prepare($sql);
        $stmt->execute();
        return $stmt->fetchAll(\PDO::FETCH_ASSOC);
    }

    public function update($id, $name, $email)
    {
        $sql = "UPDATE users SET name = :name, email = :email WHERE id = :id";
        $stmt = $this->conn->prepare($sql);
        $stmt->bindParam(':name', $name);
        $stmt->bindParam(':email', $email);
        $stmt->bindParam(':id', $id);
        return $stmt->execute();
    }

    public function delete($id)
    {
        $sql = "DELETE FROM users WHERE id = :id";
        $stmt = $this->conn->prepare($sql);
        $stmt->bindParam(':id', $id);
        return $stmt->execute();
    }
}

??? ??(index.php)

<?php namespace Controllers;

use Models\User;

class UserController
{
    public function createUser($name, $email)
    {
        $user = new User();
        return $user->create($name, $email);
    }

    public function getUsers()
    {
        $user = new User();
        return $user->read();
    }

    public function updateUser($id, $name, $email)
    {
        $user = new User();
        return $user->update($id, $name, $email);
    }

    public function deleteUser($id)
    {
        $user = new User();
        return $user->delete($id);
    }
}

??

??? OOP ??? ??? PHP? ?? ??? ???? ???? ?? ??? CRUD ??????? ??????. ? ?? ??? ???? ??? ???? ????? ?? ????? ?????? ?? ??? ???? ? ????.

? ????? ??? ??? ??? ????.

• ???? ???? ?? ?? ??.
• MySQL ??? ?? ??? ??? ?????? ??????.
• ?? CRUD ??? ????? ??? ?????.
• ???? ??? ???? ?? UserController???.

? ??? ???? PHP ??????? ? ????, ?????, ???? ?????. ?? ? ?? ??? ???? OOP ? MySQL? ???? ? ?? ??? ??????? ??? ? ????.

??? ?????! ?

? ??? OOP ? MySQL? ???? PHP CRUD ?????? ??: ?? ?? ???? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!