Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function createbox(){
- global $wpdb;
- $tablenom = $wpdb->prefix . 'cf7dbplugin_submits';
- $requete = "SELECT submit_time, field_value, STR_TO_DATE(field_value, '%d/%m/%Y') AS dtFormat FROM wp_cf7dbplugin_submits WHERE form_name = 'infoCo Configuration' AND field_name = 'date-reunion' ORDER BY dtFormat DESC";
- $field = $wpdb->get_results( $requete );
- $output99 = '<select name="lstdate" id="fleet" onchange="document.getElementById(\'fleet\').value=this.value;"><option></option>';
- foreach ( $field as $ligne ) {
- $output99 .= "<option value=\"$ligne->submit_time\"> $ligne->field_value </option>";
- }
- $output99 .= "</select>";
- return $output99;
- }
- $content = do_shortcode( $post->post_content );
- $fleet_selector = createbox();
- $new_content = str_replace('[autoselectfleet]', $fleet_selector, $content);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement