How to Save Elementor Form Data to Your Database 

Excellent Tony, you`re an excellent teacher. I understood your tutorial and I don`t talk english daily. Greetings from Argentina. GENIO!!!!

After long search here on yt tutorials, finally one that explained it that simple and nice. Thanks!

this helped so much tony, appreciate it brotha! made it so simple for anyone to be able to use.

Thanks so much for this!! This solves many problems at my freelancing gigs.

This one is exactly what I need! Thanks for the tutorial.

This is one of the best tutorials for using Elementor forms and adding it to the database. Thank you for your hard work creating this video.

Excellent tutorial - thanks very much!!

Wonderful!......you solved many people's problem...thank you

This video was really helpful. Thanks so much for putting this together.

great video, I see a lot clearer now how to manage my custom made websites. You have a great teaching style, I like that a lot

I am an old programmer (oracle DBA for DOTNET) from 10 years ago. I am trying to create a prayer list in our church's website. This was SO CLEAR even a programmer could understand. I hope you have lessons on how to display the data. I will add a statue field and based on that display current prayer requests and add a counter. I have been looking for the HOW TO and love it. James 6 thumbs up

Keep up the good work, Tony!😆

It works for me! Thanks for the tutorial

Tony Many thanks for sharing your knowledge with us all - this video certainly helped me to understand the complexities with WP, Elementor and MYSQL. As a non-developer I have a question if I may. I like the idea of adding data from forms to MySQL data Tables (defiantly will help with analysis) my question is how I adjust the php code to allow data form a single input form to be saved to several data tables i.e. a client sign up form that will save data to the following data tables - client_info, address_details etc I have been able to do this with HTML, CSS and PHP but am struggeling with doing the same whilst using Elementor Forms All said this was a great video and looking forward to watch all you have to offer - great job

ty bro u so good 😀

Excellent work buddy......

Awesome tutorial, very helpful and simple steps to follow

Thank you so much for this wonderful video

Thank you very much!

Searching for this a long time ago

love it! thanks

I really like the mood and setup of your desk, interesting lightning and camera angel

Thank man for the help....

Thx Sir

Thanks! Was also wondering if since you’ve custom coded that submit event - that if, say, you wanted to also send an email AND REDIRECT user if you would have to also accomplish that in the same code block - I presume so - or can one add multiple actions after submit ? Is there any “run code” option available through the interface directly - it seemed you had to leave the reservation and custom code the event in the child theme as your only custom option. All good if so - just curious

Great vid! Couple q's about the data: 1) where would that data be hosted and how could you make sure that you are the sole owner and only person with access to the data? 2) how could you connect the data base to scripts that would run calculation on each new database entry and markup a pdf to send back to user? Thanks!

great vedio

finally i found it.. this is exaaactly what I'm looking for.. Hey Tony, i'd be great if you complete it with tutorial to show the table on the page using elementor.. thanks anyway

Good one Tony. If you don't want to touch theme editor files, you can also choose webhook as your after submit action. Provide a php file url, the file would accept the post request and insert the data into your db.

So cool!! thanks!! so much!!

thanks for share. hope will have searies how to show in backend wordpress to see all infomation after submit in elementor form!

Thanks for this Tony, it's helped me out a lot, however, I want to add a photo upload to the form. So I added another column to my database called 'photo' and added a line in the functions.php - 'photo' => $fields['photo'], but when I submit the form it displays '0' in the photo column. How is it really done? Cheers.

Hi Tony! Thank you for this tutorial, it was very helpful for me too! How can I display those submissions (saved in the database) in the front-end with Elementor Pro? I have created a guestbook with Elementor Form and I want to dynamically display those submissions saved in the DB. Also, if I remove a submission I think it still exists on the DB. Thank you in advance.

I have also subscribed !

Hello Tony. Thanks a lot for the Video! You say "everytime a form is submitted", what if i got many forms with different inputs for different databases. How can I get the input for the right Form? For example: FormX: Name(PK), Email, Message --> Database Demo FormY: Age, Country, Name(FK) --> Database Customer

Is it possible to have a query that pre fill a field? It looks like the field can have one. Like I want have the looged in user telefon number pre fill into a field.

thanks for the video, it was very helpful. I would like to know how then can we retrieve those values in the database to an excel fle or better yet how can we display all the entries in our website??

