How to Insert Images to MySQL and Display Them Using PHP

Sdílet
Vložit
  • čas přidán 5. 09. 2024

Komentáře • 114

  • @DylanNeo
    @DylanNeo Před 5 lety +173

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

    • @Vichion
      @Vichion Před 4 lety +8

      Thank you.

    • @yogeshbhatt388
      @yogeshbhatt388 Před 4 lety +8

      saved from watching his video

    • @naimroslann
      @naimroslann Před 4 lety +3

      LOUDER

    • @realdvgarg
      @realdvgarg Před 4 lety +12

      saved 15 minutes.

    • @fredericklowe568
      @fredericklowe568 Před 4 lety +4

      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

  • @dibraniuk
    @dibraniuk Před 5 lety +5

    Great tutorials ; Clever Techie will be missed .

  • @codemon_
    @codemon_ Před 6 lety +7

    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

  • @VFRodriguez
    @VFRodriguez Před 4 lety +2

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

    • @valentinobahati9947
      @valentinobahati9947 Před 4 lety

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

  • @dibraniuk
    @dibraniuk Před 5 lety +2

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

  • @timoanjala4358
    @timoanjala4358 Před 7 měsíci

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

  • @Ronnie_S
    @Ronnie_S Před 2 lety +1

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

  • @nilagangKamoteQ
    @nilagangKamoteQ Před rokem

    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!

  • @crunchraven000
    @crunchraven000 Před 3 lety +1

    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)

  • @valentealejandroguardiolab5752

    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

  • @joshuacoonghe1854
    @joshuacoonghe1854 Před 3 lety +2

    bro i couldn't get the source code

  • @samrudhipatil3812
    @samrudhipatil3812 Před 4 lety +1

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

  • @muhammadyusmanal-arifbinma9718

    Thanks and its work for my project but i cant upload my image using safari(ios Browser) when i upload it in my webhost

  • @lisheng262
    @lisheng262 Před 2 lety

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

  • @ony6182
    @ony6182 Před 4 lety +1

    DONE! thankyou 😁👍

  • @yasyashu3092
    @yasyashu3092 Před 5 lety +3

    how to download ur source code?

  • @JeremieNtiti-qh4on
    @JeremieNtiti-qh4on Před 3 měsíci

    Cette vidéo m'a été très utile !

  • @WolF-GameR-For-Games
    @WolF-GameR-For-Games Před 9 měsíci

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

  • @Qubson._.
    @Qubson._. Před 4 měsíci

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

  • @t2gamerz4
    @t2gamerz4 Před 2 lety

    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?

  • @sohamzemse
    @sohamzemse Před 5 lety +5

    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.

  • @eriayoumadeitbralameck3205

    awesome video nice programming tutorial

  • @Mathsbom
    @Mathsbom Před 3 lety

    Can you create a vedio for creating the image slide show with same method plz

  • @poorboy2400
    @poorboy2400 Před 5 lety +1

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

  • @t2gamerz4
    @t2gamerz4 Před 2 lety

    thanks. I want to hug you man
    love you :)
    God bless you

  • @liudasstonys1293
    @liudasstonys1293 Před 5 lety +4

    You don't insert images, just their path...

    • @theekingyodah1431
      @theekingyodah1431 Před 4 lety

      how can i do that

    • @liudasstonys1293
      @liudasstonys1293 Před 4 lety

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

  • @DiyintheGhetto
    @DiyintheGhetto Před 2 lety

    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?

  • @adarshprabhalakumar6804

    You can add more image field in one table

  • @TECLOVENIA
    @TECLOVENIA Před 3 lety

    Hello bro, I would like to ask you to kindly teach how to retrieve students marksheet with profile image. Thank you.

  • @khansawidhani9899
    @khansawidhani9899 Před 3 lety

    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.

  • @caringtoolsrizqif7190
    @caringtoolsrizqif7190 Před 4 lety

    Great Tutorials, can you do it in videos except images?
    Good to know :)

  • @ahmoahmic1393
    @ahmoahmic1393 Před 5 lety +1

    how to in this code get image size extension and format

  • @VFRodriguez
    @VFRodriguez Před 5 lety +1

    Good job. God bless you.

  • @samj94
    @samj94 Před 3 lety

    How to store finger print using arduino

  • @analie1372
    @analie1372 Před 2 lety

    can u do display if image is click

  • @cedrio1027
    @cedrio1027 Před 4 lety

    thx man you helped me

  • @dogvscatfunny9956
    @dogvscatfunny9956 Před rokem

    А что просто путь прописать в БД нельзя на картинку?

  • @anthonyoburu
    @anthonyoburu Před 2 lety

    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.

    • @onadiranbayonle2368
      @onadiranbayonle2368 Před 2 lety +1

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

    • @bashmunir3928
      @bashmunir3928 Před 2 lety

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

    • @ibnOrfi
      @ibnOrfi Před 2 lety

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

    • @onadiranbayonle2368
      @onadiranbayonle2368 Před rokem

      @@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');

      }

  • @dfdfg5646er
    @dfdfg5646er Před 5 lety +4

    u just doing business here.. u didnt even show us code.. this is not tutorial .. dislikes

  • @hutyinsight1306
    @hutyinsight1306 Před 2 lety

    can you style the images and make them be in one table with proper arrangement..
    NICE VIDEO

    • @ovarer
      @ovarer Před 2 lety

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

  • @AbdulRahman-gb8wz
    @AbdulRahman-gb8wz Před 2 lety

    How do I add text to speech into it

  • @eizzuliman2456
    @eizzuliman2456 Před 4 lety +2

    can this code be use in notepade ++?>

  • @ysad696
    @ysad696 Před 4 dny

    If you want to create tutorial please do not use copy and paste
    Because we didn't have a clear understanding of it

  • @Happystoreup
    @Happystoreup Před 4 lety

    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!

    • @productivearab9438
      @productivearab9438 Před 4 lety

      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

    • @Happystoreup
      @Happystoreup Před 4 lety

      @@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?

  • @venkatasulochanapolisetty1139

    nice tutoriai video

  • @calebterawskyj5366
    @calebterawskyj5366 Před 6 lety

    Rip to newsletter, press F

  • @zoltanfelhazi8446
    @zoltanfelhazi8446 Před 5 lety

    You are a king :3

  • @chrislx7007
    @chrislx7007 Před 5 lety

    Thank You

  • @johnberttubal985
    @johnberttubal985 Před 5 lety +5

    Can somebody post the code on comment. haha. I'am broke right now

  • @justanickname8960
    @justanickname8960 Před 4 lety +12

    "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...?

    • @corporacionbhcorporacionbh923
      @corporacionbhcorporacionbh923 Před 3 lety

      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.

  • @oldguy8177able
    @oldguy8177able Před 3 měsíci

    does not work

  • @vitufez843
    @vitufez843 Před 2 lety

    thanks bro

  • @lashmidaryanani3640
    @lashmidaryanani3640 Před 5 lety +3

    bro can u plzz give the source code
    i really appreciate ur work

  • @Alex_Eicher
    @Alex_Eicher Před 6 lety +4

    At 9:56 i think "missing echo" .... 10:05 voila... :-)

  • @janlawrence12
    @janlawrence12 Před 3 lety

    link source code pls^^

  • @hazratbilal699
    @hazratbilal699 Před 5 lety +2

    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

  • @fredericklowe568
    @fredericklowe568 Před 4 lety +1

    Don't bother. Unless you want to pay for the source code.

    • @rickylove1449
      @rickylove1449 Před 3 lety

      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.

  • @tranhoang5825
    @tranhoang5825 Před 3 lety

    this is video good

  • @jubaerrahman5464
    @jubaerrahman5464 Před rokem

    nice ❤❤

  • @tahashameli7699
    @tahashameli7699 Před rokem

    you have a cold, don't you??😅😂

  • @cheongjiayun3901
    @cheongjiayun3901 Před 5 lety +1

    bro i got this why this would happened?:Uncaught Error: Call to undefined function reArrayFiles()

  • @alextwo4543
    @alextwo4543 Před 3 lety

    Mistake from 1st line :( 🤦‍♂️

  • @ajanthalakmal
    @ajanthalakmal Před 5 lety +1

    unlike an report from me to paying you for code

  • @downloadhome1342
    @downloadhome1342 Před 4 lety

    Dude Can You Do Pdf files

  • @Shahzaib.55
    @Shahzaib.55 Před rokem

    how to get source code?

    • @clevertechie
      @clevertechie  Před rokem

      Subscribe to my patreon - patreon.com/clevertechie

  • @abdulsalam-tw1gi
    @abdulsalam-tw1gi Před 4 lety +1

    waste of time

  • @zoherarnb3146
    @zoherarnb3146 Před rokem

  • @muhammadferozk
    @muhammadferozk Před 4 lety +2

    just wast of time

  • @hasanafzal5892
    @hasanafzal5892 Před 4 lety +1

    not good teacher

  • @computerworld3835
    @computerworld3835 Před 5 lety +1

    time wasting

  • @surajsharma007
    @surajsharma007 Před 5 lety +2

    noob, so much confusion
    ,

  • @mainurrifqizidan9557
    @mainurrifqizidan9557 Před 4 lety +1

    kkkkkkkk this is marketing

  • @ShamoOoS25
    @ShamoOoS25 Před 5 lety

    Hi

  • @mariusbruviksinnes2978

    That nose is killing me

  • @ISLaM-fh6ov
    @ISLaM-fh6ov Před 4 lety

    9:56 10:05

  • @ankitmeher102
    @ankitmeher102 Před 2 lety

    Delete this video bro 😂😂

  • @ujjvalw2684
    @ujjvalw2684 Před 4 lety

  • @codemon_
    @codemon_ Před 6 lety

    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