Wednesday, September 29

PHP : Dynamic Pagination [paginasi]

Paging ini diperlukan jika data yang ditampilkan sangat panjang akan dibagi menjadi beberapa halaman. Misalnya record data berjumlah 10000 maka jika ditampilkan sekali akan terlihat sangat panjang dan kurang menarik, maka dari itu paging diperlukan di sini, agar tampilan data dapat dibatasi.

langkah-langkahnya adalah sebagai berikut:
1. buat code php seperti di bawah ini

<?php

$paginationObj = new pagination(total_limit);
$limit = $paginationObj->paginationGetLimit();

mysql query(variable $limit goes here)

$paginationObj->paginationCreatePages();

?>



2. Buat Class Pagination

class pagination
{

private $max_rows = 30;//MAXIMUM NUMBER OF DISPLAYING ITEMS
private $max_num = 5;//MAXIMUM NUMBER OF NUMERIC LINKS
private $limit;
private $maxId;//TOTAL NUMBER OF ITEMS
private $lastpage;
private $page;
private $url;
private $match = "page=";


public function __construct($maxId = null)
{
if(!$maxId)
{
$this->maxId = 500;
}
else
{
$this->maxId = $maxId;
}
}


public function getPage()
{
return $this->page;
}


public function paginationGetLimit()
{
$this->page = isset($_GET['page']) ? strip_tags($_GET['page']) : 1;
$this->lastpage = ceil($this->maxId / $this->max_rows);
$this->page = (int)$this->page;

if($this->page < 1)
{
$this->page = 1;
}
elseif($this->page > $this->lastpage)
{
$this->page = $this->lastpage;
}

return ($this->limit = 'LIMIT ' .($this->page - 1) * $this->max_rows .',' .$this->max_rows);
}


public function paginationCreatePages()
{

$this->url = $_SERVER['REQUEST_URI'];//THE REQUESTED URL
$pos = strpos($this->url, $this->match);
.
echo "";
}


}


3. Buat CSS filenya


.pagination
{
width:100%;
margin-top:20px;
margin-left:10px;
clear:left
}

.pagination ul
{
list-style-type: none;
margin:0;
padding:0;
}

.pagination ul li
{
color:#666666;
float:left;
font: Eras Bold ITC;
font-size: 12px;
letter-spacing: .01em;
}

.pagination ul li a
{
color: #47809E;
display: block;
margin: 0 0.1em;
padding: 2px;
padding-left: 4px;
padding-right: 4px;
text-decoration: none;
}

li#f
{
background-color:#fff;
display: block;
margin: 0 0.1em;
padding: 2px;
padding-left: 4px;
padding-right: 4px;
text-decoration: none;
color:#666666;
}

.pagination ul li a:hover
{
text-decoration:underline;
}

jquery: Contoh Accordion Menggunakan JQuery

Unordered List with anchors and nested lists. Title 2 also demonstrates how to add a second level list.
Take a look at the source code to see how easy it's done!


<ul id="theMenu">
<li style="position: static;">
<h3 class="head"><a href="javascript:;">Title 1</a></h3>
<ul style="display: none;">
<li><a href="http://komputerbelajar.blogspot.com/">Content 1 1</a></li>
<li><a href="http://komputerbelajar.blogspot.com/">Content 1 2</a></li>
<li><a href="http://komputerbelajar.blogspot.com/">Content 1 3</a></li>
</ul>
</li>
<li>
<h3 class="head"><a href="javascript:;">Title 2</a></h3>
<ul style="display: none;">
<li><a href="http://komputerbelajar.blogspot.com/">Content 2 1</a></li>
<li><a href="http://komputerbelajar.blogspot.com/">Content 2 2</a></li>
<li><a href="http://komputerbelajar.blogspot.com/">Content 2 3</a></li>
</ul>
</li>
<li>
<h3 class="head"><a href="javascript:;">Title 3</a></h3>
<ul style="display: none;">
<li><a href="http://komputerbelajar.blogspot.com/">Content 3 1</a></li>
<li><a href="http://komputerbelajar.blogspot.com/">Content 3 2</a></li>
<li><a href="http://komputerbelajar.blogspot.com/">Content 3 3</a></li>
</ul>
</li>
<li>
<h3 class="head"><a href="javascript:;">Title 4</a></h3>
<ul style="display: none;">
<li><a href="http://komputerbelajar.blogspot.com/">Content 4 1</a></li>
<li><a href="http://komputerbelajar.blogspot.com/">Content 4 2</a></li>
<li><a href="http://komputerbelajar.blogspot.com/">Content 4 3</a></li>
</ul>
</li>
<li>
<h3 class="head"><a href="javascript:;">Title 5</a></h3>
<ul style="display: none;">
<li><a href="http://komputerbelajar.blogspot.com/">Content 5 1</a></li>
<li><a href="http://komputerbelajar.blogspot.com/">Content 5 2</a></li>
<li><a href="http://komputerbelajar.blogspot.com/">Content 5 3</a></li>
</ul>
</li>
</ul>



