add new field issue

[smashdes]

Hi,

I added a new registration field following the guide created by nick.

Everything is ok, but I would like to make a variation..

Instead of creating a registration field like summary so with a text area I would like to create one with a form select..

I copy the code I wrote inside reserve.template.php

Code:

<?php
}

/**
* Tabella per selezionare se il socio ha pagato o no.
* @param string $payment environment to edit
* @param string $type type of reservation
*/


function print_payment($payment) {

if (Auth::isAdmin()) { ?>
<table width="200" border="0" cellspacing="0" cellpadding="0" class="recur_box" id="repeat_table" style="margin-top:5px;">
    <tr>
      <td style="padding: 5px;">

    <?php
 echo translate('Pay') . ' ';
 echo '<select name="payment" id="payment" class="textbox">';
 echo '<option value=" '. $payment . ' ">' . translate('No') . '</option>';
 echo '<option value=" '. $payment . ' ">' . translate('Yes') . '</option>';
 echo '</select>';
 ?>   
   </td>
    </tr>
</table>



<?php
}
}

As you can see I need only 2 options..

But if I save it doesn't save anything into the database.

I explain how it should work.

Like default value I want the option NO
so everytime I save it should write into Database the text NO
only the administrator can set the option YES.

At this moment if I go in phpmyadmin and I go the row of the registration the column called payment is empty


Other question

I would like to add that field to the search option for the administrator.. how can i do that?

Thank you

[Nick]

To get it to save, you'll need to read it off of the page and insert pass it to the query that saves the information.

Making it searchable is a bit more work.  You'll need to add it to templates/usage.template.php, lib/db/UsageDB.class.php and usage.php.  In general it will be similar to what you did for adding it to reserve.

[smashdes]

To get it to save, you'll need to read it off of the page and insert pass it to the query that saves the information.

how can I do that? what do you mean for read it off of the page etc?

thanks

[Nick]

Pretty much the same steps required for adding the new field.  You'll need to change the files mentioned above to allow that field to be searchable.

[smashdes]

Nick,

my problem now is that the form doesn't write anything inside the DB...

So even if I choose yes or not and click to save inside the database the field Payment is empty..

because in the add new field tutorial is explained how to add a text box but not how to add a select form and I'm not that good with PHP..

thanks for your help

[Nick]

Once we get past the UI, the select box is identical to adding a text box.  The only way it would be different is if you were doing a multi-select box.

[zaky]

Hello Nick,
I am having a similar problem. For me the value of the new fields are writing in the database ( checked with phpadmin) but when I want to modify the reservation, the value of these two new fields is empty.  The first field is a select box and the other is a number ( quantity).
Anything I am doing wrong? Where / which file could I check ?

In advance thank you.

[narongkorn]

thanks for your help

[Nick]

You'll need to populate the value of the field from the value in the database.  You should be able to pretty much copy how other fields are working.

[zaky]

Thanks Nick for your response, unfortunately I don't know how to populate the field from the values in the database. Which files should I be looking for?

In advance thank you for all.

Zaky

[alisondesser]

Like default value I want the option NO
so everytime I save it should write into Database the text NO
only the administrator can set the option YES.

[Nick]

For that you should only show the drop down if the user is an admin, otherwise hide it and default it to NO