Date Compare in YII model search function

View : Search form

label($model,'fromdate'); ?>
          widget('zii.widgets.jui.CJuiDatePicker',array(
                                'id'=>'HolidayHolidayrange_fromdate',
                                'name'=>'HolidayHolidayrange[fromdate]',
                                'value'=>$model->fromdate==''?'':date('d-m-Y',strtotime($model->fromdate)),  
                                'options'=>array(
                                    'dateFormat' => 'dd-mm-yy',
                                    'showAnim'=>'slide',
                                    'showButtonPanel'=>true,
                                    'changeMonth'=>true,
                                    'changeYear'=>true,
                                    'yearRange'=>'1900:'.date('Y'),
                                ),
                                'htmlOptions'=>array(
                                    'style'=>'',
                                    'placeHolder'=>'End Date'
                                ),
                            ));
                            ?>
 

label($model,'todate'); ?>
                widget('zii.widgets.jui.CJuiDatePicker',array(
                                'id'=>'HolidayHolidayrange_todate',
                                'name'=>'HolidayHolidayrange[todate]',
                                'value'=>$model->todate==''?'':date('d-m-Y',strtotime($model->todate)),  
                                'options'=>array(
                                    'dateFormat' => 'dd-mm-yy',
                                    'showAnim'=>'slide',
                                    'showButtonPanel'=>true,
                                    'changeMonth'=>true,
                                    'changeYear'=>true,
                                    'yearRange'=>'1900:'.date('Y'),
                                ),
                                'htmlOptions'=>array(
                                    'style'=>'',
                                    'placeHolder'=>'End Date'
                                ),
                            ));
                            ?>
 

Model's Search function

public function search()
 {
           ....................
        if(!empty($this->fromdate))  
        $criteria->addCondition('fromdate > "'.date("Y-m-d",strtotime($this->fromdate)).'" ');
   
        if(!empty($this->todate))
        $criteria->addCondition('todate < "'.date("Y-m-d",strtotime($this->todate)).'" ');
         .......................
       }

Dropdown Filter in CGridView

