How to Insert Images to MySQL and Display Them Using PHP

Поділитися
Вставка
  • Опубліковано 18 вер 2024

КОМЕНТАРІ • 114

  • @dibraniuk
    @dibraniuk 5 років тому +5

    Great tutorials ; Clever Techie will be missed .

  • @DylanNeo
    @DylanNeo 5 років тому +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 4 роки тому +8

      Thank you.

    • @yogeshbhatt388
      @yogeshbhatt388 4 роки тому +8

      saved from watching his video

    • @naimroslann
      @naimroslann 4 роки тому +3

      LOUDER

    • @realdvgarg
      @realdvgarg 4 роки тому +12

      saved 15 minutes.

    • @fredericklowe568
      @fredericklowe568 4 роки тому +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

  • @codemon_
    @codemon_ 6 років тому +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 4 роки тому +2

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

    • @valentinobahati9947
      @valentinobahati9947 4 роки тому

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

  • @timoanjala4358
    @timoanjala4358 8 місяців тому

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

  • @dibraniuk
    @dibraniuk 5 років тому +2

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

  • @Ronnie_S
    @Ronnie_S 2 роки тому +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 Рік тому

    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!

  • @VFRodriguez
    @VFRodriguez 5 років тому +1

    Good job. God bless you.

  • @crunchraven000
    @crunchraven000 3 роки тому +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)

  • @ony6182
    @ony6182 4 роки тому +1

    DONE! thankyou 😁👍

    • @valentinobahati9947
      @valentinobahati9947 4 роки тому

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

  • @JeremieNtiti-qh4on
    @JeremieNtiti-qh4on 4 місяці тому

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

  • @WolF-GameR-For-Games
    @WolF-GameR-For-Games 9 місяців тому

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

  • @joshuacoonghe1854
    @joshuacoonghe1854 3 роки тому +2

    bro i couldn't get the source code

  • @eriayoumadeitbralameck3205
    @eriayoumadeitbralameck3205 3 роки тому

    awesome video nice programming tutorial

  • @samrudhipatil3812
    @samrudhipatil3812 4 роки тому +1

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

  • @yasyashu3092
    @yasyashu3092 5 років тому +3

    how to download ur source code?

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

  • @liudasstonys1293
    @liudasstonys1293 5 років тому +4

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

    • @theekingyodah1431
      @theekingyodah1431 4 роки тому

      how can i do that

    • @liudasstonys1293
      @liudasstonys1293 4 роки тому

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

  • @t2gamerz4
    @t2gamerz4 2 роки тому

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

  • @cedrio1027
    @cedrio1027 4 роки тому

    thx man you helped me

  • @DiyintheGhetto
    @DiyintheGhetto 2 роки тому

    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?

  • @Qubson._.
    @Qubson._. 5 місяців тому

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

  • @lisheng262
    @lisheng262 2 роки тому

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

  • @sohamzemse
    @sohamzemse 5 років тому +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.

  • @justanickname8960
    @justanickname8960 4 роки тому +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 3 роки тому

      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.

  • @t2gamerz4
    @t2gamerz4 2 роки тому

    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?

  • @adarshprabhalakumar6804
    @adarshprabhalakumar6804 4 роки тому

    You can add more image field in one table

  • @dfdfg5646er
    @dfdfg5646er 5 років тому +4

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

  • @khansawidhani9899
    @khansawidhani9899 3 роки тому

    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.

  • @muhammadyusmanal-arifbinma9718
    @muhammadyusmanal-arifbinma9718 2 роки тому

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

  • @poorboy2400
    @poorboy2400 5 років тому +1

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

  • @ahmoahmic1393
    @ahmoahmic1393 5 років тому +1

    how to in this code get image size extension and format

  • @caringtoolsrizqif7190
    @caringtoolsrizqif7190 4 роки тому

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

  • @dogvscatfunny9956
    @dogvscatfunny9956 Рік тому

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

  • @venkatasulochanapolisetty1139
    @venkatasulochanapolisetty1139 3 роки тому

    nice tutoriai video

  • @chrislx7007
    @chrislx7007 5 років тому

    Thank You

  • @Mathsbom
    @Mathsbom 3 роки тому

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

  • @eizzuliman2456
    @eizzuliman2456 4 роки тому +2

    can this code be use in notepade ++?>

  • @analie1372
    @analie1372 2 роки тому

    can u do display if image is click

  • @TECLOVENIA
    @TECLOVENIA 3 роки тому

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

  • @tahashameli7699
    @tahashameli7699 2 роки тому

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

  • @Happystoreup
    @Happystoreup 4 роки тому

    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 4 роки тому

      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 4 роки тому

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

  • @AbdulRahman-gb8wz
    @AbdulRahman-gb8wz 2 роки тому

    How do I add text to speech into it

  • @vitufez843
    @vitufez843 2 роки тому

    thanks bro

  • @samj94
    @samj94 3 роки тому

    How to store finger print using arduino

  • @anthonyoburu
    @anthonyoburu 2 роки тому

    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 2 роки тому +1

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

    • @bashmunir3928
      @bashmunir3928 2 роки тому

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

    • @ibnOrfi
      @ibnOrfi 2 роки тому

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

    • @onadiranbayonle2368
      @onadiranbayonle2368 2 роки тому

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

      }

  • @ysad696
    @ysad696 17 днів тому

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

  • @hutyinsight1306
    @hutyinsight1306 2 роки тому

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

    • @ovarer
      @ovarer 2 роки тому

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

  • @calebterawskyj5366
    @calebterawskyj5366 6 років тому

    Rip to newsletter, press F

  • @johnberttubal985
    @johnberttubal985 5 років тому +5

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

  • @fredericklowe568
    @fredericklowe568 4 роки тому +1

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

    • @rickylove1449
      @rickylove1449 4 роки тому

      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.

  • @oldguy8177able
    @oldguy8177able 4 місяці тому

    does not work

  • @Shahzaib.55
    @Shahzaib.55 Рік тому

    how to get source code?

    • @clevertechie
      @clevertechie  Рік тому

      Subscribe to my patreon - patreon.com/clevertechie

  • @ajanthalakmal
    @ajanthalakmal 5 років тому +1

    unlike an report from me to paying you for code

  • @zoherarnb3146
    @zoherarnb3146 Рік тому

  • @tranhoang5825
    @tranhoang5825 3 роки тому

    this is video good

  • @Alex_Eicher
    @Alex_Eicher 6 років тому +4

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

  • @janlawrence12
    @janlawrence12 3 роки тому

    link source code pls^^

  • @zoltanfelhazi8446
    @zoltanfelhazi8446 5 років тому

    You are a king :3

  • @lashmidaryanani3640
    @lashmidaryanani3640 5 років тому +3

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

  • @downloadhome1342
    @downloadhome1342 4 роки тому

    Dude Can You Do Pdf files

  • @hazratbilal699
    @hazratbilal699 5 років тому +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

  • @alextwo4543
    @alextwo4543 3 роки тому

    Mistake from 1st line :( 🤦‍♂️

  • @jubaerrahman5464
    @jubaerrahman5464 Рік тому

    nice ❤❤

  • @cheongjiayun3901
    @cheongjiayun3901 5 років тому +1

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

  • @muhammadferozk
    @muhammadferozk 4 роки тому +2

    just wast of time

  • @abdulsalam-tw1gi
    @abdulsalam-tw1gi 4 роки тому +1

    waste of time

  • @surajsharma007
    @surajsharma007 5 років тому +2

    noob, so much confusion
    ,

  • @mariusbruviksinnes2978
    @mariusbruviksinnes2978 4 роки тому

    That nose is killing me

  • @computerworld3835
    @computerworld3835 5 років тому +1

    time wasting

  • @mainurrifqizidan9557
    @mainurrifqizidan9557 4 роки тому +1

    kkkkkkkk this is marketing

  • @hasanafzal5892
    @hasanafzal5892 4 роки тому +1

    not good teacher

  • @ISLaM-fh6ov
    @ISLaM-fh6ov 4 роки тому

    9:56 10:05

  • @ShamoOoS25
    @ShamoOoS25 5 років тому

    Hi

  • @ujjvalw2684
    @ujjvalw2684 4 роки тому

  • @ankitmeher102
    @ankitmeher102 2 роки тому

    Delete this video bro 😂😂

  • @codemon_
    @codemon_ 6 років тому

    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