Upload Image to MySQL BLOB

# MySQL BLOB using PHP FULL (ok) ### Ví dụ 1:

C:\xampp71\htdocs\testpro\index.php ```php 0) { if (is_uploaded_file($_FILES['userImage']['tmp_name'])) { $imgData = file_get_contents($_FILES['userImage']['tmp_name']); $imgType = $_FILES['userImage']['type']; $sql = 'INSERT INTO tbl_image(imageType ,imageData) VALUES(?, ?)'; $statement = $conn->prepare($sql); $statement->bind_param('ss', $imgType, $imgData); $current_id = $statement->execute() or die('Error: Problem on Image Insert
' . mysqli_connect_error()); } } ?> Upload Image to MySQL BLOB ``` C:\xampp71\htdocs\testpro\listImages.php ```php prepare( $sql ); $stmt->execute(); $result = $stmt->get_result(); ?> num_rows > 0 ) { while ( $row = $result->fetch_assoc() ) { ?>

'> ``` C:\xampp71\htdocs\testpro\db.php ```php ``` C:\xampp71\htdocs\testpro\structure.sql ```sql CREATE TABLE `tbl_image` ( `imageId` int(11) NOT NULL, `imageType` varchar(255) NOT NULL, `imageData` longblob NOT NULL ); -- -- Indexes for dumped tables -- -- -- Indexes for table `tbl_image` -- ALTER TABLE `tbl_image` ADD PRIMARY KEY (`imageId`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `tbl_image` -- ALTER TABLE `tbl_image` MODIFY `imageId` int(11) NOT NULL AUTO_INCREMENT; ``` C:\xampp71\htdocs\testpro\css\form.css ```css input, textarea, select { box-sizing: border-box; width: 200px; height: initial; padding: 8px 5px; border: 1px solid #9a9a9a; border-radius: 4px; } input[type="checkbox"] { width: auto; vertical-align: text-bottom; } textarea { width: 300px; } select { display: initial; height: 30px; padding: 2px 5px; } button, input[type=submit], input[type=button] { padding: 8px 20px; font-size: 1em; cursor: pointer; border-radius: 25px; color: #000000; background-color: #ffc72c; border-color: #ffd98e #ffbe3d #de9300; } input[type=submit]:hover { background-color: #f7c027; } ::placeholder { color: #bdbfc4; } label { display: block; color: #565656; } ``` C:\xampp71\htdocs\testpro\css\style.css ```css body { font-family: -apple-system, BlinkMacSystemFont, Roboto, Segoe UI, Helvetica Neue, Helvetica, Arial, sans-serif; margin: 0 auto; -webkit-font-smoothing: antialiased; box-sizing: border-box; color: #2f2f2f; line-height: 1.5; } a { text-decoration: none; color: #2f20d1; } a:hover { text-decoration: underline; } img { height: auto; max-width: 100%; vertical-align: middle; } .phppot-container { width: 740px; margin: 20 auto; padding: 0px 20px 0px 20px; } .row { padding: 6px 0 6px 0; } .label { color: #565656; margin-bottom: 2px; } .card { padding: 1rem 2rem; border-radius: 4px; box-shadow: 0 1px 3px #747681; } .message { padding: 6px 20px; font-size: 1em; color: rgb(40, 40, 40); box-sizing: border-box; margin: 0px; border-radius: 3px; width: 100%; overflow: auto; } .error { background-color: #fb817c; border: 1px solid #e46b66; } .success { background-color: #48e0a4; border: #40cc94 1px solid; } .validation-message { color: #e20900; } .font-bold { font-weight: bold; } .display-none { display: none; } .inline-block { display: inline-block; } .float-right { float: right; } .float-left { float: left; } .text-center { text-align: center; } .text-left { text-align: left; } .text-right { text-align: right; } .full-width { width: 100%; } .cursor-pointer { cursor: pointer; } .mr-20 { margin-right: 20px; } .m-20 { margin: 20px; } .tile-container { width: 240px; border: #9a9a9a 1px solid; border-radius: 3px; padding: 10px 20px 10px 20px; } @media all and (max-width: 780px) { .phppot-container { width: auto; } } @media all and (max-width: 400px) { .phppot-container { padding: 0px 20px; } .tile-container { width: auto; } input, textarea, select { width: 100%; } } ``` ### Ví dụ 2: {% embed url="" %} ``` CREATE TABLE `products` (product_id BIGINT PRIMARY KEY AUTO_INCREMENT, product_name VARCHAR(50), price DOUBLE, product_image BLOB) ENGINE = InnoDB; ```

C:\xampp71\htdocs\testpro\config.php ```php setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false); ``` C:\xampp71\htdocs\testpro\insert\_products.php ```php 'VIRTUAL SERVERS', 'price' => 5, 'product_image' => file_get_contents('https://i.imgur.com/VEIKbp0.png') ]; $products[] = [ 'product_name' => 'MANAGED KUBERNETES', 'price' => 30, 'product_image' => file_get_contents('https://i.imgur.com/cCc9Gw9.png') ]; $products[] = [ 'product_name' => 'MySQL DATABASES', 'price' => 15, 'product_image' => file_get_contents('https://i.imgur.com/UYcHkKD.png') ]; $sql = 'INSERT INTO products(product_name, price, product_image) VALUES (:product_name, :price, :product_image)'; foreach ($products as $product) { $stmt = $pdo->prepare($sql); $stmt->execute($product); } echo 'Records inserted successfully'; ``` C:\xampp71\htdocs\testpro\display\_products.php ```php Using BLOB and MySQL prepare($sql); $stmt->execute(); ?> fetch(PDO::FETCH_ASSOC)) { echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; } ?>

Products Database
Product Id	Product Name	Price	Product Image
' . $row['product_id'] . '	' . $row['product_name'] . '	' . $row['price'] . '	' . '' . '

``` --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://learnphp.gitbook.io/learnphp/mysql-blob-using-php-full-ok.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.