<?php session_start();
include('includes/function_db.php');
$cdb=new control_db();
switch ($_POST['form_action']){
    case 'reuser':
       // print_r($_POST);
        //session_destroy();
        unset($_POST['form_action']);
        $sql="select member.* ";
		$sql .=" ,member_type.name as utitle, member_type.status as sts ";
		$sql .=" from member ";
		$sql .=" inner join member_type on member.member_type_id=member_type.id ";
		$sql .=" where member.id=:user_id";
		$query=$cdb->conn->prepare($sql);
		try{
			$query->execute($_POST);
			$data=$query->fetch(PDO::FETCH_ASSOC);
			$json_data['utid']=$data['member_type_id'];
			$json_data['status']=$data['status'];
            foreach($data as $key=>$value){
                $_SESSION[$key]=$value;
                if($key=='member_type_id'){
                    if($value=='9'){
                        $_SESSION['user_type_it']='programer';
                    }
                }
            }
			}catch(PDOException $er){
			echo 'Error :'.$er->getMessage();
		}
    break;
    case 'sel_user':
        //print_r($_POST);
        $sql="select prefix_id as id, prefix_name as name ";
        $sql .=" from prefix ";
        $query=$cdb->conn->prepare($sql);
		try{
			$query->execute();
			while($data=$query->fetch(PDO::FETCH_ASSOC)){
                $prefix[$data['id']]=$data['name'];
			}
			}catch(PDOException $er){
			echo 'Error :'.$er->getMessage();
		}
        unset($_POST['form_action']);
        $sql="select id,prefix_id,name,surname ";
        $sql .=" from member ";
        $sql .=" where member_type_id=:user_type_it and status='1' ";
		$query=$cdb->conn->prepare($sql);
		try{
			$query->execute($_POST);
			$count = $query->rowCount();
			$i=1;
			while($data=$query->fetch(PDO::FETCH_ASSOC)){
				foreach($data as $key=>$value){
                    if($key=='prefix_id'){
                        $json_data[$i]['prefix']=$prefix[$value];
                    }
					$json_data[$i][$key]=$value;
				}
				++$i;
			}
			}catch(PDOException $er){
			echo 'Error :'.$er->getMessage();
		}
		$json=json_encode($json_data);
		echo $json;		
    break;
}
?>