How to get SQL group_concat comma separated value sort in ASC/DESC order?

- Here is simple example to explain how to get group concat comma seprated value into order by

Example :

SELECT field1,
  GROUP_CONCAT(first_name ORDER BY first_name ASC SEPARATOR ',')
  FROM tablename

Enjoy!

Wordpress admin - How add custom column in post listing table?

- If you want to add custom column in wordpress admin all post listting, then you just need to add some function on functions.php file.

- Here I try to explain with one example like if you want to add Post ID on admin post listing page.

- Example:

File: wp-content/yourtheme/functions.php

//BELOW FUNCTION FOR DISPLAY HEADER TITLE
add_filter('manage_posts_columns', 'columns_header');

function columns_header('$default') {
 $default['post_id'] = 'Post ID';
 return $default;
}


//BELOW FUNCTION FOR DISPLAY VALUE ON THAT COLUMN

add_action('manage_posts_custom_column', 'columns_content', 10, 2);

function columns_content($column_name, $post_id) {
 if($column_name == 'post_id') {
  echo $post_id;
 }
}

Enjoy!

SQL - How to get between value from current timestamp with table timestamp?

- Here I explain with simple example to get between timestamp value from database value

Example:

$starttime = '1479612462'; (timestam value)
$endtime = '1479612462'; (timestam value)

SELECT * FROM <tablename> WHERE date(from_unixtime(<tablefield>)) between '".."' AND '".."'

Enjoy!

SQL - How to check database timestamp value with current timestamp

SQL - Check database timestamp value with current timestamp

- I find a solution for check sql database timestamp value with current timestamp.

Example:

If you want to get past value from current time:

- SELECT * FROM <tablename> WHERE <fieldname> >= UNIX_TIMESTAMP(currentdate())

Enjoy!

Wordpress temporary session to save any message?

If you need to save any error OR success message on wordpress function.php file OR any other file then please follow below steps:

Here I explain with one success message save on function file and display on home page:

function.php

<?php
function myTempFun() {
   if(!session_id()) {
       session_start();
   }
   $_SESSION['my_session_name'] = 'Write here any message';
}
?>

home page template.php

if ( array_key_exists( 'my_session_name', $_SESSION ) ) {?>
    <p><?php echo $_SESSION['my_session_name']; ?></p>
<?php
    unset( $_SESSION['my_session_name'] );
}

After session display also unset that , So when you refresh page then second time that session not displaying.

Enjoy!