Kamis, 31 Maret 2016

JQuery Mobile With Sorting

For this time, I want to show you about the sorting on web. It was using selecting method I made. The software that I made was using Netbeans version 8.1. and the database I was using MySQL to store data. You can see that at below the codes of the web and a view form website sorting. It was very simple to flow the codes.
connecting code :
<?php
// Algoritma dan Pemrograman III, By.M.Ropianto, 2015
// Teknik Informatika - STT Ibnu Sina Batam
// Set up koneksi kedatabase sesuai dengan user id dan password aplikasi
define('MYSQL_HOST', 'localhost');
define('MYSQL_USER', 'root');
define('MYSQL_PASS', '');
define('MYSQL_DB', 'mypmb');
// If we fail to connect, we cant keep going, so we exit
$db = mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASS);
//$db=mysql_select_db("csci") or die(mysql_error());
if (!$db)
{
die('<br />Tidak Terhubung KeDatabase "' . MYSQL_HOST . '".');
}
else
{
//echo 'Connected to MySQL server ' . MYSQL_HOST . ' as user ' . MYSQL_USER .
'<br/>';
mysql_select_db(MYSQL_DB);
}
// Calls to MySQL functions go here...
?>
index codes :

<?php
include_once('koneksi.php'); //start of search
$a1 = isset($_REQUEST['a1']) ? $_REQUEST['a1'] : '';
$listGel = isset($_POST['listGel']) ? $_POST['listGel'] : '';
$listProd = isset($_POST['listProd']) ? $_POST['listProd'] : '';
$listSUjian = isset($_POST['listSUjian']) ? $_POST['listSUjian'] : '';

