PHP CRUD: Bootstrap Modal: Edit and Update Data into Database in PHP

[@saniyasaher]

thankyou. i was searching this but didnt find such informative tutorial anywhere else. You explains the at the same time you write it , is the best part of your videos. thanks again

[@endlesstTCG]

THIS!! This was a freaking lifesaver. I had been struggling with this for a week and within 30 minutes I had everything working. THANK YOU!!!

[@ronniebarasi9700]

Same feeling with me. Thanks to the owner of the video😢

[@spicystrike5088]

Every thing is working just fine for me, thank you for your efforts.

[@fundaofwebit]

Thank you for supporting me :) Please subscribe, like and share.

[@jeffreysumalde8590]

@@fundaofwebit hey brother how about loading the data in src img ? how to that

[@nellyville8657]

@@fundaofwebit Hi plz, i checked everything there is no erros but the update code doesn't work with me. Can y help plz ?

[@rnggaming4705]

Hi how about fetching the selected value from database into the drop down box?

[@vithusas4024]

Please Did you find the solution ?

[@rnggaming4705]

@@vithusas4024 Hi, sorry to say I no longer doing this project

[@vielo9775]

$('#sample_id option:selected').text(data[12]);

[@shinvlog1126]

@@vielo9775 hello how about the update if update that it remove the data when i using that $('#sample_id option:selected').text(data[12]);

[@mehmetsarresmi]

hello, it worked for me but when I try a second data, it doesn't work. no popups.

[@ijsis4091]

Thank you. You help me a lot!!!!!

[@davidsmith-ws4bz]

Coding structure is very impressive.

[@CutieTheGreat]

thank you sir, quick question when i hit update it echo or alert "Data Not Updated" its the else in update.php.

[@tajwarshah6264]

Wow this is great knowledge. Thanks man 🙏

[@yamina2513]

how can I fetch the value of select option into the Edit modal?

[@ashikanedoict]

Thanks, the modal works it is shown. But when I checked in mobile view, the modal forms input fields appears blank which did work properly on PC. Could you please check and sort this issue?

[@amitchaudhary6]

Loved your video. It helped me alot.

[@soumenpati5865]

Thank you so much sir for helping us🙏🙏🙏🙏😀😀😀 it's works

[@Freuivan]

I have problem...when I press the edit button there's spaces in the first letter. Help me please

[@lyzazanury2831]

Can we use the same modal and ajax/jquery code to update different table? Or do we need to create new code for different table?

[@nellyville8657]

Plz, why the update code doesn't work with me ? Can I paste it here for some help?

[@vanrajkhunti8106]

Sir ,plz...help..... When I press save data it throw Me in updatecode.php and not returned in index.php and also not upadeted my data

[@revtane9]

How about when calling an image in td . It is not showing.

[@michaelkisingi8650]

cool tutorial bro, but you should use $(document).on('click', 'className', function(){ }); insteady of using $('className').on('click', function(){ });. This will not just show the modal for some minutes then it will dissapear for some browsers. Thanks

[@ignicionfilms]

Thank you!!!

[@ibrahimsherif3261]

Thank you very much !

[@dumarc3063]

Yes! NOW it works for me! Thank you!

[@hafizyanuar2373]

Thanks! it works for me

[@santoshkumardas1988]

where is your popup alert update successful

[@tifiko0865]

What the meaning of “Children”? is it database?

[@faizanjamshaid673]

same code but not working

[@brentv1746]

same, did you find a solution?

[@RoseStudiorose]

It's clearly understandable but I faced issue when I show image from database to input file Element. Can you help me out this?

[@akshatbyndla]

How to fetch value for date and from select dropdown menu?

[@eduardodelacruzjr.8502]

Hello, can you help me display the data in other type of form like dropdown. In the tutorial the data cannot be displayed when you used number form. Thank you

[@azgiraffe]

Same do you have a solution for this?

[@lenardagbalo9251]

@@azgiraffe up same prob

[@gurosiya]

Can anyone help me. The modal does not show if there is class = "modal fade". if I remove fade, it works but the background turns black.

[@akhilkazi1454]

Hello sir i have a database working on xampp i want to connect it to live server on my websites. Please reply.

[@FaranKhan-gd6uv]

i have noticed in alot of tutorials id of record is exposed.is there a way to hide it so that no one can modify it from inspect element with the same code in video

[@ahmedsuleiman7144]

Thank you sir, please help me I have follow all the steps but when i click the update the page load successfully but the records are NOT update

[@andiillank6813]

Where i can download the file of this tutorial from begining to search part

[@flavio5328]

my echo records dont found dont work, can you help ?

[@tidermanaog5362]

My modal is not showing even though I followed all the steps you said

[@luisvillegas444]

it happened to me because i had href=" " in the button to show the modal

[@jevahreablancaflormontas115]

Hi sir, do you have a database and web application for gadget sales and inventory?

[@eziochannel9373]

hello sir, i got problem from fetch data for edit, didnt show data from the textbox. help me to check if u are free

[@hananebouidia6485]

i have u button in my column , and it also show if i press edit !! how can i remove it i don't want it to be shown

[@ahhyanearl]

If you want your input type number to get the data just add parseInt() on the code. e.g var numData = $tr.children("td").map(function () { return parseInt($(this).text()); }).get();

[@johnmaverickclemente2922]

can you teach me sir the code didnt work

[@carlosgrandez9493]

Help, modal only works for me with the first row of the table and not with the other rows. I'm using DataTable

[@carlosgrandez9493]

Por fin lo encontré. Está en los comentarios. Lo que pasaba era que el modal solo me funcionaba en la primera fila y luego no se mostraba. $(document).ready(function() { $('#example').on('click','#btnupdate',function() { $('#modal-edit').modal('show'); $tr = $(this).closest('tr'); var data = $tr.children("td").map(function () { return $(this).text(); }).get(); console.log(data); $('#id').val(data[0]); $('#task').val(data[1]); }); }); Donde: #example : mi tabla #btnupdate: mi botón #id: primer campo de la tabla #task: segundo campo de la tabla

[@luisvillegas444]

@@carlosgrandez9493 el codigo javascript lo estabas agregando en otro archivo?

[@carlosgrandez9493]

@@luisvillegas444 no. lo tengo en el mismo index.php

[@ashfakhossainevan791]

What Should I do for a view button ? Help please

[@fundaofwebit]

41:35 in the given link : kzbin.info/www/bejne/fnjVm2N7q7OEjas You can make the view button from here.

[@rakzam488]

My edit is not running, i follow you but error

[@sunnydagar2567]

how to use htmlspecialchars??? and where to use??

[@faizanjamshaid673]

form ki field main data get ho kar he nahi aaraha please help what can i do

[@hameddore]

hello man how are you, thanks for your videos, I have a concern, I can't display my different pages in a sidebar

[@randiapriliyadirahmat5230]

how about materialize?

[@flashlight7290]

hi sir ,how to retrieve image from database ?

[@genosthegreat7870]

What bootstrap version is this ?

[@fundaofwebit]

It's bootstrap 4.

[@attitudebhakiro8302]

hi, thank you for this tutorial, Unfortunately i encountered a problem. The popup modal is running well on the first 10 rows of my table then the 11th onward are not running. How can i fix?

[@fundaofwebit]

$('#datatable1').on('click', '.editbtn', function () { $tr = $(this).closest('tr'); var data = $tr.children("td").map(function () { return $(this).text(); }).get(); console.log(data); $('#edit_id').val(data[0]); $('#product_name').val(data[1]); $('#sub_heading').val(data[2]); $('#description').val(data[3]); $('#images').val(data[4]); $('#status').val(data[5]); $('#editForm').attr('action', '/product-category-update/'+data[0]); $('#edit-product-cate').modal('show'); });

[@michaelangeloserban4859]

@@fundaofwebit can i know what is the product-category-update?

[@domenicoventurin7339]

Hi, I have this problem, when I click Edit the modal show up properly but the input fields are empty. I checked many times the ID names of every input fields. The JS run properly because in the console log I see every correct value but the input fields remain empty. What can I do?

[@fundaofwebit]

Make sure... U are not using add form and edit form... Both id names are not same... Bcz.. This is also one reason for clashing the data to it's first priority..

[@domenicoventurin7339]

Sorry, I found my error, the "id" of every input fields must be in lowercase, I had some id input fields with some capital letter, my error.

[@domenicoventurin7339]

@@fundaofwebit thank you very much, your tutorial was been really helpful for my project.

[@m.k.fellah4216]

Thank you. All things is Ok, but i don't want to show the ID element (ID is used as reference for updating or deleting data, but it is not necessary to show it). How can i do this simply ?

[@fundaofwebit]

U can use in many ways. Like you can make it " display:none; " in your shown html tag. So I'd will be hidden. Orelse you can use input type ="hidde"

[@m.k.fellah4216]

@@fundaofwebit Thank you. I'll try it.

[@fundaofwebit]

Demo is done in it. kzbin.info/www/bejne/o3XCgJKZeNaqjK8

[@m.k.fellah4216]

@@fundaofwebit It works. Thank you

[@ipsitaacharya7013]

Thank you so mch sir for this amazing tutorial but sir i checked everything no error but when I am clicking on update button nothing is happening.. Please suggest sir what I can do☹️ :) Regards

[@nellyville8657]

I have the same problem too. Have you found the solution, plz ???

[@nellyville8657]

Hi have you found the solution, plzzzz ???

[@abhishekkavade1236]

Are You Inlude popper JS File ?

