How to Insert Images to MySQL and Display Them Using PHP
HTML-код
- Опубликовано: 12 июл 2024
- Upgrade your Clever Techie learning experience:
/ clevertechie
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:
/ clevertechie
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:
/ 21026294
( 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! )
``````````````````````````````````````````````````````````````````````````````````````````````
( Website ) clevertechie.com - PHP, JavaScript, Wordpress, CSS, and HTML tutorials in video and text format with cool looking graphics and diagrams.
( RUclips Channel ) / clevertechietube
( Google Plus ) goo.gl/J71p6f - clever techie video tutorials.
( Facebook ) / clevertechie
( Twitter ) / theclevertechie Хобби
Great tutorials ; Clever Techie will be missed .
What is the point of a tutorial where you copy code from somewhere else you've written that you expect us to pay for?
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
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
Clever Techie has contributed a lot to the online free learning so thumbs up and thanks.
Nice, very useful video! I will look through your other tutorials too!
Thank you so much! Your $img_dir variable demonstration at the 5:00-6:00 mark helped me resolved my display image dilemma!
Good job. Well done. I have learned a lot with you. (And I am 64 )
ya it is a nice video but you can check also this y2u.be/Hf8bJiRBPio
Good job. God bless you.
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?
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)
thx man you helped me
awesome video nice programming tutorial
You are a king :3
Great Tutorials, can you do it in videos except images?
Good to know :)
how can i put this in a form along with other information ???
how to in this code get image size extension and format
how to download ur source code?
Cette vidéo m'a été très utile !
Thank You
How to align images ??
Like i want 4 images in 1 row next 4 images in 2nd row
DONE! thankyou 😁👍
nice video you can also check this one too y2u.be/Hf8bJiRBPio
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
Hello bro, I would like to ask you to kindly teach how to retrieve students marksheet with profile image. Thank you.
You can add more image field in one table
Excuse me! Can we add some other form fields (e.g. description, address, email..) to the multiupload insert them to the database too? if yes, how can we do that? Thank you!
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?
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?
12:32
Why not to use Factory inside the while loop?
Thanks and its work for my project but i cant upload my image using safari(ios Browser) when i upload it in my webhost
Can you create a vedio for creating the image slide show with same method plz
bro i couldn't get the source code
can u do display if image is click
thanks. I want to hug you man
love you :)
God bless you
When I send more than 20 images together, only the first 20 images reach the database. What is the solution?
can you style the images and make them be in one table with proper arrangement..
NICE VIDEO
Echo is used to write HTML using PHP so just do CSS in the echo elemenets
nice tutoriai video
Fatal error: Uncaught Error: Call to undefined function reArrayFiles() - why?
thanks bro
Welcome
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!
nice ❤❤
can this code be use in notepade ++?>
this is video good
Rip to newsletter, press F
Hi. please can you do a tutorial to show how one can display an image dynamically on one's website from an online database registration page where you don't have the images locally on your computer. Thank you.
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');
}
А что просто путь прописать в БД нельзя на картинку?
How do I add text to speech into it
bro can u plzz give the source code
i really appreciate ur work
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.
You don't insert images, just their path...
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 ;)
How to store finger print using arduino
bro i got this why this would happened?:Uncaught Error: Call to undefined function reArrayFiles()
how to get source code?
Subscribe to my patreon - patreon.com/clevertechie
link source code pls^^
❤
Dude Can You Do Pdf files
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.
Sir, this is very helpful, sir i need this code, i will pay but i am from pakistan and there is no system of paypal, so can you please also share the source code,it will be very kind of you ! Thanks
paypal is online could be use anywhere xoxo
At 9:56 i think "missing echo" .... 10:05 voila... :-)
;)
you have a cold, don't you??😅😂
unlike an report from me to paying you for code
Can somebody post the code on comment. haha. I'am broke right now
9:56 10:05
u just doing business here.. u didnt even show us code.. this is not tutorial .. dislikes
does not work
Hi
"How to insert images to MySql..." I'm still waiting for you to show this, as you only inserted their names. Why do lie to ppl in the title of your video...?
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.
Mistake from 1st line :( 🤦♂️
That nose is killing me
Don't bother. Unless you want to pay for the source code.
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.
kkkkkkkk this is marketing
noob, so much confusion
,
just wast of time
time wasting
waste of time
not good teacher
Delete this video bro 😂😂
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