I have two table 'login' and 'profile'. login table contains user_id, username, password, type. profile table contains profile_id, user_id, name, address, phone_no,email,status,pancardno,gender,birthday,joiingdate,endingdate. Here i have use user_id as reference key.Form contains username,password,type,name,address,phone number. So how can i insert username,password,type in 'login' table and ohter field in profile table in Zend Framework.
Here is my controller code.
include_once(APPLICATION_PATH.'/modules/admin/models/DbTable/Login.php');
public function emppostAction()
{
$session=new Zend_Session_Namespace();
if(isset($session->id))
{
$this->view->name="<b>".$session->name."</b>";
$this->render('employee');$data= new Model_DbTable_Login(); if($this->getRequest()->isPost()) { $un=$this->getRequest()->getPost('un'); $name=$this->getRequest()->getPost('name'); $bday=$this->getRequest()->getPost('bday'); $bmnth=$this->getRequest()->getPost('bmonth'); $byear=$this->getRequest()->getPost('byear'); $bdate=$byear."-".$bmnth."-".$bday; $jday=$this->getRequest()->getPost('jday'); $jmnth=$this->getRequest()->getPost('jmonth'); $jyear=$this->getRequest()->getPost('jyear'); $jdate=$jyear."-".$jmnth."-".$jday; $eday=$this->getRequest()->getPost('eday'); $emnth=$this->getRequest()->getPost('emonth'); $eyear=$this->getRequest()->getPost('eyear'); $edate=$eyear."-".$emnth."-".$eday; $phoneno=$this->getRequest()->getPost('phoneno'); $add=$this->getRequest()->getPost('add'); $qf=$this->getRequest()->getPost('qf'); $jod=$this->getRequest()->getPost('jod'); $email=$this->getRequest()->getPost('email'); $pwd=$this->getRequest()->getPost('pwd'); $gn=$this->getRequest()->getPost('gender'); $ms=$this->getRequest()->getPost('ms'); $desg=$this->getRequest()->getPost('desig'); $status=$this->getRequest()->getPost('status'); $pan=$this->getRequest()->getPost('pancard'); $insert=$data-> >insertData($un,$pwd$name,$bdate,$phoneno,$add,$qf,$jdate,$edate,$gn,$ms,$desg,$email,$pan,>$status); $this->_helper->redirector('viewemp', 'Leave'); exit; } } else { $this->_helper->redirector('login','index'); }}
In model i have
class Model_DbTable_Login extends Zend_Db_Table_Abstract
{
public function insertData($un,$pwd){
$data = array(
'username'=> $un,
'password'=> $pwd
);
$data2 = array( 'name'=> $name, 'birthdate'=> $bdate, 'phoneno'=> $phoneno, 'address'=> $add, 'qualification'=> $qf, 'joiningdate'=> $jdate, 'endingdate'=> $edate, 'gender'=> $gn, 'maritalstatus'=> $ms, 'designation'=> $desg, 'email'=> $email, 'pancardno'=>$pan, 'status'=> $status );try{ //here i m inserting data in login table. $result=$this->insert($data); // now here i want to insert data in profile table $profile=$this->insert($data2) }catch(exception $e){
echo "
".$e;exit;
}
}
So how to insert data in profile table while inserting data in login table?
loginandprofile1:1? If so, wouldn't it be more logical to merge them in this case?