How to use OPENROWSET command in sql server

Dear all,

Sometimes we need to copy the data from access db to sql server. For transferring data we can use openrowset command.
For using openrowset you need the Ad Hoc Distributed Queries component turned on.
But, by default this component is being turned off for the security of server. But you can turn it on for using the openrowset command.

Debugging codeigniter with firephp

Hi all,
Today we will explore how to debug the codeigniter application with firephp a extension of firebug. For this you have to install the firebug with your firefox browser.

Than, you have to download the firephp library. You can download from here or here. After downloading the library you have to copy it to your application/libraries directory. And then load the library as..

$this->load->library("firephp");

And finally to debug your code just write the code as follow…

Integrate twig with codeigniter and codeigniter hmvc

Hi all,

Today we learn how to integrate twig template engine with codeigniter and also with codeigniter hmvc. At first, you have to download hmvc third_party for module integration in your latest codeiginter. You can download from here.

After download the file extract the file and you find two folder “third_party” and “core”. You have to copy the “MX” folder to your codeigniter “third_party” folder and copy the files from “core” to your codeigniter “core” folder. After copying this just add the following line to your “autoload.php”

Integrate jqgrid with codeigniter

Today we learn how to integrate jqgrid with codeigniter.

At first, write a model in your application/model directory. The code is ….

class JqgridSample extends CI_Model {
function getAllData($start,$limit,$sidx,$sord,$where){
    $this->db->select('id,name,email,passport,phone,fax,address');
    $this->db->limit($limit);
    if($where != NULL)
        $this->db->where($where,NULL,FALSE);
    $this->db->order_by($sidx,$sord);
    $query = $this->db->get('info',$limit,$start);

    return $query->result();
}

}