How to upload image to MySQL database and display it using php

Поділитися
Вставка
  • Опубліковано 25 січ 2025

КОМЕНТАРІ • 248

  • @ryumawano9370
    @ryumawano9370 3 роки тому +28

    ITS WORKING OMG THANK YOU :( I PASSED MY EXAM BECAUSE OF YOU!

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

      Same here man. Thx for the tutorial

  • @denizasar87
    @denizasar87 3 роки тому +15

    11:33 Insert Database (Creating connectiondb.php)
    12:30 Connection to the database.
    ► Procedural style: mysqli_connect(host, username, password, dbname, port, socket)
    ► Object oriented style: new mysqli(host, username, password, dbname, port, socket)

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

      Hey dude, thanks for the video. I have a problem when I try to upload an image. what happens is that the image rotates 90 degrees to the left and I can't find a way to prevent that from happening. I hope you can help me, thank you very much.

  • @kelongFX
    @kelongFX 3 роки тому +15

    It was one silent tutorial but I needed it ....have been stalling for years to do this ....I did it thanks men💪

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

      same,you want code that does everything you want

  • @Pro_coder.007
    @Pro_coder.007 Рік тому +2

    Thankyou very much lots of help bro, i seen lots of videos in UA-cam but not work but this video is awesome keep going bro ..😊❤

  • @tebogomgidi9876
    @tebogomgidi9876 Рік тому +2

    This was really helpful. I was struggling with another way to upload an image from another tutorial I was doing and images were not displaying but with your code it works perfectly.

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

    Hi ela....I have big respect for you.....because I are real programer and UA-camr.....
    You don't hide ur knowledge ur source code.

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

    This is the BEST tutorial. Easy to follow and it works 100%! Thank you so much for this!

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

      Great to hear!

    • @friktogurg9242
      @friktogurg9242 9 місяців тому

      @@CodingwithElias I may have missed a few things, why does the code save into the Pc after upload?

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

    yes yes yes yes, thanx so much u have simplified my task , this tutorial has seriously worked form me, am fully sorted now, thanx so much in deed. i will b waiting for more lessons

  • @mosessakala8550
    @mosessakala8550 8 місяців тому +1

    Finally something that just works. Thanks a lot!

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

    Hi, you saved my life. Thank you so much for this clear and straightforward video, subscribed!

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

    A perfect tutorial ! you're the best, all the luck !

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

    Gal, this i can relate with, but thing is some people will not get it, like its strange and doesn't make sense to them. Honestly i have few friends, and my friends have shown me support in their own ways🤗❤️😇. But i get your point dear. Thanks for sharing

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

    Bros i really thank you a lot for this video you put up, it is amazing and i appreciate it

  • @melisa-tl9mu
    @melisa-tl9mu 3 роки тому +1

    omg thankyou so much!! im gonna try this with our assignment its due in 2days skhdskfhd thanks

  • @Tawfig-Tamer
    @Tawfig-Tamer 2 роки тому +1

    Thank you, really it is very good and very clear 👍👍👍👍👍👍👍👍

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

    Thanks for the tutorial, was just looking for something like this to help me out.

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

    You are really an amazing programmer .

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

    nice and thanks. with your effort i have succeeded.

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

    bro t at 11:09 i cant see the files that i uploaded in my uploads folder , i am using mac . can you help me bro?

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

    Thanks a lot this really helps me to do my project 👍

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

    Very nicely explained.Thanx

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

    Wow That's Amazing

  • @JohnDoe-rj9oy
    @JohnDoe-rj9oy 2 роки тому +1

    Thank you so much bro! It works

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

    good video, very helpful! Keep it up.

  • @gabreturns917
    @gabreturns917 3 роки тому +5

    Great video! I have got few questions:
    1) Isnt that code exposed to MySQL Injection? How could I use prepared parametrized statements in your code?
    2)How to show the images upload into a table?
    3)How can I manage to rename the images I upload matching them to the AutoIncrement ID that mysql assigns to them?

  • @DavidAshby1
    @DavidAshby1 3 роки тому +3

    Thanks for that. I have a question about the returned array at 5:25. Depending on which image file I select to upload I only get the name returned with a 1 at error rather than the zero returned with other images. The file throwing the 1 is a bog standard photo but I do not get any data in [type] =>
    [tmp_name] => because of the [error] => 1 but I cannot work out why. Any ideas please? Thanks again

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

      checkout the source code under the description

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

      ​@@CodingwithEliasgive me the source code at one paste here i cant figure it out in description

  • @Индрой
    @Индрой Рік тому

    Really awesome u solved soo many problems

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

    thank you:question ; if user insert image into database, will it also be inserted to uploads file that we also store like in the video ? or directly to dabatase without inserting into your file in your pc and then can be display in the page ?, because when i insert image,it's url also comes uploads, and it can be some user that want be upload image from their mobile,will it be work withour problem ? or we need to do another system ?

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

      To upload a file follow this two steps.
      1. the image/file/video must be uploaded to the server. in this case we used my pc as server.
      2. store the file location in to the database .

  • @HuyNguyen-cz8md
    @HuyNguyen-cz8md 3 роки тому +1

    From team 6 with love

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

    Does it possible to upload cnic copy instead a pic for better security??

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

    Thank you buddy for that it helps lot try to add your voice it will be easy for us to understand

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

    so helpful thx 🌹👏

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

    thanks for the tutorial brother.

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

    Tnq so muchhhhh 😭😭😭

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

    Thanks for this great tutorial!

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

    silent but great!!!!thank you very much

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

    i have a problem becouse my pictures does not show its just show picture logo and squer around how can i fix that and how can i incrise suported picture file size

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

    Thank you very much❤❤

  • @s.b.mukesh4879
    @s.b.mukesh4879 3 роки тому +2

    Hello bro,
    I am going to do a project. Now I am design phase of it I want to know weather if we upload a file of word or xl or ... to a database(MySql) and can we access the file and it's related data using php.
    Please bro need a reply.

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

      Check out my new Video "Online Book Store - Full PHP & MYSQL Project - Part 1
      " related to Your question

    • @s.b.mukesh4879
      @s.b.mukesh4879 3 роки тому

      Thank you for the reply

  • @vigneshvigneshbala3502
    @vigneshvigneshbala3502 10 місяців тому

    Sir i have a doubt,that uploaded img will be showed in other users id

  • @abdellatif.x8127
    @abdellatif.x8127 2 роки тому +2

    Thanks man 🧡

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

    4:50 mine does not show hello it redirects to index how to solve it?? Pls help

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

      Does your code have an enctype attribute on form tag?

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

    Thank you so much. Can you please post get and post method difference

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

    terimakasih banyak atas tutorialnya

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

    Thank you love 💞💖💖💖💞💖💖💞🤗🤗

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

    Correct if im wrong. I think you just upload the new file name to the database? not the file it self. When you delete the image in the upload folder is it still you can display it ??

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

      yeah.. but you can't upload file into database. instead store file name and extension in the database

  • @قناةالشيخيوتيوبر
    @قناةالشيخيوتيوبر 3 роки тому +1

    simple and easy thanks alot

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

    well done brother

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

    Hey I would like to ask how to do editing? I want to upload a new picture and delete the old one

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

    Thanks for this video. A couple of question for you though. Will this allow for very large files to be uploaded like videos? Can you upload from a mobile phone to the website using this code?

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

      yes for sure, check out my video called, how to upload video using PHP and MySQL

  • @MekdesGebreselase
    @MekdesGebreselase День тому

    hello thank you it works but the images are not loading it has little question mark at the center how can I fix it please somebody tell me I need it asap

  • @mentor-abdullah
    @mentor-abdullah 2 роки тому

    One of best

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

    Hello.
    Good work .. I have a qus. ....
    Jis trh se online examination form me Photo aur sign alg alg upload and display hota h wo kese hoga .... Plz samjhao

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

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

    I got some errors, it's says
    "Warning: mysqli_connect(): The server requested authentication method unknown to the client [caching_sha2_password] in C:\xampp\htdocs\image-upload-php-and-mysql-main\db_conn.php on line 9
    Warning: mysqli_connect(): (HY000/2054): The server requested authentication method unknown to the client in C:\xampp\htdocs\image-upload-php-and-mysql-main\db_conn.php on line 9
    Connection failed! "

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

    thanks for helping me

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

    Thanks a lot😍 bro

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

    Great one !

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

    Hi Sir! I want to add the name of the person below the picture. how do I want to add in the upload.php section sir? Please help me sir. Urgent .

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

      check out my new video called how to upload profile picture

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

    Thank you!

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

    i have a login system and i want to insert the profile image inside the user table where there is the user information like the id how can i do this? cuss i have tried and when i upload it keeps adding new id's thanks :)

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

    Thank u so much u saved my life lol

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

    Hello can you make a tutorial that if you click those picture it will redirect to another file? By the way this tutorial is great💕

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

      Yeah, sure. You can just easily use a tag to do that. Thanks 👍

  • @leefelix6469
    @leefelix6469 7 місяців тому

    YOU ARE A SAVIOUR

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

    Thanks a lot this helps a lot

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

    The tutorial is great. I would like to know how to delete a picture once it's uploaded? Thank you in advance.

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

      I'm making a tutorial on online book store. You question will be answered on that video. Thanks

  • @duksisruksis
    @duksisruksis Рік тому +2

    Info for Linux users. For me in beginning not working when I write my own code. :( After than I take source code from github and its not working :( After than I figure out. :) I must change permissions for folders where I want upload pictures. :) When I allow "Write " than it works :)

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

    do i need to open 21 port for ftp or?

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

    what can I used in PDO method instead of ( mysqli_num_rows ) ??

  • @Anuj.Subedi
    @Anuj.Subedi 3 роки тому +1

    The files are uploaded and seen in uploads folder, but those images wont display on the webpage. Can you help please?

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

      Checkout the source code under the description

    • @Anuj.Subedi
      @Anuj.Subedi 3 роки тому

      @@CodingwithElias I copied the the code and still same problem. Those uploaded images has the permission to read only though and it wont allow me to add permission for write and execute. Is this the issue or something else

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

      @@Anuj.Subedi maybe this is your OS or server problem

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

      I had the same problem when I was using Kali Linux for this project. these are the steps I took. 1) open console in the uploads folder 2)put sudo su command 3) type this command chmod ugo+rwx uploads
      now you have applying read write and execute permissions for all users. should work now!

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

    isset($_FILES['my_image']) is not working for me :/ If im adding image, there is no Hello. Do you know why?

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

      maybe you you forget to give a name for the input. like name="my_image" or enctype="multipart/form-data"

  • @AliHamza-pi7zm
    @AliHamza-pi7zm Рік тому

    very nice

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

    how much is the storage limit of files that can be uploaded in mysql

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

    Hello friend, how can I use this code to upload 3 pictures directly from webcam android? I have 3 input to pictures and 1 to text, and 1 to username, can you help me?

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

    getting a error : Uncaught TypeError: strtolower(): Argument #1 ($string) must be of type string, array given in C:\xampp\htdocs\project\calender.php:55 Stack trace: #0 C:\xampp\htdocs\project\calender.php(55): strtolower(Array) #1 {main} thrown in

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

    so is the picture going to be uploaded to your database or what? i only see urls?

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

      The picture uploaded into the server and the url inserted into the database

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

    Amazing

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

    Good

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

    Thanks a lot

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

    My url is not seen in database because of which i am not able to retrieve the photos

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

      We're not inserting the image URL alternatively we're inserting the image name and extention

  • @Juan-rb5uv
    @Juan-rb5uv 3 роки тому +1

    Friend you can upload 5 to 6 images with the same self-increasing id

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

    can u pls tell me how to check the image dimension
    u have given the validation of image size...
    I too need to check image dimension how to do that

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

    good

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

    Thanks bro

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

    hey bro I'm at arround 11th minutes, I created a file 'uploads' and I can upload a jpeg file from website in this 'uploads' file (thanks to you), but when the image comes in file, it doesn't displaying, its saying 'maybe I don't have permission', do you know why is happening?

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

      Hello, I'm experiencing the same problem as you. Could you please tell me how you solved it?

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

    How do you make it so that the image uploaded is on the same page as the upload button, not on another page?

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

      make action="" copy past the code from the other page

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

    6:58 How much for a maximum of 20mb?

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

    Nice

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

    Heii great video but how can I make a userid for the upload ?

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

      Check out my video called " how to upload profile picture"

  • @leahkuria5210
    @leahkuria5210 10 місяців тому

    After uploading the video, how can i make the video to be liked and commented on by other users

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

    thank you

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

    thanks so much can you explain about the header('location:index.php?error=$em');

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

      Just making redirect.
      Redirect to index .php and passing query error message

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

    thank you for explaining each every step

  • @-MdApu
    @-MdApu 2 роки тому

    Bro, if I do it on WAMPSERVER instead of using XAMPP, where should I create the uploaded file?

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

      on your root directory/folder/ where you create index. php file

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

    BEST!

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

    thanks for tutorial but my file not show in folder but in database is show, how i fixed it?

  • @themiya-125
    @themiya-125 3 роки тому +1

    how to fetch image form database relevent unique image to diplay, example - profile picture

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

      Check out my chat app tutorial, all explained

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

    hi elias i hope to help me if you have time for me
    i'm try to save image in databass and then display to clients in real time please help me

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

      check out the source code it's under the description

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

    YOU SAVE ME FROM HELL THANKS ELIASSSSSSSSSS

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

    i want to add a file .zip into my db , can you help me please