From Wordpress plugin data is not getting inserted into custom table

Question

I have created a plugin to insert and fetch records. When I save record, record is getting saved from localhost but when I try it on online server it is not getting saved. Here is what I am trying to do.

function data_custom_ajax(){      
        global $wpdb;
        $tbl = "tripplan";
        $table_name=$wpdb->prefix . $tbl;
        $custom_val = $_POST['text'];
        $totaltime = $_COOKIE['totalduration'];
        $totaldistance = $_COOKIE['totaldistance'];
        $origin_address = $custom_val['originaddress'];
        $end_address = $custom_val['destinationaddress'];
        $waypoints = $custom_val['waypts'];
          $wpdb->insert($table_name,
                          array(
                            'startpoint' => $origin_address,
                            'endpoint' => $end_address,
                            'waypoints' => json_encode($waypoints),
                            'totaldistance' => $totaldistance,
                            'totalduration' => $totaltime
                            ),
                            array('%s','%s','%s','%f','%f')
                          );
          echo "data has been saved";

    }

I have added it for logined user as well not logined user add_action('wp_ajax_data_custom_ajax', 'data_custom_ajax'); add_action('wp_ajax_nopriv_data_custom_ajax', 'data_custom_ajax'); — vivek kumar
– vivek kumar, Commented Sep 6, 2017 at 12:39

Akshay Shah · Accepted Answer · 2017-09-06 12:57:23Z

1

function data_custom_ajax(){      
    global $wpdb;
    $tbl = "tripplan";
    $table_name=$wpdb->prefix . $tbl;
    $custom_val = $_POST['text'];
    $totaltime = $_COOKIE['totalduration'];
    $totaldistance = $_COOKIE['totaldistance'];
    $origin_address = $custom_val['originaddress'];
    $end_address = $custom_val['destinationaddress'];
    $waypoints = $custom_val['waypts'];

    $data = array(
        'startpoint' => $origin_address,
        'endpoint' => $end_address,
        'waypoints' => json_encode($waypoints),
        'totaldistance' => $totaldistance,
        'totalduration' => $totaltime
        )

    $lastInsertedId = $wpdb->insert($table_name,$data);


     if($lastInsertedId != '')
     {
        echo "data has been saved";
     }else{
         $wpdb->print_error();
     }
      die();

}

edited Sep 6, 2017 at 12:57

answered Sep 6, 2017 at 12:40

Akshay Shah

3,5042 gold badges22 silver badges35 bronze badges

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

5 Comments

vivek kumar Over a year ago

record is not getting saved and it doesn't show error. after doing above no response is coming. It doesn't echo.

Akshay Shah Over a year ago

check with updated code. and be cool. every issue has solution.

vivek kumar Over a year ago

still it is not getting saved.

Akshay Shah Over a year ago

write echo $wpdb->print_error(); and let me know what response is coming.

vivek kumar Over a year ago

it doesn't echo anything.

vivek kumar · Accepted Answer · 2017-09-08 05:45:25Z

0

After lot of reading and debugging I got to know the problem. My cookie was not getting saved correctly. Even though it was working on localhost, it was not working on website. After reading this [PHP cannot read javascript cookies and then after I modified my cookie while saving. I was setting cookie like this and it was not working-

document.cookie="cookiename="+value

after setting this way it worked -

document.cookie = 'cookiename='+value+'; path=/'

edited Sep 8, 2017 at 5:45

answered Sep 8, 2017 at 5:38

vivek kumar

551 silver badge10 bronze badges

Collectives™ on Stack Overflow

From Wordpress plugin data is not getting inserted into custom table

2 Answers 2

5 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related