mysql - 如何根据当前登录的用户输入数据?
问题描述
我做了一个表格帖子,我有一个字段 email_id 到带有用户 ID 的外键,我做了一些添加的帖子,我的问题是我如何可以自动添加来自用户会话发布它的 email_id .. 我已经尝试了 2 天并且帖子可以发布,但 email_id 不会自动从发布者那里获取数据..
<?php echo form_open_multipart('user/addpost'); ?>
<div class="modal-body">
<div class="form-group">
<input type="text" class="form-control" id="namaFes" name="namaFes" placeholder="Nama Festival">
</div>
<div class="form-group">
<select name="daerah_id" id="daerah_id" class="form-control">
<option value="">Pilih Daerah</option>
<?php foreach ($nm_daerah as $nm) : ?>
<option value="<?= $nm['id_daerah']; ?>"><?= $nm['nm_daerah']; ?></option>
<?php endforeach; ?>
</select>
</div>
<div class="form-group">
<input type="date" class="form-control" id="tanggal" name="tanggal" placeholder="Tanggal Festival">
</div>
<div class="form-group">
<textarea style="height: 80px;" class="form-control" id="deskripsi" name="deskripsi" placeholder="Keterangan"></textarea>
</div>
<div class="form-group">
<input type="text" class="form-control" id="email_id" name="email_id" value="<?= $user['email']; ?>" readonly>
<!--<div class=" form-group">
<div class="form-check">
<input class="form-check-input" type="checkbox" value="1" name="isActive" id="isActive" checked>
<label class="form-check-label" for="isActive">
Is it active?
</label>
</div>
</div>-->
<div class="custom-file">
<input type="file" class="custom-file-input" id="image" name="image">
<label class="custom-file-label" for="image">Choose 1:1 image...</label>
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
<button type="submit" class="btn btn-primary">Add</button>
<? echo form_close(); ?>
这是我添加的post.php
$data['title'] = 'Add Posting';
$data['user'] = $this->db->get_where('user', ['email' => $this->session->userdata('email')])->row_array();
$data['nm_daerah'] = $this->db->get('daerah')->result_array();
$data['postfes'] = $this->db->get('postfes')->row_array();
$this->load->model('PostModel', 'post');
$data['postFes'] = $this->post->getPostModel4();
$this->form_validation->set_rules('namaFes', 'Nama Festival', 'required|trim');
$this->form_validation->set_rules('daerah_id', 'Nama Daerah', 'required|trim');
$this->form_validation->set_rules('tanggal', 'Tanggal', 'required|trim');
$this->form_validation->set_rules('deskripsi', 'Deskripsi', 'required|trim');
if ($this->form_validation->run() == false) {
$this->load->view('templates/user-header', $data);
$this->load->view('templates/user-sidebar', $data);
$this->load->view('templates/user-topbar', $data);
$this->load->view('user/addpost', $data);
$this->load->view('templates/user-footer');
} else {
$namaFes = $this->input->post('namaFes');
$daerah = $this->input->post('daerah_id');
$tanggal = $this->input->post('tanggal');
$desk = $this->input->post('deskripsi');
$idpost = $this->input->post('email_id');
$image = $_FILES['image'];
if ($image = '') {
} else {
$config['upload_path'] = './assets/img/posting/';
$config['allowed_types'] = 'jpg|gif|png|jpeg';
$this->load->library('upload', $config);
if (!$this->upload->do_upload('image')) {
echo 'failed upload image';
die();
} else {
$image = $this->upload->data('file_name');
}
}
$data = [
'namaFes' => $namaFes,
'daerah_id' => $daerah,
'tanggal' => $tanggal,
'deskripsi' => $desk,
'email_id' => $idpost,
'image' => $image
];
$this->db->insert('postfes', $data);
$this->session->set_flashdata('message', '<div class="alert alert-success" role="alert">Please wait admin approve your post</div>');
redirect('user/addpost');
}
}
这是我的模型和控制器我加入它
解决方案
<input type="text" class="form-control" id="email_id" name="email_id" value="<?= $user['email']; ?>" readonly>
您在控制器页面上通过 email_id 发送电子邮件节目和电子邮件。您可以在查看页面上使用:
<input type="text" class="form-control" id="email" name="email" value="<?= $user['email']; ?>" readonly>
<input type="hidden" class="form-control" id="email_id" name="email_id" value="<?= $user['email_id']; ?>">
然后在控制器页面上:
$emailpost = $this->input->post('email');
$idpost = $this->input->post('email_id');
$data = [
'namaFes' => $namaFes,
'daerah_id' => $daerah,
'tanggal' => $tanggal,
'deskripsi' => $desk,
'email_id' => $idpost,
'email' => $emailpost,
'image' => $image
];
请替换这些代码,您的问题就解决了。
推荐阅读
- angular - 重置行数据后,ag网格行数据正在更新
- android - 为什么我无法在 Xubuntu 上打开我的 Android Studio 项目?
- java - 如何导入我用java编写的类
- ios - 在 Swift / SwiftUI 中禁用向下滚动以关闭全屏封面
- ios - 使用命令行从 Flutter 生成 ipa 的任何方法?
- visual-studio-code - 在 vs-code 扩展中,如何将参数传递给 viewsWelcome.contents 中的命令
- java - Spring Boot 与 Datadog 的集成
- javascript - Web API 是 javascript 功能还是浏览器功能?
- reactjs - React-router URL 更改,但页面仍未更改
- installshield - Installshield 2015 关闭打开的浏览器