Welcome Guest, Not a member yet? Register   Sign In

hi i need help for that

i have a small project i need to bring data from DB and print it i in a table that is the code what wrong with that :

function viwe()
$user_id = $this->session->userdata('user_id');
//connect to DB
$sql = "SELECT
user_id= '$user_id'
$query = $this->db->query($sql);
if ($query->num_rows() == 0){
echo'no item in your list';
} else {
$row = $query->result();


and view:
<form method="POST" action="delete">
<table border='1'>
<tr><th>X</th> <th>Title</th> <th>Description</th><th>Status</th><th>Date</th><th>Action</th></tr>
&lt;?echo 'This Is The List Of Your Order';?&gt;
&lt;?echo "&lt;input type='checkbox' name=\"checked[]\" value=\"$row-&gt;todo_id\">";?&gt;
&lt;?echo $row->title?&gt;
&lt;?echo $description?&gt;
&lt;?echo $status?&gt;
&lt;?echo $update_date?&gt;
&lt;?echo "<a href=\"http://localhost/codeigniter/index.php/todo/to_edit\"> edit</a>" ;?&gt;

<tr><td>&lt;input type="submit" value="Delete Todo"&gt;</td>
<td align="center"><a href = http://localhost/codeigniter/index.php/todo/back>GO back</a></td></tr>

$data['row'] = $query->row();

thank you for that but i have many row in DB that code give me just last row

than you have to use $query->row() but then you also have to add a loop to your view file

thank you for that

Theme © iAndrew 2016 - Forum software by © MyBB