dongwen2162 2016-08-25 13:50
浏览 72


I have already database connected in config folder database.php file. Is there any variable that can simply refers to that MySQLi connection, so that i can use the connection and do manual insertion like-

mysqli_query($alreadyconn, "insert into table ...");

insert() in

I know how to insert in codeigniter but i need the above specific case. and here i can not reconnect that database and use the variable.

Any Help Much Appreciated !

  • 写回答

4条回答 默认 最新

  • dongying7667 2016-08-25 16:36

    Ok. Seems you know about database.php. Will get know some more

    $db['default'] = array(
        'dsn'   => '',
        'hostname' => 'localhost', # host
        'username' => '', # Username
        'password' => '', # password
        'database' => '', # Databse name
        'dbdriver' => 'mysqli', # this can be MySQL or MySQLi

    Note: Recommend to use MySQLi as db driver.

    How to connect database??

    There are Three ways to archive this

    1. Gobally - (path - application/config/autoload.php)

      $autoload['libraries'] = array('database');
    2. Within the class only.

      class ClassName extends CI_Model 
          public function  __construct()

      Can use in all the methods added within this class

    3. Withing Methods only. (Mostly on controllers only)

      class ClassName extends CI_Controller {
          public function  __construct()
          public function index()

      Can use inside the class only

    What is Query Builder (3.0+) or Active Records(3.0-) ??

    This pattern allows information to be retrieved, inserted, and updated in your database with minimal scripting. In some cases only one or two lines of code are necessary to perform a database action. CodeIgniter does not require that each database table be its own class file. It instead provides a more simplified interface.

    How to query with the database & (Query Builder or Active Records) ??

    First Load DB in autoload.php mention above(personally recommended).
    Where ever you are in model or controller just use $this->db to get open connection with your DB.
    With that you can add Query Builder methods like mention in the codeigniter docs. if you are like to use traditional SQL method, you feel free to use query() (Which is my favorite).


    $this->db->query("SELECT * FROM user WHERE name = 'Sparatn' AND ... OR... ");

    But this not enough to produce meaningful data. So you have to follow these steps as well

    $query = $this->db->query("SELECT * FROM user WHERE name = 'Sparatn' "); # 1
    $result  = $query->result_array(); # 2
    return $result; #3

    In #1 assign the database row data to an variable.
    In #2 Convert the #1 to objective array(result_array objective array represent by this).
    In #3 return the result to controller.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
  • doulifang5554 2016-08-25 14:06

    To Insert Data In Database you must do not need MySQL function in code igniter . You should have to use


    function to store data in database . For More Help kindly visit Thank You

  • dongxing7530 2016-08-25 15:24

    Use $this->db to refer to your db connection

    $query = $this->db->query("
            YOUR QUERY HERE
  • dongxie2756 2017-03-08 11:34

    None really answered to the question. The question is clear: how to recycle the codeigniter database connection to be used with a native mysqli_query function without using mysqli_connect again. The upvoted answers above aren't helpful by any means to the issuer's question.

    Use $this->db->conn_id as database connection reference in your $alreadyconn variable.




  • ¥15 这个四人抢答器代码哪儿有问题?仿真程序怎么写?
  • ¥15 burpsuite密码爆破
  • ¥15 关于#ubuntu#的问题,如何解决?(相关搜索:移动硬盘)
  • ¥15 scikit安装之后import不了
  • ¥15 Ros2编译一个使用opencv的c++节点的时候,报了这个错误,请问怎么解决啊
  • ¥15 人脸识别相关算法 YOLO,AI等
  • ¥15 spark问题方便加V17675797079
  • ¥15 Python代码不打印的原因
  • ¥20 微软SEAL库的安装和使用,VS2022环境配置问题
  • ¥15 数学问题也不知道那种类型的问题