__( 'A widget with collapsible feature which displays posts by authors. ', 'text_domain' ), ) // Args ); } public function widget( $args, $instance ) { // outputs the content of the widget global $wpdb; $html = '

Authors

'; $table = $wpdb->prefix . 'users'; $users = $wpdb->get_results('SELECT ID FROM '.$table.' ORDER BY user_login'); if(!empty($users)){ foreach($users as $results){ $id = $results->ID; $user_info = get_userdata($id); $table = $wpdb->prefix . 'posts'; $result = $wpdb->get_results('SELECT * FROM '.$table.' WHERE post_author = '.$id.' AND post_status = "publish" AND post_type = "post" ORDER BY post_date DESC'); $i = 0; if(!empty($result)){ $html .= '

'.$user_info->first_name.' '.$user_info->last_name.' ('.count($result).')'; $html .= '

'.$numpost->post_title.''; if($excerpt == 'true'){ $html .= '
'.$numpost->post_excerpt.'
'; } $html .= '

'; } } } $html .= '

'; echo $html; } public function form( $instance ) { // outputs the options form on admin if ( isset( $instance[ 'title' ] ) ) { $title = $instance[ 'title' ]; } else { $title = __( 'New title', 'text_domain' ); } ?>