I'm new in php. I'm doing a project on online bus ticket system.
In a part of the system i want to update a table of database. At first i want to display all the rows of the table which i have done in index method. When a row is selected it's attribute value(which is primary key) is caught in 'edit schedule' method. This value is saved in the class variable attr_value. There I call another view to receive updated information. From that view the info's are passed to 'e_schedules' method by form. But there the value of class variable attr_value is reset to default value. But I want the value saved in 'edit_schedule' method. How can i do it?
controller class
<?php
//$flag_edit_schedule = 1 ;
class edit_schedule extends CI_Controller {
//public $flag_edit_schedule = 1 ;
public $attr_value=1;
protected $table= 'schedule';
function index() {
$data= array();
if($query = $this->database_model->get_records($this->table)){
$data['records']= $query;
}
$this->load->view('select_schedule_view',$data) ;
}
function e_schedules(){
//$table='schedule';
$attribute_name='schedule_no';
$attribute_value=$this->attr_value;
echo $this->attr_value;
$data = array(
'schedule_no' => $this->attr_value,
'bus_no' => $this->input->post('bus_no'),
'route_no' => $this->input->post('route_no'),
'start_time' => $this->input->post('start_time')
);
//$this->database_model->update_record($this->table,$attribute_name,$attribute_value,$data);
//redirect('/admin/admin_home');
echo $attribute_name;
}
function edit_schedules() {
$this->attr_value=$this->uri->segment(4) ;
echo $this->attr_value;
$this->load->view('edit_schedule_view');
}
}
select_schedule_view
<!DOCTYPE html>
<head>
<meta charset="utf-8">
<title></title>
<style>
table, th, td {
padding: 5px;
}
th,td {
text-align: center;
}
table {
border-spacing: 15px;
}
</style>
</head>
<body>
<h2>Select Schedule </h2>
<table style="width:75%">
<tr>
<th> bus_no </th>
<th> route_no </th>
<th> time </th>
</tr>
<?php if(isset($records)) : foreach($records as $rows) : ?>
<tr>
<td><?php echo anchor("admin/edit_schedule/edit_schedules/$rows->schedule_no", $rows->bus_no); ?></td>
<td> <?php echo $rows->route_no?> </td>
<td> <?php echo $rows->start_time ?></td>
</tr>
<?php endforeach; ?>
<?php else: ?>
<h2> No records were returned </h2>
<?php endif; ?>
</table>
</body>
edit_schedule_view
<!DOCTYPE html>
<head>
<meta charset="utf-8">
<title></title>
</head>
<body>
<h2> Edit Route </h2>
<?php echo form_open('admin/edit_schedule/e_schedules'); ?>
<p>
<label for="bus_no"> Enter Bus Number:</label>
<input type="text" name="bus_no" id="bus_no" />
</p>
<p>
<label for="route_no"> Enter Route Number:</label>
<input type="text" name="route_no" id="route_no" />
</p>
<p>
<label for="start_time"> Start Time:</label>
<input type="text" name="start_time" id="start_time" />
</p>
<p>
<input type="submit" value="Edit" />
</p>
<?php echo form_close(); ?>
<hr />
</body>
This is my first post. I have done this much by scrolling other questions and answer. But now i need a quick help because i am running short of time.