$month_list=array('1'=>'JAN','2'=>'FEB');
$this->widget('zii.widgets.grid.CGridView', array(
 'id'=>'form-grid',
 'dataProvider'=>$model->search(),
 'filter'=>$model,
 'columns'=>array(
        array(
            'name'=>'festivals.festival_name',
            'filter' => CHtml::activeTextField($model, 'festival_name'),
            ),      
  'day',
        array(
            'name'=>'month',
             'value'=>function($data,$row) use ($month_list){
                            return $month_list[$data->month];
                        },
             'filter'=>CHtml::activeDropDownList($model,'month',$month_list,array('empty'=>'Select Month')),
            ),
...........

Multiple Row Updates in MySQL

CREATE TABLE  `testimonial_setting` (
  `testimonial_setting_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `testimonial_label` varchar(255) NOT NULL,
  `testimonial_key` varchar(45) NOT NULL,
  `testimonial_value` varchar(45) NOT NULL,
  PRIMARY KEY (`testimonial_setting_id`)
);

Table :-  testimonial_setting

testimonial_setting_id, testimonial_label,    testimonial_key, testimonial_value

            1,                       'Background Color',    'bgcolor',            ''

            2,                        'Text Color',               'textcolor',          ''

            3,                      'Heding Text Color',    'headtextcolor',    ''

            4,               'Heding Background Color', 'headbgcolor',    ''

Query :-

UPDATE `testimonial_setting` SET
`testimonial_value` = IF(`testimonial_key`="bgcolor","#ff00ff",`testimonial_value`),
`testimonial_value` = IF(`testimonial_key`="textcolor","#ffffff",`testimonial_value`),
`testimonial_value` = IF(`testimonial_key`="headtextcolor","#ff0000",`testimonial_value`),
`testimonial_value` = IF(`testimonial_key`="headbgcolor","#ff0fff",`testimonial_value`);

After update table :-  testimonial_setting

testimonial_setting_id, testimonial_label,    testimonial_key, testimonial_value

            1,                       'Background Color',    'bgcolor',            '#ff00ff'

            2,                        'Text Color',               'textcolor',          '#ffffff'

            3,                      'Heding Text Color',    'headtextcolor',    '#ff0000'

            4,               'Heding Background Color', 'headbgcolor',    '#ff0fff'

Import a SQL file using the command line in MySQL

A common use of mysqldump is for making a backup of an entire database:

  shell> mysqldump db_name > backup-file.sql

 You can load the dump file back into the server like this:

  UNIX
shell> mysql db_name < backup-file.sql

  Same in Windows comand prompt
mysql -p -u[user] [database] < backup-file.sql

  PowerShell
C:\> cmd.exe /c "mysql -u root -p db_name < backup-file.sql"

  MySQL command line
mysql> use db_name; mysql> source backup-file.sql;

PHP find value by index in multidimensional/associative array

Following function has easily to find and retrieve value by index from multidimensional/associative array

function array_key_exists_value($searchkey, $assocarray)
{
 $output='';
    $result = array_key_exists($searchkey, $assocarray);
    if ($result)
 {
  $output =$assocarray[$searchkey];
 }
else
{ 
    foreach ($assocarray as $val) {
        if (is_array($val)) {
            $output = array_key_exists_value($searchkey, $val);
        }
    }
} 
    return $output;
}

Convert a PHP Object to an Array

Following function has easily to convert an associative array from object data

function object_to_array($result) 
{ 
    $arraydata = array(); 
    foreach ($result as $key=>$value) 
    { 
        if (is_object($value)) 
        { 
            $arraydata [$key]=object_to_array($value); 
        } 
        elseif (is_array($value)) 
        { 
            $arraydata [$key]=object_to_array($value); 
        } 
        else 
        { 
            $arraydata [$key]=$value; 
        } 
    } 
    return $arraydata ; 
}  

Uncaught TypeError: Object [object Object] has no method 'live'

Uncaught TypeError: Object [object Object] has no method 'live'

.live() is a deprecated function (from 1.7+) and removed completely from jQuery 1.9+.

You can instead use .on() or .bind() methods:

http://api.jquery.com/on/

http://api.jquery.com/bind/

Parent child relationship mysql query

Create table like this :-

CREATE TABLE `nodeslist` (

  `NodeID` mediumint(9) NOT NULL AUTO_INCREMENT,

  `NodeTypeID` tinyint(3) unsigned NOT NULL,

  `NodeCode` char(20) NOT NULL,

  `NodeLocationName` char(75) NOT NULL,

  PRIMARY KEY (`NodeID`),

) ;

Here this query to select tree struture data :-

 SELECT
    p.NodeID as parent_id,
    c1.NodeID as child_id_1,
    c1.ParentNode as parent_id_1,
    c2.NodeID as child_id_2,
    c2.ParentNode as parent_id_2,
    c3.NodeID as child_id_3,
    c3.ParentNode as parent_id_3
FROM
    nodeslist p
LEFT JOIN nodeslist c1
    ON c1.ParentNode = p.NodeID
LEFT JOIN nodeslist c2
    ON c2.ParentNode = c1.NodeID
LEFT JOIN nodeslist c3
    ON c3.ParentNode = c2.NodeID
WHERE
    p.ParentNode=0;

Select all child and subchild for particular Parent ID:-

SELECT NodeID,ParentNode,NodeTypeID

FROM nodeslist

WHERE NodeID = 1

OR ParentNode = 1

OR ParentNode IN (SELECT NodeID

    FROM nodeslist

    WHERE ParentNode = 1 OR

    ParentNode IN (SELECT NodeID

    FROM nodeslist

    WHERE ParentNode = 1)

  );

My client isn't accepting my username and password for SMTP emails

We suggest making some adjustments in your mail client's settings so you aren't always prompted to enter your username and password. Please check the following settings in your mail client:

• Make sure that you've entered your full email address (e.g. username@gmail.com)
• Re-enter your password to ensure that it's correct. Keep in mind that passwords are case-sensitive.
• Make sure your mail client isn't set to check for new mail too often. If your mail client checks for new messages more than once every 10 minutes, your client might repeatedly request your username and password.

Now, please follow the steps below to resolve the problem:

1. Open your web browser and sign in to Gmail at http://mail.google.com/mail. If you see a word verification request, type the letters in the distorted picture and finish signing in.
2. Close your browser and try accessing your messages in your email client again.
3. If you're still having problems, visit http://www.google.com/accounts/DisplayUnlockCaptcha and sign in with your Gmail username and password. If necessary, enter the letters in the distorted picture.
4. Click Continue.
5. Restart your mail client and try accessing messages in your email client again.

Remove Wordpress Logo in Admin Bar

Add following code in your themes function.php

add_action( 'admin_bar_menu', 'remove_wp_logo', 999 );

function remove_wp_logo( $wp_admin_bar ) {
	$wp_admin_bar->remove_node( 'wp-logo' );
}

Add Custom Logo in Wordpress

1)Add following function in your themes function.php
2)upload customlogo.png image in your themes image folder

function custom_login_logo() {
	echo '';
}
add_action('login_head', 'custom_login_logo');

Hide / Remove Menu and SubMenu in wordpress Admin Panel

Remove a top level admin menu.
remove_menu_page( $menu_slug )
Here menu_slug has menu's slugname or page


Remove an admin submenu.
remove_submenu_page( $menu_slug, $submenu_slug )

Use following php code for theme's function.php
Ex:- for slug name

add_action( 'admin_menu', 'adjust_the_wp_menu', 999 );
function adjust_the_wp_menu() {
  $page =remove_menu_page( 'plugins' );
  $page = remove_submenu_page( 'themes', 'widgets' ); // widget page under themes
}

Ex:- for filename/page

add_action( 'admin_menu', 'adjust_the_wp_menu', 999 );
function adjust_the_wp_menu() {
  $page =remove_menu_page( 'plugins.php' );  
  $page = remove_submenu_page( 'themes.php', 'widgets' ); // widget page under themes
}

Moodle course list in every where for custom php

You can copy & paste following php code for every where

 
$con = mysql_connect("hostname","username","password");
if (!$con) {
die('Could not connect: ' . mysql_error());
}
mysql_select_db("moodledatabase", $con) or die(mysql_error());
$query_course_list = "SELECT c.id AS courseid, c.fullname FROM mdl_course c where category != 0";
$courses = mysql_query($query_course_list);
$output = '
';
while ($course = mysql_fetch_object($courses)){
$output .= '
';
$output .= '';
$output .= $course->fullname; 
$output .='
';
}
$output .= '
';
echo $output;

Add Pagination for Blog/Post list at custom Page

Download the following plugin : http://wordpress.org/plugins/wp-pagenavi/
Add Following code in your current shortcode function :

function sc_newsletter_list($atts) {
     extract(shortcode_atts(array('limit' => '10', 'number' => '3','fullpage' => 'no', 'category' => '', 'title' => '',), $atts)); 
$paged = (get_query_var('paged')) ? get_query_var('paged') : 1;
    $number = $limit;
    $wp_query = new WP_Query(
    array(
    'post_type' => array('Newsletter'),
    'paged' => $paged,
    'posts_per_page' => $number,
    ));

    $output = '';
    $counter = 0;
    if ( $wp_query->have_posts() ):      
    while( $wp_query->have_posts() ) : $wp_query->the_post();
   ...............................
   .................................
// Pagination : [wp-pagenavi] plugin used
    if(function_exists('wp_pagenavi')) { 
      $output .= '
'.wp_pagenavi( array(
                    'query' =>$wp_query   
                )).'
'; 
            }

Menu Highlight : Main menu & Submenu in Wordpress

Add css style:

.current-page-item a { ... }
.current-subpage-item a { ... }

Customize the wordpress shortcode : recent_blog

Find the php file for shortcode in customtheme :

File Location:

webroot\wp-content\themes\themename\backend\shortcode.php

Find the below code :

 function recent_blog($atts) {
     extract(shortcode_atts(array('limit' => '3', 'number' => '3','fullpage' => 'no' ), $atts));  

    $number = $limit;
 $categoryid = $category; // added category slug here...
    $wp_query = new WP_Query(
    array(
    'post_type' => array('post'),
    'showposts' => $number,
    ));
....................
 add_shortcode('recent_blog', 'recent_blog');

add category , category_name - category slug name to filter the post by category

function recent_blog($atts) {
     extract(shortcode_atts(array('limit' => '3', 'number' => '3','fullpage' => 'no', 'category'=>'' ), $atts));  //added slug category  here......'category'=>'' 

    $number = $limit;
 $categoryslug = $category; // added category slug here...
    $wp_query = new WP_Query(
    array(
    'post_type' => array('post'),
    'showposts' => $number,
 'category_name' => $categoryslug , // added category slug here...
    ));
.............
 add_shortcode('recent_blog', 'recent_blog');

Use following shortcode on page/post in content area

[recent_blog limit="5" fullpage="yes" category="slugname"]

List category posts in Wordpress

List Category Posts allows you to list posts from a category into a post/page using the [catlist] shortcode. When you're editing a page or post, directly insert the shortcode in your text and the posts will be listed there. The basic usage would be something like this:

[catlist id=1]

[catlist name="news"]

The shortcode accepts a category name or id, the order in which you want the posts to display, and the number of posts to display. You can also display the post author, date, excerpt, custom field values, even the content! The [catlist] shortcode can be used as many times as needed with different arguments on each post/page. You can add a lot more parameters according to what and how you want to show your post's list:

[catlist id=1 numberposts=10]

Please read the instructions to learn what parameters are available and how to use them.

Customization: The different elements to display con be styled with CSS. you can define an HTML tag to wrap the element with, and a CSS class for this tag. Check Other Notes for usage.

Great to use WordPress as a CMS, and create pages with several categories posts.

Widget: It includes a widget which works pretty much the same as the plugin. Just add as many widgets as you want, and select all the available options from the Appearence > Widgets page.

Please, read the information on Other Notes and Changelog to be aware of new functionality, and improvements to the plugin.

Support the plugin

If you've found the plugin useful, consider making a donation via PayPal or visit my Amazon Wishlist for books or comic books :).

Development

I've moved the development to GitHub. Fork it, code, make a pull request, suggest improvements, etc. over there. I dream of the day all of the WordPress plugins will be hosted on Github :)

http://wordpress.org/plugins/list-category-posts/

How to use WordPress Shortcode

 WordPress Shortcode Usage

Example 2 is the simplest version of WordPress Shortcode to execute.

Copy and Paste this onto your WordPress Theme’s functions.php file:

function donatebutton() { return '<a href="/donate/" class="donate-button">Donate!</a>'; } add_shortcode('donate', 'donatebutton');

Use this shortcode in your WordPress post/page’s content:

[donate]

The HTML output will be this:

<a href="/donate/" class="donate-button">Donate!</a>

Using a simple “[foo-bar]” shortcode can output an entire content block across multiple pages, making it easy to update.

More of a blockquote style usage of WordPress Shortcode, like in the first example, requires a little extra, but is still extremely easy to execute.

Copy and Paste this onto your WordPress Theme’s functions.php file:

function postrecap($atts, $content = null) { return '<span class="recap">'.$content.'</span>'; } add_shortcode("recap", "postrecap");

Use this in your WordPress post/page’s content:

[recap]A bit of text content[/recap]

The HTML output will be this:

<span class="recap">A bit of text content</span>

This exact code snippet was used on one of our client’s WordPress sites, AgendaWise, to great effect and made the blog a lot easier to maintain for the site owner. This allows the client to use a pre-built-custom blockquote, and cite someone with unique and consistant styling thanks to WordPress shortcode. It automatically detects if there’s a name and/or url being referenced. If there’s a name and a url, the WordPress Shortcode adds a styled link at the end of the quote, and if there’s a name but no url, it just adds a styled name at the bottom of the blockquote.

Use any of these in your WordPress post/page’s content:

[blockquote]Test content.[/blockquote]   [blockquote cite="John Doe"]Test content.[/blockquote]   [blockquote cite="John Doe" url="http://example.com/"]Test Content[/blockquote]

Copy and Paste this onto your WordPress Theme’s functions.php file:

function bc($atts, $content = null) { extract(shortcode_atts(array( "cite" => 'Unknown', "url" => 'url' ), $atts)); if ( $cite == 'Unknown' ) { return '<blockquote class="bc-full"><p>'.$content.'</p></blockquote>'; } elseif ( $url == 'url' ) { return '<blockquote class="bc-full"><p>'.$content.'</p><p class="bc-cite">- '.$cite.'</p></blockquote>'; } else { return '<blockquote class="bc-full"><p>'.$content.'</p><p class="bc-cite">- <a href="'.$url.'">'.$cite.'</a></p></blockquote>'; } } add_shortcode("blockquote", "bc");

The HTML output will any of these, respectively:

<blockquote class="bc-full"><p>Test content.</p></blockquote>   <blockquote class="bc-full"><p>Test content.</p><p class="bc-cite">-John Doe</p></blockquote>   <blockquote class="bc-full"><p>Test content.</p><p class="bc-cite">- <a href="http://example.com">John Doe</a></p></blockquote>

This technique could be very well combined with some of the concepts in example 2. Say, if you were to have a blog with multiple authors, you could use [twitter handle="brianpurkiss"] to output a custom styled Twitter follow button that plugs in the specified twitter handle. Again, the possibilites of WordPress shortcode are endless.

Wrap Up

WordPress’ Shortcode has vast amounts of untapped possibilities. It is extremely beneficial in allowing clients to add more complex content areas with no technical knowledge and great ease. WordPress shortcode can even be beneficial for those with lots of technical knowledge to better manage duplicate content areas.

Make website management easier – use WordPress Shortcode.

What is WordPress Shortcode?

WordPress Shortcode :

        It’s a common phenomenon to see a designer’s website in a design class several levels above that of it’s clients web design work. While there are many factors that can play into this occurrence, one in particular is very common. Designers/developers know more about code, whereas many clients don’t try at all to learn any. That is a huge component in making it difficult for those who build WordPress websites to make top notch sites for clients. There are certain site components that require additional code custom to each usage in order to function. Thus, for many jobs, additional code means more advanced components are off limits for client work, limiting the site’s possibilities.

However, it is possible to use WordPress Shortcode to output complex snippets in a simple manner so that people with no HTML/CSS background can output any pre-determined code snippet.

WordPress Shortcode has a wide variety of applications and can be extremely beneficial for website managers of all ranges of technical backgrounds.

What is WordPress Shortcode?

Example 1

[container]Lorem ipsum dolar sit amet[/container]

With that shortcode, you can output whatever you want on your WordPress website. You can build anything – any amont of HTML, CSS, Javascript, PHP, or anything else you may want. The possibilities are endless.

Example 2

The simplest, yet most overlooked, example of using WordPress Shortcode can be extremely simple or extremely complex.

This:

[donate]

Can output this:

<a href="/donate/" class="donate-button">Donate!</a>

This simple technique utilizing WordPress shortcode can output pre-built complex, or simple, code snippets. This one is great for having pre-built content areas that are used on multiple pages and/or articles. It’s less code to maintain and allows you to update all of the pages by editing a single code snippet. Very similar to WordPress’ file structure, but using WordPress shortcode gives you more versatility and applications.

Example 3

The most common example of WordPress’ Shortcode can be derived from BBCode.

This:

[img title="Example Logo"]http://example.com/images/logo.png[/img]

Can output this:

<img src="http://example.com/images/logo.png" alt="Example Logo" />

BBCode, essentially a different form of WordPress Shortcode common on forums, uses the above snippet to output an image. While this isn’t all that different than the  tag, it is simpler enough that, as a general rule, website managers who aren’t very technically savvy have an easier time grasping shortcode than actual html.

Even though it’s an extremely simple concept, the possibilities are endless and WordPress shortcode can open up a whole new world for your client work.

Create custom short code in Wordpress

Wordpress Page content : add short code

[column width="full" place="none" ][recentwork] [/column]

Add function for shortcode creation : File location : webroot\wp-content\themes\currenttheme\functions.php

add_shortcode('recentwork','showrecentworks');

function showrecentworks(){ 
return $content='



 



Recent Work











Digital World
Aenean aliquet pulvinar dui, nec tempus lectus posuere quis. Proin dignissim

';
 }