snipt

Ctrl+h for KB shortcuts

PHP

Wordpress widget archive listing by years (jqueryui accordion compatible)

<?php

class archive_widget extends WP_Widget {
    public function __construct() {
    	parent::__construct(
	 		'archive_widget',
			'Special Post Archive',
			array( 'description' => __( 'Post Archive by years and months', 'pippajean' ), ) // Args
		);
	}

    public function widget( $args, $instance ) {
		global $wpdb;
		extract( $args );
        $title = apply_filters( 'widget_title', $instance['title'] );
        echo $before_widget;
        echo "<div class='archive-by-year'>";
        echo $before_title . $title . $after_title;
        echo "<div id='archives' class='accordion'>";

        /* http://www.wpbeginner.com/wp-themes/how-to-customize-the-display-of-wordpress-archives-in-your-sidebar/ */

		$limit = 0;
		$year_prev = null;
		$months = $wpdb->get_results("SELECT DISTINCT MONTH( post_date ) AS month ,	YEAR( post_date ) AS year, COUNT( id ) as post_count FROM $wpdb->posts WHERE post_status = 'publish' and post_date <= now( ) and post_type = 'post' GROUP BY month , year ORDER BY post_date DESC");

		foreach($months as $month) :
			$year_current = $month->year;
			if ($year_current != $year_prev){ echo "<h3>$month->year</h3><ul>"; } ?>
			<li><a href="<?php bloginfo('url') ?>/<?php echo $month->year; ?>/<?php echo date("m", mktime(0, 0, 0, $month->month, 1, $month->year)) ?>"><?php echo date("F", mktime(0, 0, 0, $month->month, 1, $month->year)) ?></a></li>
			<?php 
			if ($year_current == $year_prev) echo "</ul>";
			$year_prev = $year_current;
		endforeach;

		echo "</div></div>";
        echo $after_widget;
	}

	public function update( $new_instance, $old_instance ) {
		$instance = $old_instance;
		$instance['title'] = strip_tags( $new_instance['title'] );
		return $instance;
	}

	public function form( $instance ) {
		if ( $instance ) { 
            $title = esc_attr( $instance[ 'title' ] );
        } else {
            $title = __( '', 'pippajean' );
        } ?>
	    <p>
            <label for="<?php echo $this->get_field_id( 'title' ); ?>"  title="Title"><?php _e( 'Title:', 'pippajean' ); ?></label>
            <input class="widefat" id="<?php echo $this->get_field_id( 'title' ); ?>" name="<?php echo $this->get_field_name( 'title' ); ?>" type="text" value="<?php echo $title; ?>" />
		</p>
		<?php 
	}
}

