Fill combobox with query

  • Resolved cbeagrecia

    (@cbeagrecia)


    1 year ago

    Hello,

    I have a search form in Code manager to connect with a DataAccess table. Can I fill a combobox with query in the search form, like this? 

    <form method="get" action="https://www.miweb/reporte-usuarios/">
	<label for="wpda_search_column_Usuario">
		Usuario
	</label>

<select id="wpda_search_column_Usuario" name="wpda_search_column_Usuario">
    <?php
  $query = "SELECT * FROM users";
  $result = mysql_query($query);
  while($row=mysql_fetch_assoc($result)){
    echo '
      <option value='.$row["user_id"].'>'.$row["user_login"].'</option>
    ';
   }?>         
 </select>

<br/><br/>
	<label for="wpda_search_column_Activo">
		Estado de Usuarios
	</label>
  <select id="wpda_search_column_Activo" name="wpda_search_column_Activo">
    <option value="1">Activos</option>
    <option value="0">Bajas</option>
  </select>
	<br/><br/>
	<input type="submit" />
</form>
</center>
Viewing 1 replies (of 1 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi @cbeagrecia,

    Sorry for my late reply!

    You can use class WPDADB to connect. This works with local and remote connections. Here is an example:

    // Connect to your database
$wpdadb = WPDataAccess\Connection\WPDADB::get_db_connection( 'your-database-name-here' );

// Check if the connection failed
if ( null === $wpdadb ) {
    // Handle errors here
}

// We are now connected...
$query = "SELECT * FROM users";
$result = $wpdadb->get_results( $query, 'ARRAY_A' );

// Process result
foreach( $result as $row) {
    // Add option to combobox
    echo "<option value='{$row["user_id"]}'>{$row["user_login"]}</option>";
}

    Please be aware that WPDADB is a sub class of wpdb which allows you to use the prepare method to sanitize user input (if applicable) as documented here:
    https://developer.www.ads-software.com/reference/classes/wpdb/prepare/

    Hope this helps,
    Peter

Viewing 1 replies (of 1 total)
  • The topic ‘Fill combobox with query’ is closed to new replies.