Это видео недоступно.
Сожалеем об этом.

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

Поделиться
HTML-код
  • Опубликовано: 20 окт 2020
  • Upload Files and Images to Website in PHP | PHP Tutorial | Learn PHP Programming | Image Upload. In this PHP tutorial I will show how to easily upload images and files to a website using PHP.
    ❤️ SUBSCRIBE:
    ruclips.net/user/codingwitheli...
    Source Code
    github.com/codingWithElias/im...
    PHP File uploading.
    With Source Code
    Image Preview and Upload PHP and MySQL database
    image upload in php mysql database
    How to Insert Images to MySQL and Display Them Using PHP

Комментарии • 247

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

  • @TheDickname
    @TheDickname 7 месяцев назад +2

    Shortest explanations are the best; thanks 👍 Gonna try that right away!

  • @jooryalhamed938
    @jooryalhamed938 2 года назад +2

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

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

  • @Pro_coder.007
    @Pro_coder.007 Год назад +2

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

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

  • @yasserrazzaki7235
    @yasserrazzaki7235 2 года назад +1

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

  • @melisa-tl9mu
    @melisa-tl9mu 3 года назад +1

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

  • @kelongFX
    @kelongFX 3 года назад +14

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

    • @oldguy8177able
      @oldguy8177able 9 месяцев назад

      same,you want code that does everything you want

  • @mosessakala8550
    @mosessakala8550 2 месяца назад +1

    Finally something that just works. Thanks a lot!

  • @okaforchinyerematthew1937
    @okaforchinyerematthew1937 Год назад +1

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

  • @akarshashamin1317
    @akarshashamin1317 2 года назад +1

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

  • @joyinmahmmadaslamlaskar3355
    @joyinmahmmadaslamlaskar3355 2 года назад +1

    You are really an amazing programmer .

  • @marcjacob11
    @marcjacob11 11 месяцев назад +1

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

    • @CodingwithElias
      @CodingwithElias  10 месяцев назад

      Great to hear!

    • @friktogurg9242
      @friktogurg9242 4 месяца назад

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

  • @Tawfig-Tamer
    @Tawfig-Tamer Год назад +1

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

  • @denizasar87
    @denizasar87 2 года назад +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.

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

  • @user-qz8jg8pg2n
    @user-qz8jg8pg2n 3 года назад +1

    simple and easy thanks alot

  • @monowersadaf
    @monowersadaf 3 года назад +2

    thanks for the tutorial brother.

  • @JohnDoe-rj9oy
    @JohnDoe-rj9oy 2 года назад +1

    Thank you so much bro! It works

  • @sumanroshan2873
    @sumanroshan2873 Год назад +1

    Very nicely explained.Thanx

  • @dhananjaychavan5540
    @dhananjaychavan5540 Год назад +1

    silent but great!!!!thank you very much

  • @frzlr7
    @frzlr7 2 года назад +1

    good video, very helpful! Keep it up.

  • @camilleschori
    @camilleschori 3 года назад +2

    Thank u so much u saved my life lol

  • @YUhave2Bawsome
    @YUhave2Bawsome 3 года назад +3

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

  • @qukh2908
    @qukh2908 2 года назад +1

    Thank you very much❤❤

  • @mistysam6645
    @mistysam6645 2 года назад +1

    so helpful thx 🌹👏

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

  • @itxxsaiff
    @itxxsaiff Год назад +1

    Wow That's Amazing

  • @stephanpetersen3600
    @stephanpetersen3600 3 года назад +2

    Thanks for this great tutorial!

  • @Gireeshkorani
    @Gireeshkorani Год назад +1

    Great one !

  • @uttarakhandvloggerlifestyl922
    @uttarakhandvloggerlifestyl922 2 года назад +1

    thanks for helping me

  • @rzstudio5204
    @rzstudio5204 Год назад +1

    Thank You So Much Sir

  • @primozdornik9791
    @primozdornik9791 Год назад +1

    Thank you!

  • @joey7491
    @joey7491 Год назад +1

    thank you very much

  • @InfiniteLK
    @InfiniteLK Год назад

    Thanks a lot😍 bro

  • @anninajose9035
    @anninajose9035 9 месяцев назад +1

    Tnq so muchhhhh 😭😭😭

  • @tdarafalagi2382
    @tdarafalagi2382 Год назад

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

  • @kennmarkeay6193
    @kennmarkeay6193 3 года назад +1

    Thanks a lot

  • @abidniazmalik3417
    @abidniazmalik3417 2 года назад +1

    well done brother

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

  • @mentor-abdullah
    @mentor-abdullah Год назад

    One of best

  • @oumaimaoum5606
    @oumaimaoum5606 3 года назад +1

    thank you

  • @mfs6165
    @mfs6165 3 года назад +1

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

  • @user-pt3ur9uh4c
    @user-pt3ur9uh4c Год назад

    Really awesome u solved soo many problems

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

  • @vigneshvigneshbala3502
    @vigneshvigneshbala3502 5 месяцев назад

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

  • @shortclips400
    @shortclips400 Год назад

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

  • @TheBulletThrough
    @TheBulletThrough 3 года назад +1

    BEST!

  • @infinixhot3305
    @infinixhot3305 2 года назад +1

    nice and thanks. with your effort i have succeeded.

  • @anasaljawa858
    @anasaljawa858 3 года назад +1

    Thanks

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

  • @bernadettefernando1762
    @bernadettefernando1762 3 года назад +1

    Thanks a lot this helps a lot

  • @minternetcafe7850
    @minternetcafe7850 3 года назад +2

    good

  • @joyinmahmmadaslamlaskar3355
    @joyinmahmmadaslamlaskar3355 2 года назад +1

    Amazing

  • @bryanjonathan407
    @bryanjonathan407 9 месяцев назад

    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?

  • @Timatej
    @Timatej Год назад

    do i need to open 21 port for ftp or?

  • @abbeed1
    @abbeed1 2 года назад +1

    thanks

  • @HuyNguyen-cz8md
    @HuyNguyen-cz8md 2 года назад +1

    From team 6 with love

  • @abdellatif.x8127
    @abdellatif.x8127 2 года назад +2

    Thanks man 🧡

  • @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 9 месяцев назад

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

  • @clarkykuuun937
    @clarkykuuun937 3 года назад +1

    YOU SAVE ME FROM HELL THANKS ELIASSSSSSSSSS

  • @thearmor9231
    @thearmor9231 2 года назад +1

    Nice

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

  • @reyvincentalcantara5563
    @reyvincentalcantara5563 2 года назад

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

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

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

  • @maishaalam658
    @maishaalam658 Год назад +1

    Good

  • @focusontheroad5190
    @focusontheroad5190 3 года назад +1

    silent but effective!

  • @AliHamza-pi7zm
    @AliHamza-pi7zm Год назад

    very nice

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

  • @pradumanpandey6065
    @pradumanpandey6065 2 года назад +1

    Thanks bro

  • @anusuyar8423
    @anusuyar8423 2 года назад +1

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

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

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

  • @sabinaanibassabinaanibas
    @sabinaanibassabinaanibas 2 года назад +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  2 года назад +1

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

  • @shaileshkumar-qf6bd
    @shaileshkumar-qf6bd 3 года назад

    Img with extension very nice

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

  • @user-df5er9tf7h
    @user-df5er9tf7h 9 месяцев назад

    is it not with using pdo

  • @leefelix6469
    @leefelix6469 Месяц назад

    YOU ARE A SAVIOUR

  • @adhilfairooz1003
    @adhilfairooz1003 3 года назад +1

    thank you for explaining each every step

  • @abdelmajiedabusuliman4429
    @abdelmajiedabusuliman4429 Год назад

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

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

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

  • @leahkuria5210
    @leahkuria5210 4 месяца назад

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

  • @semirucucu7925
    @semirucucu7925 Год назад

    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?

  • @alnajafyprogrammer3460
    @alnajafyprogrammer3460 Год назад +1

    thaaaaaaaaaaaaaaaaank you

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

  • @Juan-rb5uv
    @Juan-rb5uv 3 года назад +1

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

  • @s.b.mukesh4879
    @s.b.mukesh4879 2 года назад +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  2 года назад +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 2 года назад

      Thank you for the reply

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

  • @Eman0576
    @Eman0576 Год назад +1

    terimakasih banyak atas tutorialnya

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

  • @cristianjaysino570
    @cristianjaysino570 3 года назад

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

  • @suryasudeep3124
    @suryasudeep3124 2 года назад

    I am getting this error
    unexpected identifier data

  • @duksisruksis
    @duksisruksis 10 месяцев назад +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 :)

  • @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  Год назад

      check out the source code it's under the description

  • @jomcabanilla3732
    @jomcabanilla3732 9 месяцев назад

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

    • @CodingwithElias
      @CodingwithElias  9 месяцев назад

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

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

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