How to update/edit data into database using PHP MySql

[@fundaofwebit]

Latest video with clear explanation to edit update data. kzbin.info/www/bejne/pJ64pZaca9CKfJo

[@mayorca_institute]

How do I Edit this file after updating

[@kabhikachambala3392]

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

kzbin.info/www/bejne/pJ64pZaca9CKfJo

[@suchithranv502]

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

[@claudiojavierlopezsalvador5659]

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.

[@kovacslilla157]

You saved my life with this video! Thanks!

[@amiraroseli3232]

thank you my code is workinggg

[@doctmohamedabdo]

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

[@jettoblack9483]

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

[@Антон-н1в]

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

[@udityadutta8929]

Thank u so much sir

[@mwahid10]

Thanks, perfect and simple!!!!!

[@Spiderlag]

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

[@ThatThing1020]

you saved me for real 😍

[@luvgohel4602]

thnk u brother 😄

[@exogendesign4582]

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

[@goal_post24]

thanks again for your help keep doing..

[@fabrizioalpuche5984]

I fucking love you broooo

[@EWneiL]

Thank you very much! Helped a lot!!!

[@invsg5072]

That's great, thanks 👍👍👍

[@senthilnathan712]

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

[@pedropaiva3400]

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

[@kainatgull1840]

can you send the source code you tried through mail

[@ayushpansari274]

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

[@4101ashish]

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

[@shumailaaslam1265]

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

[@dheerajsirsikar9657]

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

[@ersazidsaifi9727]

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

[@Yusful001]

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

[@elizabethgrant6018]

Thank you!

[@kainatgull1840]

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

[@xtylishbilli8496]

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

[@jezreelleop2609]

What are your query?

[@dilsherbalouch]

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

[@fundaofwebit]

Get data in textbox.. kzbin.info/www/bejne/o6upgoyCarera80 Update data from textbox.. kzbin.info/www/bejne/bnbRkJp8aLhseKs

[@hristotanchev6036]

oke

[@arvind23prasad]

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]

$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);

[@mohammadjaved485]

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

[@VaradT_15]

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?

[@paulpagcaliwangan5137]

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

[@AdityaGupta-ke1vd]

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

[@AR-15K1]

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

[@muchopeanut22]

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

[@lefegoenterprise1455]

What if you only want to update one value

[@amiruljalil1560]

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]

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

[@taniapromi4075]

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

[@joenieakilimali9720]

mine too , did you find a way ro do it?

[@Brlitzkreig]

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

[@pchaitanya6985]

Brother how can I contact you

[@graphicguru5902]

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

[@fundaofwebit]

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"

[@ananyarajeev8199]

Could you please upload the source code

[@Jay-lx8ch]

Hi would you mind to share ur coding?

[@fundaofwebit]

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

[@muhammaddaniel8463]

bro why my data cant updated bro :D

[@kmattthephonefarmer4028]

I keep getting my error message

[@doroshamlifestyle4064]

not get any thing what r u doing

[@poolwise1622]

And your PC wallpaper color combination is weird.

[@mo_oc7142]

didn't work

[@fundaofwebit]

PHP - CRUD: kzbin.info/aero/PLRheCL1cXHrsxB2aUyfNMxr50XMKwQoa1

[@joenieakilimali9720]

i did like you but its still not update

[@fundaofwebit]

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]

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

[@kainatgull1840]

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

[@joenieakilimali9720]

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

[@kainatgull1840]

@@joenieakilimali9720 no problem

[@poolwise1622]

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.