所用框架 Codelgniter 3.1.2版本
环境要求:
PHP 5.3.7以上, mysql 要求开启 mysqli扩展
本程序需要安装在网站根目录
在线效果网址:http://www.xuxucode.top/code/cizsgc/
Ci框架的增删改查,效果如下图
主要控制器源码:
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Home extends CI_Controller {
/**
* Index Page for this controller.
*
* Maps to the following URL
* http://example.com/index.php/welcome
* - or -
* http://example.com/index.php/welcome/index
* - or -
* Since this controller is set as the default controller in
* config/routes.php, it's displayed at http://example.com/
*
* So any other public methods not prefixed with an underscore will
* map to /index.php/welcome/<method_name>
* @see https://codeigniter.com/user_guide/general/urls.html
*/
public function index()
{
$result = $this->db->query('select * from contact');
foreach ($result->result_array() as $row)
{
$data['lists'][] = $row;
}
$this->load->view('home',$data);
}
public function add()
{
if($this->input->post('submit'))
{
$name = $this->input->post('name');
$sex = $this->input->post('sex');
$phone = $this->input->post('phone');
$address = $this->input->post('address');
$result = $this->db->query("insert into contact(name,sex,phone,address) values('$name','$sex','$phone','$address')");
if($result){
$this->load->view('ok');
}else{
$this->load->view('error');
}
}else{
$this->load->view('add');
}
}
public function del()
{
$id = $this->uri->segment(3);
$result = $this->db->query("delete from contact where id=$id");
if($result){
$this->load->view('ok');
}else{
$this->load->view('error');
}
}
public function mod()
{
$id = $this->uri->segment(3);
if($this->input->post('submit'))
{
$id = $this->input->post('id');
$name = $this->input->post('name');
$sex = $this->input->post('sex');
$phone = $this->input->post('phone');
$address = $this->input->post('address');
$result = $this->db->query("update contact set name='$name',sex='$sex',phone='$phone',address='$address' where id=$id");
if($result){
$this->load->view('ok');
}else{
$this->load->view('error');
}
}else{
$result = $this->db->query("select * from contact where id=$id");
$data['row'] = $result->row_array();
$this->load->view('mod',$data);
}
}
public function search()
{
$keyword = $this->input->post('keyword');
$result = $this->db->query("select * from contact where (name like '%$keyword%') or (address like '%$keyword%') or (phone like '%$keyword%')");
foreach ($result->result_array() as $row)
{
$data['lists'][] = $row;
}
$this->load->view('home',$data);
}
}