How to Insert Images to MySQL and Display Them Using PHP

แชร์
ฝัง
  • เผยแพร่เมื่อ 24 พ.ย. 2024

ความคิดเห็น • 114

  • @DylanNeo
    @DylanNeo 5 ปีที่แล้ว +177

    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 5 ปีที่แล้ว +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

  • @dibraniuk
    @dibraniuk 5 ปีที่แล้ว +4

    Great tutorials ; Clever Techie will be missed .

  • @dibraniuk
    @dibraniuk 5 ปีที่แล้ว +2

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

  • @timoanjala4358
    @timoanjala4358 10 หลายเดือนก่อน

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

  • @WolF-GameR-For-Games
    @WolF-GameR-For-Games ปีที่แล้ว

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

  • @yasyashu3092
    @yasyashu3092 5 ปีที่แล้ว +3

    how to download ur source code?

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

  • @samrudhipatil3812
    @samrudhipatil3812 4 ปีที่แล้ว +1

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

  • @joshuacoonghe1854
    @joshuacoonghe1854 3 ปีที่แล้ว +2

    bro i couldn't get the source code

  • @Qubson._.
    @Qubson._. 7 หลายเดือนก่อน

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

  • @valentealejandroguardiolab5752
    @valentealejandroguardiolab5752 2 ปีที่แล้ว

    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

  • @t2gamerz4
    @t2gamerz4 3 ปีที่แล้ว

    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?

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

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

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

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

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

  • @poorboy2400
    @poorboy2400 5 ปีที่แล้ว +1

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

  • @lisheng262
    @lisheng262 2 ปีที่แล้ว

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

  • @eizzuliman2456
    @eizzuliman2456 4 ปีที่แล้ว +2

    can this code be use in notepade ++?>

  • @VFRodriguez
    @VFRodriguez 5 ปีที่แล้ว +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

  • @ahmoahmic1393
    @ahmoahmic1393 5 ปีที่แล้ว +1

    how to in this code get image size extension and format

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

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

  • @Mathsbom
    @Mathsbom 3 ปีที่แล้ว

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

  • @TECLOVENIA
    @TECLOVENIA 4 ปีที่แล้ว

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

  • @justanickname8960
    @justanickname8960 5 ปีที่แล้ว +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 4 ปีที่แล้ว

      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.

  • @analie1372
    @analie1372 3 ปีที่แล้ว

    can u do display if image is click

  • @dogvscatfunny9956
    @dogvscatfunny9956 ปีที่แล้ว

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

  • @JeremieNtiti-qh4on
    @JeremieNtiti-qh4on 6 หลายเดือนก่อน

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

  • @AbdulRahman-gb8wz
    @AbdulRahman-gb8wz 2 ปีที่แล้ว

    How do I add text to speech into it

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

      }

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

  • @lashmidaryanani3640
    @lashmidaryanani3640 5 ปีที่แล้ว +3

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

  • @Happystoreup
    @Happystoreup 5 ปีที่แล้ว

    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?

  • @dfdfg5646er
    @dfdfg5646er 5 ปีที่แล้ว +4

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

  • @samj94
    @samj94 4 ปีที่แล้ว

    How to store finger print using arduino

  • @caringtoolsrizqif7190
    @caringtoolsrizqif7190 4 ปีที่แล้ว

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

  • @Ronnie_S
    @Ronnie_S 3 ปีที่แล้ว +1

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

  • @johnberttubal985
    @johnberttubal985 5 ปีที่แล้ว +5

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

  • @adarshprabhalakumar6804
    @adarshprabhalakumar6804 4 ปีที่แล้ว

    You can add more image field in one table

  • @ony6182
    @ony6182 4 ปีที่แล้ว +1

    DONE! thankyou 😁👍

    • @valentinobahati9947
      @valentinobahati9947 4 ปีที่แล้ว

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

  • @cheongjiayun3901
    @cheongjiayun3901 5 ปีที่แล้ว +1

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

  • @janlawrence12
    @janlawrence12 3 ปีที่แล้ว

    link source code pls^^

  • @Shahzaib.55
    @Shahzaib.55 2 ปีที่แล้ว

    how to get source code?

    • @clevertechie
      @clevertechie  ปีที่แล้ว

      Subscribe to my patreon - patreon.com/clevertechie

  • @eriayoumadeitbralameck3205
    @eriayoumadeitbralameck3205 3 ปีที่แล้ว

    awesome video nice programming tutorial

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

    • @harshdhillon7160
      @harshdhillon7160 4 ปีที่แล้ว

      paypal is online could be use anywhere xoxo

  • @t2gamerz4
    @t2gamerz4 3 ปีที่แล้ว

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

  • @cedrio1027
    @cedrio1027 4 ปีที่แล้ว

    thx man you helped me

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

  • @ysad696
    @ysad696 2 หลายเดือนก่อน

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

  • @oldguy8177able
    @oldguy8177able 6 หลายเดือนก่อน

    does not work

  • @calebterawskyj5366
    @calebterawskyj5366 6 ปีที่แล้ว

    Rip to newsletter, press F

  • @VFRodriguez
    @VFRodriguez 5 ปีที่แล้ว +1

    Good job. God bless you.

  • @Alex_Eicher
    @Alex_Eicher 6 ปีที่แล้ว +4

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

  • @ajanthalakmal
    @ajanthalakmal 5 ปีที่แล้ว +1

    unlike an report from me to paying you for code

  • @zoltanfelhazi8446
    @zoltanfelhazi8446 5 ปีที่แล้ว

    You are a king :3

  • @alextwo4543
    @alextwo4543 3 ปีที่แล้ว

    Mistake from 1st line :( 🤦‍♂️

  • @jubaerrahman5464
    @jubaerrahman5464 ปีที่แล้ว

    nice ❤❤

  • @venkatasulochanapolisetty1139
    @venkatasulochanapolisetty1139 3 ปีที่แล้ว

    nice tutoriai video

  • @chrislx7007
    @chrislx7007 5 ปีที่แล้ว

    Thank You

  • @vitufez843
    @vitufez843 2 ปีที่แล้ว

    thanks bro

  • @tahashameli7699
    @tahashameli7699 2 ปีที่แล้ว

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

  • @tranhoang5825
    @tranhoang5825 3 ปีที่แล้ว

    this is video good

  • @zoherarnb3146
    @zoherarnb3146 ปีที่แล้ว

  • @muhammadferozk
    @muhammadferozk 5 ปีที่แล้ว +2

    just wast of time

  • @surajsharma007
    @surajsharma007 5 ปีที่แล้ว +2

    noob, so much confusion
    ,

  • @computerworld3835
    @computerworld3835 5 ปีที่แล้ว +1

    time wasting

  • @mariusbruviksinnes2978
    @mariusbruviksinnes2978 4 ปีที่แล้ว

    That nose is killing me

  • @mainurrifqizidan9557
    @mainurrifqizidan9557 4 ปีที่แล้ว +1

    kkkkkkkk this is marketing

  • @abdulsalam-tw1gi
    @abdulsalam-tw1gi 4 ปีที่แล้ว +1

    waste of time

  • @ISLaM-fh6ov
    @ISLaM-fh6ov 4 ปีที่แล้ว

    9:56 10:05

  • @ShamoOoS25
    @ShamoOoS25 5 ปีที่แล้ว

    Hi

  • @ujjvalw2684
    @ujjvalw2684 4 ปีที่แล้ว

  • @hasanafzal5892
    @hasanafzal5892 5 ปีที่แล้ว +1

    not good teacher

  • @ankitmeher102
    @ankitmeher102 2 ปีที่แล้ว

    Delete this video bro 😂😂

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