form dropdown.

[radacla]

Hello, I wanted to know if it was possible to take the data entered in the database and place it in a form dropdown.
thanks

[Ally]

You don't have permission to view this content. Please log in or register and then verify your purchases to gain access.

[radacla]

Yes, thank you, I tried but I would like to show all the fields in a table.
this is what I added to myself.


function enterreport_dynamic_dropdown_values($form)
{
$options = array();
$dbc = mysqli_connect('localhost', 'xxxxxxx', 'xxx', 'bresaola_wor2');
$query = "SELECT * FROM ukz_iphorm_form_entry_data`";
$result = mysqli_query($dbc, $query);

while ($row = mysqli_fetch_assoc($result)) {
$options[] = array('label' => $row['CLIENTE'], 'value' => $row['CLIENTE']);
}

$dropdown = $form->getElement('iphorm_12_22');
if ($dropdown instanceof iPhorm_Element_Select) {
$dropdown->setOptions($options);
}
}
add_action('iphorm_pre_display_12', 'enterreport_dynamic_dropdown_values');


I would not only show the label and value, but all fields included in element_id.

thanks Claudio

• This reply was modified 11 years, 2 months ago by radacla.
• This reply was modified 11 years, 2 months ago by radacla.

[Ally]

You don't have permission to view this content. Please log in or register and then verify your purchases to gain access.

[radacla]

Ok thanks solved, but if I wanted to retrieve data in a single line text how can I do?
eg:
Single line text 1 product
Single line text product 2

[Ally]

You don't have permission to view this content. Please log in or register and then verify your purchases to gain access.

[Ally]

You don't have permission to view this content. Please log in or register and then verify your purchases to gain access.

[radacla]

Ok thanks solved

Regards
Claudio

[Author]

Posts