Live Table Add Edit Delete using Ajax Jquery in PHP Mysql

In this Video, we learn live table Insert, Update, Delete, Fetch data from mysql database using Ajax Jquary in php without page refresh. For this I use html5 contenteditable attribute for table column editable. For source code - www.webslesson....

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

[@webslesson]

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

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

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

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

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

[@d3xx3rDE]

Perfect tutorial for live database usage on websites.

[@OnePageVoter]

Thanks for giving valuable help and learnning...

[@DineshNairMumbai]

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

[@squirrelgaming4028]

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

[@arafatsage8415]

Good Tutorial... Keep it up

[@ehtishamsaid783]

U r Hero boss ....liked ,subscribed

[@mcvgs1780]

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

[@renzogf1103]

Gracias, es exactamente lo que estaba buscando.

[@jeshtimayank7911]

this tutorial is toooooo good sir

[@clickadelic7681]

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

[@marklesterpine3739]

It helps me a lot. Thanks

[@boliviareports]

Thank you for your awesome tutorial

[@vaidehipanchal7635]

very helpful..

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

[@GharGrihasthi]

Thank you so much, you saved my day !!

[@warsyam778]

Nice tutorial, please tutorial relation table

[@raeesfarooq8936]

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

[@cesargutierrez2508]

This is a great tutorial, thanks for the aport

[@webslesson]

Thanks Cesar gutierrez for your friendly words.

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

[@pohonbunga6271]

i like it very detail . thanks

[@webslesson]

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

[@SatoshiLearning]

great, thanks

[@rockrubio4404]

Its cool, trying to find same functions under jquery mobile

[@bartgarcia9405]

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

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

[@shkarmohammed7596]

thank you very much

[@drmacsika]

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

[@RandomKocakUniverse]

Thankyou 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

[@antoniosan1218]

awesome thx

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

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

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

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

[@mdsaiemkhan2212]

Awesome

[@zerogravity8150]

Too good

[@webslesson]

Thanks Laces...

[@ganeshkgp]

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

[@sasibhushansaikia926]

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

[@MrGigi-dz9cv]

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

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

[@junramosyours5805]

nice! thanks for sharing.

[@webslesson]

Thanks Jun...

[@THEHISTORY_TV]

Nice

[@aravindkathiravan905]

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

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

[@mysterious_Journey888]

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

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

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

[@dimasadiandrea9384]

can i integrated that with jquery datatables plugnin?

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

[@jamesbond-cx2uh]

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

[@mohammaduzzwal5011]

excellent waiting mail send from hosting....

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

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

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

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

[@vatsaljoshi4390]

great approch to do crud

[@JavaScriptWithExample]

i follow your instruction but table is not editable why?

[@shahmirjadoon1322]

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

[@ajncz5161]

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

[@ganeshkgp]

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

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

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

[@Ing.RaulPadilla]

how can i show the information of each textbox?

[@Caliscanne]

when i click on enter it not update

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

[@samsonosarodion9792]

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

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

[@kevinavery9788]

where can I download?

[@サイシュマンス]

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

[@vamshidharreddy6189]

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

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

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

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

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

[@TheRonron1994]

Robot?

[@emanuelb.2559]

well, robots are very good coding

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

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

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

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

[@sistemasinfor]

Good!...

[@webslesson]

Thanks...

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

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

[@PuneExprees24]

How to add drop-down while edit

[@Callme_Buddy1092]

Oo

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

[@sujoenilshahi9715]

Can u Explain nicely....

[@ayandas6225]

sir need it in codeigniter.....Please

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

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

[@slobodantajisic2762]

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

[@shahbazimma]

me too

[@honsertume]

plugin for autocomplete???? :c

[@wgconsultants3030]

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

[@arnabbhattacharya448]

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

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