您指定了无效的数据库连接组codeigniter错误 [英] You have specified an invalid database connection group codeigniter error
问题描述
我从教程制作CRUD。
您指定了无效的数据库连接组。会有什么问题?
database.php - 数据库配置
$ db ['default'] ['hostname'] ='localhost' ;
$ db ['default'] ['username'] ='root';
$ db ['default'] ['password'] ='';
$ db ['default'] ['database'] ='cicrud';
$ db ['default'] ['dbdriver'] ='mysql';
$ 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;
users_model.php -model
<?php
class Users_model extends CI_Model {
function __construct()
{
parent :: __ construct();
$ this-> load-> database('cicrud');
}
public function get_all_users()
{
$ query = $ this-> db-> ; get('users');
return $ query-> result();
}
public function insert_users_to_db($ data)
{
return $ this-> db-&用户',$ data);
}
}
?>
users.php - 控制器
<?php
if(!defined('BASEPATH'))exit('不允许直接脚本访问);
类用户扩展CI_Controller {
函数__construct()
{
parent :: __ construct
#$ this-> load-> helper('url');
$ this-> load-> model('users_model');
}
public function index()
{
$ data ['user_list'] = $ this- > users_model-> get_all_users();
$ this-> load-> view('show_users',$ data);
}
public function add_form()
{
$ this-> load-> view('insert') ;
}
public function insert_new_user()
{
$ udata ['name'] = $ this-& > post('name');
$ udata ['email'] = $ this-> input-> post('email');
$ udata ['address'] = $ this-> input-> post('address');
$ udata ['mobile'] = $ this-> input-> post('mobile');
$ res = $ this-> users_model-> insert_users_to_db($ udata);
if($ res){
header('location:'。base_url()。index.php / users /\".$ this-& );
}
}
}
show_users.php - html视图
<!DOCTYPE html PUBLIC // DTD XHTML 1.0 Transitional // ENhttp://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">
< html xmlns =http://www.w3.org/1999/xhtml>
< head>
< meta http-equiv =Content-Typecontent =text / html; charset = utf-8/>
< title> CI CRUD< / title>
< script type =text / javascript>
function show_confirm(act,gotoid)
{
if(act ==edit)
r = confirm(你真的要编辑吗?);
else
var r = confirm(你真的要删除吗?
if(r == true)
{
window.location =<?php echo base_url();?> index .php / users /+ act +/+ gotoid;
}
}
< / script>
< / head>
< body>
< h2>简单CI CRUD应用程序< / h2>
< table width =600border =1cellpadding =5>
< tr>
< th scope =col> Id< / th>
< th scope =col>用户名< / th>
< th scope =col>电子邮件< / th>
< th scope =col> Mobile< / th>
< th scope =col>地址< / th>
< th scope =colcolspan =2> Action< / th>
< / tr>
<?php foreach($ user_list as $ u_key){?>
< tr>
< td><?php echo $ u_key-> id; ?>< / td>
< td><?php echo $ u_key-> name; ?>< / td>
< td><?php echo $ u_key-> email; ?>< / td>
< td><?php echo $ u_key-> address; ?>< / td>
< td><?php echo $ u_key-> mobile; ?>< / td>
< td width =40align =left>< a href =#onClick =show_confirm('edit',<?php echo $ u_key-> id>?>)> Edit< / a>< / td>
< td width =40align =left>< a href =#onClick =show_confirm('delete',<?php echo $ u_key-& id;?>)> Delete< / a>< / td>
< / tr>
<?php}?>
< tr>
< td colspan =7align =right> < a href =<?php echo base_url();?> index.php / user / add_form>插入新用户< / a>< / td>
< / tr>
< / table>
< / body>
< / html>
正在加载一个名为 circrud
。但是没有数据库组称之为。您唯一拥有的是一个名为 default
的组,如果您未指定组,将默认加载
$ this-> load-> database('cicrud');
do
$ this-> load-> database();
/ p>
class Users_model extends CI_Model {
function __construct()
{
parent :: __ construct();
$ this-> load-> database();
}
i'm making a CRUD from a tutorial. And i'm getting this error.
You have specified an invalid database connection group.
What would be the problem?
database.php - database config
$db['default']['hostname'] = 'localhost';
$db['default']['username'] = 'root';
$db['default']['password'] = '';
$db['default']['database'] = 'cicrud';
$db['default']['dbdriver'] = 'mysql';
$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;
users_model.php -model
<?php
class Users_model extends CI_Model {
function __construct()
{
parent::__construct();
$this->load->database('cicrud');
}
public function get_all_users()
{
$query = $this->db->get('users');
return $query->result();
}
public function insert_users_to_db($data)
{
return $this->db->insert('users', $data);
}
}
?>
users.php - controller
<?php
if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class Users extends CI_Controller {
function __construct()
{
parent::__construct();
#$this->load->helper('url');
$this->load->model('users_model');
}
public function index()
{
$data['user_list'] = $this->users_model->get_all_users();
$this->load->view('show_users', $data);
}
public function add_form()
{
$this->load->view('insert');
}
public function insert_new_user()
{
$udata['name'] = $this->input->post('name');
$udata['email'] = $this->input->post('email');
$udata['address'] = $this->input->post('address');
$udata['mobile'] = $this->input->post('mobile');
$res = $this->users_model->insert_users_to_db($udata);
if($res){
header('location:'.base_url()."index.php/users/".$this->index());
}
}
}
show_users.php - html views
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>CI CRUD</title>
<script type="text/javascript">
function show_confirm(act,gotoid)
{
if(act=="edit")
var r=confirm("Do you really want to edit?");
else
var r=confirm("Do you really want to delete?");
if (r==true)
{
window.location="<?php echo base_url();?>index.php/users/"+act+"/"+gotoid;
}
}
</script>
</head>
<body>
<h2> Simple CI CRUD Application </h2>
<table width="600" border="1" cellpadding="5">
<tr>
<th scope="col">Id</th>
<th scope="col">User Name</th>
<th scope="col">Email</th>
<th scope="col">Mobile</th>
<th scope="col">Address</th>
<th scope="col" colspan="2">Action</th>
</tr>
<?php foreach ($user_list as $u_key){ ?>
<tr>
<td><?php echo $u_key->id; ?></td>
<td><?php echo $u_key->name; ?></td>
<td><?php echo $u_key->email; ?></td>
<td><?php echo $u_key->address; ?></td>
<td><?php echo $u_key->mobile; ?></td>
<td width="40" align="left" ><a href="#" onClick="show_confirm('edit',<?php echo $u_key->id;?>)">Edit</a></td>
<td width="40" align="left" ><a href="#" onClick="show_confirm('delete',<?php echo $u_key->id;?>)">Delete </a></td>
</tr>
<?php }?>
<tr>
<td colspan="7" align="right"> <a href="<?php echo base_url();?>index.php/user/add_form">Insert New User</a></td>
</tr>
</table>
</body>
</html>
You are loading a database group called circrud
. But there are no database group called that. The only one you have is a group called default
which will be loaded by default if you don't specify a group.
$this->load->database('cicrud');
You should just do
$this->load->database();
in this part of the code:
class Users_model extends CI_Model {
function __construct()
{
parent::__construct();
$this->load->database();
}
这篇关于您指定了无效的数据库连接组codeigniter错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!