Fix the column in table

HTML Code:

 
   
     
        GOD
        Average
        Ram
       

        Hanuman
       
        Arjun
       
        Bharat
       
        Duryodhan
       
        Bhishm
       
        Krishna
       
     
   
   
     
        1GOD
        12
       
        12
        12
        12
        12
        12
        12
        12
     
     
        2GOD
        11
       
        11
        11
        11
        11
        11
        11
        11
     
     
        3GOD
        10
       
        10
        11
        11
        11
        11
        11
        11
     
     
        4GOD
        10
       
        10
        11
        10
        11
        11
        10
        11
     
     
        5GOD
        10
       
        10
        10
        10
        10
        10
        10
        10
     
     
        6GOD
        10
       
        10
        10
        10
        10
        10
        10
        10
     
     
        7GOD
        9
       
        9
        10
        10
        10
        10
        9
        10
     
     
        8GOD
        9
       
        9
        9
        9
        10
        10
        9
        9
     
     
        9GOD
        9
       
        9
        9
        9
        10
        10
        9
        9
     
     
        10GOD
        9
       
        9
        9
        9
        9
        9
        9
        9
     
   

 





CSS:

div {
  overflow-x:scroll; 
  margin-left:2em;
    }
.headcol {
  position:absolute;
width:2em;
left:0;
    }

Nodejs Perfect example for post & get

"use strict";

var http = require('http'),

express = require('express'),

mysql = require('mysql'),

parser = require('body-parser'),

dateTime = require('node-datetime');

var dts = dateTime.create();

var formatteddate = dts.format('Y/m/d');

// Database Connection

var connection = mysql.createConnection({

host : 'XXXXXXXXXX',

user : 'XXXXXXXXXX',

password : 'XXXXXXXXXX',

database : 'XXXX',

multipleStatements: true

});

try {

connection.connect();

} catch(e) {

console.log('Database Connetion failed:' + e);

}

var app = express();

app.use(parser.json());

app.use(parser.urlencoded({ extended: true }));

app.set('port', process.env.PORT || 8080);

app.get('/',function(req,res){

res.send("ref. Administrator");

});

app.get('/data',function(req,res){

    connection.query("SELECT count(user_id) as cnt from u_master where status=1", function (error, rows) {

if(error) {

        res.json({"Error" : true, "Message" : "Error executing MySQL query"});

} else {

        res.json({"Error" : false, "Message" : "Success ", "Login" : rows});

}

    });

});

app.get('/branchlist',function(req,res){

connection.query("SELECT * from b_master where status=1 order by branch_name asc", function (error, rows) {

        if(error) {

res.json({"status" : "error","bCount":rows.length,"blist":"There is no fresh data"});

} else {

res.json({"status" : "ok", "bCount":rows.length,"blist":rows});

}

    });

});

app.post('/login', function (req,res) {

    var response = [];

    if (typeof req.body.username !== 'undefined') {

        var name = req.body.username;

res.json(name);

    } else {

        response.push({'result' : 'error', 'msg' : 'Please fill required details'});

        res.setHeader('Content-Type', 'application/json');

    res.status(200).send(JSON.stringify(response));

    }

});

http.createServer(app).listen(app.get('port'), function(){

    console.log('Server listening on port ' + app.get('port'));

});

SOAP WDSL using php

Easiest way to create SOAP API using PHP.

Download  :   http://www.nusphere.com/php_script/nusoap.htm

SERVER.PHP

require_once('lib/nusoap.php');

include('function.php');

$server = new nusoap_server;

$server->configureWSDL('server', 'urn:server');

$server->wsdl->schemaTargetNamespace = 'urn:server';

//SOAP complex type return type (an array/struct)

$server->wsdl->addComplexType(

    'Person',

'complexType',

'struct',

'all',

'',

array(

'id_user' => array('name' => 'id_user', 'type' => 'xsd:int'),

'fullname' => array('name' => 'fullname', 'type' => 'xsd:string'),

'email' => array('name' => 'email', 'type' => 'xsd:string'),

'level' => array('name' => 'level', 'type' => 'xsd:int')

)

);

//first simple function

$server->register('hello',

            array('username' => 'xsd:string'), //parameter

            array('return' => 'xsd:string'), //output

            'urn:server', //namespace

            'urn:server#helloServer', //soapaction

            'rpc', // style

            'encoded', // use

            'Just say hello'); //description

//this is the second webservice entry point/function

$server->register('login',

            array('username' => 'xsd:string', 'password'=>'xsd:string'), //parameters

            array('return' => 'tns:Person'), //output

            'urn:server', //namespace

            'urn:server#loginServer', //soapaction

            'rpc', // style

            'encoded', // use

            'Check user login'); //description

            //SOAP complex type return type (an array/struct)

$server->wsdl->addComplexType(

    'asstele',

'complexType',

'struct',

'all',

'',

array(

        'cnt' => array('name' => 'cnt', 'type' => 'xsd:integer'),

        'cStat' => array('name' => 'cStat', 'type' => 'xsd:integer')

)

);

//this is the second webservice entry point/function

$server->register('assigntele',

            array('branch' => 'xsd:integer'), //parameters

            array('return' => 'tns:asstele'), //output

            'urn:server', //namespace

            'urn:server#assignteleServer', //soapaction

            'rpc', // style

            'encoded', // use

            'data assign tele'); //description

//$HTTP_RAW_POST_DATA = isset($HTTP_RAW_POST_DATA) ? $HTTP_RAW_POST_DATA : '';

//$server->service($HTTP_RAW_POST_DATA);

$server->service(file_get_contents("php://input"));

?>

FUNCTION.PHP

//first function implementation

function hello($username) {

return 'Howdy, '.$username.'!';

}

//second function implementation

function login($username, $password) {

//should do some database query here

// .... ..... ..... .....

//just some dummy result

return array(

'id_user'=>1,

'fullname'=>'John Reese',

'email'=>'john@reese.com' ,

'level'=>99

);

}

function assigntele($branch){

$conn = new mysqli('host','user','password','database');

if ($conn->connect_error) {

die("Connection error: " . $conn->connect_error);

}

$var=array();

$result = $conn->query("select count(lm.mobile) as cnt from lead_master lm where lm.branch=".$branch);

while($obj = mysqli_fetch_object($result)) {

$var[] = $obj;

}

return $var;

}

?>

SKYPE CALL CHAT VOICEMAIL

SKYPE CALL

call using Skype

SKYPE CHAT

Chat with Skype

SKYPE VOICEMAIL

Leave a voicemail

Google Map on website

https://embedgooglemaps.com/en/

this is commandeered site to generate map for website.

NodeJs on Amazon EC2

Tutorial: Setting Up Node.js on an Amazon EC2 Instance

The gist of the tutorial is:

Make sure you are ssh'd onto the instance.
Grab nvm: curl -o- https://raw.githubusercontent.com/creationix/nvm/v0.32.0/install.sh | bash
Active . ~/.nvm/nvm.sh
Install node using nvm nvm install 4.4.5 (NOTE: You can choose a different version. Check out the remote versions first by running $ nvm ls-remote)
Finally, test that you have installed node Node correctly by running $ node -e "console.log('Running Node.js' + process.version)"
Hopefully this helps the next person.

Custom search like google in Angular JS