3

I'm using Ian Stewart's Sample Theme Options for a lightweight Theme Options panel.

INSERTION FAILED

I need to insert Multiple categories into db, where I used the following code:

<select multiple="multiple" name="site_options[categorychoice]"> <?php $args = array( 'orderby' => 'name', 'parent' => 0, 'exclude' => 1 ); $categories = get_categories( $args ); foreach ($categories as $category) { ?> <option value="<?php echo $category->term_id; ?>" style="padding-right: 10px;" <?php selected( $site_options['categorychoice'], $category->term_id ); ?> ><?php echo $category->cat_name . ' (' . $category->category_count .')'; ?></option> <?php } ?> </select>

On the validation portion of the code:

function theme_options_validate( $input ) { $got_categories = array( $input['categorychoice'] ); }

It is inserting data into Options table, but not multiple, it's inserting the last selection only. So what I got is: 'categorychoice' => string '5' (length=1) — only a single value among all, and the that's the last cat_id among the selected.

SELECTED=SELECTED FAILED

I'm also failing to make the value selected, when that matches the data with the db. I tried my code with This WPSE solution, but failed:

foreach ($categories as $category) { ?> <?php $selected = in_array( $category->cat_ID, $selected ) ? ' selected="selected" ' : '' ?> <option value="<?php echo $category->term_id; ?>" style="padding-right: 10px;" <?php echo $selected; ?> ><?php echo $category->cat_name . ' (' . $category->category_count .')'; ?></option> <?php } ?>
Improve this question

2 Answers 2

Reset to default
9

The problem here is that you don’t allow PHP to read more than one value, because all values use the same name site_options[categorychoice], so they overwrite each other, and the last one wins.

You need more brackets. Set the name attribute of your select element to site_options[categorychoice][], and all values will be read by PHP.

Improve this answer
2
  • Thanks. I posted my complete code with another answer. Thanks for your suggestion. :) Commented Feb 12, 2014 at 4:55
  • Perfect answer! Commented Sep 8, 2017 at 21:08
7

Ok. Here's the correct bit of code, I got solution with:

<select multiple="multiple" name="site_options[categorychoice][]"> <?php $option = get_option('site_options'); ?> <?php $args = array( 'orderby' => 'name', 'parent' => 0, 'exclude' => 1 ); $categories = get_categories( $args ); foreach ($categories as $category) { ?> <?php $selected = in_array( $category->cat_ID, $option['categorychoice'] ) ? ' selected="selected" ' : ''; ?> <option value="<?php echo $category->term_id; ?>" <?php echo $selected; ?> > <?php echo $category->cat_name . ' (' . $category->category_count .')'; ?> </option> <?php } //endforeach ?> </select>

First of all: Getting knowledge from @toscho, I made change to the <select name=""> to allow array value to store two dimensional array:

<select multiple="multiple" name="site_options[categorychoice][]">

it solved the data insertion problem.

Secondly: I took the front-end part to back end to fetch what I stored in db with:

<?php $option = get_option('site_options'); ?>

And then checked my values with in_array() as suggested by chrisguitarguy to select the values what have already inserted:

<?php $selected = in_array( $category->cat_ID, $option['categorychoice'] ) ? ' selected="selected" ' : ''; ?>

and echoed the value of $selected into <option>s:

<option <?php echo $selected; ?> >

It solved everything, and I can insert multiple category choice into db, and can deduct from them too. :)

Thanks to @toscho, and @chrisguitarguy. :)

Improve this answer

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.