错误:mysqli :: real_connect():(08004/1040):连接太多[CodeIgniter v3] [英] Error : mysqli::real_connect(): (08004/1040): Too many connections [CodeIgniter v3]

问题描述

我的网站上有一些问题，我的连接数太多了.

I have some problems in my site, I got an error too many connections .

屏幕截图: http://pasteboard.co/Hz7QJQR.png

Backtrace表示我在__construct，模型函数list_slider和get function上的模型中的错误:

the Backtrace said my error in my __construct, model function list_slider and my model on get function:

这是我的控制器代码:

<?php 

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

class Beranda extends CI_Controller {

    public function __construct()
    {
            parent::__construct();
            $this->load->helper(array('form', 'url', 'html'));
            $this->load->model(array('slider_model', 'slider_2_model', 'group_model', 'contact_model'));
    }

    public function index()
    {
            $data['slider_data'] = $this->slider_model->list_slider();
            $data['slider_2_data'] = $this->slider_2_model->list_slider();
            $data['group_data'] = $this->group_model->list_group();
            $data['contact_data'] = $this->contact_model->list_contact();
            $data['title'] = 'Kitchenware Equipments & Utensiles - norwinskitchenware.com';
            $this->load->view('fend/view_beranda', $data);
    }

}

?>

这是我的模型 [更新] :

<?php
    class Slider_model extends CI_Model {

        function list_slider()
        {

                $this->db->select('*');
                $this->db->from('slider');
                $query = $this->db->get();
                $this->db->close();
                return $query->result();
        }
     }
?>

我已经设置了'pconnect' => FALSE和mysql.allow_persistent = OFF

我该怎么办?

谢谢

推荐答案

在模型中，您应该关闭函数的连接.

In your model you should close the connection for your function.

如果您在Controller中这样做

And If you do it in your Controller

public function __destruct() {  
    $this->db->close();  
}  

您应通过__destruct()

这篇关于错误:mysqli :: real_connect():(08004/1040):连接太多[CodeIgniter v3]的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！