Multiple Inline Insert into Mysql using Ajax JQuery in PHP
ฝัง
- เผยแพร่เมื่อ 20 ก.ย. 2024
- In this video tutorial we are going to learn how to insert multiple inline table data into Mysql database by using Ajax Jquery with PHP. We have use HTML 5 Contenteditable attribute for editable table cell and by using JQuery we have append editable cell into table and by using Ajax send multiple table cell data to php script for insert multiple data into table. For Source code and online demo of this video tutorial - www.webslesson....
The Best Place to find a solution to your web Project, I am so amazed that when ever I couldn't find a solution to my problem in other part of the world, I found it here. Many thanks Guys, especially the tutor...
very helpful tutorial, thank you
Webslesson
This is very nice tutorial. Thanks for making this tutorial. please go ahead
Best tutorial I ever seen thank you sir
Great video :-)
One suggestion: it will be better for your application to take whole line '$query .= "INSERT into ..." before FOR loop and insert all values in one go. You can use syntax like:
INSERT INTO table item (item_name,item_code,item_description,item_price) VALUES (tval1, qval1, pval1, dval1, aval1), (tval2, qval2, pval2, aval2), (tval3, qval3, pval3, dval3,aval3), ....
It is much faster and uses less database resources.
Thank you so much for the video !! You are the best !! But can you do a video for delete and edit rows after insertion ?? 👍👍👍👍👍👏👏👏👏
Thank, Your video is of good quality, expect more publications
Nice Tutorial , i find solution here .thanks
This is awesome! Nice tutorial. Thanks for making this
Oh, thank you Zulshaffikka! Always at your service.
I need to enter item date as well. But no need to enter again and again in each time. What can i do?
Muito obrigado por compartilhar seu conhecimento... É de muita ajuda.
I know this tutorial has been around for a while, but I'm just getting around to seeing it based on a google search for something similar. It's a wonderful tutorial. Thanks very much for sharing. Initially, I had an issue with this working because my jquery libraries were loaded in the footer of my template. After moving all the javascript/jquery references to the head of the template, everything worked flawlessly. One question though. Many sources on the internet advise loading the jquery libraries in the footer. Given that mine was originally loaded in the footer and I had issues, what is the best way to load the jquery libraries and, will this tutorial work if jquery was loaded in the footer of the template with bootstrap also loaded there?
Bonjour Merci pour ce contenu
Why the first item is not inserting to the database?
Wow!!
This is great!
Thankyou so much!
Thankyou Tommy Surya Jaya, have a nice day!
good day you will not prompt how to make in this example more fields for input ? just I tried to do as in the video but with a lot of fields but the entry of records is not happening can you tell what my mistake thank you
Hi, thank you for the tutorial, it gave me a clear understanding.
But I have two more requirements:
1. How can I make the td non expandable (without giving fixed width in px, but i would like to give fixed %) while typing long data, 2. how can I include select option as td, and how will I take the value for insertion in DB? Please help how to do it. Thanks.
Loitongbam Sanayai same question
Column item_price. I want change from textbox to select option but I can't
Its really really good about the dynamic concept
How can we manipulate the insert.php code to make the - to actually DELETE records within a table?
is this work for 1000 row and 20 columns table? why data truncate?
How would this work with codeigniter? Which part would I add to my controller?
When will you make a complete system for channel subscribers?
thanks for this tuts.. it help me.. But have a problem.. passing multiple Data as array.
Very nice ,great work
Please can you post a video invoice bill design i didnt multiplication a two input values and show to the third input textbox and also doesnt store third input value in database its aal time showing 00 in data base
excellent video, please I need an example to add rows within others for example:
Questions and within the possible answers
I want to get item_name block as constant. So whenever I press add the same value of item_name goes in the dB as long as I click add button
Hi thanks for this tutorial. I have a little problem when I try to add a checkbox.
I somehow can't get its value even when I'm using modem.push($(this).val());
(modem is the array of checkbox).
would you please help me solve this problem.
thanks sir
its all functioning but iwant to add select option value
Did you have any code for expiry date attribute in the table I am struck with it.
could you pls share how to update this multiple row coz i got error updating...thanksss
when i insert the data then it gives error or data is not inserted.i executed your source code
its really good but displaying alert for same times of checked item, how can i resolve it
How to add select option in the table? please help
great tutorial, but in my case $('#' + delete_row).remove() doesn't work. How can i fix it?
you were able to recover the error?
help me sir.
when I input the item name and item code, it appears an alert if the data I input is less complete. but after I click ok. the name and code data that I input was missing. please tell me how the way when I click ok on alerts, the data that I input is still on screen. thanks.
How can i add a select option in this code? Please help me. Thank You
pleasee
How can I add a calendar field?
no textbox field
thank you
Please someone tell me how to write code if we want to do addition of column “price” and dynamically will be shown in text box. Please tell me. I have to apply same concept in my project . Plz plz
Good work
Help me..
build and implement online students attendance management system.
Please
How to edit and inset in edit page
Nice video.. but can u make the same for duplicate entries validation of multiple insert form
Thanks Linson Loranace, We appreciate your valuable feedback.
nice very details. thanks
Thank you Friska Novita Sari, You're most welcome.
In the second file not add select :/
Thank very much :)
Hi You're most welcome.
thanks for sharing : )
Hi may i ask if this is possible with a radiobutton in it or a checkbox in it?
Hi Jep Padua, it only support textbox and select box only, you cannot use radio button or checkbox in it.
Thanks! :)
there is a error please anyone can help me please
Warning: count(): Parameter must be an array or an object that implements Countable in C:\xampp\htdocs\kamal\pannel\bill.php on line 12
how can I insert option value please give me a source code
how add datatables into that data?
Sir ask po how to make it no duplication of data?
Hello sir please make some video for printing receipt sir please
how to total the price of the product
how to update the table ??
Thanks
WoW.....!!!
Buenos días, quisiera hacer una aplicación donde se puede tener un control de personal y aportes en dinero. Me puedes colaborar por favor?
image insert kase ho ga sir
i got problem cannot save..how to fix it? anyone can help me please..
same
how can i convert to codeigniter pls help me
in ajax URL: 'controler_name/function_name';
would love to learn this but can't get my head around the monotone electronic voice! at times it makes no sense and sounds like its stuck in a mind-numbing loop! its a shame as it looks interesting. please ditch the steven hawking effect voiceover and actually explain whats going on
Sir please make a complete E-commerance Project
Thank you Younas Aslam for your suggestion. We have forwarded it.
He did. It's not "Completely" handed out to you. but the essentials is there
I like's php less...
you forgot "how to delete the item" haha
do you have a code for it?