遇到PHP错误
严重度:通知
消息:未定义的索引:晚餐
文件名:cn.php
行号:18
回溯:
文件:C:\应用程序\模型\供应商_m. php
生产线:18
函数:错误处理程序
文件:C:\应用程序\控制器\供应商. php
生产线:42
功能:添加
文件:C:\文件夹
生产线:315
函数:需要一次(_O)
发生数据库错误
错误编号:1048
列'name'不能为空
INSERT INTO '供应商'('名称','电话','地址','描述')值(NULL,'81213176824',' xa',NULL)
文件名:/xampp/htdocs/系统/数据库/数据库驱动程序. php
行号:692
我的控制器:controllers/Supplier.php
<?php defined('BASEPATH') OR exit('No direct script access allowed');
class Supplier extends CI_Controller {
function __construct()
{
parent::__construct();
check_not_login();
check_admin();
$this->load->model('supplier_m');
}
public function index()
{
$data['row'] = $this->supplier_m->get();
$this->template->load('template', 'supplier/supplier_data', $data);
}
public function add()
{
$data['row'] = $this->supplier_m->get();
$supplier = new stdClass();
$supplier->supplier_id = null;
$supplier->name = null;
$supplier->phone = null;
$supplier->address = null;
$supplier->description = null;
$data = array(
'page' => 'add',
'row' => $supplier
);
$this->template->load('template', 'supplier/supplier_form', $data);
}
public function process()
{
$post = $this->input->post(null, TRUE);
if(isset($_POST['add'])) {
$this->supplier_m->add($post);
}
if($this->db->affected_rows() > 0) {
echo "<script>alert('Data berhasil disimpan');</script>";
}
echo "<script>window.location='".site_url('supplier')."';</script>";
}
public function del($id) {
$this->supplier_m->del($id);
if($this->db->affected_rows() > 0) {
echo "<script>alert('Data berhasil dihapus');</script>";
}
echo "<script>window.location='".site_url('supplier')."';</script>";
}
}
我的视图:views/supplier_form.php
<section class="content-header">
<h1>Suppliers
<small>Pemasok Barang</small>
</h1>
<ol class="breadcrumb">
<li><a href="#"><i class="fa fa-dashboard"></i></a></li>
<li><a href="#"></a></li>
<li class="active">Suppliers</li>
</ol>
</section>
<!-- Main content -->
<section class="content">
<div class="box">
<div class="box-header">
<h3 class="box-title">Add Supplier</h3>
<div class="pull-right">
<a href="<?=site_url('supplier')?>" class="btn btn-warning btn-flat">
<i class="fa fa-undo"></i> Back
</a>
</div>
</div>
<div class="box-body">
<div class="row">
<div class="col-md-4 col-md-offset-4">
<form action="<?=site_url('supplier/process')?>" method="post">
<div class="form-group">
<label>Supplier Name *</label>
<input type="text" name="supp" value="<?=$row->name?>" class="form-control" required>
</div>
<div class="form-group">
<label>Phone *</label>
<input type="number" name="phone" value="<?=$row->phone?>" class="form-control" required>
</div>
<div class="form-group">
<label>Address</label>
<textarea name="addr" class="form-control" required <?=$row->address?>></textarea>
</div>
<div class="form-group">
<label>Description</label>
<textarea name="desc" class="form-control" <?=$row->description?>></textarea>
</div>
<div class="form-group">
<button type="submit" name="<?=$page?>" class="btn btn-success btn-flat">
<i class="fa fa-paper-plane"></i> Save
</button>
<button type="Reset" class="btn btn-flat">Reset</button>
</div>
</form>
</div>
</div>
</div>
</div>
</section>
我的模特:模特/供应商_m. php
<?php defined('BASEPATH') OR exit('No direct script access allowed');
class Supplier_m extends CI_Model {
public function get($id = null)
{
$this->db->from('supplier');
if($id != null) {
$this->db->where('supplier_id', $id);
}
$query = $this->db->get();
return $query;
}
public function add($post)
{
$params = [
'name' => $post['supp'],
'phone' => $post['phone'],
'address' => $post['addr'],
'description' => empty($post['desc']) ? null : $post['desc'],
];
$this->db->insert('supplier', $params);
}
public function del($id)
{
$this->db->where('supplier_id', $id);
$this->db->delete('supplier');
}
}
请帮助我解决这个错误,我已经尝试,但仍然不能
1条答案
按热度按时间sczxawaw1#
对于第一个错误
您已经打开了Supplier_m模型并查找函数-〉公共函数add($post)
在函数开始时,您必须检查从控制器发送的数据,如
您将获得过帐数据的实际结果
对于第二个错误
打开你的phpMyadmin(数据库)编辑表格,并选择复选框为空旁边的名称列,找到下面的图像可能会帮助你