How could I collect forms from visitors on my site and then add a search feature so users can search for the data for those filled out forms? For example, I am working on a site where customers can come and input a negative review of XYZ place and I want the data to be sent to a database which then people can search for XYZ place on the homepage and see what negative reviews that place has. Any advice, Tony?

hi, how to set login page as we enter the website? I want to make web portal using elementor. but getting stopped out because of the flow. in PHP we set login page and move it in the beginning of folder htdocs and named it index.php but how to showed it in elementor? how does we set first page in elementor is login page before it redirect to dasboard after login of course, and how to connect users and password database in phpmyadmin to match in login page? thanks

Are there any validation tools in the Elementor form? And how do you usefully extract the data from the PHPAdmin environment?

Could I check if it is possible to save data to database using Forminator or Contact Form 7?

Thanks... and is it possible to prevent duplicate submission? please

very good bro do you have the to show that data in some page?

how does this work for only a certain page? if I adde to the functions, will this not run for every form?

Hi Tony, This is a very good Tutorial Please teach me how to upload files from Elementor form to a folder and show them into dashboard.

Can I collect from multiple websites using this way?

May I ask how can I get the submission ID in elementor pro form hook? like in elementor_pro/forms/new_record?

Hey Tony Is it possible to do the same with formulator Forms? Like if I create a form on forminator, so will I be able to save that form data to a custom table in myphpadmin.

And how about if i want to show data on my wordpress page?

how to do same thing but with checkboxes and selects? please i need it for school project

is it possible to save the data from elementor form to external database?

Hi tony. Can you make a video how to using this elementor forms to connect with webhook?

Hello Tony, is it possible to send data of Form in mean time to email address in addition to external Database, thanks a lot in advance

Hi Tony can you provied a tutorial video about how to upload image or document and save to a folder with PHP MySQL data base

hi tony, its a really good tutorial can you make a tutorial how to create registration and login using elementor and save the data we have collect into database? thank you.

How to save that a custom post type?

Hi Tony! Thank you for this video! How do I update a field in the usermeta? For example I want to update the Facebook URL using my customized Elementor page. Thank you in advance!

Do you have and example .. when you display on screen the same table in elementor form for me

Using this method, how can you do this for multiple forms on your website and put the data into their own separate tables? (Example: Form1 > Form1Table and Form2 > Form2Table) Thank you for creating this video!

What are those 10 and 2 at the end in the code snippet you entered in the functions.php file?

i use exactly the same staps , doesn't for me and i don't know why can i get some help plz

This video is a gem. glad I found it. anyway, using the same method, can you also delete data from the database? if so, how?

will this only work with one form? i have multiple forms on wbsite i need to store data in diffrent tables

thank u tony but when ineen do do some thing calculation ?

Hi Tony! This is a great tutorial. Is these items possible to do in Elementor forms?: - Populating drop-down menus with data from database - Updating data using Elementor forms Thank you!!

HI, this was very useful, thanks a lot. I was wondering whether I can just go to appearance/customize/additional css and add the code there or is it better to install the child theme?

hi tony tnx about this amaze video, how i can create a page that when someone type in search box on that page, many fields shows information from database that I before imported to database, query information and show , for example you search "tony" name in search box, then show information's from tony - like age, family, job and so... pls help me by share link or something like that tnx again man keep it on... i want do this all in wordpress by elementor

how to save data useing contact from 7 in my phpmyadmin wordpress

Excellent tutorial, how do I do it if I want to read a row from the table and perform an update, then showing the result in an attached list.

Hi Tony, really great tutorial! Do you know how to read data from a custom table (like your demo table), and display it on a page? Thank you.

i dont know when you will answer this Tony but i would wish to know.if i installed wordpress locally on my machine ,and installed xampp on my machine,would the code snippet you provide work?i would wish to create a form with my own fields maybe to store my shop inventory.otherwise thank alot for the light.i appreciate this tutorial

Hello sir thanks for this vidéo but is not work on mine I don't know why.

Hi Tony, your tutorial has been very good, you gave me a solution that I was looking for. however, suppose that the $ fields (message) has three options, separated by three Fields in the form, field A, field C, field D, how would you make the array 👉 $ wpdb-> insert ('table', array (' name '=> $ fields [' name '],' email '=> $ fields [' email '],' message '=> $ fields [' $ fieldA, $ fieldB, $ fieldC '])); is that correct? remember that my question is if three fields of the form separated by comma "," could go in the message field !!!

