Re: [PHP] populate form input option dropdown box from existing data
[email protected] (PJ)
| Newsgroups | php.general |
|---|---|
| Message-ID | <[email protected]> |
Ashley Sheridan wrote:
> On Tue, 2009-06-16 at 20:46 -0400, PJ wrote:
>
>> Ashley Sheridan wrote:
>>
>>> On Tue, 2009-06-16 at 18:19 -0400, PJ wrote:
>>>
>>>
>>>> Ashley Sheridan wrote:
>>>>
>>>>
>>>>> On Tue, 2009-06-16 at 15:48 -0400, PJ wrote:
>>>>>
>>>>>
>>>>>
>>>>>> jenai tomaka wrote:
>>>>>>
>>>>>>
>>>>>>
>>>>>>> You can try like this,
>>>>>>>
>>>>>>> $row = stored data;
>>>>>>>
>>>>>>> and write the options like this
>>>>>>> <option value="id" (id == $row ? "selected" : "") >xxxx</option>
>>>>>>>
>>>>>>>
>>>>>>> Yuri Yarlei.
>>>>>>>
>>>>>>> <http://brasil.microsoft.com.br/IE8/mergulhe/?utm_source=MSN%3BHotmail&utm_medium=Tagline&utm_campaign=IE8>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>> Yuri, I'm still "wet behind the ears" on this so I don't quite
>>>>>> understand what you mean by "stored data" ; and what does the "id"
>>>>>> (id==$row?"selected":"") mean?
>>>>>> I get the idea that this might be translated into something in the code
>>>>>> I have dreamed up - further down.
>>>>>>
>>>>>> echo "<option value=", $row['id'], ">", $row['category'], "</option><br />";
>>>>>> I suppose that I must add an if clause to insert the selected option for
>>>>>> the categories that are relevant...
>>>>>>
>>>>>>
>>>>>> Gentlemen,
>>>>>> I have been diligently studying all this and have just returned my
>>>>>> attention to the list, so I've read the replies/inputs and now comment:
>>>>>>
>>>>>> BTW, I had some problems with the multiple statement - it does not take
>>>>>> any parameters; it must simply be stated multiple without quotes.
>>>>>>
>>>>>> Now, I was happy to learn that it is simpler to populate the insert new
>>>>>> books page dynamically from the db. Much shorter & neater.
>>>>>> It looks to me like the best solution for the edit page is close to what
>>>>>> Yuri suggests.
>>>>>> Since the edit page is very similar to the insert new books page, I
>>>>>> merely need to populate the Select options box slightly differently.
>>>>>> This is the code to populate the insert page:
>>>>>> <select name="categoriesIN[]" multiple size="8">
>>>>>> <?php
>>>>>> $sql = "SELECT * FROM categories";
>>>>>> if ( ( $results = mysql_query($sql, $db) ) !== false ) {
>>>>>> while ( $row = mysql_fetch_assoc($results) ) {
>>>>>> echo "<option value=", $row['id'], ">", $row['category'],
>>>>>> "</option><br />";
>>>>>> }
>>>>>> }
>>>>>> ?>
>>>>>> </select>
>>>>>>
>>>>>> The problem nowis to find a way to add a conditional clause above that
>>>>>> will insert the option="selected" in the output.
>>>>>> The input for this comes from:
>>>>>> // do categories
>>>>>> $sql = "SELECT id, category FROM categories, book_categories
>>>>>> WHERE book_categories.bookID = $idIN &&
>>>>>> book_categories.categories_id = categories.id";;
>>>>>> if ( ( $results = mysql_query($sql, $db) ) !== false ) {
>>>>>> while ( $row = mysql_fetch_assoc($results) ) {
>>>>>> echo$row['id'], "<br />";
>>>>>> }
>>>>>> }
>>>>>>
>>>>>> This may return any number of category ids so the problem is to figure
>>>>>> out a way to pass the ids from the above code to the right ids in the
>>>>>> first code above.
>>>>>> How & what do I search to match the two ids?
>>>>>>
>>>>>> --
>>>>>> Hervé Kempf: "Pour sauver la planète, sortez du capitalisme."
>>>>>> -------------------------------------------------------------
>>>>>> Phil Jourdan --- [email protected]
>>>>>> http://www.ptahhotep.com
>>>>>> http://www.chiccantine.com/andypantry.php
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>> <option value="id" (id == $row ? "selected" : "") >xxxx</option> is
>>>>> pretty bad HTML, as attributes should always have a value. Personally, I
>>>>> do something like this as it tends not to confuse the code too much
>>>>>
>>>>> $selected = ($id == $row)?'selected="selected"':'';
>>>>> print "<option value=\"$id\" $selected >xxxx</option>";
>>>>>
>>>>>
>>>>>
>>>> I was unable to get any of the suggestions to work, except in_array().
>>>> However, the selected item refuses to become highlighted.
>>>> code:
>>>> <select name="categoriesIN[]" multiple size="8">
>>>> <?php
>>>> $sql = "SELECT * FROM categories";
>>>> //$selected = ($id == $row)?'selected="selected"':'';
>>>> if ( ( $results = mysql_query($sql, $db) ) !== false ) {
>>>> while ( $row = mysql_fetch_assoc($results) ) {
>>>> if (in_array($row['id'], $ccc)) {
>>>> echo "<option value=", $row['id'], " selected >",
>>>> $row['category'], "</option><br />";
>>>> }
>>>> else echo "<option value=", $row['id'], ">",
>>>> $row['category'], "</option><br />";
>>>> }
>>>> }
>>>> ?>
>>>> </select>
>>>> I can't find anything that explains why the selected item is not
>>>> highlighted.
>>>>
>>>> --
>>>> Hervé Kempf: "Pour sauver la planète, sortez du capitalisme."
>>>> -------------------------------------------------------------
>>>> Phil Jourdan --- [email protected]
>>>> http://www.ptahhotep.com
>>>> http://www.chiccantine.com/andypantry.php
>>>>
>>>>
>>>>
>>> Have you actually looked at the html this produces to see if any of the
>>> elements are being marked with the selected="selected" attribute?
>>>
>>> Thanks
>>> Ash
>>> www.ashleysheridan.co.uk
>>>
>>>
>> I just cannot find a way to pass the selected fields to the options script.
>> Even if I add the selected to all the fields, they show up in the source
>> code but the fields are still not highlighted.
>> There has to be a way to get this right??? :'(
>>
>> --
>> Hervé Kempf: "Pour sauver la planète, sortez du capitalisme."
>> -------------------------------------------------------------
>> Phil Jourdan --- [email protected]
>> http://www.ptahhotep.com
>> http://www.chiccantine.com/andypantry.php
>>
>>
>>
> have you an example page somewhere?
>
I can send it as attachment? or I can put it on the website; but the
script is a real mess since I am using the insert script as a sort-of
template.
For the moment, I am trying to resolve the problem of extracting a value
from a string returned by a query. I thought that in_array() would do
it, but the tests I have run on it are 100% negative. The only thing I
have not used in the tests is third parameter bool $strict which only
affects case-sensitivity if the $needle is a string. This leads me to
believe that in_array() is either inappropriately defined in the manual
and not effective on associative arrays... but it doesn't say so. I've
tried entering a string variable a number text with and without quotes
but the results are inevitably negative.
--
Hervé Kempf: "Pour sauver la planète, sortez du capitalisme."
-------------------------------------------------------------
Phil Jourdan --- [email protected]
http://www.ptahhotep.com
http://www.chiccantine.com/andypantry.php