[@দূরবীন-গ৬ষ]

Where i can download the file?

[@animasinghdhabal5052]

How to insert selection option data and how to edit it using modal..

[@johndominicescoto6884]

This only works for the data on the first page of the table. Idk why

[@fundaofwebit]

Use this format on button click: $(document).on('click', '.editButton') Hope this helps you.

[@misterx8014]

Unable to fetch data into edit modal form... Didn't work for me..

[@fundaofwebit]

Try to give different id in ur edit form.. into ur input field.. and same thing in script also... Bcz.. your add form id and edit form id get clashed.... so... try to give different ID in edit form in input filed.. and same in jQuery code.. then try .. it wil come..

[@misterx8014]

@@fundaofwebit Okay i'll try, thank you for ur response..👍

[@fundaofwebit]

@@misterx8014 did it work for you ?.

[@misterx8014]

No it didn't work, actually i created profile page and pop up modal was for edit profile page with image upload functionality.. Would be great if u help me out..

[@zabarmastpakistan7172]

same problem

[@mkiitdelhi]

How to only display data in popup without input box, if possible please make a video in this playlist to only view data in Pop up modal when click on view button like edit button.

[@fundaofwebit]

Yes ... I'll upload it.. very soon..

[@muhammadilhamrobani7042]

when i click edit button it doesn't do anything , plz help me sir

[@jesusjimenez1486]

If anybody else is having this problem, check your query. I was having the same issue, I was missing a: ' at the end.

[@pryadarsshini7778]

@@jesusjimenez1486 Hi, can you tell at which query that we need to add :' ?

[@santoshSadashankarNepal]

thanks for the videos lesson, really helpful for me, I have a question: How to show select/option value taken from database in bootstrap model?

[@ilyesmilyesm2576]

hello, diid you find an answer to this problem?

[@trinovitasari447]

hi sir, I tried to make it but when updating data, the updated data is not stored in the database. why is that?

[@luisvillegas444]

check your query

[@SaifAlerwi]

Why it just work with first record ? 😢

[@doodrobe1761]

thx a lot mate, u saved my life

[@jonermarchadesch2887]

Uhm.. I've done all the things in the video. And I can also click the update button and all the data will be in the textboxes. I'm just wondering why is the update not working on mine? Even tho the query is right, all the other things are right as well. It's just weird...

[@jonermarchadesch2887]

The update process is getting read as well. But nothing changes on the updated information after that.

[@jonermarchadesch2887]

@fares ousama it worked for me already. You should change the id of each input type

[@nshimiyimanaeliepatient4969]

thank you brother you saved my life too

[@nellyville8657]

Hi plz @elie Patient, Can y pass me your update code. Mine doesn't work

[@and-why]

will this do the update without a full page reload?

[@fundaofwebit]

Yes... yes.. Just remove that reload function from success... inside success display with a message. And clear the txt field and then close the modal using bootstrap modal query.

[@habeasventuresinc.9858]

thank you for your efforts! but i have a question. i tried using the lates bootstrap version and modal won't work. help please ^^

[@fundaofwebit]

Whn u click edit button... the model popup using jQuery.. So.. nothing abt latest.. :-)

[@habeasventuresinc.9858]

@@fundaofwebit but it just doesnt work when i replace this "" with this " "

[@raxomovasadullo]

Sir can make a video by js about adding new modal like ur this video i searched more time but i couldnt find. If ist possible could u do it?

[@eenaperez149]

Thank you sir. You helped me a lot! :)

[@AndreLuiz-ln5bm]

When I click the button to edit the modal it does not load the fields. can you help me ?

[@fundaofwebit]

Make sure ur input field id are correct and. The id which u hv given in inserting form.. and edit updating form are different frm eachother id-names. So.. that it shld nt clash.

[@AndreLuiz-ln5bm]

@@fundaofwebit Thank you very much. The IDs of ADD and EDIT were of the same name and gave conflict. Thank you for your help. Now I'll be continuing the videos.

[@fundaofwebit]

@@AndreLuiz-ln5bm Thank you. Keeping supporting. :)

[@nellyville8657]

Hi Thank you so mch sir for this amazing tutorial but sir i checked everything no error but when I am clicking on update button nothing is happening.. Please suggest sir what I can do

[@luisvillegas444]

Thanks a lot, this worked for me.

[@nellyville8657]

Hi, I checked everything no error but when I am clicking on update button nothing is happening..

[@luisvillegas444]

@@nellyville8657 did You verify the button id is the same in "on click" event?

[@nellyville8657]

@@luisvillegas444 Yea, everything is the same. The problem is about the update code.

[@luisvillegas444]

@@nellyville8657 paste your code here

[@luisvillegas444]

@@nellyville8657 You can also check the browser console to see any errors

[@maveradesign777]

i was looking for this thanx

[@pmychannel2581]

