This article mainly introduces the student information system site dynamic release function based on Codeigniter framework. it analyzes in detail the Database SQL statements related to dynamic sites, the functions and implementation skills of various MVC modules, the student information system site dynamic publishing function based on Codeigniter # css/css-rwd-frameworks.html "target =" _ blank "> framework is introduced, this article analyzes in detail the Database SQL statements related to dynamic sites, functions and implementation skills of various MVC modules. if you need them, refer
This document describes how to dynamically publish student information system sites based on the Codeigniter framework. We will share this with you for your reference. The details are as follows:
Since it is a dynamic site, there must be a database table, which is not nonsense here. let's take a look at the database table:
Create table if not exists 'student '(// primary key id 'id' int (11) not null AUTO_INCREMENT, // student name's _ name' varchar (64) not null, // the parents' name 'P _ name' varchar (64) not null, // The student's home address 'address' varchar (100) not null, // The city 'city' varchar (30) not null, // The country 'state' varchar (30) not null, // The zip code 'Zip' varchar (20) not null for the region, // The phone number 'phone' varchar (15) not null, // The email 'email 'varchar (20) not null, // set the primary key to primary key ('id') ENGINE = innodb default charset = UTF8 AUTO_INCREMENT = 1;
* Note: I have two points to explain:
1. "if not exists": IF "if not exists" is added before the table is created, the operation is successful even IF the table already EXISTS;
2. "ENGINE = INNODB": this is the database ENGINE settings. commonly used mysql database engines include ISAM, MYISAM, and HEAP;
After creating the data table, let's take a look at the database connection. Open. \ application \ config \ database. php file, including set Database variable parameters, in. \ application \ config. set the basic URL in the PHP file. for my basic url: localhost/codeigniter/
Let's take a look at the design of the mvc ideological architecture.
First open the. application \ controllers \ file directory, and create a student. php controller in it:
Student. php
Here we will test it through the student controller and print out helloworld. remember that the access path is localhost/codeigniter/index. php/student/index.
class student extends CI_Controller{ //student controller construct public function construct(){ parent::construct(); } //index test function public function index(){ echo "helloworld"; }}
It output: helloworld
Let's change the code below:
class student extends CI_Controller{ //student controller public function construct(){ parent::construct(); } //define a array,name is arraydata, it have three parameters protected $arraydata=array( 'title'=>'Classroom:Home page', 'headline'=>'welcome to the classroom Mangement System', 'include'=>'student_index' ); //index function public function index(){ $this->load->view('template',$this->arraydata); }}
This code requires a View, template. php
Template. php:
<?php echo $title; ?>
load->view($include)?>
Where:
this−>load−>view(include);
It contains another view file, studen_index.php.
Student_index.php:
Congratulations. Your initial setup is complete!
Combined output:
welcome to the classroom Mangement SystemCongratulations. Your initial setup is complete!
Data CURD
C controller
Let's take a look at the data addition process and add an add () method to the student controller.
class student extends CI_Controller{ //student controller public function construct(){ parent::construct(); } //new add function public function add(){ $this->load->helper('form'); //display information for the view $data['title']='Classroom:Add Page'; $data['headline']='Add data'; $data['include']='student_add'; //upload view $this->load->view('template',$data); } //create function public function create(){ $this->load->helper('url'); $this->load->model('MStudent','',TRUE); $this->MStudent->addData($_POST); redirect('student/add','reflesh'); } //update function public function update(){ //upload codeigniter library $this->load->library('table'); $this->load->model('MStudent','',TRUE); $student_query=$this->MStudent->updateData(); $update_table=$this->table->generate($student_query); //display information for the view $data['title']='Classroom:Update Page'; $data['headline']='Update Page'; $data['include']='update_student'; $data['updatetable']=$update_table; $this->load->view('template',$data); } //index function public function index(){ $data['title']='Classroom:Home page'; $data['headline']='welcome to classroom Mangement System'; $data['include']='student_index'; $this->load->view('template',$this->arraydata); }}
V view
Template. php
<?php echo $title;?>
load->view($include)?>
Student_add.php
".$value.":" echo form_input(array('name'=>$value)); echo "" } form_submit('','Add'); form_close();?>
Update_student.php
M model
class MStudent extends CI_Model{ public function addData($data){ $this->db->insert('student',$data); } public function updateData(){ $this->db->get('student'); }}
The above is a detailed description of the code case for implementing the function code of the student information system website dynamic release based on the Codeigniter framework. For more information, see other related articles in the first PHP community!