public function registerAction(){
            if ( $this->request->isPost() ){
                $usernamel = $this->request->getPost("username") ;
                $passwordl = $this->request->getPost("password") ;
                $email = $this->request->getPost("email") ;
                $pnumber = $this->request->getPost("pnumber") ;
                $fname = $this->request->getPost("fname") ;
                $lname = $this->request->getPost("lname") ;
                $gender = $this->request->getPost("gender") ;
                $dob = $this->request->getPost("dob") ;
                $homeadd = $this->request->getPost("homeadd") ;
                $workadd = $this->request->getPost("workadd") ;
                $cid = (string)rand(100000,999999);
                $balance = 0;

                $this->response->redirect('login') ;
                $servername = "localhost";
                $username = "root";
                $password = "";
                $dbname = "mydb";
                $conn = new mysqli($servername, $username, $password, $dbname);

                $sql = "INSERT INTO customers VALUES ('$cid','$fname','$lname','$dob','$gender','$pnumber','$homeadd','$workadd','$usernamel','$passwordl','$email','$balance')";
                $conn->query($sql);
                }
            }