Display Results from query in a select tag in wordpress page?

Question

I have a WordPress page that connects to an external database from WordPress using the following code:

$my_wpdb = new wpdb('me', 'password', 'database', 'localhost');

$myrows = $my_wpdb->get_results( "SELECT Name FROM testing" );

...then i use print_r($myrows); and get the following:

Array
(
  [0] => stdClass Object (
            [Name] => Jesus
         )

  [1] => stdClass Object (
            [Name] => James
         )

  [2] => stdClass Object (
            [Name] => Matt
         )
)

Now I need to output the names inside those objects in a select tag using php.

Any help would be appreciated.

Do you mean that each Name in each row should be an <option> in a <select> html tag? — dewd
– dewd, Commented Mar 29, 2016 at 16:29
@dewd yes so up there it says jesus,james,matt i need it to show up as options the code below dose nto work since im using shortcodes[insertphp][/insertphp] — james potter1
– james potter1, Commented Mar 29, 2016 at 17:20

Pol Mesalles · Accepted Answer · 2016-03-29 20:17:21Z

1

There you go:

<select>
<?php foreach ($myrows as $myrow) : ?>
    <option value=""><?php echo $myrow->Name; ?></option>
<?php endforeach; ?>
</select>

Also, by the looks of your table it might be easier to just use WordPress get_col() function, which works pretty much the same way as get_results but should directly return "Name".

EDIT - Maybe the [insertphp] plugin likes this version better:

<select>
[insertphp]
foreach ($myrows as $myrow) {
    echo '<option>' . $myrow->Name . '</option>';
}
[/insertphp]
</select>

Also, please provide any error info that might help troubleshoot the problem otherwise.

edited Mar 29, 2016 at 20:17

answered Mar 29, 2016 at 16:31

Pol Mesalles

1111 silver badge9 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

james potter1 Over a year ago

i should of mentioned this before im using [insertphp][/insertphp] short code i took out the <?php ?> and the code dose not see to work

Pol Mesalles Over a year ago

i am not familiar with the [insertphp] plugin... if it's an issue with the plugin, maybe try changing the : for { and the endforeach for a {, though I don't think that's the problem. Is there any way you can test this in raw php?

Pol Mesalles Over a year ago

@jamespotter1 see my edit above, maybe that will help with the plugin

Collectives™ on Stack Overflow

Display Results from query in a select tag in wordpress page?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related