if ($a1 == "Search") {
    if ($listProd != "" && $listGel != "" && $listSUjian != "") {
        $sql = "SELECT * FROM tbl_identitas WHERE gelombang = '$listGel' AND prodi='$listProd' and ujian = '$listSUjian'";
    } elseif ($listProd != "" && $listGel != "") {
        $sql = "SELECT * FROM tbl_identitas WHERE gelombang = '$listGel' AND prodi='$listProd'";
    } elseif ($listProd != "" && $listSUjian != "") {
        $sql = "SELECT * FROM tbl_identitas WHERE prodi='$listProd' and ujian = '$listSUjian'";
    } elseif ($listGel != "" && $listSUjian != "") {
        $sql = "SELECT * FROM tbl_identitas WHERE gelombang = '$listGel' AND ujian = '$listSUjian'";
    } elseif ($listGel != "") {
        $sql = "SELECT * FROM tbl_identitas WHERE gelombang = '$listGel'";
    } elseif ($listProd != "") {
        $sql = "SELECT * FROM tbl_identitas WHERE prodi='$listProd'";
    } elseif ($listSUjian != "") {
        $sql = "SELECT * FROM tbl_identitas WHERE ujian = '$listSUjian'";
    } else {
        echo 'Please select the options';
    }

    if (!$q = mysql_query($sql)) {
        echo mysql_error();
    } elseif (mysql_num_rows($q) == 0) {
        echo "<center>Tidak ditemukan!!</center>";
    } else {
        $tsql = "SELECT FOUND_ROWS() as found";
        $qq = mysql_query($tsql);
        $rr = mysql_fetch_object($qq);
        $found_rows = $rr->found;
        $display_result = true;
    }
}
?>
<!DOCTYPE html>
<html>
    <head>
        <title> SORTING </title>
        <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
        <link rel="stylesheet" href="jqm/jquery.mobile-1.4.5.css" />
        <style>
            th {
    border-bottom: 1px solid #d6d6d6;
}
tr{
    background: #e9e9e9;
}
body{
    font-family: Helvetica;
}
i{
    font-size: 8pt;
}
tr:nth-child(even) {
    background: #e9e9e9;
}
</style>
        <script type="text/javascript" src="jq/jquery-2.2.0.js"></script>
        <script type="text/javascript" src="jqm/jquery.mobile-1.4.5.min.js"></script>
    </head>
    <body>
        <div data-role="page">
            <div data-role="header"><h1><center><b>WELCOME TO SORTINGSITE</b></center></h1></div>
            <br />
            <br />
            <div data-role="content">
                <form method="post" name="a1" action="index.php">
                    <div data-role="fieldcontain">
                        <div>
                        <label><b>Gelombang : </b></label>
                        <select name="listGel" >
                            <option value="">--Pilih--</option>
                            <?php
                            $listQuery = "select gelombang from tbl_identitas group by gelombang";
                            if ($gel = mysql_query($listQuery)) {
                                while ($row = mysql_fetch_object($gel)) {
                                    echo "<option value='$row->gelombang'>$row->gelombang</option>";
                                }
                            }
                            ?>
                        </select>
                        </div>
                        <br>
                        <div>
                    <label><b>Program Studi : </b></label>
                        <select name="listProd">
                            <option value="">--Pilih--</option>
                            <?php
                            $listQuery = "select prodi from tbl_identitas group by prodi";
                            if ($gel = mysql_query($listQuery)) {
                                while ($row = mysql_fetch_object($gel)) {
                                    echo "<option value='$row->prodi'>$row->prodi</option>";
                                }
                            }
                            ?>
                        </select></div>
                        <br>
                        <div>
                        <label><b>Status Ujian : </b></label>
                        <select name="listSUjian">
                            <option value="">--Pilih--</option>
                            <?php
                            $listQuery = "select ujian from tbl_identitas group by ujian";
                            if ($gel = mysql_query($listQuery)) {
                                while ($row = mysql_fetch_object($gel)) {
                                    echo "<option value='$row->ujian'>$row->ujian</option>";
                                }
                            }
                            ?>
                        </select></div>
                    <br>
                                <div data-role="button">
                                    <input type="submit" name="a1" align="center" value="Search" />
                                </div>   
                </form>

                <?php
                if (isset($display_result)) {
                    ?>
                    <br/><br/>
                    <h3 align="center" id="hasil">Entries Found: <?php echo $found_rows; ?></h3>
                    <table align="center" data-role="table" class="ui-responsive ui-shadow">
                    <!--<table align="center" cellpadding="2" cellspacing="0" border="1" >-->
                        <thead>
                        <tr>
                            <th align="center"><font color="black" size="2"><strong>GELOMBANG</strong></font>
                        </th>
                        <th align= "center" width="70"><font color="black" size="2"><strong>NAMA</strong></font>
                        </th>
                        <th align= "center" width="70"><font color="black" size="2"><strong>NAMA ORANG TUA PEREMPUAN</strong></font>
                        </th>
                        <th align= "center" width="70"><font color="black" size="2"><strong>NIK</strong></font>
                        </th>
                        <th align= "center" width="70"><font color="black" size="2"><strong>NO TELP</strong></font>
                        </th>
                        <th align= "center" width="70"><font color="black" size="2"><strong>EMAIL</strong></font>
                        </th>
                        <th align= "center" width="70"><font color="black" size="2"><strong>PRODI</strong></font>
                        </th>
                        <th align= "center" width="70"><font  color="black" size="2"><strong>STATUS</strong></font>
                        </th>
                        <th align= "center" width="70"><font color="black" size="2"><strong>STATUS UJIAN</strong></font>
                        </th>
                        </tr>
                        </thead>
                        <?php
                        while ($rs = mysql_fetch_object($q)) {
                            ?>
                        <tbody>
                            <tr>
                                <td><font color="black"><?php echo $rs->gelombang; ?></font>
                                </td>
                                <td align='center'><font color="black" ><?php echo $rs->nama; ?></font>
                                </td>
                                <td align='center'><font color="black" ><?php echo $rs->n_ibu; ?></font>
                                </td>
                                <td align='center'><font color="black"><?php echo $rs->nik; ?></font>
                                </td>
                                <td align='center'><font color="black"><?php echo $rs->no_telp; ?></font>
                                </td>
                                <td align='center'><font color="black"><?php echo $rs->email; ?></font>
                                </td>
                                <td align='center'><font color="black"><?php echo $rs->prodi; ?></font>
                                </td>
                                <td align='center'><font color="black"><?php echo $rs->status; ?></font>
                                </td>
                                <td align='center'><font color="black"><?php echo $rs->ujian; ?></font>
                                </td>
                            </tr>
                        </tbody>

                            <?php
                        }
                        ?>

                        <?php
                        while ($r = mysql_fetch_object($q)) {
                            echo "<tr>
    <td align='center'><font color='black' size='2'><b>$r->Nama</b></font>
    </td>
    </tr>";
                        }
                        ?>

                    </table>
                    <?php
                }
                ?>
            </div>
        </div>
            <div data-role="footer">
                <i><center>Copyright Zuliandri &copy; 2016</center></i>
            </div>
           
    </body>
</html>

Dosen Pengampuh Matakuliah
Nama : M. Ropianto, M.Kom
NIDN : 1028067804
Status : Doesn Tetap YAPISTA/stt Ibnu Sina
Pengampu Matakuliah : Pemograman Mobile Lanjutan
Diposting oleh di Tidak ada komentar:

Rabu, 16 Maret 2016

Jquery content hide and show instantaneously

on this tutorial I want to show you how to make some of content in my blog with method hide() and show() using jquery. You can take look below  screenshoot and the code.

Hide Method
On jquery hide method used for many programmer to hide their content on website. Their wrote their code on text editor they have, and putted hide method among their code as that I did it at bellow. You could see hide method on blocked with red thick character. 

Show Method
Opponent with method hide, Show method also many programmer used it to show their content on their website. Give the number on the method how long the elements can be showor hide. The both content will makes your website look likes beautifull. You can see Show method on blocked with black thick character.






 android

Dosen Pengampuh Matakuliah
Nama : M. Ropianto, M.Kom
NIDN : 1028067804
Status : Doesn Tetap YAPISTA/stt Ibnu Sina
Pengampu Matakuliah : Pemograman Mobile Lanjutan
Diposting oleh di Tidak ada komentar:
Langganan: Postingan (Atom)