Admin->Teachers: Remove subject

[zishan0215]

So lets discuss this here

[wadhwasahil]

public function view_teacher() { $this->data['page'] = 1; $this->data['name'] = $this->session->userdata('name'); $this->data['teacher_id'] = $this->input->post('teacher_id'); $array = array('teacher_id' => $this->data['teacher_id']); $this->data['teacher1']=$this->teacher_m->get_by($array,TRUE); $this->data['teacher2']=$this->subject_m->get_by($array); $this->data['subject_code'] = $this->input->post('subject_code'); $array=array("subject_code"=>$this->data['subject_code'],"teacher_id"=>0); $this->teacher_m->save($array); $this->load->view('admin/components/admin_header', $this->data); $this->load->view('admin/view_teacher_layout'); }

[zishan0215]

$array=array("subject_code"=>$this->data['subject_code'],"teacher_id"=>0); $this->teacher_m->save($array); // To insert new data OR $this->teacher_m->save($array, $id); //To update existing data with given id

[wadhwasahil]

yahi to kiya hai maine

[wadhwasahil]

public function view_teacher() { $this->data['page'] = 1; $this->data['name'] = $this->session->userdata('name'); $this->data['teacher_id'] = $this->input->post('teacher_id'); $array = array('teacher_id' => $this->data['teacher_id']); $this->data['teacher1']=$this->teacher_m->get_by($array,TRUE); $this->data['teacher2']=$this->subject_m->get_by($array); $this->data['subject_code'] = $this->input->post('subject_code'); $array=array("subject_code"=>$this->data['subject_code'],"teacher_id"=>0); $this->teacher_m->save($array); $this->load->view('admin/components/admin_header', $this->data); $this->load->view('admin/view_teacher_layout'); }

[zishan0215]

kya kar rahe ho ?

[zishan0215]

This is not the way to do it..

[wadhwasahil]

tumne bhi to same cheez likhi hai upar

[wadhwasahil]

$array=array("subject_code"=>$this->data['subject_code'],"teacher_id"=>0); $this->teacher_m->save($array);

[zishan0215]

firstly.. this query should only run when the admin clicks on the remove button.. secondly, what you are doing is insertion and not updation

[wadhwasahil]

so how to check if remove is clicked or not?

[zishan0215]

refer increment semester

[wadhwasahil]

ok

[wadhwasahil]

using &nbsp??

[zishan0215]

its just for space

[wadhwasahil]

$this->data['subject_code'] = $this->input->post('subject_code'); if($this->data['subject_code']){ $array=array('subject_code'=>$this->data['subject_code'],'teacher_id'=>0); $this->subject_m->save($array,$this->data['teacher_id']); }

[wadhwasahil]

ab theek hai??

[zishan0215]

nope...if condition is wrong

[wadhwasahil]

kya galat hai isme?

[zishan0215]

$array=array('teacher_id' => 0);

[zishan0215]

just use this

[wadhwasahil]

foreign key constraint hai

[zishan0215]

if condition galat hai tumhari.. pehle usko theek karo

[wadhwasahil]

pehle yeh batao ki subject table mein hum teacher_id=0 kaise kr sakte hain jab ki koi teacher ki teacher_id 0 nhi hai

[wadhwasahil]

delete hi krna padega

[zishan0215]

hai teacher id 0.. check the database

[wadhwasahil]

mere mein nhi hai

[wadhwasahil]

lol

[wadhwasahil]

aagaye??

[zishan0215]

haan

[wadhwasahil]

kaam ho gya

[wadhwasahil]

but ek error hai

[zishan0215]

kya

[wadhwasahil]

delete ho ja rhi hain

[zishan0215]

kya

[wadhwasahil]

wait main screen shot bhejta hoon

[wadhwasahil]

public function view_teacher() { $this->data['page'] = 1; $this->data['name'] = $this->session->userdata('name'); $this->data['teacher_id'] = $this->input->post('teacher_id'); $array = array('teacher_id' => $this->data['teacher_id']); $this->data['teacher1']=$this->teacher_m->get_by($array,TRUE); $this->data['teacher2']=$this->subject_m->get_by($array); $this->data['subject_code'] = $this->input->post('subject_code'); if(isset($_POST['subject_code'])){ $array=array('teacher_id'=>0); $this->subject_m->save($array,$this->data['subject_code']); } $this->load->view('admin/components/admin_header', $this->data); $this->load->view('admin/view_teacher_layout'); }

[wadhwasahil]

nowcheck

[zishan0215]

abhi bhi galat hai if condition

[wadhwasahil]

kya galata hai

[wadhwasahil]

maine net se dekhi hai

[zishan0215]

net se kyun dekh rahe ho.. code nahi dekh sakte ? keh raha hun increment waale main dekho kaise pata chal raha hai kab click kiya button ko

[wadhwasahil]

vo samajh nhi aaraha

[zishan0215]

if($this->input->post('submit')) { //code here }

[wadhwasahil]

bhai tum ajeeb ho

[wadhwasahil]

upar wala bhi same chhez krta hai

[zishan0215]

no

[wadhwasahil]

uss button ka naam remove hai

[wadhwasahil]

not submit

[wadhwasahil]

and uska name hai subject_code

[zishan0215]

karlo changes.. idea de raha hun tumhe