Insert Array in Plugin Database

Question

trying to create one plugin, getting some issue to submit the array data in wordpress database.

$formDATA gets the array value now issue is when

    $sql = "INSERT INTO `".$table_name ."` (`paid_arr`) VALUES '".$formDATA."'";

   $result  = $wpdb->insert($table_name,$formDATA);

getting strange warnings and errors not able to insert data in wp DB.

  Warning: array_keys() expects parameter 1 to be array, string given in /home3/mahesh/public_html/project/lal/wp-includes/wp-db.php on line 1316

 Warning: Invalid argument supplied for foreach() in /home3/mahesh/public_html/project/lal/wp-includes/wp-db.php on line 1318

  Warning: implode() [function.implode]: Invalid arguments passed in /home3/mahesh/public_html/project/lal/wp-includes/wp-db.php on line 1327

here is php code;

$formDATA = array(
    'fname'     => $fname,
    'lname'     => $lname,
    'email'     => $paidemail,
    'Phone'     => $paidphone,
    'gender'    => $gender,
    'hobbies'   => $interest,
    'hear'      => $city,
    'message'   => $message_field,
    'time'      => $curtime
 );

formsubmitpaid($formDATA);       

function formsubmitpaid( $formDATA ) {

global $wpdb;
$formDATA = json_encode($formDATA);
$table_name = $wpdb->prefix . "padi_forms";
$sql = "INSERT INTO `".$table_name ."` (`paid_arr`) VALUES '".$formDATA."'";
$result  = $wpdb->insert($table_name,$formDATA);

if( !$result ){
    echo '<script>alert("dfdf")</script>';
} else {
    echo '<script>alert("No")</script>';
 }
print_r($sql);
print_r($result);

} 

Answer 1

You should pass data as an array, not a json encoded string. So changing these line would work. Just remove the following line -

$formDATA = json_encode($formDATA);

if you want to see the reference, prepare sql this way

$sql = "INSERT INTO `".$table_name ."` (`paid_arr`) VALUES '".json_encode($formDATA)."'";

Answer 2

you can php serialize function to convert array to string before inserting to database. during retrieval, call unserialize function to get the array back from string.

to insert:

$result  = $wpdb->insert($table_name,serialize($formDATA));

to retrieve:

   $result = unserialize($wpdb->get_col("SELECT paid_arr from $table_name"));

you can use json_encode and json_decode as well. but json_* functions are not available in older version of php.

Answer 3

You need not have to json_encode the array as long as you have the table structure same as the form data key values. Reference: wpdb

$formDATA = array(
    'fname'     => $fname,
    'lname'     => $lname,
    'email'     => $paidemail,
    'Phone'     => $paidphone,
    'gender'    => $gender,
    'hobbies'   => $interest,
    'hear'      => $city,
    'message'   => $message_field,
    'time'      => $curtime
);

formsubmitpaid($formDATA);      

function formsubmitpaid($formDATA) {
    global $wpdb;
    $table_name = $wpdb->prefix . "padi_forms";    

    $result = $wpdb->insert( 
        $table_name, 
        $formDATA, 
        array( 
            '%s', 
            '%s', 
            '%s', 
            '%s', 
            '%s', 
            '%s', 
            '%s', 
            '%s', 
            '%s' 
        ) 
    );  

    if( $result === false )
        echo 'Error';
    else 
        echo 'success';
}