Login

06-05-2008, 12:03 PM

[eluser]ealonw[/eluser]
Hey CI's!!

Im having problems creating an update and delete function... Take look at my controller and view files and see if you can spot the errors for me..

Here are the problems:

1. the EDIT link doesnt populate the view form 'update_contact_view'
2. the DELETE removes all entries in database and NOT the selected entry... so if you are
interested in wiping out your database you can definitely use this code.. LOL!

Any brains out there that can help me correct the syntax?

*******CONTROLLER-->Contact**********
function update()
{

$data = array(

$this->input->post('fname') => $fname,
$this->input->post('lname') => $lname,
$this->input->post('email') => $email,
$this->input->post('comment') => $comment,

);

$this->db->where('fname', $fname);
$this->load->view('update_contact_view');
}

function delete()
{
$this->db->delete('usercomment', array('id' => $id));
// Produces: DELETE FROM usercomment WHERE id = $id

}

}

*********VIEW-->update_contact_view.php**********
<HTML>
<HEAD>
<TITLE>Update</TITLE>
</HEAD>
<BODY>

<?php echo form_open('contact/update'); ?>
<table border="0">
<tr><td>First Name:</td><td>
<input type="text" name="fname" maxlength="20" value="<? echo "$fname"; ?>">
</td></tr>
<tr><td>Last Name:</td><td>
<input type="text" name="lname" maxlength="20" value="<? echo "$lname"; ?>">
</td></tr>
<tr><td>Email:</td><td>
<input type="text" name="email" maxlength="50" value="<? echo "$email"; ?>">
</td></tr>
</table>
<br><br>
<textarea name="comment" cols="40" rows="5" value="<? echo "$comment"; ?>">
</textarea><br><br>
<input type="submit" name="submit" value="submit">
</form>
<br>
<br>
<DIV ALIGN=CENTER>

</form>
</DIV>
</BODY>
</HTML>