How to update/edit data into database using PHP MySql

Поделиться
HTML-код
  • Опубликовано: 17 окт 2024

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

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

    Latest video with clear explanation to edit update data.
    ruclips.net/video/nmUtcf6kWF8/видео.html

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

      How do I Edit this file after updating

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

      @Funda Of Web IT
      Please can you show how To get id
      MY PROBLEM 👇example
      UPDATE table SET name= brk, age=jc WHERE ID=John
      The question how do I get ID (John)???
      Please do Update data direct From Webpage.

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

      ruclips.net/video/nmUtcf6kWF8/видео.html

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

    You are god for me sir.. 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏 thousand thanks .. 🙏🙏🙏You saved me sir 😭😭😭😭

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

    You saved my life with this video! Thanks!

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

    Really really very nice and very helpful.
    Thank you so much

  • @claudiojavierlopezsalvador5659
    @claudiojavierlopezsalvador5659 3 года назад +15

    The idea of update is to modify what a record contains, I expected for you to PRE-LOAD the form with what is contained in the DB record, and then to edit it using the form, and then to update.

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

    im continously getting the message data not update?
    update profile info

    body{
    background-color:whitesmoke;
    }
    input{
    width : 40%;
    height: 5%;
    border:1px;
    border-radius: 05px;
    padding : 8px 15px 8px 15px;
    margin: 10px 0px 15px 0px;
    box-shadow: 1px 1px 2px 1px grey;
    }


    Update Profile information

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

    You are the light of my life ! Thank you so much!

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

    thank you my code is workinggg

  • @shumailaaslam1265
    @shumailaaslam1265 5 лет назад +1

    Dear i have a task to fetch data in text box by finding id but datashow in in same table where insert query work
    please help me

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

    it says data not updated for me... which part do you think my mistake?

  • @arvind23prasad
    @arvind23prasad 5 лет назад +1

    please tell me where is the problem. I have done as same as shown in your video. But when I am trying to update data it shows "Data Not Updated". I have also check the db name and fields name.
    updation

    body{
    background-color:whitesmoke;
    }
    input{
    width : 40%;
    height: 5%;
    border:1px;
    border-radius: 05px;
    padding : 8px 15px 8px 15px;
    margin: 10px 0px 15px 0px;
    box-shadow: 1px 1px 2px 1px grey;
    }


    Updating of Data into Arvind Prasad Database using PHP

    • @fundaofwebit
      @fundaofwebit  5 лет назад +1

      $your_id = $_POST['id'];
      $fname = $_POST['fname'];
      $lname = $_POST['lname'];
      $email = $_POST['email'];
      $password = $_POST['password'];
      $address = $_POST['address'];
      $phone = $_POST['phone'];
      $query = "UPDATE employee SET fname='$fname', lname='$lname', email='$email', password='$password', address='$address', phone='$phone' WHERE id='$your_id' ";
      $query_run = mysqli_query($connection, $query);

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

    Please 🙏🏼🙏🏼🙏🏼 drop your name ..... I will love to have almost the video you've done html, JavaScript, MySQL and php

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

    please sir, help me.
    i already follow everything just like you did but it cannot update the data.
    Update User Info
    body{
    backgroud-color:whitesmoke;
    }
    input {
    width:40%;
    height: 5%;
    border: 1px;
    border-radius: 05px;
    padding: 8px 15px 8px 15px;
    margin: 10px 0px 15px 0px;
    box-shadow: 1px 1px 2px 1px grey;
    }

    Updating User Info









    i dont know where i get wrong

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

      $name = $_POST['name'];
      "UPDATE personalinfo SET name='$name', material='$matrial' WHERE id='$id' ";

  • @4101ashish
    @4101ashish 4 года назад +2

    how the user will know the ID ??? better to display the data in table and add and edit button then pass it on another form

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

    Thank you my friend! It was very helpful, worked like a charm

  • @dheerajsirsikar9657
    @dheerajsirsikar9657 4 года назад +1

    I want to update photo with particular id, what should I do?

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

    Thanks, perfect and simple!!!!!

  • @paulpagcaliwangan5137
    @paulpagcaliwangan5137 4 года назад

    when i submit all the data will update. not the specific id. thanks whats wrong.

  • @senthilnathan712
    @senthilnathan712 4 года назад +1

    Hi bro, one doubt input type file attachment can you do on this crud operation

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

    How to upload Pdf 8n database and display pdf file in new web pages by I'd ?

  • @ersazidsaifi9727
    @ersazidsaifi9727 4 года назад +1

    I login particular id and i want update data of that id. What i do??

  • @Антон-н1в
    @Антон-н1в 3 года назад

    как всегда, меня выручает умный индус, спасибо!

  • @AdityaGupta-ke1vd
    @AdityaGupta-ke1vd 4 года назад

    sir, I am getting undefined index for submit
    I am writing the same as u have written, please help me.

  • @AR-15K1
    @AR-15K1 4 года назад

    Uncaught Error: Call to undefined function mysqli_connection(), how can i resolve it? im using xampp, i've done the database and ecc ecc, this error is from the index.php i have made, pls help me

  • @VaradT_15
    @VaradT_15 4 года назад +1

    When we have multiple email id's of people stored in our database. .can we make Gmail group of those people and send email automatically without manual forming the group?

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

    you saved me for real 😍

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

    Thank u so much sir

  • @taniapromi4075
    @taniapromi4075 4 года назад

    i did the exactly same thing u did , but mine is not getting updated ..... its only showing not updated :( what should i do

  • @goal_post24
    @goal_post24 4 года назад

    thanks again for your help keep doing..

  • @xtylishbilli8496
    @xtylishbilli8496 4 года назад +1

    How can i update data into multi table at a time.... Using php....
    Plz guide me

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

    Thank you very much! Helped a lot!!!

  • @dilsherbalouch
    @dilsherbalouch 4 года назад +1

    Is there any way to show data in text fields to edit

    • @fundaofwebit
      @fundaofwebit  4 года назад

      Get data in textbox..
      ruclips.net/video/mzFQYL5Rx5k/видео.html
      Update data from textbox..
      ruclips.net/video/8En_gF3S9BI/видео.html

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

    That's great, thanks 👍👍👍

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

    thnk u brother 😄

  • @pedropaiva3400
    @pedropaiva3400 4 года назад +2

    Thank you for the help, keep doing well. :)

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

      can you send the source code you tried through mail

  • @lefegoenterprise1455
    @lefegoenterprise1455 4 года назад

    What if you only want to update one value

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

    Hello Sir is there any chance you could release the source code?

  • @graphicguru5902
    @graphicguru5902 5 лет назад +1

    Sir form mein agar image bhi ho toh kya karein??

    • @fundaofwebit
      @fundaofwebit  5 лет назад

      Aap puch rahe ho ki.... form k andr image use kar rahe hai toh kya kare...
      So.. to use image in form.. u hv to mention.. the form tag I.e.. action="" method="post" enctype="multipart/form-data"
      And input type="file"

  • @exogendesign4582
    @exogendesign4582 4 года назад +3

    Please make simple content management system from scratch front and back end plsss

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

    thank you for this video , this video is very help full .

  • @Jay-lx8ch
    @Jay-lx8ch 2 года назад

    Hi would you mind to share ur coding?

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

      www.fundaofwebit.com/php/update-data-into-database-in-php-mysql

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

    I fucking love you broooo

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

    Brother how can I contact you

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

    Thank you!

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

    bro why my data cant updated bro :D

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

    What are your query?

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

    I keep getting my error message

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

    Could you please upload the source code

  • @doroshamlifestyle4064
    @doroshamlifestyle4064 4 года назад

    not get any thing what r u doing

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

    i did like you but its still not update

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

      i think you have given single quote ( ' ) in your table name, instead use tilde symbol ( ` ).
      you can even use without tilde symbol as given below:
      $query = "UPDATE yourtablename SET col1='$var1', col2='$val2', col3='$var3' WHERE id='$id' ";
      $query_run = mysqli_query($connection, $query);
      if($query_run)
      {
      echo "updated";
      }
      else
      {
      echo "Not udpated";
      }

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

      @@fundaofwebit thank you I didn't put the coma

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

      @@joenieakilimali9720 can you send me the code u used plz
      im getting the came error not matached

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

      @@kainatgull1840 im sorry i've changed pc , i lost everything

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

      @@joenieakilimali9720 no problem

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

    And your PC wallpaper color combination is weird.

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

    oke

  • @mo_oc7142
    @mo_oc7142 5 лет назад +1

    didn't work

    • @fundaofwebit
      @fundaofwebit  5 лет назад

      PHP - CRUD: ruclips.net/p/PLRheCL1cXHrsxB2aUyfNMxr50XMKwQoa1

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

    useless video no benefit to me. Fetch the data from database then the fields will be filled with that data you fetch from database and then change it.