<?php
/*nrbname nrbfather nrbmother nrbdob nrbaddress nrbgender nrboccp

nrbmbl nrbmail nrbnidno nrbpass nrbpassno nrbissuedt nrbissueplc

nrbexdt nrbbank nrbbranch nrbaccno nrbrouting nomname nrbrlsn

deponame depombl  depoamnt selbank 
   nrbnidimg nrbsignature nrbimg nrbpassimg nrbpermit nrbnomimg depositslip*/
 
                                 
session_start();
 $db = new mysqli("localhost", "easterns_eastern", "pass@7@8@9", "easterns_essl");

if (isset($_POST['submit'])){
    $nrbname=$_POST['nrbname'];
    $nrbfather=$_POST['nrbfather'];
    $nrbmother=$_POST['nrbmother'];
    $nrbdob=$_POST['nrbdob'];
    $nrbaddress=$_POST['nrbaddress'];
    $nrbgender=$_POST['nrbgender'];
    $nrboccp=$_POST['nrboccp'];
    $nrbmbl=$_POST['nrbmbl'];
    $nrbmail=$_POST['nrbmail'];
    $nrbnidno=$_POST['nrbnidno'];
    $nrbpass=$_POST['nrbpass'];
    $nrbpassno=$_POST['nrbpassno'];
    /*$nrbissuedt=$_POST['nrbissuedt'];*/
    $nrbissueplc=$_POST['nrbissueplc'];
    /*$nrbexdt=$_POST['nrbexdt'];*/
    $nrbbank=$_POST['nrbbank'];
    $nrbbranch=$_POST['nrbbranch'];
    $nrbaccno=$_POST['nrbaccno'];
    $nrbrouting=$_POST['nrbrouting'];
    $nomname=$_POST['nomname'];
    $nrbrlsn=$_POST['nrbrlsn'];
    $deponame=$_POST['deponame'];
    $depombl=$_POST['depombl'];
    $depoamnt=$_POST['depoamnt'];
    $selbank=$_POST['selbank'];

     
    $imgname = basename($_FILES["nrbnidimg"]["name"]);                
    $imgname2 = basename($_FILES["nrbsignature"]["name"]);
    $imgname3 = basename($_FILES["nrbimg"]["name"]);
    $imgname4 = basename($_FILES["nrbpassimg"]["name"]);
    $imgname5 = basename($_FILES["nrbpermit"]["name"]);
    $imgname6 = basename($_FILES["nrbnomimg"]["name"]);
    $imgname7 = basename($_FILES["depositslip"]["name"]);

    $target = "nrbbo/nid/";
    $target2 = "nrbbo/signature/";
    $target3 = "nrbbo/image/";
    $target4 = "nrbbo/passport/";
    $target5 = "nrbbo/workpermit/";
    $target6 = "nrbbo/nomimg/";
    $target7 = "nrbbo/depositslip/";

    $newname = $target.basename($_FILES["nrbnidimg"]["name"]);
    $newname2 = $target2.basename($_FILES["nrbsignature"]["name"]);
    $newname3 = $target3.basename($_FILES["nrbimg"]["name"]);
    $newname4 = $target4.basename($_FILES["nrbpassimg"]["name"]);
    $newname5 = $target5.basename($_FILES["nrbpermit"]["name"]);
    $newname6 = $target6.basename($_FILES["nrbnomimg"]["name"]);
    $newname7 = $target7.basename($_FILES["depositslip"]["name"]);

    $img_type = pathinfo($newname,PATHINFO_EXTENSION);
    $img_type2 = pathinfo($newname2,PATHINFO_EXTENSION);
    $img_type3 = pathinfo($newname3,PATHINFO_EXTENSION);
    $img_type4 = pathinfo($newname4,PATHINFO_EXTENSION);
    $img_type5 = pathinfo($newname5,PATHINFO_EXTENSION);
    $img_type6 = pathinfo($newname6,PATHINFO_EXTENSION);
    $img_type7 = pathinfo($newname7,PATHINFO_EXTENSION);
                                   
     
    if (move_uploaded_file($_FILES["nrbnidimg"]["tmp_name"], $newname)) {
      if (move_uploaded_file($_FILES["nrbsignature"]["tmp_name"], $newname2)) {
        if (move_uploaded_file($_FILES["nrbimg"]["tmp_name"], $newname3)) {
          if (move_uploaded_file($_FILES["nrbpassimg"]["tmp_name"], $newname4)) {
            if (move_uploaded_file($_FILES["nrbpermit"]["tmp_name"], $newname5)) {
              if (move_uploaded_file($_FILES["nrbnomimg"]["tmp_name"], $newname6)) {
                if (move_uploaded_file($_FILES["depositslip"]["tmp_name"], $newname7)) {
                      
                        

                    $sql = "INSERT INTO nrb_bo (nrbname, nrbfather, nrbmother, nrbdob, nrbaddress, nrbgender, nrboccp,  nrbmbl, nrbmail, nrbnidno, nrbpass, nrbpassno, nrbissueplc, nrbbank, nrbbranch, nrbaccno, nrbrouting, nomname, nrbrlsn, deponame, depombl, depoamnt, selbank, nrbnidimg, nrbsignature, nrbimg, nrbpassimg, nrbpermit, nrbnomimg, depositslip) VALUES ('$nrbname', '$nrbfather', '$nrbmother', '$nrbdob', '$nrbaddress', '$nrbgender', '$nrboccp', '$nrbmbl', '$nrbmail', '$nrbnidno', '$nrbpass', '$nrbpassno',  '$nrbissueplc', '$nrbbank', '$nrbbranch', '$nrbaccno', '$nrbrouting', '$nomname', '$nrbrlsn', '$deponame', '$depombl', '$depoamnt', '$selbank', '$imgname', '$imgname2', '$imgname3', '$imgname4', '$imgname5', '$imgname6', '$imgname7')";

                    $result = mysqli_query($db, $sql);
                    if($result){
                        echo "upload successful";
                    }else{
                        echo "upload failed1";
                    } 
              }      
            }
          }
        }
      }
    }
  }

       
}
?>


