Skip to main content

Membuat Advanced Search

    <!-- form advanced search -->
    <form name="form1" method="get" action="">
    nama : <input type="text" name="nama" id="nama"/> <br/>
    nip : <input type="text" name="nip" id="nip"/> <br/>
    lokasi_kerja : <input type="text" name="lokasi_kerja" id="lokasi_kerja"/> <br/>
    <br/><input type="submit" value="Search" name="search"/>
    </form>
    <!-- menampilkan hasil pencarian -->
    <?php
    if(isset($_GET['search'])){
        $mysqli = new mysqli("localhost", "root", "","simpeg");
        $nama = $_GET['nama'];
        $nip = $_GET['nip'];
        $lokasi_kerja = $_GET['lokasi_kerja'];
        $sql = "select * from tbdos where nama like '%$nama%' and
        nip like '%$nip%' and lokasi_kerja like '%$lokasi_kerja%' ";       
        $result = $mysqli->query($sql);
        if ($result->num_rows > 0){
            ?>
            <table>
                <tr>
                    <td>nama</td>
                    <td>nip</td>
                    <td>lokasi_kerja</td>
                    <td>Alamat</td>
                </tr>
                <?php
                while($row = mysqli_fetch_array($result)){?>
                <tr>
                    <td><?php echo $row['nama'];?></td>
                    <td><?php echo $row['nip'];?></td>
                    <td><?php echo $row['lokasi_kerja'];?></td>
                </tr>
                <?php }?>
            </table>
            <?php
        }else{
            echo 'Data not found!';
        }
    }
    ?>

Comments

Post a Comment

Popular posts from this blog

Menggenerate nomor id

<?php //config $database = "dopo"; $tabel = "po"; $kolom_generate ="id"; $kolom_referensi = "id"; /* Database connection start */ $servername = "localhost"; $username = "root"; $password = ""; $dbname = $database; $mysqli = mysqli_connect($servername, $username, $password, $dbname) or die("Connection failed: " . mysqli_connect_error()); $q1 = "select * from $tabel order by $kolom_referensi DESC"; /* Database connection end */ echo '<table>'; // connect to the database // number of results to show per page $per_page = 10000; // figure out the total pages in the database if ($result = $mysqli->query($q1)) { if ($result->num_rows != 0) { $total_results = $result->num_rows; // ceil() returns the next highest integer value by rounding up value if necessary $total_pages = ceil($total_results / $per_page); // check if the 'page' variab...
Post a Comment
Read more

Membuat Codeigniter PDF di CPANEL

1. Download FPDF dan copykan di folder application/thirdparty/pdf/ 2. Buat file Fpdf_gen.php di libraries. <?php if ( ! defined('BASEPATH')) exit('No direct script access allowed'); class Fpdf_gen { public function __construct() {  require_once APPPATH.'third_party/fpdf/fpdf-1.8.php'; define('FPDF_FONTPATH', APPPATH.'third_party/fpdf/font/'); $pdf = new FPDF(); $pdf->AddPage(); $CI =& get_instance(); $CI->fpdf = $pdf; } public function Footer() { $this->fpdf->SetY(-15); $this->fpdf->SetFont('Arial','I',8); $this->fpdf->SetTextColor(128); $this->fpdf->Cell(0,10,'Page ',0,0,'C'); } } 3. Buat file pdf.php di controller <?php if ( ! defined('BASEPATH')) exit('No direct script access allowed'); defined('BASEPATH') OR exit('No direct script access allowed'); class Pdf extends CI_Controller {   public f...
Post a Comment
Read more

Nusoap Web Service

hellowsdl.php ---> di server <?php // Pull in the NuSOAP code require_once('lib/nusoap.php'); // Create the server instance $server = new soap_server(); // Initialize WSDL support $server->configureWSDL('hellowsdl', 'urn:hellowsdl'); // Register the method to expose $server->register('hello',                // method name     array('name' => 'xsd:string'),        // input parameters     array('return' => 'xsd:string'),    // output parameters     'urn:hellowsdl',                    // namespace     'urn:hellowsdl#hello',                // soapaction     'rpc',       ...
Post a Comment
Read more