    <div class="row">
        <div class="col-12">
            <pre class="with-hljs"><code class="lang-php">&lt;?php
//$conn = new mysqli(&#039;localhost&#039;, &#039;root&#039;, &#039;&#039;, &#039;fsib24&#039;);

if ($conn-&gt;connect_error) {
    die(&quot;connection failed :&quot; . $conn-&gt;connect_error);
}

$br_sql = &#039;&#039;;
if (isset($_POST[&#039;br_search_btn&#039;])) {

    $br_zone_name = $conn-&gt;real_escape_string($_POST[&#039;br_zone_name&#039;]);
    $br_name = $conn-&gt;real_escape_string($_POST[&#039;br_name&#039;]);

    $br_sql = &quot;select * from location where type=&#039;branch&#039;&quot;;

    if ((!empty($br_zone_name)) and (empty($br_name))) {
        $br_sql .= &quot; and zone_name =&#039;&quot; . $br_zone_name . &quot;&#039;&quot;;
    } else if ((!empty($br_zone_name)) and (!empty($br_name))) {
        $br_sql .= &quot; and br_name =&#039;&quot; . $br_name . &quot;&#039; and br_name =&#039;&quot; . $br_name . &quot;&#039;&quot;;
    } else if ((empty($br_zone_name)) and (!empty($br_name))) {
        $br_sql .= &quot; and br_name =&#039;&quot; . $br_name . &quot;&#039;&quot;;
    }
    
    // print_r($br_sql);

}

$atm_sql = &#039;&#039;;
if (isset($_POST[&#039;atm_search_btn&#039;])) {

    // for atm division is zone
    $atm_zone_name = $conn-&gt;real_escape_string($_POST[&#039;atm_zone_name&#039;]);
    $atm_name = $conn-&gt;real_escape_string($_POST[&#039;atm_name&#039;]);

    $atm_sql = &quot;select * from location where type=&#039;atm&#039;&quot;;
    

    if ((!empty($atm_zone_name)) and (empty($atm_name))) {
        $atm_sql .= &quot; and zone_name =&#039;&quot; . $atm_zone_name . &quot;&#039;&quot;;
    } else if ((!empty($atm_zone_name)) and (!empty($atm_name))) {
        $atm_sql .= &quot; and br_name =&#039;&quot; . $atm_name . &quot;&#039; and zone_name =&#039;&quot; . $atm_zone_name . &quot;&#039;&quot;;
    } else if ((empty($atm_zone_name)) and (!empty($atm_name))) {
        $atm_sql .= &quot; and br_name =&#039;&quot; . $atm_name . &quot;&#039;&quot;;
    }
    // $result=$conn-&gt;query($atm_sql);
    // print_r($atm_sql);
}

$crm_sql = &#039;&#039;;
if (isset($_POST[&#039;search_btn&#039;])) {

    // for atm division is zone
    $zone_name = $conn-&gt;real_escape_string($_POST[&#039;zone_name&#039;]);
    $crm_name = $conn-&gt;real_escape_string($_POST[&#039;crm_name&#039;]);

    $crm_sql = &quot;select * from location where type=&#039;CRM&#039;&quot;;

    
    if ((!empty($zone_name)) and (empty($crm_name))) {
        $crm_sql .= &quot; and zone_name =&#039;&quot; . $zone_name . &quot;&#039;&quot;;
    } else if ((!empty($zone_name)) and (!empty($crm_name))) {
        $crm_sql .= &quot; and br_name =&#039;&quot; . $crm_name . &quot;&#039; and zone_name =&#039;&quot; . $zone_name . &quot;&#039;&quot;;
    } else if ((empty($zone_name)) and (!empty($crm_name))) {
        $crm_sql .= &quot; and br_name =&#039;&quot; . $crm_name . &quot;&#039;&quot;;
    }
    
}

?&gt;</code></pre>        </div>
    </div>