Home Database Mysql Tutorial CodeIgniter底层数据库类继承关系

CodeIgniter底层数据库类继承关系

Jun 07, 2016 pm 02:59 PM
codeigniter mysql relation Ground floor database inherit

1、CI_DB_mysql_driver 继承CI_DB, CI_DB这个类是不存在的,每次调用文件中~/CodeIgniter_2.1.3/system/database/DB.php函数DB来初始化database的时候, 根据用户是否开启active_record,生成继承CI_DB_active_record或CI_DB_driver类的CI_DB类, 2、CI_DB_a

1、CI_DB_mysql_driver 继承 CI_DB,  CI_DB这个类是不存在的,每次调用文件中~/CodeIgniter_2.1.3/system/database/DB.php函数&DB来初始化database的时候,

根据用户是否开启active_record,生成继承CI_DB_active_record或CI_DB_driver类的CI_DB类,

2、CI_DB_active_record类继承CI_DB_driver类

    <span>require_once</span>(BASEPATH.'database/DB_driver.php'<span>);

    </span><span>if</span> ( ! <span>isset</span>(<span>$active_record</span>) OR <span>$active_record</span> == <span>TRUE</span><span>)
    {
        </span><span>require_once</span>(BASEPATH.'database/DB_active_rec.php'<span>);

        </span><span>if</span> ( ! <span>class_exists</span>('CI_DB'<span>))
        {
            </span><span>eval</span>('class CI_DB extends CI_DB_active_record { }'<span>);
        }
    }
    </span><span>else</span><span>
    {
        </span><span>if</span> ( ! <span>class_exists</span>('CI_DB'<span>))
        {
            </span><span>eval</span>('class CI_DB extends CI_DB_driver { }'<span>);
        }
    }</span>
Copy after login

3、最终会调用顶级父类CI_DB_driver的构造方法,将数据库配置的各字段赋值到CI_DB_driver类的各个字段上,

<span>$active_group</span> = 'default'<span>;
</span><span>$active_record</span> = <span>TRUE</span><span>;

</span><span>$db</span>['default']['hostname'] = 'localhost'<span>;
</span><span>$db</span>['default']['username'] = ''<span>; 
</span><span>$db</span>['default']['password'] = ''<span>; 
</span><span>$db</span>['default']['database'] = ''<span>; 
</span><span>$db</span>['default']['dbdriver'] = 'mysql'<span>;
</span><span>$db</span>['default']['dbprefix'] = ''<span>; 
</span><span>$db</span>['default']['pconnect'] = <span>TRUE</span><span>;
</span><span>$db</span>['default']['db_debug'] = <span>TRUE</span><span>;
</span><span>$db</span>['default']['cache_on'] = <span>FALSE</span><span>;
</span><span>$db</span>['default']['cachedir'] = ''<span>; 
</span><span>$db</span>['default']['char_set'] = 'utf8'<span>;
</span><span>$db</span>['default']['dbcollat'] = 'utf8_general_ci'<span>;
</span><span>$db</span>['default']['swap_pre'] = ''<span>; 
</span><span>$db</span>['default']['autoinit'] = <span>TRUE</span><span>;


        </span><span>var</span> <span>$username</span><span>;
    </span><span>var</span> <span>$password</span><span>;
    </span><span>var</span> <span>$hostname</span><span>;
    </span><span>var</span> <span>$database</span><span>;
    </span><span>var</span> <span>$dbdriver</span>        = 'mysql'<span>;
    </span><span>var</span> <span>$dbprefix</span>        = ''<span>;
    </span><span>var</span> <span>$char_set</span>        = 'utf8'<span>;
    </span><span>var</span> <span>$dbcollat</span>        = 'utf8_general_ci'<span>;
    </span><span>var</span> <span>$autoinit</span>        = <span>TRUE</span><span>;
    </span><span>var</span> <span>$port</span>            = ''<span>;
    </span><span>var</span> <span>$pconnect</span>        = <span>FALSE</span><span>;
    </span><span>var</span> <span>$db_debug</span>        = <span>FALSE</span>;    
Copy after login

 

如果autoinit自动初始化为TRUE,则将DB初始化,这个DB对象是CI_DB_mysql_driver类

<span>    require_once</span>(BASEPATH.'database/DB_driver.php'<span>);

    </span><span>if</span> ( ! <span>isset</span>(<span>$active_record</span>) OR <span>$active_record</span> == <span>TRUE</span><span>)
    {
        </span><span>require_once</span>(BASEPATH.'database/DB_active_rec.php'<span>);

        </span><span>if</span> ( ! <span>class_exists</span>('CI_DB'<span>))
        {
            </span><span>eval</span>('class CI_DB extends CI_DB_active_record { }'<span>);
        }
    }
    </span><span>else</span><span>
    {
        </span><span>if</span> ( ! <span>class_exists</span>('CI_DB'<span>))
        {
            </span><span>eval</span>('class CI_DB extends CI_DB_driver { }'<span>);
        }
    }

    </span><span>require_once</span>(BASEPATH.'database/drivers/'.<span>$params</span>['dbdriver'].'/'.<span>$params</span>['dbdriver'].'_driver.php'<span>);

    </span><span>//</span><span> Instantiate the DB adapter</span>
    <span>$driver</span> = 'CI_DB_'.<span>$params</span>['dbdriver'].'_driver'<span>;
    </span><span>$DB</span> = <span>new</span> <span>$driver</span>(<span>$params</span><span>);
    </span><span>if</span> (<span>$DB</span>->autoinit == <span>TRUE</span><span>)
    {
        </span><span>$DB</span>-><span>initialize();
    }

    </span><span>return</span> <span>$DB</span>;
