Awesome, thank you! 😀

Thanks James! I have a similar video that goes through a basic CRUD implementation which I think you'll find helpful too kzfaq.info/get/bejne/ptWJo6-fvrXUY5s.html

You're very welcome!

Great, glad you found me

Happy to help!

Awesome to hear that :)

Awesome! I'm happy to hear that David

Glad I could help!

That's fantastic :)

Sure thing!

Thanks Richard

Please see my comment here for working with multiple forms tonyteaches.tech/save-form-data-elementor/#comment-602

1. The data is hosted in a table in the same database as your WordPress site. If you own this, then you also own the Elementor data. 2. This is possible, but would require you to hire a developer to write a custom solution. I'm not aware of an existing solution for this

@@TonyTeachesTech thanks!

This code snippet will show you how to do that tonyteaches.tech/save-form-data-elementor/#multiple-forms

Glad it was helpful!

Good to know that!

@@TonyTeachesTech thanks for commenting here. I watched your other video where you processed "addition" and returned the sum to an HTML. My question to that is, how do I pass that returned data to Email action? Something tells me the mail fires before that data arrived. Any direction would be appreciated. Thanks

@@kemekenneth Oh okay I understand. That I don't know the answer to unfortunately

Thanks @@TonyTeachesTech, I'll keep poking and looking around.

How?

Usually the primary also uses auto-advance, it will apply the next number in +1 order. You don't have to do anything. If I understand your question...

You're welcome!

You're welcome!

You are so welcome!

Thank you! Cheers!

Yes you can achieve this with custom HTML/PHP, but it requires some coding and design to show the data to the user before submitting it to the db

@@TonyTeachesTech easy way wp data tables plugin, im working on this right now, what tony shares plus data tables to show and manage the data.

I don't fully understand your setup with xampp (not familiar with that). If xampp give you PHP functionality, then I could see this working.

Perhaps this longer, more-comprehensive tutorial will bring things full circle for you kzfaq.info/get/bejne/ptWJo6-fvrXUY5s.html

You're welcome

Hi Federico. You can certainly have multiple forms. Distinguish between them with their 'id' on the server like this: if ( 'MY_FORM_NAME' == $form_name ) { // do something } else if ( 'MY_OTHER_FORM' == $form_name ) { // do something else } .... developers.elementor.com/forms-api/#Form_New_Record_Action

I'm not sure without seeing your code

I think all themes should have functions.php. This will not work with code snippets alone

What do you mean?

Something I can look into

Something I can possible look into for a future video

What?

That's a good question. I don't think one way is better than the other. If you have the child theme installed, I guess I would suggest there in case the main theme for some reason removes your custom CSS during an update or something.

It is always better to install a child theme. Otherwise, any customization you do at the parent theme level will be overwritten when there is an update.

To read data you would use the wpdb class as we did in this video, but call the get_row function. Please refer to the WordPress developer documentation here developer.wordpress.org/reference/classes/wpdb/#select-a-row To return the data, see what I do in this tutorial here kzfaq.info/get/bejne/g8qeZcp31MrUqWQ.html&t=997 (I recommend you watch the whole thing) To display it on a page, watch the linked tutorial in its entirety and that should do it.

this is my question bro

You can log into your database on the command line and execute raw SQL commands to delete individual rows. Also, if you have something like phpMyAdmin installed, you can do this through a web browser kzfaq.info/get/bejne/mdiWdM1q3sfdZas.html

@@TonyTeachesTech okay, thanks! do you also happen to know what would be the directory 'elementor_pro/forms/new_record' for WPForms? or is this method not usuable with WPForms?

@@kenmelitado7952 Sorry Ken, I'm not familiar with WPForms

I'm not sure what's going on here 🤔

Yes. It will require custom code

I'm not sure if that's correct. I would suggest testing it out. Sorry if that's not too helpful

Maybe something like the would help kzfaq.info/get/bejne/ptWJo6-fvrXUY5s.html

Welcome

Great question! It's the priority and number of arguments respectively developer.wordpress.org/reference/functions/add_action/

This will work wether you have a child theme installed or not, but I highly recommend installing a child theme. Otherwise when you edit functions.php, you’ll find lots of other code in that file. This goes for other themes like Medicalpress. If there is a child theme for Medicalpress, use that. If not, this will still work, but just be careful when editing functions.php. Please note that this only applies to Elementor Pro. PS: I saw you comment on the blog post too :)

Sorry I'm not familiar ninja forms

Solved with following 2 lines (if anyone got also stucked) : jQuery( document ).on('submit_success', function(event, response){ document.getElementById("answer").innerHTML = response.data['1'].result; var old_value = $("#form-field-a").val(); $("#form-field-a").attr("value", old_value).val("").focus().blur(); }); Let me know if this aproach is good, thx ;)

Seems like you answered your own question 😁

