Live Table Add Edit Delete using Ajax Jquery in PHP Mysql

[@moulayelmehdimourtada7815]

i wanna thank you from the bottom of my heart, you just saved me a whole day of work, thank you a million time, you deserve a bottle of fine wine and a poem lol, hope you're living well , stay safe

[@wgconsultants3030]

This person has helped make our programs not only look a heck of a lot better but also shedded some light on how professional and more intuitive like todays apps can be. I've already done the search functions and answering my prayers on live updating....THANK YOU!!!!!! Im such old school and don't even use mysqli. I still use mysql_.... as im scared if I start, I have 500 files to fix.

[@caominhnhat1455]

you are the only one who provide free source code, I am grateful!!

[@uzi2406]

thanks allot i had been finding delete method for 2 days finally found your video thank you soooo much

[@willonedision]

good job!! what a good person!!! i am your chinese follower

[@OnePageVoter]

Thanks for giving valuable help and learnning...

[@clickadelic7681]

Tutorial is good - but.. dad robot voice - rly?

[@squirrelgaming4028]

thank you very much, for real you have saved me god bless you and i hope you go far in life

[@d3xx3rDE]

Perfect tutorial for live database usage on websites.

[@DineshNairMumbai]

Great ! Very systematic and a good thought process involved in the algorithm.

[@mcvgs1780]

Hey man you are a total life saver. Thank you so much

[@renzogf1103]

Gracias, es exactamente lo que estaba buscando.

[@ehtishamsaid783]

U r Hero boss ....liked ,subscribed

[@MajklasHancas]

thank you for this! One thing is edit.php keeps buggin with alerts when I click to another table cell. If I click outside the table (first_name, last_name) it's ok. Shold there be any preventDefault ?

[@sunaba674]

Hello, I need help. When I add and delete something in the table it prompting 2 alert boxes, it results to add 2 the same values in my database... How to fix it?

[@jeshtimayank7911]

this tutorial is toooooo good sir

[@desireeagripa5219]

hi. i just want to ask how to specify in the select query in the fetch.php the id to be fetch in the database. for example in the index page the user_ID is 2. the info. that will only be display is the user that has a user_ID=2. Thank you

[@maximepro3882]

Hey, thank you for all, One question if i want edit more the two coulum_name after creating more colum in my sql, how can i do ? i manage to insert 4 colum, but if i want modify the new one everything bug... Your tuto is only for name and surname ? thank you

[@mohammedmezmiz6032]

your error is sure here : data-id2="'.$row["id"].'" all fields should have the same . and not like this: data-id3="'.$row["email"].'" ;)

[@marklesterpine3739]

It helps me a lot. Thanks

[@dimasadiandrea9384]

can i integrated that with jquery datatables plugnin?

[@boliviareports]

Thank you for your awesome tutorial

[@cbfreakbears312]

I have done everything up to 11:46 but my output is just the title, no table shows up at all. Does it have something to do with the fact that you are using localhost/livedit and not localhost/index.php?

[@arafatsage8415]

Good Tutorial... Keep it up

[@mysterious_Journey888]

hello can we make a edit between two join tables in php

[@ganeshkgp]

How to get focus on first column of last td field after inserting the data kindly help sir

[@Aldwyn-dx3cw]

may edit function is not working because the field name of my primary key is "annid" how can i fix this? Thank you.

[@sasibhushansaikia926]

sir, how to add datepicker in the cells and hide the id and display only sl.no. please reply early

[@vaidehipanchal7635]

very helpful..

[@greshanbandara8007]

my primary key is "nic_no" (varchar). some nic no like "12345678" and some are like "12345678V". i use edtable table as this tutorial, but its working only nic_no "12345678" only. what is the problem?

[@aravindkathiravan905]

please put echo $output; after you have done everything under select.php

[@GharGrihasthi]

Thank you so much, you saved my day !!

[@warsyam778]

Nice tutorial, please tutorial relation table

[@SatoshiLearning]

great, thanks

[@jamesbond-cx2uh]

Please help the alert box keeps appearing again and again each time i tried to edit the data .

[@kelviantofernando2810]

I have a problem when i try to update first is working perfectly, until i try to insert some data again, the data that i update just a moment ago is dissapear

[@raeesfarooq8936]

Thankyou very much for such valuable tutorials.. Kindly post some videos on 360 degree panorama image in website

[@webslesson]

Inline Table Add Edit Delete using AngularJS with PHP Mysql - kzbin.info/www/bejne/aF6si3Swm55qkMk

[@cesargutierrez2508]

This is a great tutorial, thanks for the aport

[@webslesson]

Thanks Cesar gutierrez for your friendly words.

[@krishganesh9985]

sir, if i replace first_name ... to add whatever it is.. this code is work or not... please immediately answer me sir... my project is ongoing ...help me sir

[@Ing.RaulPadilla]