<!doctype html>
<html lang="en">
  <head>
    <title>Eastern Shares & Securities Ltd.</title>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">

    <link href="https://fonts.googleapis.com/css?family=Rubik:300,400,700|Oswald:400,700" rel="stylesheet">

    <link rel="stylesheet" href="fonts/icomoon/style.css">

    <link rel="stylesheet" href="css/bootstrap.min.css">
    <link rel="stylesheet" href="css/jquery.fancybox.min.css">
    <link rel="stylesheet" href="css/owl.carousel.min.css">
    <link rel="stylesheet" href="css/owl.theme.default.min.css">
    <link rel="stylesheet" href="fonts/flaticon/font/flaticon.css">
    <link rel="stylesheet" href="css/aos.css">

    <!-- MAIN CSS -->
    <link rel="stylesheet" href="css/style.css">
    
  </head>
  <body data-spy="scroll" data-target=".site-navbar-target" data-offset="300">

  <div id="overlayer"></div>
  <div class="loader">
    <div class="spinner-border text-primary" role="status">
      <span class="sr-only">Loading...</span>
    </div>
  </div>
  
  <div class="site-wrap"  id="home-section">

    <div class="site-mobile-menu site-navbar-target">
      <div class="site-mobile-menu-header">
        <div class="site-mobile-menu-close mt-3">
          <span class="icon-close2 js-menu-toggle"></span>
        </div>
      </div>
      <div class="site-mobile-menu-body"></div>
    </div>
   
    <div class="top-bar"> 
      <div class="container">
        <div class="row">
          <div class="col-12">
            <a href="#" class="text-white"> <span>Eastern Shares & Securities Ltd.</span></a>
            <div class="float-right col-sm-6 text-right">
            <a href="login.php" class="text-white"><span>Login</span></a>
            <span class="mx-md-2 d-inline-block"></span>
            <a href="https://www.bangladeshstockmarket.com/" target="_blank" class="text-white"><span>ITS Trade</span></a>
            </div>
          </div>          
        </div>       
      </div>
    </div>
      
    <header class="site-navbar js-sticky-header site-navbar-target" role="banner">
      <div class="container">
        <div class="row align-items-center position-relative">
            <div class="site-logo">
              <a href="index.php" class="text-black"><span class="text-primary"><img src="images/EASTERN-LOGO.jpg"></a>
            </div>
            <div class="col-12">
              <nav class="site-navigation text-right ml-auto " role="navigation">
              <!-- <nav class="site-navigation text-right ml-auto " role="navigation"> -->
                <ul class="site-menu main-menu js-clone-nav ml-auto d-none d-lg-block">
                <li><a href="#home-section" class="nav-link">Home</a></li>
                <li><a href="#market-info" class="nav-link">Market Info</a></li>
                <li><a href="#services" class="nav-link">Services</a></li>
                <li class="has-children">
                      <a href="#">Digital Booth</a>
                      <ul class="dropdown">
                        <li><a href="digiaddress.html">Address</a></li>
                        <li><a href="digiser.html">Services</a></li>
                        <li><a href="faq.html">FAQ</a></li>
                      </ul>
                  </li>
                <li><a href="ipo.html" class="nav-link">IPO</a></li>
                <li><a href="#contact" class="nav-link">Contact</a></li>
                <li class="has-children">
                  <a href="ipo.html" class="nav-link">Open Account</a>
                  <ul class="dropdown arrow-top">
                    <li><a href="single-bo.php" class="nav-link">Single BO</a></li>
                    <li><a href="jointbo.php" class="nav-link">Joint BO</a></li>
                    <li><a href="link-acc.php" class="nav-link">Link BO</a></li>
                    <li><a href="nrbacc.php" class="nav-link">NRB BO</a></li>
                  </ul>
                </li>
                <li class="has-children">
                  <a href="ipo.html" class="nav-link">Transaction</a>
                  <ul class="dropdown arrow-top">
                    <li><a href="widthdraw.php" class="nav-link">Withdrawl</a></li>
                    <li><a href="deposit.php" class="nav-link">Deposit</a></li>
                  </ul>
                </li>
              </ul>
              </nav>         
            </div>
          <div class="toggle-button d-inline-block d-lg-none"><a href="#" class="site-menu-toggle py-5 js-menu-toggle text-black"><span class="icon-menu h3"></span></a></div>
        </div>
      </div>    
    </header>    

    <div class="site-section-cover overlay inner-page bg-light" data-aos="fade">
      <div class="container">
        <div class="row align-items-center justify-content-center text-center">
          <div class="col-lg-10">

            <div class="box-shadow-content">
              <div class="block-heading-1">
                <h3><span class="d-block mb-3 text-white"  data-aos="fade-up">Open BO Account<span class="mx-2 text-primary">/</span> NRB Account</span></h3>
                <!--<h1 class="mb-4" data-aos="fade-up" data-aos-delay="100">IPO</h1>-->
              </div>
            </div>
          </div>
        </div>
      </div>
    </div> 
    <section class="bg-light" id="pricing-section">
      <div class="container">
        <div class="row bo-top-ten">
          <div class="col-md-12">
              <div class="col-md-12 bank-table">
                <div class="col-md-12 bank-table-header text-center" data-aos="fade">
                  <h3 class="section-title top-10-head">Deposit first for openning an account</h3>
                  <h5 class="section-title text-primary">Bank Acc. Details of Eastern Shares</h5>
                </div>
                  <div class="tab-content" id="myTabContent">
                  <div class="tab-pane fade show active" id="gainer" role="tabpanel" aria-labelledby="gainer-tab">
                    <table class="table table-bordered table-sm table-responsive-sm market-table">
                      <thead>
                        <tr>
                        <th>S.l</th>
                        <th>Bank Name</th>
                        <th>Account No.</th>
                        <th>Routing No.</th>
                        <th>Branch Name</th>
                        </tr>
                      </thead>
                      <tbody> 
                        <tr>
                          <th>1</th>
                          <td>Social Islami Bank Ltd.</td>
                          <td>0041360001962</td>
                          <td>195150131</td>
                          <td>Agrabad Branch</td>
                        </tr>
                        <tr>
                          <th>2</th>
                          <td>Shahjalal Islami Bank Ltd.</td>
                          <td>300112400000232</td>
                          <td>190150136</td>
                          <td>Agrabad Branch</td>
                        </tr>
                        <tr>
                          <th>3</th>
                          <td>Dutch-Bangla Bank Ltd.</td>
                          <td>2021200001752</td>
                          <td>090150131</td>
                          <td>Agrabad Branch</td>
                        </tr>
                      </tbody>
                    </table>
                  </div>
                </div>
                <div class="col-md-12 bank-table-header text-center" data-aos="fade">
                  <h5 class="section-title text-primary">bKash No. of Eastern Shares</h5>
                </div>
                <div class="tab-content" id="myTabContent">
                  <div class="tab-pane fade show active" id="gainer" role="tabpanel" aria-labelledby="gainer-tab">
                    <table class="table table-bordered table-sm table-responsive-sm market-table">
                      <thead>
                        <tr>
                        <th>S.l</th>
                        <th>Operator Name</th>
                        <th>Mobile No.</th>
                        </tr>
                      </thead>
                      <tbody> 
                        <tr>
                          <th class="bkash-data">1</th>
                          <td class="bkash-data">bKash</td>
                          <td class="bkash-data">01875006321</td>
                        </tr>
                      </tbody>
                    </table>
                  </div>
                </div>
              </div>
            <div class="row" id="faq-section">
              <div class="col-md-12" data-aos="fade">
                <h3 class="section-title top-10-head">Personal Information</h3>
              </div>
            </div>
            <form action="nrbacc.php" method="post" enctype="multipart/form-data">
              <div class="form-group">
                <label for="exampleInputEmail1">Full Name</label>
                <input type="text" class="form-control" name="nrbname" aria-describedby="emailHelp" placeholder="Same as NID/Birth Cert.">
              </div>
              <div class="form-group">
                <label for="exampleInputEmail1">Father's/Husband Full Nmae</label>
                <input type="text" class="form-control" name="nrbfather" aria-describedby="emailHelp" placeholder="Same as NID/Birth Cert.">
              </div>
              <div class="form-group">
                <label for="exampleInputEmail1">Mother's Full Name</label>
                <input type="text" class="form-control" name="nrbmother" aria-describedby="emailHelp" placeholder="Same as NID/Birth Cert.">
              </div>
              <div class="form-group">
                <label for="exampleInputEmail1">Date of Birth</label>
                <input type="text" class="form-control" name="nrbdob" aria-describedby="emailHelp" placeholder="YYYY/MM/DD">
              </div>
              <div class="form-group">
                <label for="exampleInputEmail1">Present Address</label>
                <input type="text" class="form-control" name="nrbaddress" aria-describedby="emailHelp" placeholder="Address">
              </div>
              <div class="form-group">
                <label for="exampleFormControlSelect1">Select Gender</label>
                <select class="form-control" name="nrbgender">
                  <option value="Male">Male</option>
                  <option value="Female">Female</option>
                  <option value="Others">Others</option>
                </select>
              </div>
              <div class="form-group">
                <label for="exampleInputEmail1">Occopation</label>
                <input type="text" class="form-control" name="nrboccp" aria-describedby="emailHelp" placeholder="Doctor/Engineer etc.">
              </div>
              <div class="form-group">
                <label for="exampleInputEmail1">Mobile</label>
                <input type="number" class="form-control" name="nrbmbl" aria-describedby="emailHelp" placeholder="01717000000">
              </div>
              <div class="form-group">
                <label for="exampleInputEmail1">Email</label>
                <input type="email" class="form-control" name="nrbmail" aria-describedby="emailHelp" placeholder="abcd1122@gmail.com">
              </div>
              <div class="form-group">
                <label for="exampleInputEmail1">NID/Birth Cert. No.</label>
                <input type="number" class="form-control" name="nrbnidno" aria-describedby="emailHelp" placeholder="21547841254123">
              </div>
              <div>
                <div class="form-group">
                  <label for="exampleFormControlFile1">Upload NID/Birth Cert. No.</label>
                  <input type="file" class="form-control-file" name="nrbnidimg">
                </div>
              </div>
              <div>
                <div class="form-group">
                  <label for="exampleFormControlFile1">Upload Signature</label>
                  <input type="file" class="form-control-file" name="nrbsignature">
                </div>
              </div>
              <div>
                <div class="form-group">
                  <label for="exampleFormControlFile1">Upload Passport Size Image</label>
                  <input type="file" class="form-control-file" name="nrbimg">
                </div>
              </div>
              <div class="form-group">
                <label for="exampleInputPassword1">Password</label>
                <input type="password" class="form-control" name="nrbpass" placeholder="Password">
              </div>
              <div class="row" id="faq-section">
                <div class="col-md-12" data-aos="fade">
                  <h3 class="section-title top-10-head">Passport Details</h3>
                </div>
              </div>
              <div class="form-group">
                <label for="exampleInputEmail1">Passport Number</label>
                <input type="number" class="form-control" name="nrbpassno" aria-describedby="emailHelp" placeholder="ESC12543">
              </div>
              
             <!--<div class="form-group">
                <label for="exampleInputEmail1">Date of Issue</label>
                <input type="text" class="form-control" name="nrbissuedt" aria-describedby="emailHelp" placeholder="DD/MM/YYYY">
              </div>-->
              <div class="form-group">
                <label for="exampleInputEmail1">Place of Issue</label>
                <input type="text" class="form-control" name="nrbissueplc" aria-describedby="emailHelp" placeholder="ESC12543">
              </div>
              <!--<div class="form-group">
                <label for="exampleInputEmail1">Expiry Date</label>
                <input type="text" class="form-control" name="nrbexdt" aria-describedby="emailHelp" placeholder="ESC12543">
              </div>-->
              <div class="form-group">
                <label for="exampleFormControlFile1">Upload Passport</label>
                <input type="file" class="form-control-file" name="nrbpassimg">
              </div>
              <div class="form-group">
                <label for="exampleFormControlFile1">Upload Work Permit Copy</label>
                <input type="file" class="form-control-file" name="nrbpermit">
              </div>
              <br>
              <div class="row" id="faq-section">
                <div class="col-md-12" data-aos="fade">
                  <h3 class="section-title top-10-head">Details of Your Bank In Bangladesh</h3>
                </div>
              </div>
              <br>
              <div class="form-group">
                <label for="exampleInputEmail1">Bank Name</label>
                <input type="text" class="form-control" name="nrbbank" aria-describedby="emailHelp" placeholder="Dutch Bangla Bank Ltd.">
              </div>
              <div class="form-group">
                <label for="exampleInputEmail1">Branch Name</label>
                <input type="text" class="form-control" name="nrbbranch" aria-describedby="emailHelp" placeholder="Agrabad">
              </div>
              <div class="form-group">
                <label for="exampleInputEmail1">Account No.</label>
                <input type="number" class="form-control" name="nrbaccno" aria-describedby="emailHelp" placeholder="a15874226584251">
              </div>
              <div class="form-group">
                <label for="exampleInputEmail1">Routing No.</label>
                <input type="number" class="form-control" name="nrbrouting" aria-describedby="emailHelp" placeholder="a15874226584251">
              </div>
              <div class="row" id="faq-section">
                <div class="col-md-12" data-aos="fade">
                  <h3 class="section-title top-10-head">Nominee Details</h3>
                </div>
              </div>
              <div class="form-group">
                <label for="exampleInputEmail1">Full Namme</label>
                <input type="text" class="form-control" name="nomname" aria-describedby="emailHelp" placeholder="Dutch Bangla Bank Ltd.">
              </div>
              <div class="form-group">
                <label for="exampleInputEmail1">Relationship with Account Holder</label>
                <input type="text" class="form-control" name="nrbrlsn" aria-describedby="emailHelp" placeholder="Same as NID/Birth Cert.">
              </div>
              <div class="form-group">
                <label for="exampleFormControlFile1">Upload Passport Size Image of Nominee</label>
                  <input type="file" class="form-control-file" name="nrbnomimg">
              </div>

              

              <div class="row" id="faq-section">
                <div class="col-md-12" data-aos="fade">
                  <h3 class="section-title top-10-head">Deposit Details</h3>
                </div>
              </div>
              <div class="form-group">
                <label for="exampleInputEmail1">Namme</label>
                <input type="text" class="form-control" name="deponame" aria-describedby="emailHelp" placeholder="Name">
              </div>
              <div class="form-group">
                <label for="exampleInputEmail1">Mobile No:</label>
                <input type="number" class="form-control" name="depombl" aria-describedby="emailHelp" placeholder="01813000000">
              </div>
              <div class="form-group">
                <label for="exampleInputEmail1">Deposited Amount</label>
                <input type="number" class="form-control" name="depoamnt" aria-describedby="emailHelp" placeholder="Account opening fee: 450">
              </div>
              <div class="form-group">
                <label for="exampleFormControlSelect1">Select Bank/bKash</label>
                <select class="form-control" name="selbank">
                  <option value="SIBL">Social Islami Bank Ltd.</option>
                  <option value="SJIBL">Shahjalal Islami Bank Ltd.</option>
                  <option value="DBBL">Dutch-Bangla Bank Ltd.</option>
                  <option value="bkash">bKash</option>
                </select>
              </div>
              <div class="form-group">
                  <label for="exampleFormControlFile1">Upload Bank Deposit Slip</label>
                  <input type="file" class="form-control-file" name="depositslip">
                </div>
              <button type="submit" name="submit" class="btn btn-primary">Submit</button>
            </form>
          </div>
        </div>
      </div>   
    </section>

    <footer class="site-footer">
      <div class="container">
        <div class="row">
          <div class="col-md-4 aboutus">
            <div class="row">
              
                <h2 class="footer-heading mb-4">About Us</h2>
                <p>Eastern Shares and securities limited (ESSL) is one of the renowned brokerage houses in the capital market of Bangladesh. The company, being the 58th TREC Holder of the Chittagong Stock Exchange Limited, is operating its operation since 2005 with good reputation. </p>
              
            </div>
          </div>
          <div class="col-md-4">

                <h2 class="footer-heading mb-4">Important Link</h2>
                <ul class="list-unstyled">
                  <li><a href="#">Chittagong Stock Exchange Limited</a></li>
                  <li><a href="#">Dhaka Stock Exchange Limited</a></li>
                  <li><a href="#">Central Depository Bangladesh Ltd</a></li>
                  <li><a href="#">Tecurities and Exchange Commission</a></li>
                  <li><a href="#">Bangladesh Bank</a></li>
                </ul>
             
              
 
          </div>
          <div class="col-md-4 ml-auto">

            <div class="mb-5">
              <h2 class="footer-heading mb-4">CONTACT US</h2>  
              <p>Delwar Bhaban (2nd Floor), 104 Agrabad C/A, Chattogram</p>
              </div>
                <a href="#about-section" class="smoothscroll pl-0 pr-3"><span> 02333331744</span></a>
                <a href="#" class="pl-3 pr-3"><span> easternshareslimited@gmail.com</span></a>
                <a href="#" class="pl-3 pr-3"><span> www.easternshares.com.bd</span></a>
          
          </div>
        </div>
        <div class="row pt-5 mt-5 text-center">
          <div class="col-md-12">
            <div class="border-top pt-5">
            <p class="copyright"><small>
            <!-- Link back to Colorlib can't be removed. Template is licensed under CC BY 3.0. -->
            Copyright &copy;<script>document.write(new Date().getFullYear());</script> Eastern Shares & Securities Limited. All Rights Reserved </a>
            <!-- Link back to Colorlib can't be removed. Template is licensed under CC BY 3.0. -->
            </small></p>
            </div>
          </div>
          
        </div>
      </div>
    </footer>

  <script src="js/jquery-3.3.1.min.js"></script>
  <script src="js/popper.min.js"></script>
  <script src="js/bootstrap.min.js"></script>
  <script src="js/owl.carousel.min.js"></script>
  <script src="js/jquery.sticky.js"></script>
  <script src="js/jquery.waypoints.min.js"></script>
  <script src="js/jquery.animateNumber.min.js"></script>
  <script src="js/jquery.fancybox.min.js"></script>
  <script src="js/jquery.easing.1.3.js"></script>
  <script src="js/aos.js"></script>
  
  <script src="js/main.js"></script>
    
  </body>
</html>