CodeIgniter 从 mysql 切换驱动程序 -->mysqli

问题描述

我正在阅读这个问题:mysql 扩展是已弃用，将来会被移除:改用 mysqli 或 PDO

这让我想到我应该从 mysql 更改为 mysqli.这是 CodeIgniter 中的一个字符更改，因此不是很难:)

And it got me thinking that I should make the change from mysql to mysqli. It is a one character change in CodeIgniter so it isn't very hard :)

但是有什么我应该注意的以发现可能发生的错误吗?是否有某些查询被区别对待?

But is there anything I should look out for to spot any errors that can happen? Are there certain queries that are treated differently?

推荐答案

是否有某些查询被区别对待?

Are there certain queries that are treated differently?

没有

MySQL 和 MySQLi 扩展是处理 PHP 和 MySQL 数据库服务器之间通信的驱动程序"；

The MySQL and MySQLi extension are "drivers" that take care of the communication between PHP and the MySQL database server;

他们不会改变 MySQL 服务器理解的 SQL 命令的范围.

they do not change the range of SQL commands that the MySQL server understands.

因此，只要 DB 抽象层负责将 PHP 函数用于什么目的(并且像 CI 这样的框架肯定应该这样做)，就没有什么可担心的实际查询.

So as long as the DB abstraction layer takes care of what PHP functions are to use for what purpose for you (and a framework like CI should most certainly do that), there is nothing to worry about in regard to the actual queries.

这篇关于CodeIgniter 从 mysql 切换驱动程序 -->mysqli的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！