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!!

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

[@clickadelic7681]

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

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

[@webslesson]

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

[@willonedision]

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

[@uzi2406]

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

[@OnePageVoter]

Thanks for giving valuable help and learnning...

[@d3xx3rDE]

Perfect tutorial for live database usage on websites.

[@squirrelgaming4028]

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

[@ehtishamsaid783]

U r Hero boss ....liked ,subscribed

[@DineshNairMumbai]

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

[@jeshtimayank7911]

this tutorial is toooooo good sir

[@raeesfarooq8936]

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

[@mcvgs1780]

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

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

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

[@arafatsage8415]

Good Tutorial... Keep it up

[@warsyam778]

Nice tutorial, please tutorial relation table

[@boliviareports]

Thank you for your awesome tutorial

[@rockrubio4404]

Its cool, trying to find same functions under jquery mobile

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

[@renzogf1103]

Gracias, es exactamente lo que estaba buscando.

[@vaidehipanchal7635]

very helpful..

[@marklesterpine3739]

It helps me a lot. Thanks

[@SatoshiLearning]

great, thanks

[@aravindkathiravan905]

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

[@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"].'" ;)

[@RandomKocakUniverse]

Thankyou sir

[@bartgarcia9405]

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

[@shkarmohammed7596]

thank you very much

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

[@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'' ...

[@antoniosan1218]

awesome thx

[@cesargutierrez2508]

This is a great tutorial, thanks for the aport

[@webslesson]

Thanks Cesar gutierrez for your friendly words.

[@GharGrihasthi]

Thank you so much, you saved my day !!

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

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

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

[@pohonbunga6271]

i like it very detail . thanks

[@webslesson]

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

[@dimasadiandrea9384]

can i integrated that with jquery datatables plugnin?

[@mdsaiemkhan2212]

Awesome

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

[@shahmirjadoon1322]

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

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

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

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

[@mohammaduzzwal5011]

excellent waiting mail send from hosting....

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

[@THEHISTORY_TV]

Nice

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

[@junramosyours5805]

nice! thanks for sharing.

[@webslesson]

Thanks Jun...

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

[@MrGigi-dz9cv]

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

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

[@ganeshkgp]

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

[@jamesbond-cx2uh]

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

[@Ing.RaulPadilla]

how can i show the information of each textbox?

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

[@samsonosarodion9792]

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

[@kevinavery9788]

where can I download?

[@mysterious_Journey888]

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

[@ganeshkgp]

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

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

[@vatsaljoshi4390]

great approch to do crud

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

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

[@ajncz5161]

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

[@JavaScriptWithExample]

i follow your instruction but table is not editable why?

[@zerogravity8150]

Too good

[@webslesson]

Thanks Laces...

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

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

[@vamshidharreddy6189]

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

[@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."' ";

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

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

[@PuneExprees24]

How to add drop-down while edit

[@Caliscanne]

when i click on enter it not update

[@drmacsika]

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

[@Milktea_Buddy1092]

Oo

[@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."' ";

[@slobodantajisic2762]

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

[@shahbazimma]

me too

[@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();

[@sujoenilshahi9715]

Can u Explain nicely....

[@sistemasinfor]

Good!...

[@webslesson]

Thanks...

[@ayandas6225]

sir need it in codeigniter.....Please

[@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']. '\')"

[@TheRonron1994]

Robot?

[@emanuelb.2559]

well, robots are very good coding

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

[@サイシュマンス]

this video has really good information, but yeah.....really bad audio(no clear explanation)

[@honsertume]

plugin for autocomplete???? :c

[@wgconsultants3030]

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

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

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

[@arnabbhattacharya448]

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

[@jayadikurniawan2457]

the link is not working

[@webslesson]

which link is not working...

[@PramodKhandalkar5]

but all ajax code is visible to user

[@VanishingTacos]

and?

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