PHP Code Widget

1. Events (query and show data). Masukkan script berikut di dalam konten widget

   <?php

    $query = mysql_query("select * from wp_em_events order by event_id desc limit 1");

    while ($row = mysql_fetch_array($query)){

        echo "<div class='event_name'>".$row['event_name']."</div><br/>";

        echo "<div class='event_date'>".the_date()."</div>";

        $event_slug = $row['event_slug'];

        $str_count = strlen($row['post_content']);

        $content = $row['post_content'];

        $author = get_the_author();

        echo "<div class='event_author' >Posted by : ".$author."</div><br/>";

        echo "<div class='event_post'>".my_string_limit_words($content,25)."[<a href='events/$event_slug' target='_blank'>read more</a>] </div><br/>";

    }

    ?>

2. More post -> dibawah recent post untuk setiap kategori. Masukkan script berikut di dalam konten widget.

    ${category_id} dilihat dari database wp_term -> cari sesuai kategori yang diinginkan

    <?php

    $args = array(

        'category'        => ${category_id} ,

        'orderby'         => 'post_date',

        'order'           => 'DESC',

        'post_type'       => 'post',

        'post_status'     => 'publish' );

    $posts = get_posts($args);

    foreach( array_slice($posts , 1)as $post ) : ?>

    <li><a href="<?php echo $post->guid; ?>"><?php echo "<div class='date'>" . date('F j, Y', strtotime($post->post_date)) . "</div><div class='title'>" . $post->post_title . "</div><div class='author'>" . get_the_author() . "</div>"; ?></a></li>

    <?php endforeach; ?>