Using the select tag

Question

Hello, I am writing a site, sections are used in the news, in the editor it is necessary to make a choice accordingly to which category the site belongs to.

The question is what to do

<select> <option>новости</option> <option>не новости</option> <option>про новости</option> </select>

Data is jerking from the database, including which category the news belongs to. How on html + pkhp to make an item that is received from the database "by default" so that you do not need to set the news category again when editing?

UPD:

 Mysql: table news id(autoink) date(datetime) autor(enum=admin,moderator) postPreview(varchar100) post(varchar255) category(enum=newscat1, newscat2, newscat3, no default) <? include(config); mysql_connect(host, log, pass); mysql_select_db(base); q=mysql_query("SELECT * FROM news WHERE id=$_GET[id]") while(FALSE!==(res=mysql_fetch_assoc(q)) { ?> <html> <form method=post> <select> <option>News Cat1</option> <option>News Cat2</option> <option>News Cat3</option> </select> <textarea><? echo $res[postpreview]; ?></textarea> <textarea><? echo $res[post]; ?></textarea> <input type=submit /> </form>

If in general, that’s how it is now.

thanks, I know Russian, sometimes it happens on autopilot) - DemoriaN
the question is closed, thank you all, who responded) - DemoriaN

Accepted Answer · 2011-09-24T11:08:55

 $newscat = 15; // получить из новости $news_arr = array( /* список селекта , категории в виде: id: идентификатор категории, name: имя категории (я не знаю, как у вас называются эти поля, может, будет $obj['categoryID'], если категория - массив, а не объект) */ ); echo '<select>'; foreach ($news_arr as $n => $obj) echo '<option value="'.$obj->id.'"'.($newscat==$obj->id?' selected="selected"':'').'>'.$obj->name.'</option>'; echo '</select>';

Record example:

 $cat = new stdClass(); $cat->id = 15; $cat->name = 'Категория например';

The same result will be returned by a query like

 $cat = mysql_fetch_object(mysql_query('SELECT id, name FROM ...'));

it gets a list of news options from the array, and where does it match the one received from the database, does it "selected"?
even not so, the object is the name of the array, that is $ n and id
Apparently I didn’t understand at all, where can Russian variables come from? What variables?
> The data is jerking from the database, including which category the news belongs
so, okay, I did not understand anything, but it's cool) for my labors + and the correct answer, it remains for me to smoke the code)) everything seems to be clear, but nothing is clear))

Answer 2 · 2011-09-24T11:18:41

There is an option to use the framework. If php framework, for example Zend Framework, then there it should be implemented by native methods. There is an option to do this through javascript in particular the jquery framework:

 $(document).ready(function(){ $('#yourSelectId').val('<?=$selectValue ?>'); });

Answer 3 · 2011-09-24T11:30:20

 $res = mysql_query('SELECT variant, default FROM variants'); $variants = array(); //массив в который положим категории while($row = mysql_fetch_assoc($res)) { $variants[] = $row; //собственно ложим... }

Data is ready, we draw:

 include_once 'myTemplate.html'; /* * подключаем html шаблончик(можно прямо в скрипте) * но это ИМХО убого :) */

The template itself:

 <select> <?foreach($variants as $variant):?> <!-- Допустим что дефолтное значение у нас всегда = 1 а остальные 0--> <?if($variant['default'] == 1):?> <option value="<?=$variant['variant']?>" selected><?=$variant['variant']?></option> <?endif?> <?if($variant['default'] == 0):?> <option value="<?=$variant['variant']?>"><?=$variant['variant']?></option> <?endif?> <?endforeach?> </select>

if you understand correctly then here is how ...

Yeah, are you by any chance one of the slaves of templating? :) or your echo '<option value="'.$obj->id.'"'.($newscat==$obj->id?' > selected="selected"':'').'>'.$obj->name.'</option>'; >echo '</select>';
echo '<option value="'.$obj->id.'"'.($newscat==$obj->id?' > selected="selected"':'').'>'.$obj->name.'</option>'; >echo '</select>';
xDDD Dear Kabbi php itself is a templating engine this time two - I did not ask you how to draw a conclusion ... three - I am not going to use the templating engine in a template engine
If you read the link, there it is written that I do not digest template engines other than native ones.
Just periodically, Joomla modules are so decorated, and the backlight works on {} and look for the appropriate endif wildly.
it is normal to separate the tabulation, not? And why you touched on religious issues I don’t understand, for example, I don’t like it either, as you have written, but I don’t scream in comments that you wrote in Indian :) Why this act agroschooling?
Omfg, I say that you have extra operators (this is just about the Indian IF) and it is inconvenient to edit such code with more branching.
In order to add an option to the parameter or change the value, it must be entered twice.
With 4-5 consecutive conditions, it is difficult to search for the end of a branch even with illumination.
If I began to describe how I organize the output into a template - my answer would be overwhelming, I described an algorithm for solving this problem, how to use it is everyone's business ... I just know that absolutely most beginner programmers are soft saying not friendly with the ternary operator, which is why my answer looks like this ... I hope that the question has been settled ...

DemoriaN DemoriaN 566 4 silver marks 18 bronze marks · Answer 4 · 2011-09-24T18:45:24

Everything is simple to the shitless ...

 <select name="sex"> <option value="male" <?php if ($sex=='male') echo 'selected'; ?> >Мужской</option> <option value="female" <?php if ($sex=='female') echo 'selected'; ?> >Женский</option> </select>

Thanks to all!

Using the select tag

4 answers 4

More articles: