WordPress – Add pagination in admin listing page

When you need to add pagination in WordPress admin listing, just follow below steps:

$page_num = isset( $_GET['pagenum'] ) ? absint( $_GET['pagenum'] ) : 1;
$limit = 10; // Number of rows in page
$offset = ( $page_num - 1 ) * $limit;
$total = $wpdb->get_var( "SELECT COUNT(`id`) FROM `wp_posts`" );
$num_of_pages = ceil( $total / $limit );
$lists = $wpdb->get_results("SELECT * FROM `wp_posts` ORDER BY id ASC LIMIT $offset,$limit" );

$page_links = paginate_links( array(
'base' => add_query_arg( 'pagenum', '%#%' ),
'format' => '',
'prev_text' => __( '«', 'text-domain' ),
'next_text' => __( '»', 'text-domain' ),
'total' => $num_of_pages,
'current' => $pagenum
) );

if ( $page_links ) {
echo '<div class="tablenav"><div class="tablenav-pages" style="margin: 1em 0;">' . $page_links . '</div></div>';

Leave comments if you find it useful or you have any query about this.

Mysql – Calculate database size

You can calculate MySql database size using following steps.

Login into mysql :

mysql -h hostname -u username -p

Above command will ask you to enter mysql password.
After log in into mysql, run following query.

SELECT table_schema "DatabaseName",
sum( data_length + index_length ) / 1024 / 1024
"DataBase Size in MB" FROM information_schema.TABLES
GROUP BY table_schema;

Just replace your Database name. Thats it.
Please leave your comments if it worked for you.

Install eclipse in ubuntu-linux

Install Eclipse

Type the following command to install extensible Tool Platform, Java IDE, Java Development Tools plug-ins for Eclipse:
$ sudo apt-get install eclipse eclipse-jdt

How to start eclipse?

Click on Applications > Programming > Eclipse

OR type the following command at shell prompt:
$ eclipse &

Done. Enjoy

WordPress – Use php variables in javascript function

In WordPress , sometimes you need to use your PHP variable into included javascript file. You can use below function for this.

wp_register_script( 'myscript', FB_LIKE_PLUGIN_URL . 'fb.js' , array('jquery'), '' );
wp_enqueue_script( 'myscript' );
$local_variables = array('app_id' => $app_id,'name' => "Milap");
wp_localize_script( 'myscript', 'vars', $local_variables );

wp_register_script function include my own created javascript file from plugin directory and also include jquery file.
$local_variables contains array in which you have to pass all variables with key which you want to access into your fb.js file.
wp_localize_script function will pass this array into js file & you can access theses variables in javascript file like vars.app_id and vars.name !!

Let me know , if you have any confusion ..

Google +1 Button using Javascript

The easiest method for including google +1 button on your web page is to include the necessary JavaScript resource and to add a +1 button tag.

Just add below tag into your HTML where you want to put google +1 button.

<!-- Place this tag where you want the +1 button to render. -->
<div class="g-plusone"></div>

Add below java script into your head section.

<script type="text/javascript">
  (function() {
    var po = document.createElement('script'); po.type = 'text/javascript'; po.async = true;
    po.src = 'https://apis.google.com/js/plusone.js';
    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(po, s);

That’s it.
You can find all other parameters at https://developers.google.com/+/plugins/+1button/

Facebook login using javascript

<!DOCTYPE html>
<html xmlns:fb="https://www.facebook.com/2008/fbml">

        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

        <div id="fb-root"></div>
        <script type="text/javascript">
            var button;
            var userInfo;

            window.fbAsyncInit = function () {
                    appId: 'YOUR_APP_ID', //change your app id
                    status: true,
                    cookie: true,
                    xfbml: true,
                    oauth: true

                function updateButton(response) {
                    button = document.getElementById('fb-auth');
                    userInfo = document.getElementById('user-info');

                    if (response.authResponse) {
                        //user is already logged in and connected
                        FB.api('/me', function (info) {
                            login(response, info);

                        button.onclick = function () {
                            FB.logout(function (response) {
                    } else {
                        //user is not connected to your app or logged out
                        button.innerHTML = 'Login';
                        button.onclick = function () {

                            FB.login(function (response) {
                                if (response.authResponse) {
                                    FB.api('/me', function (info) {
                                        login(response, info);
                                } else {
                                    //user cancelled login or did not grant authorization

                            }, {
                                scope: 'email,user_birthday,status_update,publish_stream,user_about_me'

                // run once with current status and whenever the status changes
                FB.Event.subscribe('auth.statusChange', updateButton);
            (function () {
                var e = document.createElement('script');
                e.async = true;
                e.src = document.location.protocol + '//connect.facebook.net/en_US/all.js';

            function login(response, info) {
                if (response.authResponse) {
                    var accessToken = response.authResponse.accessToken;

                    userInfo.innerHTML = '<img src="https://graph.facebook.com/' + info.id + '/picture">' + "<br /> Access Token: " + accessToken + "<br /> Your Birthday:" + info.birthday + "<br /> Your Email:" + info.email + "<br /> Your First Name:" + info.first_name + "<br /> Your Last Name:" + info.last_name + "<br /> Your Gender:" + info.gender + "<br /> Profile Link:" + info.link + "<br /> Username:" + info.username;

                    button.innerHTML = 'Logout';

                    document.getElementById('other').style.display = "block";

            function logout(response) {
                userInfo.innerHTML = "";
                document.getElementById('debug').innerHTML = "";
                document.getElementById('other').style.display = "none";


            //stream publish method
            function streamPublish(name, description, hrefTitle, hrefLink, userPrompt) {

                    method: 'stream.publish',
                    message: '',
                    attachment: {
                        name: name,
                        caption: '',
                        description: (description),
                        href: hrefLink
                    action_links: [{
                        text: hrefTitle,
                        href: hrefLink
                    user_prompt_message: userPrompt

                function (response) {


        <button id="fb-auth">Login</button>
        <br />
        <div id="user-info"></div>
        <br />
        <div id="debug"></div>
        <div id="other"></div>


Some OOP Facts

Some OOP concepts

  • The main difference between OOP and functional programming is that the data and code are bundled together into one entity, which is known as an object.
  • During the execution of an object’s method, a special variable called $this is automatically defined, which denotes a reference to the object itself.
  • if a parent class declares a member as public, the inheriting child class must also declare it as public. Otherwise, the child would not have an is-a relationship with the parent, which means that anything you can do with the parent can also be done with the child.
  • When no access modifier is given for a method, public is used as the default.
  • You can define any number of methods as abstract, but once at least one method of a class is defined as abstract, the entire class needs to be declared as abstract, too.
  • In PHP, a method is either abstract (without code) or it’s fully defined.
  • PHP chose interfaces as an alternative to multiple inheritance.
  • An interface is declared similar to a class but only includes function prototypes (without implementation) and constants.
  • Note: Interfaces are always considered to be public; therefore, you can’t specify access modifiers for the method prototypes in the interface’s declaration.
  • There are times where you might want to make sure that a method cannot be re-implemented in its derived classes. For this purpose, PHP supports the final access modifier for methods that declares the method as the final version, which can’t be overridden.