In your PHP code, if you already have a number, then you can do something like: $old_num = 1; $new_num = $old_num + 1; $length = 3; $id = "ORD".str_pad($new_num, $length, "0", STR_PAD_LEFT);

@@TonyTeachesTech Thanks so much!

Sure. That's possible with a GET or POST request

// form elementor add_action( 'elementor_pro/forms/new_record', function( $record, $ajax_handler ) { $raw_fields = $record->get( 'fields' ); $fields = []; foreach ( $raw_fields as $id => $field ) { $fields[ $id ] = $field['value']; } // form 1 global $wpdb; $output['success'] = $wpdb->insert('form1', array( 'nome' => $fields['nome'], 'email' => $fields['email'], 'ddd' => $fields['ddd'],'telefone' => $fields['telefone'], 'ddd2' => $fields['ddd2'], 'telefone2' => $fields['telefone2'])); // form 2 global $wpdb; $output['success'] = $wpdb->insert('form2', array( 'nome' => $fields['nome'], 'email' => $fields['email'], 'ddd' => $fields['ddd'],'telefone' => $fields['telefone'], 'ddd2' => $fields['ddd2'], 'telefone2' => $fields['telefone2'])); // form 3 global $wpdb; $output['success'] = $wpdb->insert('form3', array( 'nome' => $fields['nome'], 'email' => $fields['email'], 'ddd' => $fields['ddd'],'telefone' => $fields['telefone'], 'ddd2' => $fields['ddd2'], 'telefone2' => $fields['telefone2'])); $ajax_handler->add_response_data( true, $output ); }, 10, 2); como usar com esse código ? add_action ( 'elementor_pro/forms/new_record' , function ( $record, $ajax_handler ) { if ( 'MEU_FORM' == $form_name ) { // lógica para MY_FORM ... } else if ( 'MY_OTHER_FORM' == $form_name ) { // lógica para MY_OTHER_FORM ... } ... } , 10 , 2 )

You can perhaps use JavaScript's alert() function to do this www.w3schools.com/jsref/met_win_alert.asp

At some point, there will be a limit, but I'm not sure what that is

Sorry, what is EA?

@@TonyTeachesTech Essential addons for elementor

@@renataqb Oh okay. Sorry... I'm not familiar with that

You're welcome!

Thanks!

Sure thing!!

The closest thing I have is this CRUD tutorial kzfaq.info/get/bejne/ac-jl8ZyqsDToWQ.html

Sorry, this video is specific to WordPress and Elementor kzfaq.info/get/bejne/ptWJo6-fvrXUY5s.html

Yes, just make sure to add the Mail "Actions after submit"

Go ahead!

Perhaps a redirect with GET parameters in the URL will do that for you

Hi Carlos, have you looked at the blog post for this video? tonyteaches.tech/save-form-data-elementor/ It has the content from the video that you can take a look at and copy/paste if you need to

@@TonyTeachesTech Thanks, Tony, have a good nigth.

You are so welcome!

@@TonyTeachesTech Maybe you dont need more extra money, but a suggestion you should have a donate button. The invitation is that if we sell someting with your tutorials we should donate, i woud do it. Really nice tutotial.

@@claudiofuentes9880 Thank you very much Claudio. Perhaps in the future I can do something like that, but for now if you subscribe and share my videos, that is all I ask!

*Update* - I found functions.php and copied the snippet there, but still doesn't work :(

You should have and will need to put the code in functions.php. Are you in the right place?

@@TonyTeachesTech the same here not working. I placed the code under functions.php, no error but the data not stored in phpmyadmin. Does it work for Free host of wordpres?im just using free hosting.

@@alvhen9655 You will need Elementor Pro for webhooks to work

@@TonyTeachesTech Tony I just found your tutorial and it's exactly what I was looking for however just like above it's not working. I do have Elementor Pro, and am putting the code into the functions.php on the child theme. The submit button returns success however no data shows up in the table of the DataBase.

In a couple weeks, I'll have a video about creating, reading, updating, and deleting database entries with Elementor, so please stay tuned for that!

@@TonyTeachesTech that would be amazing! thank you!

Thank you very much for your support 🙏

With the $wpdb object, you can access the database that WordPress uses and simply create another table for your Elementor form data

@@TonyTeachesTech Thank you for your response.But I am not using Wordpress database. I have seperate database I have Url of it. I want my form to send those details to my database as soon as I click submit button. I have url (endpoint) of my database. Where should I mention that Url to connect my form with my database.

@@mohammeddanishreza4902 You can instantiate a database object for your database like this $mydb = new wpdb( 'username', 'password', 'my_database', 'localhost' );

@@TonyTeachesTech But I am not using wordpress database.My database is somewhere else and I have only URL of it to connect my form and retreive data from Form and store it to that particular URL.

@@TonyTeachesTech and where should I write the code of database instantiate .