how can i show the information of each textbox?

[@RandomKocakUniverse]

Thankyou sir

[@rockrubio4404]

Its cool, trying to find same functions under jquery mobile

[@Caliscanne]

when i click on enter it not update

[@shkarmohammed7596]

thank you very much

[@abdomohammed5002]

I have a problem anyone can help when i insert data for first time it work when do it again didn't work or send to database

[@JavaScriptWithExample]

i follow your instruction but table is not editable why?

[@bartgarcia9405]

No comprendo lo que dice pero le entendí muy bien Thank

[@barakbattach3024]

hi, is there a reasnoble reason why i cant see te table and im only seeing the head line, i just copied the cood and changed the needed. thx and the video is great!

[@webslesson]

Thanks...

[@MrGigi-dz9cv]

Thank you very much. But, you did not properly escaped your data before using it in the database.

[@justruss7389]

Nothing is displayed in the live_data div. insert.php is working because I echoed "$output" and I see all the data but nothing inside "live_data" div

[@webslesson]

If you are looking for same tutorial on how to insert multiple live insert data into mysql by using PHP with Ajax Jquery. Then you can find from this link - kzbin.info/www/bejne/qIOliIiGodWGhNk

[@kevinavery9788]

where can I download?

[@antoniosan1218]

awesome thx

[@vamshidharreddy6189]

I want update query for 2 tables using html table pls help me sir

[@alablaco]

Very good explanation. It worked great for firefox, but doesn't work on Internet Explorer, What could be the reason?

[@45454hdfjfhd]

no one use internet Explorer anymore it's to old and havy

[@alablaco]

You're right, the problem is that in my office the Internet explorer is official. 😯

[@45454hdfjfhd]

yeah and the raesion for why doesn't work on IE bcs they didn't update their system and get the new features

[@MohammadAlbazel]

Very good example, but how to insert the first record? I inserted it from the database, but if i deleted all the records, the add button disappears and can't add more records except from the database! so I add this code $output .= ' Data not Found + '; when there is no data found and works fine Thank you for this gr8 tutorial

[@biggrinboy]

i like your tutorial. but please don't use robot.. use real voice please. sound's weird when I see few your videos.

[@webslesson]

Thanks Teddy...

[@hiltonsounds3031]

This does not work...i've tried the exact code used in this video three times. I may be doing something wrong, but i'm copying the EXACT steps in this video. Any advice?

[@webslesson]

Hi Hilton What error you have face can you describe here.

[@pohonbunga6271]

i like it very detail . thanks

[@webslesson]

Thank you for writing to us. We appreciate your valuable feedback.

[@denturnz]

Awesome tutorial sir. but i followed all that you did but it did not work for me..i dont know what the problem is..i need help

[@ganeshkgp]

I want this to automatically focus on the last td's first element

[@paristowersinc8037]

i cant see any output on my browser, can somebody tell me why it just wont appear

[@webslesson]

Have you follow source which we have provide at video description, please check it

[@webslesson]

My Latest video on Upload and Extract a Zip File in PHP - kzbin.info/www/bejne/jXacaKyPrph6Y8k

[@jorgemychaelcortejo4078]

how can i modify your code if i want the edit to have a button?

[@samsonosarodion9792]

can you pleaese post the sourcecode through reply for me please. thanks in anticipation

[@renzogf1103]

Friend, when I insert new records, you do not get the id. To obtain the Id, I must refresh the page. How can I avoid that?

[@nServicesNewDelhi]

[For the new users :-) ] $newRecordId = $con->insert_id

[@chumarosawa]

How to pass the id to the delete button when its a varchar

[@chumarosawa]

I got it y put the code uf some one need it onclick="functionJavaScript(\''. $row['id']. '\')"

[@MuhammadArshadThaheem]

really awesome tutorial. I am facing some trouble to apply this thing in my scenario. Could you help me to resolve this issue. how can i contact you?

[@jiabubbles]

I tried the source code but it is not editable.

[@jiabubbles]

so I try it in Chrome and it is editable. It's depend on the browser version. Anyway thank you for the tutorial and code sharing. its really helpful hope for more tutorial on the way :)

[@HaizadAnnuar]

Sir, can I replace the index.php into index.html?

[@allaboutnepal6294]

if you do that all your server code(the code in php ) will be seen in the web browser which can be easily available in just one step (by inspect element) and it's not good for security purpose.

[@HaizadAnnuar]

noted. thanks :)

[@jadejajaypalsinh7333]

problem in data edit, when i edit first name and press tab, alert box display again and again, if i stop alert box i must close window. what is solution??

[@aymardnounamo2963]

there is a missing request (update),

[@aymardnounamo2963]

$sql="UPDATE markers SET $column_name='".$text."' WHERE marker_id='".$id."' ";

[@jorgemychaelcortejo4078]

