How to Insert Images to MySQL and Display Them Using PHP 

Thank you.

saved from watching his video

LOUDER

saved 15 minutes.

I laughed when they wanted $5 for the source. OMG how lame. I am sure I can find it somewhere else for free. Thanks for nothing Clever Techie. ROFLOL

ya it is a nice video but you can check also this y2u.be/Hf8bJiRBPio

how can i do that

@@theekingyodah1431, images' data is in the form of byte array. Save that in images table data column and you'll be fine ;)

nice video you can also check this one too y2u.be/Hf8bJiRBPio

Insert in the bd images isn't a good idea, although you can do it but is a bad practice. With mysql only inserted the name not the images. Imagine for a second that u' insert in your db thousands images.... The bd colapse. At the first seconds of the video he was create two folders, local and web.. Web is the folder that you have in your server (proyect folder), it's where u' insert your images. And in the bd you insert the name for this images.

Gam Nguyen create another table and upload form with the .txt holding the information and rinse and repeat with the images. You will have to tweak it to the new table and .txt extension

@@productivearab9438 Thank you! Please confirm if I understand correctly: You mean I should create two tables, linking them using foreign key, then insert the text form data in one table and the images in another table?

Echo is used to write HTML using PHP so just do CSS in the echo elemenets

hey anthony, do you find solution to your question yet? I need help on it too. if you do, please share

​@@onadiranbayonle2368 I'm also finding a problem with this, if u have gotten a solution plz help me out

Firebase could be the answer to what you guys are looking for maybe?

@@bashmunir3928 check this out, does it answer your question if(isset($_FILES['image'])){ $generalError = ''; $fileName = $_FILES['image']['name']; $fileSize = $_FILES['image']['size']; $fileTmp = $_FILES['image']['tmp_name']; $fileType = $_FILES['image']['type']; $fileExt = strtolower(pathinfo($fileName, PATHINFO_EXTENSION)); $extensions = array('jpeg', 'jpg', 'png'); if(! file_exists($fileTmp)){ $imageExisteneceError = 'choose image file to upload'; } elseif(! in_array($fileExt, $extensions)){ $imageExtensionError = 'please choose the image which has the as jpeg, jpg, png'; } elseif($fileSize > 1000000){ $imageSizeError = 'sorry, file should not be than 1MB'; } else{ move_uploaded_file($fileTmp, "blogPhotoUpload/".$fileName); $insertBlogPostQuery = "INSERT INTO blogpost (post_title,post_image, post_content) VALUES ('$postTitle', '$fileName', '$postContent')" ; $result = mysqli_query($conn, $insertBlogPostQuery); if (!$result) { die ('query failed'); }

Subscribe to my patreon - patreon.com/clevertechie

paypal is online could be use anywhere xoxo

Welcome

;)

I tried storing the image as a BLOB in MySql, but the server kept timing out on and insert. That led me to this video.