Saving form value to database through ajax wordpress

Question

How can I save data to database using ajax and form. I have working this for one day but still no luck I don't know what's wrong with this code I came up right now. This is one is wordpress

Here is the code:

This javascript was in the header.php

<form>
<input name="MyUrlName" type="text" class="add_name" id="MyUrlName" placeholder="Name of website">
<input type="button" name="submit" id="MyUrlsubmit" value="Add URL" class="submit">
</form>
jQuery(document).ready(function(){
        jQuery("#MyUrlsubmit").click(function(){
            var name = jQuery("#MyUrlName").val();
            jQuery.ajax({
                type: 'POST',
                url: "<?php echo admin_url('admin-ajax.php'); ?>",
                data: {"action": "savedata", "MyUrlName":name},
                success: function(data){
                //alert('success');
                 console.log(data);
                }
            });
        });
    });

Here is the code in function.php

 function savedata(){
        $name = $_POST['MyUrlName'];
            global $wpdb;
            $table_name = $wpdb -> prefix . "save_url";

       $wpdb->insert( 
                $table_name, array( 
                    'name' => $_POST['MyUrlName']
                ),
                array(
                    '%s'
                )
            );
       return true;
exit();
    }
add_action('wp_ajax_nopriv_savedata', 'savedata');
add_action('wp_ajax_savedata', 'savedata');

I'm implementing it in frontend

Thank you in advance

Maulik · Accepted Answer · 2016-03-22 05:00:48Z

3

use this code

 <form>
    <input name="MyUrlName" type="text" class="add_name" id="MyUrlName" placeholder="Name of website">
    <input type="button" name="submit" id="MyUrlsubmit" value="Add URL" class="submit">
    </form>
    jQuery(document).ready(function(){
            jQuery("#MyUrlsubmit").click(function(){
                var name = jQuery("#MyUrlName").val();
                jQuery.ajax({
                    type: 'POST',
                    url: "<?php echo admin_url('admin-ajax.php'); ?>",
                   data: {action: "savedata", MyUrlName:name},               

                    success: function(data){
                    //alert('success');
                     console.log(data);
                    }
                });
            });
        });

answered Mar 22, 2016 at 5:00

Maulik

8971 gold badge8 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Maulik Over a year ago

please check this answer

winresh24 Over a year ago

it's still giving me 0 response

Maulik Over a year ago

function savedata(){ $name = $_POST['MyUrlName']; global $wpdb; $table_name = $wpdb -> prefix . "save_url"; $wpdb->insert( $table_name, array( 'name' => $_POST['MyUrlName'] ) ); return true; exit(); } add_action('wp_ajax_nopriv_savedata', 'savedata'); add_action('wp_ajax_savedata', 'savedata');

Maulik Over a year ago

try this in function.php

Maulik Over a year ago

<form method="post" action=""> try this in your form page

|

Collectives™ on Stack Overflow

Saving form value to database through ajax wordpress

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related