在本教程中,尝试介绍grocery CRUD 的基本功能,以及如何使用它的逐步教程。
首先遵循grocery CRUD 安装步骤.
假设我们有下表:
CREATE TABLE IF NOT EXISTS `employees` (
`employeeNumber` int(11) NOT NULL AUTO_INCREMENT,
`lastName` varchar(50) NOT NULL,
`firstName` varchar(50) NOT NULL,
`extension` varchar(10) NOT NULL,
`email` varchar(100) NOT NULL,
`officeCode` varchar(10) NOT NULL,
`file_url` varchar(250) CHARACTER SET utf8 NOT NULL,
`jobTitle` varchar(50) NOT NULL,
PRIMARY KEY(`employeeNumber`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1703 ;
首先,我们在控制器上创建函数,我们会得到如下结果:
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class Demo extends CI_Controller {
function __construct()
{
parent::__construct();
$this->load->database();
}
public function index()
{
}
public function employees_example()
{
$crud = new grocery_CRUD();
$crud->set_table('employees');
$output = $crud->render();
$this->_example_output($output);
}
function _example_output($output = null)
{
$this->load->view('our_template.php',$output);
} }
/* End of file main.php *//* Location: ./application/controllers/main.php */?>
设置表
public function my_function_name()
{
$crud = new grocery_CRUD();
$crud->set_table('your_table_name');
$output = $crud->render();
$this->_example_output($output);
}
现在,添加第一个记录,以便至少有一个项目可以处理。
始终确保表中至少有一个主键,建议将主键作为自动增量设置主题
我们先从最常见的方法开始
$crud->set_subject('your_subject_name');
public function employees_example()
{
$crud = new grocery_CRUD();
$crud->set_subject('Employee');
$crud->set_table('employees');
$output = $crud->render();
$this->_example_output($output);
}
列
第二个最常见的方法是:
$crud->columns('field_name1','field_name2','field_name3','field_name4');
在示例中,使用:
$crud->columns('lastName','firstName','email','jobTitle');
字段
$crud->fields('field_name1','field_name2','field_name3','field_name4');
在例子中,有:
public function employees_example()
{
$crud = new grocery_CRUD();
$crud->set_table('employees');
$crud->columns('lastName','firstName','email','jobTitle');
$crud->fields('lastName','firstName','extension','email','jobTitle');
$output = $crud->render();
$this->_example_output($output);
}
显示
如果想要更改,你可以简单地使用:
$crud->display_as('field_name','field_label');
在例子中,有:
$crud->display_as('lastName','Last Name');
$crud->display_as('firstName','First Name');
$crud->display_as('jobTitle','Job Title');
最常用方法由下面的代码完成:
public function employees_example()
{
$crud = new grocery_CRUD();
$crud->set_table('employees');
$crud->columns('lastName','firstName','email','jobTitle');
$crud->fields('lastName','firstName','extension','email','jobTitle');
$crud->display_as('lastName','Last Name');
$crud->display_as('firstName','First Name');
$crud->display_as('jobTitle','Job Title');
$output = $crud->render();
$this->_example_output($output);
}