search

                        <div class="large-12 medium-12 small-12 cell">
                            <form action="lisensi.php" method="POST">
                            <div class="grid-x grid-margin-x">
                                <div class="large-6 medium-6 small-6 cell">
                                    <label><h6>Nomor lisensi</h6></label>
                                    <input class="login-box-input" type="text" name="license_number2" value="">
                                    <input class="login-box-input" type="hidden" name="license_status2" value="Aktif">
                                </div>
                                <div class="large-6 medium-6 small-6 search cell">
                                    <span><button class="posting" type="submit" name="cari" value="cari"><img src="../id/images/icons/20/search.png"></button></span> &nbsp;&nbsp;
                                </div>
                            </div>
                            </form>
                            <div class="large-12 medium-12 small-12 cell">
                                <?php
                                if(isset($_POST['cari'])){
                                    $pencarian="".$_POST['license_number2']."";
                                    $pencarian2="".$_POST['license_status2']."";
                                    $tw_vpn_license = $db->prepare("SELECT * FROM tw_vpn_license WHERE license_number LIKE :license AND license_status LIKE :status");
                                    $tw_vpn_license->BindParam(":license",$pencarian);
                                    $tw_vpn_license->BindParam(":status",$pencarian2);
                                    $tw_vpn_license->execute();
                                }
                                $no = 1;
                                    while($data = $tw_vpn_license->fetch()){
                                ?>
                                <div class="large-12 medium-12 small-12 cell">
                                    <?php if ($data['license_number'] == $pencarian) { ?>

                                        <div class="large-12 medium-12 small-12 cell">
                                            Nomor lisensi:
                                            <?php echo $data['license_number']; ?>
                                        </div>
                                        <div class="large-12 medium-12 small-12 cell">
                                            IP address:
                                            <?php $ip_server = $_SERVER['SERVER_ADDR']; ?>
                                            <?php if ($data['license_ip'] == $ip_server) { ?>
                                                <?php echo $data['license_ip']; ?>
                                            <?php } else { ?>
                                                IP address tidak sama
                                            <?php } ?>
                                        </div>

                                    <?php } else { ?>
                                        Tidak ditemukan
                                    <?php } ?>
                                </div>
                                <?php } ?>
                            </div>
                        </div>