add_action( 'widgets_init', create_function( '', 'register_widget( "archive_widget" );' ) );
https://snipt.net/embed/c0f6c09f2a0d8d0f684f2122bb30df2a/
/raw/c0f6c09f2a0d8d0f684f2122bb30df2a/
c0f6c09f2a0d8d0f684f2122bb30df2a
php
PHP
61
2019-07-24T00:42:47
True
False
False
/api/public/snipt/38956/
wordpress-widget-archive-listing-by-years-jqueryui-accordion-compatible
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1"> 1</a> <a href="#L-2"> 2</a> <a href="#L-3"> 3</a> <a href="#L-4"> 4</a> <a href="#L-5"> 5</a> <a href="#L-6"> 6</a> <a href="#L-7"> 7</a> <a href="#L-8"> 8</a> <a href="#L-9"> 9</a> <a href="#L-10">10</a> <a href="#L-11">11</a> <a href="#L-12">12</a> <a href="#L-13">13</a> <a href="#L-14">14</a> <a href="#L-15">15</a> <a href="#L-16">16</a> <a href="#L-17">17</a> <a href="#L-18">18</a> <a href="#L-19">19</a> <a href="#L-20">20</a> <a href="#L-21">21</a> <a href="#L-22">22</a> <a href="#L-23">23</a> <a href="#L-24">24</a> <a href="#L-25">25</a> <a href="#L-26">26</a> <a href="#L-27">27</a> <a href="#L-28">28</a> <a href="#L-29">29</a> <a href="#L-30">30</a> <a href="#L-31">31</a> <a href="#L-32">32</a> <a href="#L-33">33</a> <a href="#L-34">34</a> <a href="#L-35">35</a> <a href="#L-36">36</a> <a href="#L-37">37</a> <a href="#L-38">38</a> <a href="#L-39">39</a> <a href="#L-40">40</a> <a href="#L-41">41</a> <a href="#L-42">42</a> <a href="#L-43">43</a> <a href="#L-44">44</a> <a href="#L-45">45</a> <a href="#L-46">46</a> <a href="#L-47">47</a> <a href="#L-48">48</a> <a href="#L-49">49</a> <a href="#L-50">50</a> <a href="#L-51">51</a> <a href="#L-52">52</a> <a href="#L-53">53</a> <a href="#L-54">54</a> <a href="#L-55">55</a> <a href="#L-56">56</a> <a href="#L-57">57</a> <a href="#L-58">58</a> <a href="#L-59">59</a> <a href="#L-60">60</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><span class="cp">&lt;?php</span> </span><span id="L-2"><a name="L-2"></a> </span><span id="L-3"><a name="L-3"></a><span class="k">class</span> <span class="nc">archive_widget</span> <span class="k">extends</span> <span class="nx">WP_Widget</span> <span class="p">{</span> </span><span id="L-4"><a name="L-4"></a> <span class="k">public</span> <span class="k">function</span> <span class="nf">__construct</span><span class="p">()</span> <span class="p">{</span> </span><span id="L-5"><a name="L-5"></a> <span class="k">parent</span><span class="o">::</span><span class="na">__construct</span><span class="p">(</span> </span><span id="L-6"><a name="L-6"></a> <span class="s1">&#39;archive_widget&#39;</span><span class="p">,</span> </span><span id="L-7"><a name="L-7"></a> <span class="s1">&#39;Special Post Archive&#39;</span><span class="p">,</span> </span><span id="L-8"><a name="L-8"></a> <span class="k">array</span><span class="p">(</span> <span class="s1">&#39;description&#39;</span> <span class="o">=&gt;</span> <span class="nx">__</span><span class="p">(</span> <span class="s1">&#39;Post Archive by years and months&#39;</span><span class="p">,</span> <span class="s1">&#39;pippajean&#39;</span> <span class="p">),</span> <span class="p">)</span> <span class="c1">// Args</span> </span><span id="L-9"><a name="L-9"></a> <span class="p">);</span> </span><span id="L-10"><a name="L-10"></a> <span class="p">}</span> </span><span id="L-11"><a name="L-11"></a> </span><span id="L-12"><a name="L-12"></a> <span class="k">public</span> <span class="k">function</span> <span class="nf">widget</span><span class="p">(</span> <span class="nv">$args</span><span class="p">,</span> <span class="nv">$instance</span> <span class="p">)</span> <span class="p">{</span> </span><span id="L-13"><a name="L-13"></a> <span class="k">global</span> <span class="nv">$wpdb</span><span class="p">;</span> </span><span id="L-14"><a name="L-14"></a> <span class="nb">extract</span><span class="p">(</span> <span class="nv">$args</span> <span class="p">);</span> </span><span id="L-15"><a name="L-15"></a> <span class="nv">$title</span> <span class="o">=</span> <span class="nx">apply_filters</span><span class="p">(</span> <span class="s1">&#39;widget_title&#39;</span><span class="p">,</span> <span class="nv">$instance</span><span class="p">[</span><span class="s1">&#39;title&#39;</span><span class="p">]</span> <span class="p">);</span> </span><span id="L-16"><a name="L-16"></a> <span class="k">echo</span> <span class="nv">$before_widget</span><span class="p">;</span> </span><span id="L-17"><a name="L-17"></a> <span class="k">echo</span> <span class="s2">&quot;&lt;div class=&#39;archive-by-year&#39;&gt;&quot;</span><span class="p">;</span> </span><span id="L-18"><a name="L-18"></a> <span class="k">echo</span> <span class="nv">$before_title</span> <span class="o">.</span> <span class="nv">$title</span> <span class="o">.</span> <span class="nv">$after_title</span><span class="p">;</span> </span><span id="L-19"><a name="L-19"></a> <span class="k">echo</span> <span class="s2">&quot;&lt;div id=&#39;archives&#39; class=&#39;accordion&#39;&gt;&quot;</span><span class="p">;</span> </span><span id="L-20"><a name="L-20"></a> </span><span id="L-21"><a name="L-21"></a> <span class="cm">/* http://www.wpbeginner.com/wp-themes/how-to-customize-the-display-of-wordpress-archives-in-your-sidebar/ */</span> </span><span id="L-22"><a name="L-22"></a> </span><span id="L-23"><a name="L-23"></a> <span class="nv">$limit</span> <span class="o">=</span> <span class="mi">0</span><span class="p">;</span> </span><span id="L-24"><a name="L-24"></a> <span class="nv">$year_prev</span> <span class="o">=</span> <span class="k">null</span><span class="p">;</span> </span><span id="L-25"><a name="L-25"></a> <span class="nv">$months</span> <span class="o">=</span> <span class="nv">$wpdb</span><span class="o">-&gt;</span><span class="na">get_results</span><span class="p">(</span><span class="s2">&quot;SELECT DISTINCT MONTH( post_date ) AS month , YEAR( post_date ) AS year, COUNT( id ) as post_count FROM </span><span class="si">$wpdb-&gt;posts</span><span class="s2"> WHERE post_status = &#39;publish&#39; and post_date &lt;= now( ) and post_type = &#39;post&#39; GROUP BY month , year ORDER BY post_date DESC&quot;</span><span class="p">);</span> </span><span id="L-26"><a name="L-26"></a> </span><span id="L-27"><a name="L-27"></a> <span class="k">foreach</span><span class="p">(</span><span class="nv">$months</span> <span class="k">as</span> <span class="nv">$month</span><span class="p">)</span> <span class="o">:</span> </span><span id="L-28"><a name="L-28"></a> <span class="nv">$year_current</span> <span class="o">=</span> <span class="nv">$month</span><span class="o">-&gt;</span><span class="na">year</span><span class="p">;</span> </span><span id="L-29"><a name="L-29"></a> <span class="k">if</span> <span class="p">(</span><span class="nv">$year_current</span> <span class="o">!=</span> <span class="nv">$year_prev</span><span class="p">){</span> <span class="k">echo</span> <span class="s2">&quot;&lt;h3&gt;</span><span class="si">$month-&gt;year</span><span class="s2">&lt;/h3&gt;&lt;ul&gt;&quot;</span><span class="p">;</span> <span class="p">}</span> <span class="cp">?&gt;</span><span class="x"></span> </span><span id="L-30"><a name="L-30"></a><span class="x"> &lt;li&gt;&lt;a href=&quot;</span><span class="cp">&lt;?php</span> <span class="nx">bloginfo</span><span class="p">(</span><span class="s1">&#39;url&#39;</span><span class="p">)</span> <span class="cp">?&gt;</span><span class="x">/</span><span class="cp">&lt;?php</span> <span class="k">echo</span> <span class="nv">$month</span><span class="o">-&gt;</span><span class="na">year</span><span class="p">;</span> <span class="cp">?&gt;</span><span class="x">/</span><span class="cp">&lt;?php</span> <span class="k">echo</span> <span class="nb">date</span><span class="p">(</span><span class="s2">&quot;m&quot;</span><span class="p">,</span> <span class="nb">mktime</span><span class="p">(</span><span class="mi">0</span><span class="p">,</span> <span class="mi">0</span><span class="p">,</span> <span class="mi">0</span><span class="p">,</span> <span class="nv">$month</span><span class="o">-&gt;</span><span class="na">month</span><span class="p">,</span> <span class="mi">1</span><span class="p">,</span> <span class="nv">$month</span><span class="o">-&gt;</span><span class="na">year</span><span class="p">))</span> <span class="cp">?&gt;</span><span class="x">&quot;&gt;</span><span class="cp">&lt;?php</span> <span class="k">echo</span> <span class="nb">date</span><span class="p">(</span><span class="s2">&quot;F&quot;</span><span class="p">,</span> <span class="nb">mktime</span><span class="p">(</span><span class="mi">0</span><span class="p">,</span> <span class="mi">0</span><span class="p">,</span> <span class="mi">0</span><span class="p">,</span> <span class="nv">$month</span><span class="o">-&gt;</span><span class="na">month</span><span class="p">,</span> <span class="mi">1</span><span class="p">,</span> <span class="nv">$month</span><span class="o">-&gt;</span><span class="na">year</span><span class="p">))</span> <span class="cp">?&gt;</span><span class="x">&lt;/a&gt;&lt;/li&gt;</span> </span><span id="L-31"><a name="L-31"></a><span class="x"> </span><span class="cp">&lt;?php</span> </span><span id="L-32"><a name="L-32"></a> <span class="k">if</span> <span class="p">(</span><span class="nv">$year_current</span> <span class="o">==</span> <span class="nv">$year_prev</span><span class="p">)</span> <span class="k">echo</span> <span class="s2">&quot;&lt;/ul&gt;&quot;</span><span class="p">;</span> </span><span id="L-33"><a name="L-33"></a> <span class="nv">$year_prev</span> <span class="o">=</span> <span class="nv">$year_current</span><span class="p">;</span> </span><span id="L-34"><a name="L-34"></a> <span class="k">endforeach</span><span class="p">;</span> </span><span id="L-35"><a name="L-35"></a> </span><span id="L-36"><a name="L-36"></a> <span class="k">echo</span> <span class="s2">&quot;&lt;/div&gt;&lt;/div&gt;&quot;</span><span class="p">;</span> </span><span id="L-37"><a name="L-37"></a> <span class="k">echo</span> <span class="nv">$after_widget</span><span class="p">;</span> </span><span id="L-38"><a name="L-38"></a> <span class="p">}</span> </span><span id="L-39"><a name="L-39"></a> </span><span id="L-40"><a name="L-40"></a> <span class="k">public</span> <span class="k">function</span> <span class="nf">update</span><span class="p">(</span> <span class="nv">$new_instance</span><span class="p">,</span> <span class="nv">$old_instance</span> <span class="p">)</span> <span class="p">{</span> </span><span id="L-41"><a name="L-41"></a> <span class="nv">$instance</span> <span class="o">=</span> <span class="nv">$old_instance</span><span class="p">;</span> </span><span id="L-42"><a name="L-42"></a> <span class="nv">$instance</span><span class="p">[</span><span class="s1">&#39;title&#39;</span><span class="p">]</span> <span class="o">=</span> <span class="nb">strip_tags</span><span class="p">(</span> <span class="nv">$new_instance</span><span class="p">[</span><span class="s1">&#39;title&#39;</span><span class="p">]</span> <span class="p">);</span> </span><span id="L-43"><a name="L-43"></a> <span class="k">return</span> <span class="nv">$instance</span><span class="p">;</span> </span><span id="L-44"><a name="L-44"></a> <span class="p">}</span> </span><span id="L-45"><a name="L-45"></a> </span><span id="L-46"><a name="L-46"></a> <span class="k">public</span> <span class="k">function</span> <span class="nf">form</span><span class="p">(</span> <span class="nv">$instance</span> <span class="p">)</span> <span class="p">{</span> </span><span id="L-47"><a name="L-47"></a> <span class="k">if</span> <span class="p">(</span> <span class="nv">$instance</span> <span class="p">)</span> <span class="p">{</span> </span><span id="L-48"><a name="L-48"></a> <span class="nv">$title</span> <span class="o">=</span> <span class="nx">esc_attr</span><span class="p">(</span> <span class="nv">$instance</span><span class="p">[</span> <span class="s1">&#39;title&#39;</span> <span class="p">]</span> <span class="p">);</span> </span><span id="L-49"><a name="L-49"></a> <span class="p">}</span> <span class="k">else</span> <span class="p">{</span> </span><span id="L-50"><a name="L-50"></a> <span class="nv">$title</span> <span class="o">=</span> <span class="nx">__</span><span class="p">(</span> <span class="s1">&#39;&#39;</span><span class="p">,</span> <span class="s1">&#39;pippajean&#39;</span> <span class="p">);</span> </span><span id="L-51"><a name="L-51"></a> <span class="p">}</span> <span class="cp">?&gt;</span><span class="x"></span> </span><span id="L-52"><a name="L-52"></a><span class="x"> &lt;p&gt;</span> </span><span id="L-53"><a name="L-53"></a><span class="x"> &lt;label for=&quot;</span><span class="cp">&lt;?php</span> <span class="k">echo</span> <span class="nv">$this</span><span class="o">-&gt;</span><span class="na">get_field_id</span><span class="p">(</span> <span class="s1">&#39;title&#39;</span> <span class="p">);</span> <span class="cp">?&gt;</span><span class="x">&quot; title=&quot;Title&quot;&gt;</span><span class="cp">&lt;?php</span> <span class="nx">_e</span><span class="p">(</span> <span class="s1">&#39;Title:&#39;</span><span class="p">,</span> <span class="s1">&#39;pippajean&#39;</span> <span class="p">);</span> <span class="cp">?&gt;</span><span class="x">&lt;/label&gt;</span> </span><span id="L-54"><a name="L-54"></a><span class="x"> &lt;input class=&quot;widefat&quot; id=&quot;</span><span class="cp">&lt;?php</span> <span class="k">echo</span> <span class="nv">$this</span><span class="o">-&gt;</span><span class="na">get_field_id</span><span class="p">(</span> <span class="s1">&#39;title&#39;</span> <span class="p">);</span> <span class="cp">?&gt;</span><span class="x">&quot; name=&quot;</span><span class="cp">&lt;?php</span> <span class="k">echo</span> <span class="nv">$this</span><span class="o">-&gt;</span><span class="na">get_field_name</span><span class="p">(</span> <span class="s1">&#39;title&#39;</span> <span class="p">);</span> <span class="cp">?&gt;</span><span class="x">&quot; type=&quot;text&quot; value=&quot;</span><span class="cp">&lt;?php</span> <span class="k">echo</span> <span class="nv">$title</span><span class="p">;</span> <span class="cp">?&gt;</span><span class="x">&quot; /&gt;</span> </span><span id="L-55"><a name="L-55"></a><span class="x"> &lt;/p&gt;</span> </span><span id="L-56"><a name="L-56"></a><span class="x"> </span><span class="cp">&lt;?php</span> </span><span id="L-57"><a name="L-57"></a> <span class="p">}</span> </span><span id="L-58"><a name="L-58"></a><span class="p">}</span> </span><span id="L-59"><a name="L-59"></a> </span><span id="L-60"><a name="L-60"></a><span class="nx">add_action</span><span class="p">(</span> <span class="s1">&#39;widgets_init&#39;</span><span class="p">,</span> <span class="nb">create_function</span><span class="p">(</span> <span class="s1">&#39;&#39;</span><span class="p">,</span> <span class="s1">&#39;register_widget( &quot;archive_widget&quot; );&#39;</span> <span class="p">)</span> <span class="p">);</span> </span></pre></div> </td></tr></table>
"archive by years", archives, wordpress