How to show costum sidebar in wordpress template

<?php

/**

 * Template Name: Home Page Template

 */

get_header(); ?>

Make plugin using shortcode in wordpress to display database information

<?php
/**

 * Plugin Name:user info

 * Plugin URI: http://wordpress_aprai.org

 * Description: this plugin will be display data from database you can use this shortcode any where

 * Author:Arunendra Pratap rai

 */


 function display()

 {

global $wpdb;

$sql ="select * from `first_projectposts` where `post_type` = 'DisplayPost'";

$query = $wpdb->get_results($sql);

echo '';

foreach($query as $data){

$id = $data->ID;   $fname=$data->post_title;       $lname=$data->post_status;    $email=$data->post_type;  $pass=$data->post_name;

echo '';

}

echo '
id
first name
Last name
email id
Password
'.$id.'
'.$fname.'
'.$lname.'
'.$email.'
'.$pass.'
';

}

 add_shortcode( 'short_code', 'display' ); // you can use any unique name for short code
?>

USAGE :- in post or page use :-
[short_code] In template use:-
<?php echo do_shortcode('[short_code]') ?>

Wordpress install and uninstall plugin table during activation and deactivation of plugin

<?php
/*

Plugin Name: sample plugin

Plugin URI: http://URI_Of_Page_Describing_Plugin_and_Updates

Description: This plugin is used to add youtube embeded video code and show video in widgets.

Version: 2.1

Author: Arunendra Pratap Rai

Author URI: http://URI_Of_The_Plugin_Author

License: A "Slug" license name e.g. GPL2

*/

register_activation_hook(__FILE__,'pro_install'); // table installation hook

register_deactivation_hook(__FILE__ , 'pro_uninstall' ); //table uninstallation hook

function pro_install()

{

    global $wpdb;

    $table = wp_."table_name";

    $structure = "CREATE TABLE $table (

        id INT(9) NOT NULL AUTO_INCREMENT,

        fname VARCHAR(255) NOT NULL,

        lname VARCHAR(255) NOT NULL,

      


    UNIQUE KEY id (id)

    );";

    $wpdb->query($structure);

      // Populate table

    $wpdb->query("INSERT INTO $table(id,fname,lname)

        VALUES('1', 'arunendra','Pratap rai')");


}

function pro_uninstall()

{

    global $wpdb;

    $table = wp_."table_name";

    $structure = "drop table if exists $table";

    $wpdb->query($structure); 

}
?>