dowload source lengkap disini

Javascript: Download JQuery Plugin

* jQuery plugin: Accordion
* jQuery plugin: Autocomplete
* jQuery plugin: Message
* jQuery plugin: Password Validation
* jQuery plugin: Prettydate
* jQuery plugin: Tooltip
* jQuery plugin: Treeview
* jQuery plugin: Validation
* Wordpress Plugin: Comment Validation

source : Jquery Plugin

jQuery plugin: Accordion

This plugin creates an accordion menu. It works with nested lists, definition lists, or just nested divs. Options are available to specify the structure, if necessary, the active element (to display at first) and to customize animations. The navigation-option automatically activates a part of the accordion based on the current location (URL) of the page.

Current version: 1.6 (last standalone release, now part of jQuery UI)
Compressed filesize: 3829 bytes
License: MIT/GPL

Download

resource : Jquery Plugin

jQuery plugin: Treeview

Lightweight and flexible transformation of an unordered list into an expandable and collapsable tree, great for unobtrusive navigation enhancements. Supports both location and cookie based persistence.

Note as of April 2010: While the plugin still works as it is, it has some shortcomings, and not maintained anymore. There are now plenty of alternative jQuery tree plugins, like jsTree. Eventually there will be successor as part of jQuery UI.

Current version: 1.4
Compressed filesize: 3390 bytes
License: MIT/GPL
Tested in: Firefox 2, IE 6 & 7, Opera 9, Safari 3
Files: Download

source : Jquery plugin

Membuat Left Tree Menu dengan JQuery

















Tree Menu dengan jQuery akan terlihat lebih menarik dan memudahkan user dalam menuju link yang dipilih...

silahkan download source code disini

