How to Fetch / Display an IMAGE from DataBase using PHP Mysql

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

КОМЕНТАРІ • 92

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

    Much helpful bro, 9 hours on just a from i couldn't pull through but your video help, now am going to sleep.

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

    My go to channel for php thanks for sharing your knowledge

  • @migdhaam821
    @migdhaam821 4 роки тому +7

    For those of you getting the error "mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool "
    for the connection & while loop you can try the following line of codes
    $conn = mysqli_connect("localhost", "root", "", "db_name");
    $sql = "SELECT * FROM table_name";
    $result = mysqli_query($conn, $sql);
    while($row = mysqli_fetch_array($result))
    It worked for me. hope it works for you guys as well.

  • @jesuscuadro228
    @jesuscuadro228 Рік тому +1

    Thanks brother, this content is pure gold. You help me so much :)

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

    Thanks Sir I Total Opretion Lern For You Are You Tube Channel Thanks Best Of Luck

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

    Thank you bro. You're a life saver 😂🙌

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

    Thanks a lot, even ChatGPT didnt know how to solve this, u showed it correctly lol

  • @kawaiimonster2980
    @kawaiimonster2980 3 місяці тому

    Thank you very much you saved me

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

    Thank You , Solved my PROBLEM ☺

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

    frumos!

  • @Dojo2000
    @Dojo2000 5 місяців тому

    thanksss uuuuu !!!

  • @jeankaleb
    @jeankaleb 2 роки тому +5

    Nice video. But I already know how to do that. It is relatively easy. But what I care to know is. Once you have retrieved the images from the database table and displayed it on a screen. How can you make each image clickable so that only the data from the table where the image is stored is displayed.

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

      Hello did you find the solution am also looking for this ... Can we connect via WhatsApp?

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

    Onek vlo🙂

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

    Thank You

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

    Thank you. It worked!

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

    Nice

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

    Thank you bro!

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

    Awesome it works. What about inserting?

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

    it still works great today

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

    thank you!!!very useful!!!!!!!!!!

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

    Thank you so much bro

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

    awsome

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

    image is not showing, what can be the reason? My code is: echo '';

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

      how did you solve this error?

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

      @@shaikhnabeel6443 $typ = "jpeg";
      $bildname = $row['bildurl'];
      if (strcmp( strtolower( substr($bildname, strlen($bildname) - 4)), ".jpg") == 0) { $typ = "jpeg"; }
      if (strcmp( strtolower( substr($bildname, strlen($bildname) - 4)), ".png") == 0) { $typ = "png"; }
      if (strcmp( strtolower( substr($bildname, strlen($bildname) - 4)), ".tif") == 0) { $typ = "tif"; }
      if (strcmp( strtolower( substr($bildname, strlen($bildname) - 4)), ".bmp") == 0) { $typ = "bmp"; }
      try {
      $imagick = new Imagick();
      $imageblob = $row2['file'];
      $imagick->readImageBlob( $imageblob );
      //$imagick_properties = $imagick->getImageProperties('*', FALSE);
      $height = $imagick->getImageHeight();
      $width = $imagick->getImageWidth();

      if ($width > 400) {
      $factor = 400 / $width;
      $height = $height * $factor;
      $width = 400;
      }
      echo '';
      echo $bilddaten . "";
      } catch (Exception $e) {
      }

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

      @@StephanPetrowitsch thanx bro i solved it.

  • @sofiyaabrar3783
    @sofiyaabrar3783 4 роки тому +5

    Image is not shown ...instead of it cross mark over is shown 😑

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

      i have the same problem. did you solve it?

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

    Hello, can you please show us how to zoom-in the picture (took from the data-base) in another page using a link ()

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

    Parse error: syntax error, unexpected end of file in C:\wamp64\www\g\displayimage.php showing last line

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

    Thanks B)

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

    another one down thanks

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

    hi is it possible for you to make a tutorial on how to download these files aswell with their original file extension because i realized all we need to do is figure out how to change the extension on download

  • @katrinahew4246
    @katrinahew4246 2 роки тому +2

    why don't you just post a link for us to download the code?

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

    Bro, I'm your subscriber. Now I need your help to retrieve the same content procedure using search. I mean to say it should be able to retrieve like students marksheet with photo. Thank you in anticipation.

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

    I made this example, but as I have many records in the database with photos, it doesn't work. It gives the error "Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 2893560 bytes)".

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

    Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in C:\xampp\htdocs ye error aa raha he sir plz help

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

      If ke aandar dalo aur $result saath mysqli_num pass karo

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

      @@rtxcomet3681 bro pls tell the format

  • @opticalfiber661
    @opticalfiber661 2 роки тому +1

    how can i update image from mysql using php ?

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

    Its a nice video. Can you a code to print it in pdf?

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

    followed your steps to fetch images from the database but the image cannot be displayed, the image is broken, why?

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

    image isnt displaying else all other data is dislayed plss help

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

    Can i insert the code for audio files the same way?

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

    PROBLEM FIXED BY ME: ANDREA MAE BUTALID
    FOR THOSE IMAGES STILL NOT APPEAR
    IMAGE DATA TYPE (TYPE) WILL BE BLOB IN DATABASE WHILE MAKING TABLE AND INSERT YOUR DATA IN DATABASE BY UPLOADING THE IMAGE FILE IN DATABASE THANKS ME LATER HOPE YOU UNDERSTAND.

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

    Between MySQLI and PDO which one is best? 🤦‍♂

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

    ty

  • @KashifAli-tf4rc
    @KashifAli-tf4rc 5 років тому +1

    Dear, have you accounts software for school or university?

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

    Hi Sir, Im just getting the alt value only... No image is displaying

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

      keep img save into the same folder as where your file

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

    how ican create search bar which my search artist videos from the database using php and mysqli

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

    image not showing, this is my code

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

    Why is only half of my picture coming out? pls😭😭

  • @UzairKhan-if5uh
    @UzairKhan-if5uh 3 роки тому

    bro dont mind but in this video you are doing only your work , you are not teaching how to do that... but well effort...

  • @KashifAli-tf4rc
    @KashifAli-tf4rc 5 років тому +1

    Images/images/field how to get image from this path plz explain i will thankful to you

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

      ua-cam.com/video/e-vmQhNqLMM/v-deo.html

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

    Is it possible to save image in database by entering path in php??

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

      Here, it is for image upload with saving path in database.
      ua-cam.com/video/7S42lpImZ4s/v-deo.html

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

    sorry iwant to learn how to search videos from mysql database using php and mysql help me

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

      To Insert Video into Database u can use Upload in php
      ua-cam.com/video/QT2aFYbWP74/v-deo.html
      Searching your video on the table ... by stored names u can use.. datatables
      ua-cam.com/video/oOL--VASs8Q/v-deo.html

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

    If you post it to the web, can people see your database password when they check the page source?

    • @god_rex579
      @god_rex579 3 роки тому +1

      People will not be able to see what's written in the PHP code because all the php the code get hidden

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

    image is not showing, plz help me

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

    undefined index error dekha rha hai??plz help...

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

    I have use the code same as you used..
    here it is:

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

    Sir image tag ka Samaj nhi aaya ...plz explain??

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

      Doubt pucho... tab hi I can explain... like.. ur image is nt fetched ya.. aur kch..

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

      @@fundaofwebit hi sir it shows fatal error: Uncaught TypeError: mysqli_fetch_array():

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

    Image fetch nhi ho rahe please solve it

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

    Where its data base video?

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

    Sir issko agar delete karna ho toh kaise kareinge??plz reply...

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

      Haa... we can delete by its id..
      Sorry for late reply.. ws lil busy..

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

      ua-cam.com/video/gj5c8lfnEuo/v-deo.html

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

    sir meri image show nhi ho rhi??

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

    can you send source code

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

    upload image code

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

    i want source code sir

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

    Funda meyer

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

    not working - get an error unexpected T_string. why?

  • @ane-manda
    @ane-manda 4 роки тому

    thank you