Copy after login

 

 

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Best Graphic Settings
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. How to Fix Audio if You Can't Hear Anyone
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Unable to log in to mysql as root Unable to log in to mysql as root Apr 08, 2025 pm 04:54 PM

The main reasons why you cannot log in to MySQL as root are permission problems, configuration file errors, password inconsistent, socket file problems, or firewall interception. The solution includes: check whether the bind-address parameter in the configuration file is configured correctly. Check whether the root user permissions have been modified or deleted and reset. Verify that the password is accurate, including case and special characters. Check socket file permission settings and paths. Check that the firewall blocks connections to the MySQL server.

mysql whether to change table lock table mysql whether to change table lock table Apr 08, 2025 pm 05:06 PM

When MySQL modifys table structure, metadata locks are usually used, which may cause the table to be locked. To reduce the impact of locks, the following measures can be taken: 1. Keep tables available with online DDL; 2. Perform complex modifications in batches; 3. Operate during small or off-peak periods; 4. Use PT-OSC tools to achieve finer control.

The relationship between mysql user and database The relationship between mysql user and database Apr 08, 2025 pm 07:15 PM

In MySQL database, the relationship between the user and the database is defined by permissions and tables. The user has a username and password to access the database. Permissions are granted through the GRANT command, while the table is created by the CREATE TABLE command. To establish a relationship between a user and a database, you need to create a database, create a user, and then grant permissions.

Can mysql run on android Can mysql run on android Apr 08, 2025 pm 05:03 PM

MySQL cannot run directly on Android, but it can be implemented indirectly by using the following methods: using the lightweight database SQLite, which is built on the Android system, does not require a separate server, and has a small resource usage, which is very suitable for mobile device applications. Remotely connect to the MySQL server and connect to the MySQL database on the remote server through the network for data reading and writing, but there are disadvantages such as strong network dependencies, security issues and server costs.

Query optimization in MySQL is essential for improving database performance, especially when dealing with large data sets Query optimization in MySQL is essential for improving database performance, especially when dealing with large data sets Apr 08, 2025 pm 07:12 PM

1. Use the correct index to speed up data retrieval by reducing the amount of data scanned select*frommployeeswherelast_name='smith'; if you look up a column of a table multiple times, create an index for that column. If you or your app needs data from multiple columns according to the criteria, create a composite index 2. Avoid select * only those required columns, if you select all unwanted columns, this will only consume more server memory and cause the server to slow down at high load or frequency times For example, your table contains columns such as created_at and updated_at and timestamps, and then avoid selecting * because they do not require inefficient query se

Explain the difference between self::, parent::, and static:: in PHP OOP. Explain the difference between self::, parent::, and static:: in PHP OOP. Apr 09, 2025 am 12:04 AM

In PHPOOP, self:: refers to the current class, parent:: refers to the parent class, static:: is used for late static binding. 1.self:: is used for static method and constant calls, but does not support late static binding. 2.parent:: is used for subclasses to call parent class methods, and private methods cannot be accessed. 3.static:: supports late static binding, suitable for inheritance and polymorphism, but may affect the readability of the code.

How to optimize MySQL performance for high-load applications? How to optimize MySQL performance for high-load applications? Apr 08, 2025 pm 06:03 PM

MySQL database performance optimization guide In resource-intensive applications, MySQL database plays a crucial role and is responsible for managing massive transactions. However, as the scale of application expands, database performance bottlenecks often become a constraint. This article will explore a series of effective MySQL performance optimization strategies to ensure that your application remains efficient and responsive under high loads. We will combine actual cases to explain in-depth key technologies such as indexing, query optimization, database design and caching. 1. Database architecture design and optimized database architecture is the cornerstone of MySQL performance optimization. Here are some core principles: Selecting the right data type and selecting the smallest data type that meets the needs can not only save storage space, but also improve data processing speed.

Do mysql need to pay Do mysql need to pay Apr 08, 2025 pm 05:36 PM

MySQL has a free community version and a paid enterprise version. The community version can be used and modified for free, but the support is limited and is suitable for applications with low stability requirements and strong technical capabilities. The Enterprise Edition provides comprehensive commercial support for applications that require a stable, reliable, high-performance database and willing to pay for support. Factors considered when choosing a version include application criticality, budgeting, and technical skills. There is no perfect option, only the most suitable option, and you need to choose carefully according to the specific situation.

See all articles