Login

05-27-2011, 01:58 PM

[eluser]Unknown[/eluser]
Hi all, I am just getting started with CI and am trying to create a customized online run-log for daily tasks. I need a way to populate an HTML text field value to the current time when the checkbox associated with that row is clicked. Additionally, I would like for that value to then be updated (stored) to the corresponding Time field in my database. Any ideas would be appreciated. Here is my code:

VIEW: dctasks_view.php

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Tasks</title>
</head>
<body>

<table bgcolor=62A9FF border=3 width=95% cellpadding=3 cellspacing=10>
<tr>
<th><BR><H1>TASKS</H1></th>
</tr>
</table>
<table bgcolor=BBDAFF border=1 width=95% cellpadding=3 cellspacing=5>
<tr>
<th></th>
<th>Time</th>
<th>TaskName</th>
</tr>

<tr>
<?php foreach($query as $row):?>
<td><input type="checkbox" name="<?echo $row->ID;?>"></td>
<td><input type="text" size=6 name="Time_<?echo $row->ID;?>" value="<?echo $row->Time;?>"></td>
<td><?echo $row->TaskName;?></td>
</tr>
<?php endforeach; ?>
</table>

</body>
</html>

MODEL: dctasks_model.php

<?php

class dctasks_model extends CI_Model {
function getData() {
$query=$this->db->query('SELECT * FROM tasks');
return $query->result();
}
}
?>

CONTROLLER: dctasks.php

<?php

class Dctasks extends CI_Controller {
function index() {
$this->load->model('dctasks_model');
$data['query'] = $this->dctasks_model->getData();
$this->load->view("dctasks_view", $data);
}
}
?>

05-27-2011, 05:07 PM

[eluser]theprodigy[/eluser]

Quote:Hi all, I am just getting started with CI and am trying to create a customized online run-log for daily tasks. I need a way to populate an HTML text field value to the current time when the checkbox associated with that row is clicked. Additionally, I would like for that value to then be updated (stored) to the corresponding Time field in my database. Any ideas would be appreciated.

First off, welcome to CodeIgniter!
Please remember when posting code, to surround it with the code tags. It makes it much easier to read ;-)

As for your problem, it sounds like you're looking for a javascript/ajax solution. This could easily be done using jQuery. jQuery makes it really easy to bind events (such as click events) and to make ajax calls to your server to save the data into the database.

Take a look at their docs page.

05-27-2011, 07:42 PM

[eluser]Unknown[/eluser]

Quote:Please remember when posting code, to surround it with the code tags. It makes it much easier to read ;-)

Sorry about that, I'll definitely try to do a better job in the future. :-)

Quote:As for your problem, it sounds like you're looking for a javascript/ajax solution. This could easily be done using jQuery. jQuery makes it really easy to bind events (such as click events) and to make ajax calls to your server to save the data into the database.

Take a look at their docs page.

Thank you for pointing me in the right direction... very much appreciated!