how deposit a picture to MYSQL database

A short, practical add-on to the thread that complements @shaocpa’s followups and the pointers from @noppid and @BlazingWolf: a reliable pattern, a minimal example, and common host-side pitfalls to check when uploads "work locally but fail on the host."

Keep uploads simple and safe: prefer saving image files to a controlled directory and storing a small metadata record in the database (filename, original name, MIME, size, upload timestamp). This avoids large-row I/O inside MySQL and makes serving, caching, and backups easier. If DB storage is required, use parameterized statements and a LONGBLOB for bigger images.

Example (save file on disk and insert metadata with PDO):

<?php
// $tmpPath = temporary uploaded file path (from the upload handler)
// $origName = original filename
$uploadsDir = __DIR__ . '/uploads';
if (!is_dir($uploadsDir)) mkdir($uploadsDir, 0755, true);

$filename = bin2hex(random_bytes(12)) . '.' . pathinfo($origName, PATHINFO_EXTENSION);
$target = $uploadsDir . '/' . $filename;

if (!move_uploaded_file($tmpPath, $target)) { /* handle error */ }

$pdo = new PDO($dsn, $user, $pass, [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]);
$stmt = $pdo->prepare('INSERT INTO images (filename, original_name, mime, size) VALUES (?, ?, ?, ?)');
$stmt->execute([$filename, $origName, mime_content_type($target), filesize($target)]);
?>

Troubleshooting checklist (hosts often differ): confirm upload size limits in php.ini (upload_max_filesize, post_max_size), ensure the script has write permission to the uploads directory, verify no mod_security rules or open_basedir restrictions block the write, and enable error logging to capture failed moves. Security notes: validate the MIME and image headers (don’t trust client filename/MIME), generate non-guessable filenames, store uploads outside webroot or block execution in the uploads folder, and restrict accepted types and sizes.