PHP? ???? ???? ??????? ???? ??

?? ??

????? ? ? HTML ???? ????? ?? PHP ??? ???? MySQL ??????? ???, SQL ???? ?? ??? ??? ???? ???? ????. ??.

?? ??

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

1. ? ?? ???? ?? MySQL ??: ??? ? ?? ???? ?? mysql ??? ?????. ? ??? PDO ?? ??? ?? ? ???? ?? MySQLi.
2. ??? ?? ??: ????? ??? ?? BLOB ????? ????? ?? ?????? ????? ???? ???.
3. SQL ?? ???: ?? ??? ??????? ???? ? ?? SQL ??? ?????. ???.
4. ??? SQL ??: INSERT ?? ??? ?? ????(") ?? ?????(')? ?????.

???

??? ??? ???? MySQL ??????? ???? ????? ?????? ??? ??????. ??:

1. PDO ?? MySQLi ??: ?????? ?? ??? ?? ? ?? ???? ?? mysql ??? PDO ?? MySQLi? ???? ??? ???? ??????.
2. BLOB ?? ?: ?????? ???? ??? ?? ???? ??? BLOB ???? ?????. data.
3. Prepared ? ??: ???? ?? ??? ????? ???? SQL ?? ???? ????? ??? ?? ?????.
4. ???? ??: ??? SQL? ????? INSERT ? ??? ??? ?? ????(")? ????. ??.

PDO? ??? ?? ?

PHP ??:

<?php

try {
    // Connect to the database using PDO
    $dsn = 'mysql:host=localhost;dbname=database_name';
    $username = 'username';
    $password = 'password';
    $conn = new PDO($dsn, $username, $password);

    // Check if the image column is BLOB type
    $query = "DESCRIBE table_name";
    $stmt = $conn->prepare($query);
    $stmt->execute();
    $result = $stmt->fetchAll(PDO::FETCH_ASSOC);

    if ($result[0]['Type'] != 'blob') {
        throw new Exception('The image column is not of BLOB type');
    }

    // Process the image upload
    $file = $_FILES['image']['tmp_name'];
    $image_name = $_FILES['image']['name'];
    $image = file_get_contents($file);

    // Prepare the INSERT statement
    $query = "INSERT INTO product_images (id, image_name, image) VALUES (1, ?, ?)";
    $stmt = $conn->prepare($query);

    // Execute the statement and bind parameters
    $stmt->execute([$image_name, $image]);

    // Success message
    echo "Image uploaded successfully";
} catch (Exception $e) {
    echo "Failed to upload image: " . $e->getMessage();
}

?>

HTML ??

<form action="insert_product.php" method="POST" enctype="multipart/form-data">
  <label for="image">File:</label>
  <input type="file" name="image">

?? ??

• ??????? ???? ???? ?? ??? ??? ?? ????? ? ??? ??? ??? ?? ? ????. ??? ??? ?? ?? ???? ???? ?? ??????.
• ????? ??? ??? ????? ??? ??? ?? ?? ??? ?????.
• ?? ??? ? ??? ??? ???? ?? ??? ?? ??? ?????.

? ??? PHP? ???? MySQL ??????? ???? ??? ? SQL ?? ??? ???? ??? ??????? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!