This is for create table, before this you must create database with name is "dbname".
CREATE TABLE guestbook (
  id int(11) auto_increment,
  nama varchar(20),
  email varchar(20),
  tanggal date,
  komentar text,

So, this is code.
echo "NamaEmailTanggalKomentar";
while($data = mysql_fetch_array($result))
   echo "".$data['nama']."".$data['email']."".$data['tanggal']."".$data['komentar']."";

echo "";

// mencari jumlah semua data dalam tabel guestbook

$query   = "SELECT COUNT(*) AS jumData FROM guestbook";
$hasil  = mysql_query($query);
$data     = mysql_fetch_array($hasil);

$jumData = $data['jumData'];

// menentukan jumlah halaman yang muncul berdasarkan jumlah semua data

$jumPage = ceil($jumData/$dataPerPage);

// menampilkan link previous

if ($noPage > 1) echo  "<< Prev";

// memunculkan nomor halaman dan linknya

for($page = 1; $page <= $jumPage; $page++)
         if ((($page >= $noPage - 3) && ($page <= $noPage + 3)) || ($page == 1) || ($page == $jumPage))
            if (($showPage == 1) && ($page != 2))  echo "...";
            if (($showPage != ($jumPage - 1)) && ($page == $jumPage))  echo "...";
            if ($page == $noPage) echo " ".$page." ";
            else echo " ".$page." ";
            $showPage = $page;

// menampilkan link next

if ($noPage < $jumPage) echo "Next >>";


I finded this code in Blog Rosihanari.

You can complete seen theory in there website.

This application very usefull for me, setting melody guitar to be easier than before. Running in android. gStrings - a chromatic tuner for the guitar, violin, or any other instrument.

This is the ad supported version of gStrings (, a chromatic tuner application measuring sound pitch and intensity.
It will let you tune any musical instrument (violin, viola, violoncello, bass, guitar, piano, wind instruments).
Features include:
1. orchestra tuning (shifting/redefining tone frequencies),
2. different temperaments (just, pythagorean, meantone, comma, etc.),
3. a variable range nonlinear scale,
4. microphone sensitivity setup,
5. pitch pipe,
and many more.
If you were looking for a guitar tuner, try it!

WinPDF can convert your document example from word to PDF. extention word (.docx) often inspected virus so you can rescue your document with format PDF.

Document from Microsoft Word

How to convert: like print your document but you choose WinPdf Writer

This is a result 

Installation Instructions:
  1. Double click on the WinPDF.exe file
  2. The WinPDF Installation Wizard starts
  3. Click the “NEXT” button
  4. Read the License Agreement and accept it by checking “I accept the license agreement”
  5. Click the “NEXT” button
  6. Enter your name and organization and choose to install only for the current logged in user or for anyone who uses this computer
  7. Click the “NEXT” button
  8. In the following dialogue box you can modify the installation directory or just accept the standard directory by clicking “NEXT”
  9. Select the installation type “complete” or “custom” and click on the “NEXT” button
  10. If all installation information was entered correctly click “NEXT” to install. Otherwise click on the “BACK” button to re-enter information.
  11. The application is being installed.
  12. Click on the “FINISH” button
  13. Setup is complete

System Requirements:

Microsoft® Windows 7, Vista®, Windows XP®, Windows Server® 2008, Windows Server® 2003
Processor: Pentium® processor, or equivalent
Hard Drive Space: 10MB of available hard-disk space
Memory: 256MB RAM
Monitor: VGA 16 color 640x480 screen resolution

This freeware very usefull. I used this freeware for learning nihongo (Japanase language). 

 Like the picture below.

That is example how I remember katakana words.

You can input words

Available to see statistic


These are some of the features of Mnemosyne:
  • Efficient scheduling algorithm, so you don't waste time on things you know well
  • Support for languages using different scripts through unicode
  • Support for pictures, sounds and html formatting
  • Can be integrated with LaTeX to display mathematical formulas
  • Support for three-sided cards, e.g. foreign words where you are interested in written form, pronunciation and translation
  • Can be run from a USB key
  • Can display some basis statistical info on your learning process
  • Keeps a detailed record of your entire learning process for analysis
  • Your cards can be organised in categories, which can be activated and disactivated to control your learning process
  • Clean, deceptively simple user interface, yet fully customisable for advanced users through configuration files and plugins
  • Available in several languages
  • Support for a large number of import and export formats (text, XML, Supermemo, Memaid, ...)

Makes your Windows XP look like the new Windows 7. 
Size : 20.80MB
OS  : Windows XP

This installer is designed to work on the following operating systems and languages:
  • Windows XP (Home, Pro, RTM, SP1, SP2, SP3, Corporate)
  • Windows 2003 (Standard, Enterprise, Datacenter, Web, RTM, SP1)
  • Windows Media Center Edition (2003, 2004, 2005)
  • Windows XP Tablet PC Edition
  • All Language Versions
  • Does NOT work with 64 bit versions of Windows! 
The Seven Remix XP application was designed to improve the Graphical interface of your Windows XP. A great part of the resources of your system files are replaced. Files that contain icons, images, animations are extracts of Windows 7 to update your Windows XP interface to that of Windows 7.

Download Seven Remix XP 2.41
Publisher : Visit Website

Convert your digital photos into a sketch or a drawing.
 Size : 3.76MB
OS   : Windows 2000/XP/2003/Vista/7

FotoSketcher is a 100% free program which can help you convert your digital photos into art, automatically. If you want to turn a portrait, the photograph of your house or a beautiful landscape into a painting, a sketch or a drawing then look no further, FotoSketcher will do the job in just a few seconds.
Thanks to FotoSketcher you can create stunning images to make original gifts for your friends or relatives. Create birthday cards, season's greetings stationary or simply print your work of art and hang it on the wall.
Different styles are available: pencil sketch, pen and ink drawing, various painting renderings. You can also improve your original photo with simple tools (enhance contrast, sharpen, simplify image, increase luminosity, color saturation etc...).

Download FotoSketcher 1.97
Publisher : Visit Website

Automatically finds and organizes all of your pictures.
Size: 11.81MB

OS: Windows XP/2003/Vista/7

Picasa automatically finds and organizes all of your pictures including: jpeg, tiff, bmp, psd, and standard camera movie files. Sending pictures with e-mail used to mean five steps just to get it right.
Picasa lets you pick the size and then automatically attaches your pictures. Browse through all your pictures and view slideshows of your albums with the click of a button. Enhance, fix red-eye, and even crop without losing data or permanently changing your original picture.

Download Picasa 3.6
Publisher : Visit Website

Create mosaic-pictures from your own photos.
Size : 1.84MB
OS  :  Windows 2000/XP/Vista/7

Foto-Mosaik helps you to create mosaic-pictures, which are composed of many small pictures (tiles), from your own photos. The individual tiles, from which the mosaic-picture will be created, can be selected at random. After analysis, Foto-Mosaik puts them into one or multiple databases. As a basis you can grab the pictures from your private collection, or from a photo-cd.
A simple to use wizard will guide you through the freeware/postcardware program. So it's a piece of cake to create you own mosaic pictures with an extraordinary effect.

Download Foto-Mosaik 5.5.10
Publisher : Visit Website


free counters