php - Codeigniter 输入到有条件的数据库
问题描述
我是 codeigniter 的新手,当我想使用输入添加一些数据时遇到问题。就我而言,在第一页上,它将从用户数据库中获取默认显示交付信息的数据,可以编辑此输入,如果我单击提交,它将保存在交付数据库中。第一个问题当我点击提交数据时,它无法保存到数据库。如何解决这个问题?第二种情况,我想给出一些条件,如果复选框打勾,输入的数据将默认保存到用户数据库,并将保存到交付数据库。
这个我的模型(M_checkout):
public function get_user_by_id($customer_id)
{
$data = $this->db->select('*')
->from('user')
->where('user_id', $customer_id)
->get()
->row();
return $data;
}
public function add_delivery()
{
$data = array();
$customer_id = $this->input->post('user_id');
$this->db->where('user_id', $customer_id);
$data['user_id'] = $customer_id;
$data['user_nama'] = $this->input->post('user_nama');
$data['user_email'] = $this->input->post('user_email');
$data['user_phone'] = $this->input->post('user_phone');
$data['user_wa'] = $this->input->post('user_wa');
$data['user_alamat'] = $this->input->post('user_alamat');
$data['user_kota'] = $this->input->post('user_kota');
$data['user_provinsi'] = $this->input->post('user_provinsi');
$data['user_zip'] = $this->input->post('user_zip');
$this->db->insert('delivery', $data);
$customer_deliv_id = $this->db->insert_id();
$sdata = array();
$sdata['delivery_id'] = $customer_deliv_id;
$this->session->set_userdata($sdata);
}
这个我的控制器(结帐):
public function add_delivery_to_db()
{
$this->form_validation->set_rules('user_nama', 'Nama', 'trim|required');
$this->form_validation->set_rules('user_email', 'Email', 'trim|required');
$this->form_validation->set_rules('user_phone', 'Nomer Telpon', 'trim|required|min_length[10]|max_length[12]');
$this->form_validation->set_rules('user_wa', 'Nomer WA', 'trim|required|min_length[10]|max_length[12]');
$this->form_validation->set_rules('user_alamat', 'Nomer Alamat', 'trim|required');
$this->form_validation->set_rules('user_kota', 'Nomer Kota', 'trim|required');
$this->form_validation->set_rules('user_provinsi', 'Nomer Provinsi', 'trim|required');
$this->form_validation->set_rules('user_zip', 'Nomer Zip', 'trim|required|min_length[5]|max_length[5]');
if ($this->form_validation->run()) {
$delivery_post_id = $this->M_checkout->add_delivery();
redirect('payment', 'refresh');
} else {
redirect('delivery', 'refresh');
}
}
这是我的观点(交付):
<div class="columns">
<p>
</p>
<div class="column is-3"></div>
<div class="column is-6 has-addons-fullwidth">
<form class="" action="<?= base_url() ?>add_deliv" method="POST">
<section class="mt-2">
<input class="input is-medium" type="text" placeholder="Nama" name="user_nama" value="<?= $user_info->user_nama ?>" disabled>
</section>
<section class="mt-2">
<input class="input is-medium" type="email" placeholder="Email" name="user_email" value="<?= $user_info->user_email ?>" disabled>
</section>
<section class="mt-2">
<input class="input is-medium" type="text" placeholder="No. Telepon" name="user_phone" value="<?= $user_info->user_phone ?>">
</section>
<section class="mt-2">
<input class="input is-medium" type="text" placeholder="Whatapp" name="user_wa" value="<?= $user_info->user_wa ?>">
</section>
<section class="mt-2">
<input class="input is-medium" type="text" placeholder="Alamat" name="user_alamat" value="<?= $user_info->user_alamat ?>">
</section>
<section class="mt-2">
<input class="input is-medium" type="text" placeholder="Kota" name="user_kota" value="<?= $user_info->user_kota ?>">
</section>
<section class="mt-2">
<input class="input is-medium" type="text" placeholder="Provinsi" name="user_provinsi" value="<?= $user_info->user_provinsi ?>">
</section>
<section class="mt-2">
<input class="input is-medium" type="text" placeholder="Kode Pos" name="user_zip" value="<?= $user_info->user_zip ?>">
</section>
<section class="columns mt-4">
<div class="column">
<p class="has-text-white has-text-weight-semibold">
Simpan sebagai default
</p>
</div>
<div class="column">
<input class="checkbox is-white" type="checkbox" name="delivery_checkbox" value="on">
</div>
</section>
<section class="columns">
<div class="column"></div>
<div class="column">
<button class="button is-danger is-medium">
Simpan & Lanjut
</button>
</div>
<div class="column"></div>
</section>
</form>
</div>
<div class="column is-3"></div>
</div>
这张交货视图delivery.php的图片
对不起,我的英语不好。请帮我。我感谢每一个答案。
解决方案
INSERT
语句不应该包含WHERE
子句。该where
子句永远不会得到满足,因此永远不会进行插入。
更新或替换记录时,一个where
子句是有意义的(因为它会缩小您实际最终更新的现有记录的范围)
从您的方法中删除该$this->db->where('user_id', $customer_id);
语句,add_delivery
插入将起作用。
关于仅在选中复选框时才进行插入,有很多选择。最简单的是:
if ($this->form_validation->run()) {
if ($this->input->post('delivery_checkbox') === 'on')
{
// only do the insert if the checkbox is actually ticked
$delivery_post_id = $this->M_checkout->add_delivery();
}
redirect('payment', 'refresh');
}
推荐阅读
- r - R Shiny Reactive dplyr 过滤器以形成新的数据框以进行绘图
- javascript - 将 JSON 响应的数据存储到多个变量中
- firebase - 如何以正确的方式从firebase存储中获取pdf文件Angular 5
- node.js - 是否可以使用 `JwtStrategy` 更改`JWT` 字符串?
- php - 未部署网站的 PHP 页面重定向
- r - R:如何正确地为 ggmap 地理编码/谷歌地理编码 API 准备一个国际地址?
- python - DJANGO:创建一个允许下载 zip 文件的按钮
- mysql - 如何在mysql中替换JSON键的值
- java - 在java中使用try和catch查找元素数组
- mongodb - 将 mongo 连接到 mlab 时出现问题(登录失败)