This is a great tutorial! However, I notice you omitted adding a unique ID (primary key) for the new table. Wouldn't you want to be able to associate the table with other data in the database and therefore would need to have a primary and foreign key for each record? Also, I'm trying to understand what the use case would be for doing this since Elementor records all its submissions in the e_submissions and the e_submissions_values tables. Couldn't I just learn how to work with these tables instead of creating a new table for my form submissions?

🥰

Hello, do you know what directory this would change to if I use ninja forms instead of elementor forms, >> " 'elementor_pro/forms/new_record',"

Does this work with code snippets? My child theme did not have a functions.php, so I followed the instructions for code snippets but it did not work. Any help is appreciated

very clear but i dont see how the function is linked to the specific form...or put another way how the specific form calls the specific function

can u alos make video for fetching data

hi tony its a good videa, would like to is there any limitation on adding number of record, and how to retrieve

Hi, Tony. I did everything you did, But the data is stored in table `wp_e_submissions_values` instead of my own table. What am I doing wrong?

Is possible create more forms with each their own table? In your code where is the "link" of the Elementor's form? 'elementor_pro/forms/new_record'? But in the example the form's name is 'New Form'.......

can you write this same data to the brouwser with the same procedure, not first to the db than back to browser but drectly to the brouwser

Putting this out for anyone to chime in, but does anyone know how in wordpress or elementor to get the data that was submitted to pop up on the page as a confirmation for the user to see what they had just sent after they hit submit button?

what about with multiple forms?

Hey, there!! Thanks for making this tutorial. But, when I paste it on my function.php then it is showing this error: "Something went wrong. Your change may not have been saved. Please try again. There is also a chance that you may need to manually fix and upload the file over FTP."

can it only be used for child elementor themes or can it be with the Medicalpress theme? thankyou

is there a way to show the data on your browser in a frond-end layout before writing to the DB.

Hello sir great tutorial helped me alot but I am trying something to validate the data that is existing in DB. please help me out in this I'm trying to verify the file number whether it exist in Database or not if it exists it give success message, if not then show invalid number. My Tab has only one col i.e fileNumber. This is the code I have tried to put in the child theme in functions.php. when I enter the file number in the name field this code only show the statement after else statement ($ajax_handler->add_error( $field['id'], 'Invalid number' );). is there any other way to do this? here is the code add_action( 'elementor_pro/forms/validation', function ( $record, $ajax_handler ) { $fields = $record->get_field( ['id' => 'name1',] ); if ( empty( $fields ) ) { echo "enter the file number"; } $field = current( $fields ); global $wpdb; if($wpdb->connect_error){ echo 'Connection Failed: '; } $sql = $wpdb->get_results( "select fileNumber from wpbd_FileNumbers where fileNumber like '%$field%'"); /* $sql="select * from $wpdb->wp_FileNumbers where fileNumber like '%$field%'";*/ if($sql == $field){ $ajax_handler->add_response_data( true, $output ); } else $ajax_handler->add_error( $field['id'], 'Invalid number' ); }, 10, 2);

Thanks, Tony for very useful tips. I'm looking for a method to create a unique id containing text + number like ORD001. How can I achieve this in elementor form? This id should be automatically increased as the user fills the form. Can you please help me with that?

Well, can we send the same form data to the mail at the end of this process?

Everything I did however the database is not being updated.

hi tony i have a simple elementor how can i make a database in simple elementor?

How can i add the form data to be displayed on another page like a thank you page?

Tony can you do a video on how to put Elementor Multi Step form data into PHPmyadmin? There is no video on Elementor Multi Step Form data into PHPmyadmin.

Thanks for the tutorial TOny! How to do this for files?

Hello, great video, Any idea how to prevent form clearing data after Submit? I'm looking for this option, not sure should it be done through javascript...

Could you do a video tutorial on how to add a database to google cloud server and the sent the data there. Example: I bought my domain name I set up free hosting with google cloud the installed word press now need a php database....

hello tony, thank you for the tutorial you made very useful, can I make the same tutorial as the material from this video in my language (indonesia)? , I think a lot of my country needs it, I'm going to include this video link in the description that this is your content I'm just recycling

Hello, can this be customised for EA registration forms... Actually, cannot find a solution to save in db the terms and conditions acceptance for a registration form made with EA. Thank you.