nah contoh pembuatannya adalah sebagai berikut:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Kota Di Indonesia</title>
<link type="text/css" rel="stylesheet" media="all" href="css/style.css" />
<script type="text/javascript" src="js/jquery.js"></script>
<script type="text/javascript">
<!--//--><![CDATA[//><!--
$(document).ready(function() {
$("#root ul").each(function() {$(this).css("display", "none");});
$("#root .category").click(function() {
var childid = "#" + $(this).attr("childid");
if ($(childid).css("display") == "none") {$(childid).css("display", "block");}
else {$(childid).css("display", "none");}
if ($(this).hasClass("cat_close")) {$(this).removeClass("cat_close").addClass("cat_open");}
else{$(this).removeClass("cat_open").addClass("cat_close");}
});
});
//--><!]]>
</script>
</head>
<body>
<h2>Kota di Indonesia</h2>
<div class="content">
<ul id="root" class="menu">
<li>
<a href='javascript:void(0);' childid = 'c_12' class='cat_close category'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</a>
<a href='javascript:void(0);'>Jawa Timur</a>
</li>
<ul id='c_12'></ul>
<li>
<a href='javascript:void(0);' childid = 'c_13' class='cat_close category'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</a>
<a href='javascript:void(0);'>Jawa Tengah</a>
</li>
<ul id='c_13'>
<li>
<a href='javascript:void(0);' class='product'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</a>
<a href='javascript:void(0);'>Semarang</a>
</li>
</ul>
<li>
<a href='javascript:void(0);' childid = 'c_8' class='cat_close category'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</a>
<a href='javascript:void(0);'>Jawa Barat</a>
</li>
<ul id='c_8'>
<li>
<a href='javascript:void(0);' childid = 'c_11' class='cat_close category'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</a>
<a href='javascript:void(0);'>Bandung</a>
</li>
<ul id='c_11'></ul>
<li>
<a href='javascript:void(0);' childid = 'c_10' class='cat_close category'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</a>
<a href='javascript:void(0);'>Cirebon</a>
</li>
<ul id='c_10'></ul>
<li>
<a href='javascript:void(0);' childid = 'c_9' class='cat_close category'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</a>
<a href='javascript:void(0);'>Indramayu</a>
</li>
<ul id='c_9'></ul>
</ul>
<li>
<a href='javascript:void(0);' childid = 'c_5' class='cat_close category'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</a>
<a href='javascript:void(0);'>Yogyakarta</a>
</li>
<ul id='c_5'>
<li>
<a href='javascript:void(0);' childid = 'c_7' class='cat_close category'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</a>
<a href='javascript:void(0);'>Jogja</a>
</li>
<ul id='c_7'>
<li>
<a href='javascript:void(0);' class='product'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</a>
<a href='javascript:void(0);'>Malioboro</a>
</li>
<li>
<a href='javascript:void(0);' class='product'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</a>
<a href='javascript:void(0);'>Kaliurang</a>
</li>
</ul>
</ul>
<li>
<a href='javascript:void(0);' childid = 'c_3' class='cat_close category'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</a>
<a href='javascript:void(0);'>Aceh</a>
</li>
<ul id='c_3'></ul>
<li>
<a href='javascript:void(0);' class='product'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</a>
<a href='javascript:void(0);'>Jambi</a>
</li>
<li>
<a href='javascript:void(0);' class='product'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</a>
<a href='javascript:void(0);'>Sumatera Barat</a>
</li>
<li>
<a href='javascript:void(0);' class='product'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</a>
<a href='javascript:void(0);'>Sumatera Utara</a>
</li>
<li>
<a href='javascript:void(0);' class='product'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</a>
<a href='javascript:void(0);'>Riau</a>
</li>
</ul>
</div>
</body>
</html>

Wednesday, September 22

Java : Koneksi Java ke MySQL

Assalamualaikum, setelah sekian lama nggak ngeblog, akhirnya hari ini saya akan mulai lagi.. nah untuk yang akan saya bahas kali ini adalah tentang koneksi java ke data base dan data base yang akan saya gunakan adalah MySQL.
Biar lebih mudah di praktekkan saya akan kasih langsung saja source codenya... tapi bentar... ikuti langkah-langkahnya dulu, biar lebih lancar... hehe...

1. download database di sini
2. download source disini (dibuka dengan netbeans)
3. Buat data base dengan nama "testkon" dan import data base yang telah anda download pada langkah satu

Coba Jalankan.. klo ada kesulitan, Silahkan tanya... :-)

Lirik lagu Rindu Muhammad Ku - Haddad Alwi

Demi cinta-Mu ya Allah
Pada Muhammad nabi-Mu
Ampuni dosaku
Wujudkan harapanku
Ya Rasullallah

Siapa yang cinta pada nabinya
Pasti bahagia dalam hidupnya

Reff:
Muhammadku Muhammadku dengarlah seruanku
Aku rindu aku rindu kepadamu Muhammadku

Kau yang mengaku cinta kepada nabimu
Kau yang mengaku merindukan nabimu
Jika kau benar-benar cinta dan rindu kepada Muhammad nabimu
Buktikan
Taati perintah-Nya, tinggalkan larangan-Nya
Teladani akhlaknya
Niscaya kelak kau akan berjumpa dengan Rasullallah
Niscaya kelak kau akan berkumpul dengan Rasullallah

Back to Reff:

Kau ajarkan hidup ini untuk saling mengasihi
Ku tanamkan dalam hati kuamalkan sejak dini

Engkaulah nabi pembawa cinta
Kau bimbing kami menjuju surga

Back to Reff

Pencarian Google