+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Help with Update in CRUD. (/showthread.php?tid=28099)
Help with Update in CRUD. - El Forum - 03-01-2010
[eluser]HSKrustofsky[/eluser]
Well, I've pretty much got everything working in my CRUD. The only thing is with the update function. I know in editnews.php I need to have a value within the form, but everything I try to input never seems to bring up anything. Any help would be awesome.
Here is the code:
admin_model.php
Code:
<?php
class Admin_model extends Model {
function Admin() {
parent::Model();
}
function create($data) {
$this->db->insert('data', $data);
}
function retrieve() {
$query = $this->db->get('data');
return $query->result();
}
function update($data) {
$this->db->where('id', $this->uri->segment(3));
$this->db->update('data', $data);
}
function delete() {
$this->db->where('id', $this->uri->segment(3));
$this->db->delete('data');
}
}admin.php
Code:
<?php
class Admin extends Controller {
function Admin() {
parent::Controller();
}
function index() {
$data = array();
if($query = $this->admin_model->retrieve()) {
$data['records'] = $query;
}
$data['title'] = "Admin";
$this->load->view('panelview', $data);
}
function create() {
$data = array(
'title' => $this->input->post('title'),
'contents' => $this->input->post('contents')
);
$this->load->view('addnews');
if($_POST) {
$this->admin_model->create($data);
}
if($_POST != NULL) {
redirect('../admin/');
}
}
function delete() {
$this->admin_model->delete();
$this->index();
}
function update() {
$data = array(
'title' => $this->input->post('title'),
'contents' => $this->input->post('contents')
);$this->load->view('editnews', $data);
if($_POST) {
$this->admin_model->update($data);
}
if($_POST != NULL) {
redirect('../admin/');
}
}
}editnews.php
Code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html>
<head>
<title><?php echo $title; ?></title>
<meta http-equiv="Content-Type" content="text/html; charset-UTF-8">
</head>
<body>
<h1 align="center">Edit News</h1>
<table cellpadding="5px" cellspacing="0" border="1" bordercolor="#000" align="center">
<tr>
<td>
<?= form_open('../admin/update/') ?>
<ul>
<li>
<label>Title:</label>
</li>
<li>
<?= form_input('title') value ?>
</li>
<li>
<label>Content:</label>
</li>
<li>
<?= form_textarea('contents') ?>
</li>
<li>
<?= form_submit('', 'Submit') ?>
</li>
</ul>
<?= form_close() ?>
</td>
</tr>
</table>
</body>
</html>Help with Update in CRUD. - El Forum - 03-02-2010
[eluser]xeroblast[/eluser]
try this:
Code:
function update($data,$id) {
$this->db->where('id', $id);
$this->db->update('data', $data);
}Code:
if($_POST) {
$this->admin_model->update($data,$this->uri->segment(3));
}Help with Update in CRUD. - El Forum - 03-02-2010
[eluser]HSKrustofsky[/eluser]
Thanks for your help, but I did you what you said, and nothing. What could I have done wrong?
Help with Update in CRUD. - El Forum - 03-03-2010
[eluser]xeroblast[/eluser]
try to change this: <?= form_open('../admin/update/') ?>
to: <?= form_open('admin/update') ?>
Help with Update in CRUD. - El Forum - 03-03-2010
[eluser]HSKrustofsky[/eluser]
When I first did the form I did that, and it didn't work. I had to add the ../ in order for the page to read the cotnroller.
I was looking online and I think I have to set a value to the form, but can't seem to get anything to show up when I do. I also can't seem to get any information to change when I input new information in the fields.
Do you think this may be the issue?
Help with Update in CRUD. - El Forum - 03-03-2010
[eluser]wakey[/eluser]
<?= form_input('title') value ?>
Should the value be there?
Help with Update in CRUD. - El Forum - 03-03-2010
[eluser]HSKrustofsky[/eluser]
I had added a value, but when nothing work I started deleting them. I guess I didn't delete all of them. I'm pretty sure a value needs to be there. That's one of things I'm stuck on. All I need it to do is bring up that id's info so I can update whatever information comes up.
Thanks in advance for everyone's help.
Help with Update in CRUD. - El Forum - 03-03-2010
[eluser]wakey[/eluser]
If you need to retrieve data to be updated you will need to create a function to retrieve the data from the database and then echo this into the form in the editnews view - is this what you mean?
Help with Update in CRUD. - El Forum - 03-03-2010
[eluser]HSKrustofsky[/eluser]
Yes. That's exactly what I need to do.
Help with Update in CRUD. - El Forum - 03-04-2010
[eluser]xeroblast[/eluser]
i think this is the line where you got it wrong:
your controller:
Code:
function update() {
$data = array(
'title' => $this->input->post('title'),
'contents' => $this->input->post('contents')
);$this->load->view('editnews', $data);
if($_POST) {
$this->admin_model->update($data);
}
if($_POST != NULL) {
redirect('../admin/');
}
}your view:
Code:
<li>
<?= form_input('title') value ?>
</li>
<li>
<label>Content:</label>
</li>
<li>
<?= form_textarea('contents') ?>
</li>
<li>
<?= form_submit('', 'Submit') ?>
</li>you should do it like this:
controller:
Code:
function update($id) {
// this is where if the submit button is push
if ($_POST) {
$save = array(
'title' => $this->input->post('title'),
'contents' => $this->input->post('contents'),
);
$this->admin_model->update($save,$id); // use the model i created in my previous post
}
//this is where you load the data to view
$data['blah'] = $this->admin_model->get($id);
$this->load->view('editnews',$data);
}your view:
Code:
<?= form_open($this->uri->uri_string()) ?>
<li>
<?= form_input(array('name' => 'title', 'value' => $blah->title)) ?>
</li>
<li>
<label>Content:</label>
</li>
<li>
<?= form_textarea(array('name' => 'contents', 'value' => $blah->contents)) ?>
</li>
<li>
<?= form_submit('', 'Submit') ?>
</li>
<?= form_close() ?>your model should have this: to get a single row data...
Code:
function get($id) {
return $this->db->get_where('table',array('id' => $id))->row();
}