代码点火器错误:调用未定义的函数 mysql_pconnect()


Codeigniter error: Call to undefined function mysql_pconnect()

我已经逐步将我的代码点火器版本从 2.2.4 更新到 3.0.6,但出现错误:

An uncaught Exception was encountered
Type: Error
Message: Call to undefined function mysql_pconnect()
Filename: path-to-project'system'database'drivers'mysql'mysql_driver.php
Line Number: 135
Backtrace:
File: path-to-project'application'controllers'Main.php
Line: 10
Function: __construct
File: path-to-project'index.php
Line: 315
Function: require_once

我刚刚用新的索引.php文件和系统目录替换了我的索引,并根据教程在我的应用程序中进行了一些更改。

这是主控制器:

class Main extends CI_Controller {
    function __construct()
    {
        parent::__construct();
        $this->load->model('main_model');
    }
}

是什么原因导致问题?!

这是教程的链接。

PHP

5.5.x 中已弃用的功能:

原来的MySQL扩展现已弃用,并且在连接到数据库时会产生E_DEPRECATED错误。相反,请使用 MySQLi 或 PDO_MySQL 扩展。

您正在使用已弃用的 mysql 数据库驱动程序。找到config/database.php文件并更改dbdriver以使用mysqli

$db['default']['dbdriver'] = 'mysqli'; 

感谢Anant

我得出一个结论:

我用新数据库完全更改了配置文件夹中的旧数据库.php文件:

从:

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

自:

$db['default'] = array(
    'dsn'   => '',
    'hostname' => '',
    'username' => '',
    'password' => '',
    'database' => '',
    'dbdriver' => 'mysqli',
    'dbprefix' => '',
    'pconnect' => FALSE,
    'db_debug' => (ENVIRONMENT !== 'production'),
    'cache_on' => FALSE,
    'cachedir' => '',
    'char_set' => 'utf8',
    'dbcollat' => 'utf8_general_ci',
    'swap_pre' => '',
    'encrypt' => FALSE,
    'compress' => FALSE,
    'stricton' => FALSE,
    'failover' => array(),
    'save_queries' => TRUE
);

错误消失了!

转到应用程序/配置/数据库.php
只需将mysql更改为mysqli

喜欢这是以前:

 $db['default']['dbdriver'] = 'mysql';

这是在解决方案之后:

$db['default']['dbdriver'] = 'mysqli';

我只是将MySQL更改为MySQL。

我的错误是

致命错误:未

捕获错误:调用未定义的函数 mysql_pconnect() in E:''manish_data''software''xampp''htdocs''ci2''system''database''drivers''mysql''mysql_driver.php:92 堆栈跟踪:#0 E:''manish_data''software''xampp''htdocs''ci2''system''database''DB_driver.php(116): CI_DB_mysql_driver->db_pconnect() #1 E:''manish_data''software''xampp''htdocs''ci2''system''database''DB.php(149): CI_DB_driver->初始化() #2 E:''manish_data''software''xampp''htdocs''ci2''system''core''Loader.php(347): DB(数组,空) #3 E:''manish_data''software''xampp''htdocs''ci2''application''models''usermodel.php(20): CI_Loader->数据库() #4 E:''manish_data''software''xampp''htdocs''ci2''application''controllers''users.php(15): UserModel->getUsers() #5 E:''manish_data''software''xampp''htdocs''ci2''system''core''CodeIgniter.php(360): 用户->索引() #6 E:''manish_data''software''xampp''htdocs''ci2''index.php(202): require_once('E:''manish_data''...') #7 {main} 扔进去 E:''manish_data''software''xampp''htdocs''ci2''system''database''drivers''mysql''mysql_driver.php 在第 92 行

如果在托管网站时发生此错误,请确保设置正确的 PHP 版本(CI 使用的版本)。