PHP MYSQL
quick guide & example
IMAGES TABLE name | VARCHAR PRIMARY data | LONG BLOB
<form enctype="multipart/form-data"> <input type="file" name="upload" accept="image/*"> <input type="submit" value="GO!"> </form>
CONNECT TO DATABASE $pdo = new PDO("mysql:host=HOST; dbname=NAME;charset=utf8mb4", USER, PASSWORD);
SQL QUERY $stmt = $pdo->prepare("REPLACE INTO `images` (`name`, `data`) VALUES (?,?)");
SAVE INTO DATABASE $stmt->execute([ $_FILES["upload"]["name"], file_get_contents($_FILES["upload"] ["tmp_name"]) ]);
CONNECT TO DATABASE $pdo = new PDO("mysql:host=HOST; dbname=NAME;charset=utf8mb4", USER, PASSWORD);
GET IMAGE $stmt = $pdo->prepare("SELECT `data` FROM `images` WHERE `name`=?"); $stmt->execute(["IMG.JPG"]); $img = $stmt->fetchColumn();
IMAGE OUTPUT $mime = mime_content_type("IMG.JPG"); header("Content-type: $mime"); echo $img;