How to call database function into custom library in Codeigniter?

Question

I have created a library and am trying to access the database through it in codeigniter.

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class History {

function __construct() {
    //$CI->load->database();
    //$this->load->library('database');
    $CI =& get_instance();
    $CI->load->database();
}

public function create_history($id){
    //$this->load->database();
    $sql = "INSERT INTO inventory_history SELECT null,i.* FROM inventory i where i.inventory_id = :id";
    $query = $this->CI->db->conn_id->prepare($sql);
    $query->bindParam(':id', $id, PDO::PARAM_INT);
    return $query->execute();
}}

But I am getting error near the insert query. Going through Google I went around someone telling to use $this->ci->db to execute query. I'm not able to point out why there is error in database execution. How can I call database function into my custom library in codeigniter?

what error you are getting?

Balaji Kandasamy
– Balaji Kandasamy

2013-12-27 05:57:09 +00:00
Commented Dec 27, 2013 at 5:57 — Balaji Kandasamy
– Balaji Kandasamy, Commented Dec 27, 2013 at 5:57
Undefined property: History::$CI

K Cloud
– K Cloud

2013-12-27 06:03:59 +00:00
Commented Dec 27, 2013 at 6:03 — K Cloud
– K Cloud, Commented Dec 27, 2013 at 6:03

lyhong · Accepted Answer · 2016-11-08 07:20:19Z

16

is it this?

class YourLibName {
   private $CI;

   function __construct() {
       $this->CI =& get_instance();
       $this->CI->load->database();
   }

}

Update: I think you should not load and use database object in library. You better create model and call it from library instead. A library should be independent and can be used with other application.

edited Nov 8, 2016 at 7:20

answered Dec 27, 2013 at 6:49

lyhong

9471 gold badge13 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Harshal · Accepted Answer · 2013-12-27 08:02:29Z

3

In application/config/autoload.php add this :

$autoload['libraries'] = array('database'); // add database in array

Same code for your library:

Class CutomLib
{
    function getData(){
        $CI =& get_instance();
        $query  =   $CI->db->get('data');
        return $query->result();
    }
}

answered Dec 27, 2013 at 8:02

Harshal

3,6339 gold badges40 silver badges67 bronze badges

Comments

Jerza · Accepted Answer · 2019-08-02 03:09:50Z

2

//your class public function __construct() {

  $this->CI =& get_instance();
  $this->CI->load->database('default',TRUE);

}

//how to it inside function public function funcName(){

$query =   $this->CI->db->query("your QUERY");
$result = $query->result();

//what ever you want to do then

}

hope this help

answered Aug 2, 2019 at 3:09

Jerza

313 bronze badges

Comments

Anuj · Accepted Answer · 2016-07-27 08:52:01Z

1

Although the topic is very old, but Just for the shake of new readers

function __construct() {
    //$CI->load->database();
    //$this->load->library('database');
    $CI =& get_instance();
    $CI->load->database();
}

should be

function __construct() {
    //$CI->load->database();
    //$this->load->library('database');
    $this->CI =& get_instance();
    $this->CI->load->database();
}

answered Jul 27, 2016 at 8:52

Anuj

712 silver badges5 bronze badges

Comments

Vipertecpro · Accepted Answer · 2018-03-08 06:53:43Z

Okay here is how i managed to create custom database from user end without touching core files :

First I made form to get all the details from user(More like Installing our application like wordpress do ).

<?php echo form_open('your_controller_path'); ?> 
    <input class="form-control m-input" type="text" name="dbName" value="">
    <span class="help-block"><small><?php echo form_error('dbName'); ?>
    </small></span>
    <input class="form-control m-input" type="text" name="dbUsername" 
    value="">
    <span class="help-block"><small><?php echo form_error('dbUsername'); ?>
    </small></span>
    <input class="form-control m-input" type="text" name="dbPassword"  value="">
    <span class="help-block"><small><?php echo form_error('dbPassword'); ?>
    </small></span>
    <input class="form-control m-input" type="text" name="dbHostname" value="">
    <span class="help-block"><small><?php echo form_error('dbHostname'); ?></small></span>
    <input class="form-control m-input" type="text" name="dbPrefix" value="">
    <span class="help-block"><small><?php echo form_error('dbPrefix'); ?>
    </small></span>
    <button type="submit" class="btn btn-sm btn-success">
        Submit
    </button>
<?php echo form_close(); ?>

I fetch the details from controller and override default dsn before that load these in constructor:-

$this->load->dbforge();

$this->load->dbutil();

if($this->dbutil->database_exists($this->input->post('dbName')))
{
        echo $this->input->post('dbName')." Database Already Exist";
    }
    else
    {
        $this->db->hostname = $this->input->post('dbHostname');
        $this->db->database = $this->input->post('dbName');
        $this->db->username = $this->input->post('dbUsername');
        $this->db->password = $this->input->post('dbPassword');
        $this->db->dbprefix = $this->input->post('dbPrefix');
        $dsn = 'dbdriver://'. $this->db->username.':'.$this->db->password.'@'.$this->db->hostname.'/'.$this->db->database;
        if(!$this->load->database($dsn))
        {
            if ($this->dbforge->create_database($this->input->post('dbName')))
            {
                    echo 'Database created!';
                    $this->db->db_select($this->input->post('dbName'));
            }
        }else
        {
            echo "Sorry Connection Problem : ".$dsn ;
        }
    }

I Hope it Help

Collectives™ on Stack Overflow

How to call database function into custom library in Codeigniter?

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related