Postingan lainnya
A Database Error Occurred Error Number: 1146 Table 'wpu_login.email' doesn't exist
Saya mengikuti tutorial dari #10 EDIT PROFILE - Membuat Sistem Login Lengkap dengan CODEIGNITER 3
udah mencari solusinhya tetapi tetap error. mohon bantuan nya
ini codingan file controler user.php
<?php
defined('BASEPATH') or exit('No direct script access allowed');
class user extends CI_Controller
{
public function __construct()
{
parent::__construct();
is_logged_in();
}
public function index()
{
$data['title'] = 'My Profile';
$data['user'] = $this->db->get_where('user', ['email' =>
$this->session->userdata('email')])->row_array();
echo ' Selamat Datang User ' . $data['user']['name'];
$this->load->view('templates/header', $data);
$this->load->view('templates/sidebar', $data);
$this->load->view('templates/topbar', $data);
$this->load->view('user/index', $data);
$this->load->view('templates/footer');
}
public function edit()
{
$data['title'] = 'Edit Profile';
$data['user'] = $this->db->get_where('user', ['email' => $this->session->userdata('email')])->row_array();
$this->form_validation->set_rules('name', 'Full Name', 'required|trim');
if ($this->form_validation->run() == false) {
$this->load->view('templates/header', $data);
$this->load->view('templates/sidebar', $data);
$this->load->view('templates/topbar', $data);
$this->load->view('User/edit', $data);
$this->load->view('templates/footer');
} else {
$name = $this->input->post('name');
$email = $this->input->post('email');
$this->db->set('name', $name);
$this->db->update('email', $email);
$this->db->update('user');
// cek jika ada gambar yang akan d upload
$upload_image = $_FILES['image']['name'];
if ($upload_image) {
$config['allowed_types'] = 'gif|jpg|png';
$config['max_size'] = '2048';
$config['upload_path'] = './assets/img/profile';
$config['max_width'] = '1024';
$config['max_height'] = '768';
$this->load->library('upload', $config);
$this->db->set('name', $name);
$this->db->update('email', $email);
$this->db->update('user');
if ($this->upload->do_upload('image')) {
$new_image = $this->upload->data('file_name');
$this->db->set('image', $new_image);
} else {
echo $this->upload->display_errors();
}
}
$this->session->set_flashdata('message', '<div class="alert alert-success" role="alert">
Profil berhasil di ubah</div>');
redirect('user');
}
}
}
ini file menu->edit.php
<!-- Begin Page Content -->
<div class="container-fluid">
<!-- Page Heading -->
<h1 class="h3 mb-4 text-gray-800"><?= $title; ?></h1>
<div class="rows">
<div class="col-lg-8">
<?= form_open_multipart('user/edit'); ?>
<div class="form-group row">
<label for="email" class="col-sm-2 col-form-label">Email</label>
<div class="col-sm-10">
<input type="text" class="form-control" name="email" id="email" value="<?= $user['email']; ?>"readonly>
</div>
</div>
<div class="form-group row">
<label for="name" class="col-sm-2 col-form-label">Nama Lengkap</label>
<div class="col-sm-10">
<input type="text" class="form-control" id="name" name="name" value=" <?= $user['name']; ?>">
<?= form_error('name', '<small class="text-danger pl-3">', '</small>'); ?>
</div>
</div>
<div class="form-group row">
<div class="col-sm-2">Foto</div>
<div class="col-sm-10">
<div class="row">
<div class="col-sm-7">
<img id="output" src="<?= base_url('assets/img/profile/') . $user['image']; ?>" alt="" class="img-thumbnail">
</div>
<div class="col-sm-7">
<div class="custom-file">
<input type="file" accept="image/*" onchange="loadFile(event)" class="custom-file-input" id="image" name="image" for="image">
<label class="custom-file-label" for="image">Choose file</label>
</div>
</div>
</div>
</div>
</div>
<div class="form-group row justify-content-end">
<div class="col-sm-10">
<button type="submit" class="btn btn-primary">Edit</button>
</div>
</div>
</form>
</div>
</div>
</div>
<!-- /.container-fluid -->
</div>
<!-- End of Main Content -->
ini database wpu-login
Capture.PNG
Mohon bantuan nya ....
terima kasih
1 Jawaban:
Jawaban Terpilih
<div>oh iya udah solved<br>masalahnya<br><br>$this->db->update('email',$email);<br>diganti jadi<br>$this->db->where('email',$email);<br><br></div>