0

I have create a form and i want to store the form data in wp_options table so for that i have created this query

$insertquery = $wpdb->query("INSERT INTO `wp_options`(`option_name`,`option_value`) VALUES ('smsfactory123','asdasdf')");

Now when i am importing the static data then it doesn't create any problem when i pass the variable which is containing array it shows me error.

$apidetail = array(
    'userid' => $uid,
    'userpassword' => $upwd,
    'senderid' => $sid,
    'ono' => $ono,
    'message' => $message,
    );

This is how i am getting value of array in variable

2 Answers 2

-1

You could also use json_encode() function instead of serialize.

$var = json_encode($array);
update_option('option_name', $var); 
3
  • So it will insert data into wp_options table? Feb 19, 2016 at 10:30
  • 2
    You could also consult the small green martians, but for some reason you don't attempt to do that, if serializing is a waste, json is just idiotic. Feb 19, 2016 at 10:37
  • Well Well Well it works for me so now i come to know that how to insert value in wp_options table thanks a lot @maximus L Feb 19, 2016 at 10:39
1

You can save array with update_option function like below code.

update_option('option_name', $arr_store_me);  
6
  • why do you serialize the value? Feb 19, 2016 at 10:01
  • It is not necessary but i suppose they need to save array in one meta so it is best. Feb 19, 2016 at 10:07
  • beyond the slight waste of CPU, It gives the impression it is needed.... Feb 19, 2016 at 10:35
  • Hey i am creating plugin for first time so i want to insert data to wp_options so the way you are telling is it save the value to option_value? Feb 19, 2016 at 10:36
  • Yes, You do not need to serialize values. If the value needs to be serialized, then it will be serialized before it is inserted into the database. Feb 19, 2016 at 10:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.