hi sir . i test your code but the edit is not functioning. I tried to edit the text i input but it didn't change or anything. can you explain it why? i only doing it for advance study. and thanks for the tutorial.

[@aymardnounamo2963]

$sql="UPDATE markers SET $column_name='".$text."' WHERE marker_id='".$id."' ";

[@zerogravity8150]

Too good

[@webslesson]

Thanks Laces...

[@yannickmatandaofficiel5130]

hi, great tutorial. it works fine in chrome but not in internet explorer. i'm creating erp for companies, and for more security, we use internet explorer. is it possible to make a tuto for internet explorer or for all browsers. i would be happy if you give me an answer. thanks and great job again.

[@webslesson]

I will check it. Thanks.

[@skypeon1]

yannick matanda you are doing something very wrong if you are using internet explorer for ''security'' ...

[@honsertume]

plugin for autocomplete???? :c

[@wgconsultants3030]

Google has all the autocomplete codes you want. There's no "plugin" LEARN not slap it

[@neelsfer]

Please make a table like this that works like a spreadsheet with arrow navigation

[@webslesson]

Thank you CJF for writing to us. We appreciate your valuable feedback.

[@jajasaria]

hi sir im almost done with your tutorial and i want to implement the datatable function. can you help me where to put this code $(document).ready(function(){ $('#myTable').DataTable(); }); thanks in advance

[@canete_code]

Ad it on select.php file at the end of the document , bewteen two script tags

[@mdsaiemkhan2212]

Awesome

[@THEHISTORY_TV]

Nice

[@asadkhanjan7256]

sir so good .......but when you add new data the data is store in a first line whyy...... can we place the new data in the last field????? sir please help me and fix the code

[@webslesson]

yes you can do this things, by using this select query - "SELECT * FROM tbl_sample ORDER BY id ASC", please use this query and try it.

[@FigardiCanarias]

este código no funciona, metes datos en BD y si los lee, pero no deja poner mas con la aplicación ni deja update

[@ayandas6225]

sir need it in codeigniter.....Please

[@junramosyours5805]

nice! thanks for sharing.

[@webslesson]

Thanks Jun...

[@mohammaduzzwal5011]

excellent waiting mail send from hosting....

[@PuneExprees24]

How to add drop-down while edit

[@arnabbhattacharya448]

pls anyone give me suggestion on data-id attribute !!

[@shahmirjadoon1322]

kindly do some tutorials in new Laravel 5.3 will be really helpful

[@denisdev4793]

hello friend can you make a video about notifcation of messages like facebook

[@webslesson]

Hi Chemsou dev, we have already made video tutorial on this topic so please search in our channel you can find this type of video tutorial.

[@PramodKhandalkar5]

but all ajax code is visible to user

[@VanishingTacos]

and?

[@ajncz5161]

ya know what your voice sounds like pink sheep on explodingtnt channel

[@nakulsarkar_in]

When i reload the page it will automatically inserted last input data in the database. If i reload again then it will again inserted last input data. Also if i put new data then it inserted the current new data. again after inserted new data if i reload the page (without giving nothing in the input field) then it automatically inserted last new data. student_name student_city DON india DON india (same data ) code: insert data in database using mysqli

[@asadkhanjan7256]

just place the echo statement instead of header function...............

[@jamalkhan8823]

Hey, Everyone, anyone can help me how to use datepicker in table

[@nayanthakkar5720]

Take input type as Date.

[@jamalkhan8823]

@@nayanthakkar5720 thankx alot buddy i did it but in ajax when you declare var then instead of text you will be write .val

[@vatsaljoshi4390]

great approch to do crud

[@rakeshphulwari5722]

Please provide code and database in file format

[@webslesson]

Hi Rakesh Phulwari you can find complete source code with database in this video description, so please go through it.

[@djamilafiguir6491]

this is dose not work for me , is something you don't give it in this Tutorial????

[@webslesson]

Hi Figuir, what you want, can you describe.

[@jayadikurniawan2457]

the link is not working

[@webslesson]

which link is not working...

[@khoirilanwar4534]

not display anything. i follow four code until insert.php

[@cr7jersy11]

+Khoiril anwar echo $output outside while loop

[@johnmartin2341]

+Arslan Khurshid Thanks I have solved it.

[@caochenxing7168]

+Povonte Martin How do u solve it ?

[@TheRonron1994]

Robot?

[@emanuelb.2559]

well, robots are very good coding

[@slobodantajisic2762]

I have here an infinite loop with alert boxes...

[@shahbazimma]

me too

[@drmacsika]

Who else paused at this point 15:41 ? Curiosity made me do it.

[@DejaVu2017]

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in C:\Program Files (x86)\EasyPHP-5.3.9\......\fetch.php on line 24 Data Not Found

[@jadejajaypalsinh7333]

plz check connection or put connection variable in mysqli_query();