Why you did not share link of bootstrap that you use?

[@fundaofwebit]

getbootstrap.com

[@esnaidinkanakan1820]

Hi can you make a tutorial on how to fetch the product and price in database into Selected option and pass the price into the textbox. thank you in advance

[@animasinghdhabal5052]

My edit modal is not getting popped up😒😒.. Can you plzz provide the code..

[@fundaofwebit]

Modal id name, should be called with the correct name in the jQuery code.

[@MasterLenoXWolfe]

Very Nice Tutorial sir, But I have one question. When I try to update one of the data inside the tables, then I tried to change the input one of those forms, then When I click the Update Data button. Nothings Change sir. :( can you help me sir??

[@zabarmastpakistan7172]

during the process of edit i can't find data in the form

[@fundaofwebit]

When ur clicking editbtn... then.. u r retrieving data to the closest of td.. by using jQuery and its displaying into ur Input id.. So.. Please check.. the form.. u hv used for add form data and edit form ID are not same.. so.. this might be one reason for not fetching the data into ur edit form Input box.

[@saguiramanggis9228]

Do you have source code

[@wcyap8139]

pls help.. edit modal didnt popup after i clicking the editbtn

[@fundaofwebit]

Edit button : class_name and script jQuery btn_name.. should be same... and then.. your modal pop up ID n script jQuery modalpop ID should b same for modal(popup) script.

[@wcyap8139]

@@fundaofwebit can i send u an email?

[@fundaofwebit]

@@wcyap8139 yes

[@fundaofwebit]

@@wcyap8139 [e-mail]

[@wcyap8139]

@@fundaofwebit i sent u an email ady. Pls check tq.

[@dineshsubramanian3882]

hi data didnot come in modal show this error Uncaught ReferenceError: td is not defined

[@fundaofwebit]

td is not defined means.. that td is not given into your table body.. So i think.. you need to check the in the table head and in your table body. whether it u hv given correct table tags..

[@padmanabamkarri1131]

Can u make a video on multiple images insert into single column and display, update, delete using ajax php

[@laliice7154]

Thank u very helpful

[@fwt3150]

Awesome,,,, but How to Insert data & update/edit dada without refresh page.... ???

[@farangokim]

SI funciona pero si tienes paginacion ya no deja de funcionar alguna solucion a este problema!!!

[@carlosgrandez9493]

compa como hiciste?, pasa codigo porfa.

[@Allonlinegames]

bro i need the code for thid video kindly help me bro

[@Omar-zj4wpg]

thanks Sir, I am getting this error when I attempt to update the data "Not Found The requested URL was not found on the server. If you entered the URL manually please check your spelling and try again."

[@huelahuma]

you probably inserted url in you update modal form

[@pancake_j328]

it works with the sb theme tutorial too :D I tried to make it into modal too, because it was passing it to other page

[@j.tcomputer1007]

I have issue with java-script, $('#update_id').val([0]); $('#first_name').val([1]); $('#last_name').val([2]); $('#id_number').val([3]); $('#username').val([4]); it appear number 1 , 2, 3, 4, in the input field not the value from table. Please help me !!!

[@pandurangpnaik2701]

Edit U see this data ?? chech your id field it should be should have tag not .

[@RikaAyuDesiHartatik]

not working to me

[@dsweb_programming]

How to update just only one data? Please upload tutorial sir

[@fundaofwebit]

If you want to update only one data or one row from your table... then u have to call id or some field... to update your data.. Just try with this video. kzbin.info/www/bejne/bpKoq6Gjn5ljqcU

[@dineshguptha8225]

Can I get source code

[@gopo2042]

You saved my life :´)

[@nellyville8657]

@johnny pozo can y see why me update code doesn't work, plz ?

[@Omar-zj4wpg]

This is the form: Edit Employee Data × First Name Last Name Gender Female Male Other Office Amsterdam Cambridge London New York Other Comments

[@padmanabamkarri1131]

Excellent video

[@raymondgarina779]

Sir what is ('tr') in the script along with td. Btw it helps alot better than our professors hahahaha. God bless you hope I get a response.

[@fundaofwebit]

tr is table row , which comes in table attribute And thank you. Keep supporting me.

[@wreckitron8439]

Our Lord and Savior.. 🙏👼

[@omarsenoussaoui6666]

he work just with first element why?????

[@jmfelicilda8488]

my data didn't fetch on my modal. and when i inspect it shows that the "Uncaught SyntaxError: Unexpected token . ". plss help

[@ISOnepal]

plz provide the javascript code.

[@khanshab02013]

Great Work brother.Helped alot Source Code ?

[@akhiljaiswal6485]

can you provide source code ????

[@jayakumar2927]

can you share source code

[@idHawk]

the phone number didn't pop up because there are space characters, i think

[@gregmaster0st]

is here a "ok?"-counter?