How to Insert Images to MySQL and Display Them Using PHP

Upgrade your Clever Techie learning experience:

UPDATE! (9/13/19) New features and improvements for Clever Techie Patreons:

1. Download full source code with detailed comments - easy to learn and understand code
2. Weekly source code file updates by Clever Techie - every time I learn new things about a topic I will add it to the source file and let you know about the update - keep up with the latest coding technologies
3. Library of custom Clever Techie functions with descriptive, easy to understand comments - skyrocket coding productivity, code more efficiently by using Clever library of custom re-usable functions
4. Syntax code summary - memorize and review previously learned code faster
4. Organized file structure - access all Clever Techie lessons, source code, graphics, diagrams and cheat sheet from a single workspace - no more searching around for previously covered material and source code - save enormous amount of time and effort
5. Outline of topics the source file covers - fast review of all previously learned coding lessons
6. Access to all full HD 1080p videos with no ads
7. Console input examples - interactive examples that make it easier to understand and learn coding
8. Access to updated PHP Programming Book by Clever Techie
9. Early access to Clever Techie videos

Subscribe to Clever Techie patreon:
In this video we're going to learn how to insert images to MySQL database and then display them in a browser. We re-use the code from the multiple upload file video because we're still going to be uploading images to a web site, and then pulling the directory names from that folder to display the images from MySQL table.

``````````````````````````````````````````````````````````````````````````````````````````````
Hey guys, I'm now using Patreon to share improved and updated video content and source files. For a small fee you can access all the downloadable files from this lesson (source code, icons & graphics, cheat sheets, OneNote notes) and everything else included in the video from the Patreon page. Additionally, you will get access to ALL Clever Techie videos in HD format with no ads. Thank you so much for supporting Clever Techie :)

Download this video's files here:

( You also get access to ALL source code and any downloadable content of ALL Clever Techie videos, as well as access to ALL videos in HD 1080p quality format with all video ads removed! )

``````````````````````````````````````````````````````````````````````````````````````````````

[DylanNeo]

What is the point of a tutorial where you copy code from somewhere else you've written that you expect us to pay for?

[codemon_]

Hello techie... I think for multiple images, consider hashing the image names or generating some random figures for each image it would help when one tries to upload similar image name and type so to avaoid redundancy

[dibraniuk]

Great tutorials ; Clever Techie will be missed .

[WolF-GameR-For-Games]

When I send more than 20 images together, only the first 20 images reach the database. What is the solution?

[VFRodriguez]

Good job. Well done. I have learned a lot with you. (And I am 64 )

[joshuacoonghe]

bro i couldn't get the source code

[dibraniuk]

Clever Techie has contributed a lot to the online free learning so thumbs up and thanks.

[DiyintheGhetto]

Hello, I have a question. Is it possible to generate a link after uploading the image? What I mean is I would like to upload a image to the database and have a link generated so when I go to that link it will display that image and nothing else?

[timoanjala]

Nice, very useful video! I will look through your other tutorials too!

[samrudhipatil]

How to align images ??
Like i want 4 images in 1 row next 4 images in 2nd row

[crunchraven]

Do you know how can i save to xampp to a table name results, to have a row by id of user?(user is another table)

[Qubson._.]

Fatal error: Uncaught Error: Call to undefined function reArrayFiles() - why?

[khansawidhani]

We are here to learn. We don't want to copy your existing code from somewhere. Why you edited the existing code? Not recommended for beginners.

[valentealejandroguardiolab]

i have a question if somebody can help me im doing a proyect almost like a store i have to put images in cards to display for the costumer using an admin view the problem is when i try to call the image from the database to to be shown in the card it doesnt work it just appears an icon of a little paper with green

[poorboy]

how can i put this in a form along with other information ???

[tgamerz]

img_dir is stored in php myadmin but / is missing that is why it is not showing up in the display.php.
any help?
i used print_r to see the img_dir. it is upload/pic.jpg. but / is not stored in phpmyadmin. any help plz?

[Ronnie_S]

Thank you so much! Your $img_dir variable demonstration at the 5:00-6:00 mark helped me resolved my display image dilemma!

[sohamzemse]

You could do better. You could store the image data in BLOB type and retrieve it directly. Why need to store it in some directory? And you ask people to pay you and you show them this.

[lisheng]

12:32
Why not to use Factory inside the while loop?

[nilagangKamoteQ]

I am sorry. I can't donate to your Patreon. I want to but I can't. I am just a student. I like your video. It helps me a lot. If I graduate and got a dissent job, I will support your Patreon. But for now I will subscribe to your channel and like videos. Thank you!