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

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

КОМЕНТАРІ • 247

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

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

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

      Same here man. Thx for the tutorial

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

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

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

  • @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 7 місяців тому

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

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

    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.

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

  • @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 5 місяців тому +1

    Finally something that just works. Thanks a lot!

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

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

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

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

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

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

    nice and thanks. with your effort i have succeeded.

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

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

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

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

    You are really an amazing programmer .

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

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

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

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

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

    Tnq so muchhhhh 😭😭😭

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

    Wow That's Amazing

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

    Very nicely explained.Thanx

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

    Really awesome u solved soo many problems

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

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

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

    thanks for helping me

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

    Thank you so much bro! It works

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

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

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

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

    silent but great!!!!thank you very much

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

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

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

    terimakasih banyak atas tutorialnya

  • @mentor-abdullah
    @mentor-abdullah Рік тому

    One of best

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

    Thank you very much❤❤

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

    Thank you!

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

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

    good video, very helpful! Keep it up.

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

    Thanks bro

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

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

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

    thanks for the tutorial brother.

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

    From team 6 with love

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

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

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

    so helpful thx 🌹👏

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

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

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

    Thanks a lot😍 bro

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

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

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

    simple and easy thanks alot

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

    Thanks for this great tutorial!

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

    YOU ARE A SAVIOUR

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

    Thanks man 🧡

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

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

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

    thank you

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

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

    well done brother

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

    Thanks a lot this helps a lot

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

    Thanks a lot

  • @shaileshkumar-qf6bd
    @shaileshkumar-qf6bd 3 роки тому

    Img with extension very nice

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

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

    Great one !

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

    BEST!

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

    Good

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

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

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

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

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

    Thanks

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

    very nice

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

    thank you for explaining each every step

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

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

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

    silent but effective!

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

    Amazing

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

    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

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

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

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

    YOU SAVE ME FROM HELL THANKS ELIASSSSSSSSSS

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

    Thank u so much u saved my life lol

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

    good

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

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

    Nice

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

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

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

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

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

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

    thaaaaaaaaaaaaaaaaank you

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

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

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

    this code sounds lenthy for beginners

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

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

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

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

    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?

  • @samboncay9776
    @samboncay9776 3 роки тому +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! "

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

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

    do i need to open 21 port for ftp or?

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

    Thank u video for me sir
    Cloud you tell me about parameter error,

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

      Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given in C:\xampp\htdocs\upload-image\view.php on line 14
      --------
      View

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

      Updated your server to php 7 or greater

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

      And mysql to mysqli support version

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

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

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

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

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

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

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

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

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

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

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

    Is there any ways to upload an image without using and formdata() function and just use a post

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

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

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

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