


Detailed explanation of the case of dynamic publishing function code for student information system site based on Codeigniter framework
This article mainly introduces the student implemented based on the Codeigniterframework The dynamic publishing function of the information system site provides a detailed analysis of the database sql statements, MVC functions and implementation techniques of each module related to the dynamic site. Friends in need can refer to the following
This article describes an example based on Codeigniter The dynamic publishing function of the student information system site implemented by the framework is shared with everyone for your reference. The details are as follows:
Since it is a dynamic site, there must be a database table. Without further ado, let’s take a look at the database. Table:
CREATE TABLE IF NOT EXISTS `student`( //主键id `id` int(11) NOT NULL AUTO_INCREMENT, //学生姓名 `s_name` varchar(64) NOT NULL, //学生家长的姓名 `p_name` varchar(64) NOT NULL, //学生的家庭住址 `address` varchar(100) NOT NULL, //所在城市 `city` varchar(30) NOT NULL, //所在国家 `state` varchar(30) NOT NULL, //所在地区的邮政编码 `zip` varchar(20) NOT NULL, //电话 `phone` varchar(15) NOT NULL, //邮件 `email` varchar(20) NOT NULL, //主键设置 PRIMARY KEY(`id`) )ENGINE=INNODB DEFAULT CHARSET=UTF8 AUTO_INCREMENT=1;
*Note: There are two places I need to explain here:
1. "IF NOT EXISTS": If the data is added in front when creating the table "IF NOT EXISTS" means that even if the table already exists, it will be executed successfully;
2. "ENGINE=INNODB": This is the engine setting of the database, commonly used mysql database Engines include ISAM, MYISAM, HEAP, etc.;
After creating the data table, let’s take a look at the database connection. Open the .\application\config\database.php file and set the database variable parameters in it. Set the basic URL in the .\application\config\config.php file. For me, the basic URL is: localhost/codeigniter/
Let’s take a look at the mvc ideaArchitecture Design
First open the .application\controllers\ file directory and create a student.phpcontroller:
student.php
In Let's first 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 it and look at the following code:
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:
<!DOCTYPE html PUBLIC '-//W3C//DTD HTML 4.01 Strict//EN' 'http://www.w3.org/TR/html4/strict.dtd'> <html> <head> <meta http-equiv='Content-Type' content='text/html; charset=utf-8'> <title><?php echo $title; ?></title> </head> <body> <h1><?php echo $headline; ?></h1> <?php $this->load->view($include)?> </body> </html>
Among them:
this−>load−>view(include);
contains another view file student_index.php file
student_index.php:
<p>Congratulations. Your initial setup is complete!</p>
Joint output:
welcome to the classroom Mangement System Congratulations. Your initial setup is complete!
CURD of data
C Controller
Let’s first look at the process of adding data, add an add() in the student controller Method
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
<html> <head> <title><?php echo $title;?></title> </head> <body> <h1><?php echo $headline ?></h1> <?php $this->load->view($include)?> </body> </html>
student_add.php
<?php echo form_open('student/create'); $field_name=array('s_name','p_name','address','city','state','zip','phone','email'); foreach($field_name as $value){ echo "<p>".$value.":" echo form_input(array('name'=>$value)); echo "</p>" } form_submit('','Add'); form_close(); ?>
update_student.php
<?php echo $updatetable; ?>
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 the detailed content of Detailed explanation of the case of dynamic publishing function code for student information system site based on Codeigniter framework. For more information, please follow other related articles on the PHP Chinese website!

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

How to implement custom middleware in CodeIgniter Introduction: In modern web development, middleware plays a vital role in applications. They can be used to perform some shared processing logic before or after the request reaches the controller. CodeIgniter, as a popular PHP framework, also supports the use of middleware. This article will introduce how to implement custom middleware in CodeIgniter and provide a simple code example. Middleware overview: Middleware is a kind of request

CodeIgniter Middleware: Accelerating Application Responsiveness and Page Rendering Overview: As web applications continue to grow in complexity and interactivity, developers need to use more efficient and scalable solutions to improve application performance and responsiveness. . CodeIgniter (CI) is a lightweight PHP-based framework that provides many useful features, one of which is middleware. Middleware is a series of tasks that are performed before or after the request reaches the controller. This article will introduce how to use

Introduction to the method of using the database query builder (QueryBuilder) in the CodeIgniter framework: CodeIgniter is a lightweight PHP framework that provides many powerful tools and libraries to facilitate developers in web application development. One of the most impressive features is the database query builder (QueryBuilder), which provides a concise and powerful way to build and execute database query statements. This article will introduce how to use Co

As web applications continue to evolve, it is important to develop applications more quickly and efficiently. And, as RESTful API is widely used in web applications, it is necessary for developers to understand how to create and implement RESTful API. In this article, we will discuss how to implement MVC pattern and RESTful API using CodeIgniter framework. Introduction to MVC pattern MVC (Model-Vie

The HP Victus 15 is 1 15.6-inch entry-level gaming laptop that ordinarily wouldn't be worth much consideration, however a new Best Buy deal offers 40% off the entry-level gaming laptop, bringing the price down from $799.99 to a very budget-friendly $

CodeIgniter is a lightweight PHP framework that uses MVC architecture to support rapid development and simplify common tasks. CodeIgniter5 is the latest version of the framework and offers many new features and improvements. This article will introduce how to use the CodeIgniter5 framework to build a simple web application. Step 1: Install CodeIgniter5 Downloading and installing CodeIgniter5 is very simple, just follow these steps: Download the latest version

CodeIgniter middleware: Provides secure file upload and download functions Introduction: In the process of web application development, file upload and download are very common functions. However, for security reasons, handling file uploads and downloads often requires additional security measures. CodeIgniter is a popular PHP framework that provides a wealth of tools and libraries to support developers in building secure and reliable web applications. This article will introduce how to use CodeIgniter middleware to implement secure files

In today's Internet era, a website that is loved by users must have a simple and clear front-end interface and a powerful back-end management system, and the PHP framework CodeIgniter is an excellent framework that allows developers to quickly build a back-end management system. CodeIgniter has the characteristics of lightweight, high efficiency, and easy expansion. This article will be aimed at beginners and explain in detail how to quickly build a backend management system through this framework. 1. Installation and configuration Installation of PHPCodeIgniter is a PHP-based
