php - 2 查询发生错误
问题描述
处理此表单时,会生成 2 个查询。
在查询1中:所有数据都成功,但图片除外。图片:听起来值得“NULL”。
查询2:图片写对了。但其他数据正在写入“NULL”。
我想要的是,而不是查询 2,查询 2 中的图像数据应该进入查询 1,并且应该只形成 1 个查询。
这是我的控制器和模型
public function send_Basvur_message(){
$this->load->library("form_validation");
$this->load->model("Basvur_model");
$this->form_validation->set_rules("name", "Ad", "trim|required");
$this->form_validation->set_rules("email", "E-posta", "trim|required|valid_email");
$this->form_validation->set_rules("subject", "Konu", "trim|required");
$this->form_validation->set_rules("message", "Mesaj", "trim|required");
$this->form_validation->set_rules("url", "url");
$this->form_validation->set_rules("captcha", "Doğrulama Kodu", "trim|required");
$path = './panel/uploads/basvur_v/';
$initialize = $this->upload->initialize(array(
"upload_path" => $path,
"allowed_types" => "gif|jpg|jpeg|png|bmp",
"remove_spaces" => TRUE
));
$imagename = 'no-img.jpg';
$config['max_size'] = 51200;
$config['overwrite'] = false;
$config['encrypt_name'] = false;
$config['remove_space'] = false;
$imagename = 'no-img.jpg';
if($this->form_validation->run() === FALSE){
} else if(!$this->upload->do_upload('img_url')) {
$this->session->set_flashdata('info','Action Completed');
redirect(base_url("basvuru"));
} else {
$insert = $this->Basvur_model->add(
array(
"name" => $this->input->post("name"),
"email" => $this->input->post("email"),
"message" => $this->input->post("message"),
"subject" => $this->input->post("subject"),
"url" => $imagename,
"created_at" => date("Y-m-d H:i:s")
)
);
$data = $this->upload->data();
$imagename = $data['file_name'];
$this->Basvur_model->setURL($imagename);
$this->Basvur_model->create();
$this->session->set_flashdata('img_uploaded', $imagename);
if($this->session->userdata("captcha") == $this->input->post("captcha")){
$name = $this->input->post("name");
$email = $this->input->post("email");
$subject = $this->input->post("subject");
$message = $this->input->post("message");
$email_message = "{$name} isimli ziyaretçi. Başvuru Yaptı <br><b>Mesaj : </b> {$message} <br> <b>E-posta : </b> {$email}";
if(send_email("", "Yeni Aday başvurusu | $subject", $email_message)){
$this->session->set_flashdata('success','Action Completed');
redirect(base_url("basvuru"));
// TODO Alert..
} else {
$this->session->set_flashdata('success','Action Completed');
redirect(base_url("basvuru"));
// TODO Alert..
}
} else {
//başarısıs
$this->session->set_flashdata('error','Action Not Completed');
redirect(base_url("basvuru"));
}
}
}
模型
<?php
class Basvur_model extends CI_Model
{
public $tableName = "basvurs";
public function __construct()
{
parent::__construct();
}
private $_ID;
private $_url;
public function setID($ID) {
$this->_ID = $ID;
}
public function setURL($url) {
$this->_url = $url;
}
// get image
public function getPicture() {
$this->db->select(array('p.id', 'p.url'));
$this->db->from('basvurs p');
$this->db->where('p.id', $this->_ID);
$query = $this->db->get();
return $query->row_array();
}
// insert image
public function create() {
$data = array(
'url' => $this->_url,
);
$this->db->insert('basvurs', $data);
return $this->db->insert_id();
}
public function get($where = array())
{
return $this->db->where($where)->get($this->tableName)->row();
}
/** Tüm Kayıtları bana getirecek olan metot.. */
public function get_all($where = array(), $order = "id ASC")
{
return $this->db->where($where)->order_by($order)->get($this->tableName)->result();
}
public function add($data = array())
{
return $this->db->insert($this->tableName, $data);
}
public function update($where = array(), $data = array())
{
return $this->db->where($where)->update($this->tableName, $data);
}
public function delete($where = array())
{
return $this->db->where($where)->delete($this->tableName);
}
}
解决方案
关于代码中的查询 1,您会注意到:
$data = $this->upload->data();
$imagename = $data['file_name'];
直到您的插入$insert
语句之后才会填充。先搬过去。
关于您的第二个查询,我不确定填充为 NULL 的内容,但是您发送给查询的唯一变量是 url。
public function create() {
$data = array(
'url' => $this->_url,
); // see just this^
$this->db->insert('basvurs', $data);
return $this->db->insert_id();
}
现在所有这些数据似乎都进入同一张表?我不确定你为什么不只在一个插入语句中完成所有操作。为什么你想要重复的条目也有点令人困惑。
推荐阅读
- python - 安装 Python 包 PCAPY 时出错
- apache-nifi - Windows机器上的apache nifi 1.7.1重启问题
- jquery - jQuery - 匹配具有相同数据的元素
- javascript - 附加文件后动态更改回形针图标,改为显示文件图标。
- javascript - 如何使用 ajax 读取外部 docx 文件内容
- javascript - 如何获取 Chrome 浏览器的所有传入 IP 连接列表?
- python - 如何访问jinja2.Template的环境
- python - 如何在 Django 管理自定义列中获取请求参数?
- php - Wordpress PHP - 你如何将帖子缩略图移动到帖子标题和摘录下方
- python - 如何测试更复杂的功能?