I am origination a website and i have a duty to register clients, and i
need to place an choice to select from a database on a dropdown and
afterwards it is sent to a users table, i am removing 2 erros atm and i
can't find a solution.This is my Model:class Home extends CI_Model{//SQL
duty get_prodTYPE(){
$this->db->select()->from('producttype')->where('active',1);
$query=$this->db->get(); relapse $query->result_array(); }
duty get_COUNTRY(){ $this->db->select()->from('pais');
$this->db->order_by("id_pais", "asc"); $result =
$this->db->get('pais'); $resultado = array();
if($result->num_rows() > 0){ $resultado[''] = 'please select';
foreach($result->result_array() as $row){
$resultado[$row['id_pais']] = $row['Pais']; } }
relapse $resultado; }Then i have a large record where this is a sure
partial for registeringThis is my Controller:function register(){
if(!$this->session->userdata('userID')){
$data['prodTYPE']=$this->home->get_prodTYPE();
$data['info']=$this->home->get_info();
$data['country']=$this->home->get_COUNTRY(); //validacao
$config=array( array(
'field'=>'username', 'label'=>'Username',
'rules'=>'trim|required|is_unique[users.username]|callback_min_lenght_3'
), array(
'field'=>'password', 'label'=>'Password',
'rules'=>'trim|required|callback_min_lenght_6' ),
array( 'field'=>'password2',
'label'=>'Password de Confirmação',
'rules'=>'trim|required|matches[password]' ),
array( 'field'=>'email',
'label'=>'Email',
'rules'=>'trim|required|is_unique[users.email]|valid_email'
), array( 'field'=>'name',
'label'=>'Nome',
'rules'=>'trim|required|callback_username_check|callback_min_lenght_3'
), array( 'field'=>'contact',
'label'=>'Contacto',
'rules'=>'trim|required|numeric|callback_min_lenght_9' ),
array( 'field'=>'address',
'label'=>'Morada',
'rules'=>'trim|required|callback_adress_check|callback_min_lenght_9'
), array(
'field'=>'postalCODE', 'label'=>'Codigo Postal',
'rules'=>'trim|required|numeric]|callback_min_lenght_4'
), array(
'field'=>'postalCODE2', 'label'=>'Codigo Postal',
'rules'=>'trim|required|numeric|callback_min_lenght_3'
), array( 'field'=>'city',
'label'=>'Localidade',
'rules'=>'trim|required|callback_min_lenght_3|callback_city_check'
), array(
'field'=>'taxpayerNUMBER', 'label'=>'N.º Contribuinte',
'rules'=>'trim|required|numeric|callback_min_lenght_9'
), );
$this->form_validation->set_rules($config);
if($this->form_validation->run() == FALSE){//erro
$data['errors']=validation_errors(); } else {//registo
$data=array( 'username'=>$_POST['username'],
'userTYPE'=>'user',
'password'=>sha1($_POST['password']),
'email'=>$_POST['email'],
'active'=>$_POST['newsletter']==null?0:1,
'name'=>$_POST['name'], 'contact'=>$_POST['contact'],
'country'=>$_POST['country'],
'address'=>$_POST['address'],
'postalCODE'=>$_POST['postalCODE'],
'postalCODE2'=>$_POST['postalCODE2'],
'city'=>$_POST['city'],
'taxpayerNUMBER'=>$_POST['taxpayerNUMBER']
); $userid = $this->user->create_user($data);
$data_init=array( 'userID'=>$userid['userID'],
'situation'=>0 );
$this->user->init_shop($data_init);//comecar encomendas
$this->session->set_userdata('userID',$userid['userID']);
$this->session->set_userdata('userTYPE',$userid['userTYPE']);//userTYPE
$this->session->set_userdata('userNAME',$userid['username']);
$this->session->set_userdata('newsletter',$_POST['newsletter']==null?0:1);
redirect(base_url().'/index.php/emails/email_to/'.$userid['userID']);
} $data['page']="#fragment-3";
$this->load->view('header',$data);
$this->load->view('login',$data); $this->load->view('footer');
} else { redirect(base_url().'/index.php/'); }}Finnaly
i have a View:
No comments:
Post a Comment