Saturday, 23 May 2015


















Dekat jauhpun aku bahagia
Senyum manismu menerangiku
Dari mata turun ke hati
Hati berdebar ketika melihatmu

       Namun,,,
       Tiba saatnya malam tahun baru
       Hati ini mulai berdebar tanpa henti
     
Mulutpun terucap...
"Maukah engkau menjadi pacarku ?"
Terucap bibr manisnya...
"Maaf saya belum bisa menerimamu menjadi pacarku...maaf ya..."

              Terasa lega menerima jawaban nya
              Menerima... tanpa memaksa...
              Mungkin hanya itu yang harus kulakukan
Melihat tawamu, bahagiamu...
Melihat tangismu, kesedihanmu..
Hatikupun merasakan yang sama

       Meski engkau dengannya
       Aku mencoba ikhlas menerimanya...

"Salam cinta Forever dan berhenti tuk memilikinya"

Wednesday, 25 February 2015

Salam buat pengunjung KARYA_Q.

Berbagi  tentang script PHP mengenai backup database dengan cara automatis langsung dari website atau tidak secara manual dari phpmyadmin.


Back Up Database . . . . , dengan adanya backup database kita bisa membuat data cadangan untuk database yang sudah kita buat dan kita  isi setiap harinya. Membackup database dengan type file yang berbeda-beda, dengan type SQL, PDF, XML dll.
Gambar type file.


Script untuk membuat backup database.

<form action="" method="post" name="postform">
<div align="center">
                                <input class="button btncolor" type="submit" name="backup"  onClick="return confirm('Apakah Anda yakin?')"value="Proses Backup" />
                  </div>
</form>
 <?php
if(isset($_POST['backup'])){
//membuat nama file
                $file=date("DdMY").'_ri32_backup_data_'.time().'.sql';
//panggil fungsi dengan memberi parameter untuk koneksi dan nama file untuk backup
                backup_tables("localhost","root",""," NAMA_DATABASE ",$file);
?>
                <p align="center">&nbsp;</p>
                <p align="center">Backup database telah selesai.</p>
<?php
}else{    unset($_POST['backup']);
}
/*untuk memanggil nama fungsi :: jika anda ingin membackup semua tabel yang ada didalam database, biarkan tanda BINTANG (*) pada variabel $tables = '*'
jika hanya tabel-table tertentu, masukan nama table dipisahkan dengan tanda KOMA (,)  */
function backup_tables($host,$user,$pass,$name,$nama_file,$tables = '*')
{
//untuk koneksi database
                $link = mysql_connect($host,$user,$pass);
                mysql_select_db($name,$link);
if($tables == '*')               {
                                $tables = array();
                                $result = mysql_query('SHOW TABLES');
                                while($row = mysql_fetch_row($result))
                                {
                                $tables[] = $row[0];
                                } }else{
//jika hanya table-table tertentu
                                $tables = is_array($tables) ? $tables : explode(',',$tables);
                }             
                foreach($tables as $table)
                {
                                $result = mysql_query('SELECT * FROM '.$table);
                                $num_fields = mysql_num_fields($result);
//menyisipkan query drop table untuk nanti hapus table yang lama
                                $return.= 'DROP TABLE '.$table.';';
                                $row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE '.$table));
                                $return.= "\n\n".$row2[1].";\n\n";
                                for ($i = 0; $i < $num_fields; $i++)
                                {
                                while($row = mysql_fetch_row($result)) {
//menyisipkan query Insert. untuk nanti memasukan data yang lama ketable yang baru dibuat. so toy mode : ON
                                $return.= 'INSERT INTO '.$table.' VALUES(';
                                for($j=0; $j<$num_fields; $j++) {
//akan menelusuri setiap baris query didalam
                                $row[$j] = addslashes($row[$j]);
                                $row[$j] = ereg_replace("\n","\\n",$row[$j]);
                                if (isset($row[$j])) { $return.= '"'.$row[$j].'"' ; } else { $return.= '""'; }
                                if ($j<($num_fields-1)) { $return.= ','; } }
$return.= ");\n";
}
}
$return.="\n\n\n";
}
//simpan file di folder yang anda tentukan sendiri. kalo saya sech folder "DATA"
                $nama_file;
                $handle = fopen('FOLDER PENYIMPAN'.$nama_file,'w+');
                fwrite($handle,$return);
                fclose($handle);
}
?>


Silahkan mencoba... , mencoba awal dari keberhasilan dan adanya keberhasilan pasti sebelumnya mengalami kegagalan. SEMANGAT....

Friday, 20 February 2015

Salam buat pengunjung Karya_IQ.

Script...!!! saya akan berbagi pengetahuan tentang script tetapi bukan tentang skripsi, berbicara tentang script untuk membuat aplikasi website, saya akan memberi script untuk membuat hiasan atau disebut juga dengan  icon yang ada  di aplikasi tersebut.

Kebanyakan mengambil icon dengan cara memanggil link image, seperti <img src=”gambar/icon.png” width=””> kurang lebih seperti itu.  Tetapi ini berbeda dengan yang diatas, disini kita menggunakan class icon untuk memanggil gambar icon, lebih simple yang pastinya. 

Sedikit basa-basi dari saya, langsung saja mulai dari awal seperti biasa...
Ambilah gambar dibawah, simpan dengan nama icon.png . Fungsi gambar dibawah untuk mengambil gambar icon satu persatu dengan cara menggunakan script “.icon-glass {  background-position: 0      0 ; }  ” background-position untuk menempatkan posisi icon yang di pilih... satu dari beberapa icon, untuk posisi sudah saya sesuaikan, silahkan di coba !



Simpan dengan nama index.php .

<html lang="en">
  <head>
    <title>Icon-Templates</title>
    <!-- styles -->
<style>
.the-icons {
  margin-left: 0;
  list-style: none;
}
.the-icons li {
  float: left;
  width: 25%;
  line-height: 25px;
}
</style>
                <link href="bootstrap.css" rel="stylesheet">
 </head>
 <center>
 <ul class="the-icons clearfix">
            <li><i class="icon-glass"></i> icon-glass</li>
            <li><i class="icon-music"></i> icon-music</li>
            <li><i class="icon-search"></i> icon-search</li>
            <li><i class="icon-envelope"></i> icon-envelope</li>
            <li><i class="icon-heart"></i> icon-heart</li>
            <li><i class="icon-star"></i> icon-star</li>
            <li><i class="icon-star-empty"></i> icon-star-empty</li>
            <li><i class="icon-user"></i> icon-user</li>
            <li><i class="icon-film"></i> icon-film</li>
            <li><i class="icon-th-large"></i> icon-th-large</li>
            <li><i class="icon-th"></i> icon-th</li>
            <li><i class="icon-th-list"></i> icon-th-list</li>
            <li><i class="icon-ok"></i> icon-ok</li>
            <li><i class="icon-remove"></i> icon-remove</li>
            <li><i class="icon-zoom-in"></i> icon-zoom-in</li>
            <li><i class="icon-zoom-out"></i> icon-zoom-out</li>
            <li><i class="icon-off"></i> icon-off</li>
            <li><i class="icon-signal"></i> icon-signal</li>
            <li><i class="icon-cog"></i> icon-cog</li>
            <li><i class="icon-trash"></i> icon-trash</li>
            <li><i class="icon-home"></i> icon-home</li>
            <li><i class="icon-file"></i> icon-file</li>
            <li><i class="icon-time"></i> icon-time</li>
            <li><i class="icon-road"></i> icon-road</li>
            <li><i class="icon-download-alt"></i> icon-download-alt</li>
            <li><i class="icon-download"></i> icon-download</li>
            <li><i class="icon-upload"></i> icon-upload</li>
            <li><i class="icon-inbox"></i> icon-inbox</li>
            <li><i class="icon-play-circle"></i> icon-play-circle</li>
            <li><i class="icon-repeat"></i> icon-repeat</li>
            <li><i class="icon-refresh"></i> icon-refresh</li>
            <li><i class="icon-list-alt"></i> icon-list-alt</li>
            <li><i class="icon-lock"></i> icon-lock</li>
            <li><i class="icon-flag"></i> icon-flag</li>
            <li><i class="icon-headphones"></i> icon-headphones</li>
            <li><i class="icon-volume-off"></i> icon-volume-off</li>
            <li><i class="icon-volume-down"></i> icon-volume-down</li>
            <li><i class="icon-volume-up"></i> icon-volume-up</li>
            <li><i class="icon-qrcode"></i> icon-qrcode</li>
            <li><i class="icon-barcode"></i> icon-barcode</li>
            <li><i class="icon-tag"></i> icon-tag</li>
            <li><i class="icon-tags"></i> icon-tags</li>
            <li><i class="icon-book"></i> icon-book</li>
            <li><i class="icon-bookmark"></i> icon-bookmark</li>
            <li><i class="icon-print"></i> icon-print</li>
            <li><i class="icon-camera"></i> icon-camera</li>
            <li><i class="icon-font"></i> icon-font</li>
            <li><i class="icon-bold"></i> icon-bold</li>
            <li><i class="icon-italic"></i> icon-italic</li>
            <li><i class="icon-text-height"></i> icon-text-height</li>
            <li><i class="icon-text-width"></i> icon-text-width</li>
            <li><i class="icon-align-left"></i> icon-align-left</li>
            <li><i class="icon-align-center"></i> icon-align-center</li>
            <li><i class="icon-align-right"></i> icon-align-right</li>
            <li><i class="icon-align-justify"></i> icon-align-justify</li>
            <li><i class="icon-list"></i> icon-list</li>
            <li><i class="icon-indent-left"></i> icon-indent-left</li>
            <li><i class="icon-indent-right"></i> icon-indent-right</li>
            <li><i class="icon-facetime-video"></i> icon-facetime-video</li>
            <li><i class="icon-picture"></i> icon-picture</li>
            <li><i class="icon-pencil"></i> icon-pencil</li>
            <li><i class="icon-map-marker"></i> icon-map-marker</li>
            <li><i class="icon-adjust"></i> icon-adjust</li>
            <li><i class="icon-tint"></i> icon-tint</li>
            <li><i class="icon-edit"></i> icon-edit</li>
            <li><i class="icon-share"></i> icon-share</li>
            <li><i class="icon-check"></i> icon-check</li>
            <li><i class="icon-move"></i> icon-move</li>
            <li><i class="icon-step-backward"></i> icon-step-backward</li>
            <li><i class="icon-fast-backward"></i> icon-fast-backward</li>
            <li><i class="icon-backward"></i> icon-backward</li>
            <li><i class="icon-play"></i> icon-play</li>
            <li><i class="icon-pause"></i> icon-pause</li>
            <li><i class="icon-stop"></i> icon-stop</li>
            <li><i class="icon-forward"></i> icon-forward</li>
            <li><i class="icon-fast-forward"></i> icon-fast-forward</li>
            <li><i class="icon-step-forward"></i> icon-step-forward</li>
            <li><i class="icon-eject"></i> icon-eject</li>
            <li><i class="icon-chevron-left"></i> icon-chevron-left</li>
            <li><i class="icon-chevron-right"></i> icon-chevron-right</li>
            <li><i class="icon-plus-sign"></i> icon-plus-sign</li>
            <li><i class="icon-minus-sign"></i> icon-minus-sign</li>
            <li><i class="icon-remove-sign"></i> icon-remove-sign</li>
            <li><i class="icon-ok-sign"></i> icon-ok-sign</li>
            <li><i class="icon-question-sign"></i> icon-question-sign</li>
            <li><i class="icon-info-sign"></i> icon-info-sign</li>
            <li><i class="icon-screenshot"></i> icon-screenshot</li>
            <li><i class="icon-remove-circle"></i> icon-remove-circle</li>
            <li><i class="icon-ok-circle"></i> icon-ok-circle</li>
            <li><i class="icon-ban-circle"></i> icon-ban-circle</li>
            <li><i class="icon-arrow-left"></i> icon-arrow-left</li>
            <li><i class="icon-arrow-right"></i> icon-arrow-right</li>
            <li><i class="icon-arrow-up"></i> icon-arrow-up</li>
            <li><i class="icon-arrow-down"></i> icon-arrow-down</li>
            <li><i class="icon-share-alt"></i> icon-share-alt</li>
            <li><i class="icon-resize-full"></i> icon-resize-full</li>
            <li><i class="icon-resize-small"></i> icon-resize-small</li>
            <li><i class="icon-plus"></i> icon-plus</li>
            <li><i class="icon-minus"></i> icon-minus</li>
            <li><i class="icon-asterisk"></i> icon-asterisk</li>
            <li><i class="icon-exclamation-sign"></i> icon-exclamation-sign</li>
            <li><i class="icon-gift"></i> icon-gift</li>
            <li><i class="icon-leaf"></i> icon-leaf</li>
            <li><i class="icon-fire"></i> icon-fire</li>
            <li><i class="icon-eye-open"></i> icon-eye-open</li>
            <li><i class="icon-eye-close"></i> icon-eye-close</li>
            <li><i class="icon-warning-sign"></i> icon-warning-sign</li>
            <li><i class="icon-plane"></i> icon-plane</li>
            <li><i class="icon-calendar"></i> icon-calendar</li>
            <li><i class="icon-random"></i> icon-random</li>
            <li><i class="icon-comment"></i> icon-comment</li>
            <li><i class="icon-magnet"></i> icon-magnet</li>
            <li><i class="icon-chevron-up"></i> icon-chevron-up</li>
            <li><i class="icon-chevron-down"></i> icon-chevron-down</li>
            <li><i class="icon-retweet"></i> icon-retweet</li>
            <li><i class="icon-shopping-cart"></i> icon-shopping-cart</li>
            <li><i class="icon-folder-close"></i> icon-folder-close</li>
            <li><i class="icon-folder-open"></i> icon-folder-open</li>
            <li><i class="icon-resize-vertical"></i> icon-resize-vertical</li>
            <li><i class="icon-resize-horizontal"></i> icon-resize-horizontal</li>
            <li><i class="icon-hdd"></i> icon-hdd</li>
            <li><i class="icon-bullhorn"></i> icon-bullhorn</li>
            <li><i class="icon-bell"></i> icon-bell</li>
            <li><i class="icon-certificate"></i> icon-certificate</li>
            <li><i class="icon-thumbs-up"></i> icon-thumbs-up</li>
            <li><i class="icon-thumbs-down"></i> icon-thumbs-down</li>
            <li><i class="icon-hand-right"></i> icon-hand-right</li>
            <li><i class="icon-hand-left"></i> icon-hand-left</li>
            <li><i class="icon-hand-up"></i> icon-hand-up</li>
            <li><i class="icon-hand-down"></i> icon-hand-down</li>
            <li><i class="icon-circle-arrow-right"></i> icon-circle-arrow-right</li>
            <li><i class="icon-circle-arrow-left"></i> icon-circle-arrow-left</li>
            <li><i class="icon-circle-arrow-up"></i> icon-circle-arrow-up</li>
            <li><i class="icon-circle-arrow-down"></i> icon-circle-arrow-down</li>
            <li><i class="icon-globe"></i> icon-globe</li>
            <li><i class="icon-wrench"></i> icon-wrench</li>
            <li><i class="icon-tasks"></i> icon-tasks</li>
            <li><i class="icon-filter"></i> icon-filter</li>
            <li><i class="icon-briefcase"></i> icon-briefcase</li>
            <li><i class="icon-fullscreen"></i> icon-fullscreen</li>
          </ul>
</center>
</html>  

    Simpan dengan nama icon.css .

[class^="icon-"],
[class*=" icon-"] {
  display: inline-block;
  width: 14px;
  height: 14px;
  background-image: url("icon.png");
}
.icon-glass {  background-position: 0      0 ; }
.icon-music {  background-position: -24px 0; }
.icon-search {  background-position: -48px 0; }
.icon-envelope {  background-position: -72px 0; }
.icon-heart { background-position: -96px 0; }
.icon-star { background-position: -120px 0; }
.icon-star-empty { background-position: -144px 0; }
.icon-user { background-position: -168px 0; }
.icon-film { background-position: -192px 0; }
.icon-th-large { background-position: -216px 0; }
.icon-th { background-position: -240px 0; }
.icon-th-list { background-position: -264px 0;}
.icon-ok {  background-position: -288px 0;}
.icon-remove {  background-position: -312px 0;}
.icon-zoom-in {  background-position: -336px 0;}
.icon-zoom-out {  background-position: -360px 0;}
.icon-off {  background-position: -384px 0;}
.icon-signal {  background-position: -408px 0;}
.icon-cog {  background-position: -432px 0;}
.icon-trash {  background-position: -456px 0;}
.icon-home {  background-position: 0 -24px;}
.icon-file {  background-position: -24px -24px;}
.icon-time {  background-position: -48px -24px;}
.icon-road {  background-position: -72px -24px;}
.icon-download-alt {  background-position: -96px -24px;}
.icon-download {  background-position: -120px -24px;}
.icon-upload {  background-position: -144px -24px;}
.icon-inbox {  background-position: -168px -24px;}
.icon-play-circle {  background-position: -192px -24px;}
.icon-repeat {  background-position: -216px -24px;}
.icon-refresh {  background-position: -240px -24px;}
.icon-list-alt { background-position: -264px -24px;}
.icon-lock {  background-position: -287px -24px;}
.icon-flag {  background-position: -312px -24px;}
.icon-headphones {  background-position: -336px -24px;}
.icon-volume-off {  background-position: -360px -24px;}
.icon-volume-down {  background-position: -384px -24px;}
.icon-volume-up {  background-position: -408px -24px;}
.icon-qrcode {  background-position: -432px -24px;}
.icon-barcode {  background-position: -456px -24px;}
.icon-tag {  background-position: 0 -48px;}
.icon-tags {  background-position: -25px -48px;}
.icon-book {  background-position: -48px -48px;}
.icon-bookmark {  background-position: -72px -48px;}
.icon-print {  background-position: -96px -48px;}
.icon-camera {  background-position: -120px -48px;}
.icon-font {  background-position: -144px -48px;}
.icon-bold {  background-position: -167px -48px;}
.icon-italic {  background-position: -192px -48px;}
.icon-text-height {  background-position: -216px -48px;}
.icon-text-width {  background-position: -240px -48px;}
.icon-align-left {  background-position: -264px -48px;}
.icon-align-center {  background-position: -288px -48px;}
.icon-align-right {  background-position: -312px -48px;}
.icon-align-justify { background-position: -336px -48px;}
.icon-list {  background-position: -360px -48px;}
.icon-indent-left {  background-position: -384px -48px;}
.icon-indent-right {  background-position: -408px -48px;}
.icon-facetime-video {  background-position: -432px -48px;}
.icon-picture { background-position: -456px -48px;}
.icon-pencil {  background-position: 0 -72px;}
.icon-map-marker {  background-position: -24px -72px;}
.icon-adjust {  background-position: -48px -72px;}
.icon-tint {  background-position: -72px -72px;}
.icon-edit {  background-position: -96px -72px;}
.icon-share {  background-position: -120px -72px;}
.icon-check {  background-position: -144px -72px;}
.icon-move {  background-position: -168px -72px;}
.icon-step-backward {  background-position: -192px -72px;}
.icon-fast-backward {  background-position: -216px -72px;}
.icon-backward {  background-position: -240px -72px;}
.icon-play {  background-position: -264px -72px;}
.icon-pause {  background-position: -288px -72px;}
.icon-stop {  background-position: -312px -72px;}
.icon-forward {  background-position: -336px -72px;}
.icon-fast-forward {  background-position: -360px -72px;}
.icon-step-forward { background-position: -384px -72px;}
.icon-eject {  background-position: -408px -72px;}
.icon-chevron-left {  background-position: -432px -72px;}
.icon-chevron-right { background-position: -456px -72px;}
.icon-plus-sign {  background-position: 0 -96px;}
.icon-minus-sign {  background-position: -24px -96px;}
.icon-remove-sign {  background-position: -48px -96px;}
.icon-ok-sign {  background-position: -72px -96px;}
.icon-question-sign {  background-position: -96px -96px;}
.icon-info-sign {  background-position: -120px -96px;}
.icon-screenshot {  background-position: -144px -96px;}
.icon-remove-circle {  background-position: -168px -96px;}
.icon-ok-circle {  background-position: -192px -96px;}
.icon-ban-circle {  background-position: -216px -96px;}
.icon-arrow-left {  background-position: -240px -96px;}
.icon-arrow-right {  background-position: -264px -96px;}
.icon-arrow-up {  background-position: -289px -96px;}
.icon-arrow-down {  background-position: -312px -96px;}
.icon-share-alt {  background-position: -336px -96px;}
.icon-resize-full {  background-position: -360px -96px;}
.icon-resize-small {  background-position: -384px -96px;}
.icon-plus {  background-position: -408px -96px;}
.icon-minus {  background-position: -433px -96px;}
.icon-asterisk {  background-position: -456px -96px;}
.icon-exclamation-sign {  background-position: 0 -120px;}
.icon-gift {  background-position: -24px -120px;}
.icon-leaf {  background-position: -48px -120px;}
.icon-fire {  background-position: -72px -120px;}
.icon-eye-open {  background-position: -96px -120px;}
.icon-eye-close {  background-position: -120px -120px;}
.icon-warning-sign {  background-position: -144px -120px;}
.icon-plane {  background-position: -168px -120px;}
.icon-calendar {  background-position: -192px -120px;}
.icon-random {  width: 16px;  background-position: -216px -120px;}
.icon-comment {  background-position: -240px -120px;}
.icon-magnet {  background-position: -264px -120px;}
.icon-chevron-up {  background-position: -288px -120px;}
.icon-chevron-down {  background-position: -313px -119px;}
.icon-retweet {  background-position: -336px -120px;}
.icon-shopping-cart {  background-position: -360px -120px;}
.icon-folder-close {  background-position: -384px -120px;}
.icon-folder-open {  width: 16px;  background-position: -408px -120px;}
.icon-resize-vertical {  background-position: -432px -119px;}
.icon-resize-horizontal {  background-position: -456px -118px;}
.icon-hdd {  background-position: 0 -144px;}
.icon-bullhorn {  background-position: -24px -144px;}
.icon-bell {  background-position: -48px -144px;}
.icon-certificate {  background-position: -72px -144px;}
.icon-thumbs-up {  background-position: -96px -144px;}
.icon-thumbs-down {  background-position: -120px -144px;}
.icon-hand-right {  background-position: -144px -144px;}
.icon-hand-left {  background-position: -168px -144px;}
.icon-hand-up {  background-position: -192px -144px;}
.icon-hand-down {  background-position: -216px -144px;}
.icon-circle-arrow-right {  background-position: -240px -144px;}
.icon-circle-arrow-left {  background-position: -264px -144px;}
.icon-circle-arrow-up {  background-position: -288px -144px;}
.icon-circle-arrow-down {  background-position: -312px -144px;}
.icon-globe {  background-position: -336px -144px;}
.icon-wrench {  background-position: -360px -144px;}
.icon-tasks {  background-position: -384px -144px;}
.icon-filter {  background-position: -408px -144px;}
.icon-briefcase {  background-position: -432px -144px;}
.icon-fullscreen {  background-position: -456px -144px;}
*// -- End-- //*

Mungkin script nya ada yang kurang. Teliti Kunci Error Program. Silahkan dicoba... semoga berhasil yeaach... !!!


 Kurang lebihnya silahkan comment !

Monday, 15 December 2014


Penantian

Berdiri kusendiri
Dalam Penantian Yang Tak Pasti
Haruskah  Kusudahi
Semua Kepura-puraan Ku Ini

            Tertawa Dikala Duka
            Menangis Dikala Bahagia
            Namun Apalah Daya
            Ku Tak Mampu Tuk Menghindarinya

Kau Tlah Goreskan Luka
Yang Takkan Pernah Sirna
Walau Sejuta Cara Tlah Kucoba
Tuk Mengerti Akan Hatimu

            Mungkinkah Harapanku YangHilang
            Kan Kembali Bersama Anganku Tetangmu
            Oh ... Kekasihku...

Nb: seorang kekasih takkan kemana... yang sudah biarlah berlalu. Sabar, berusaha dan 

berdo’a tukmencari jawaban nya.

Tuesday, 2 December 2014


Seputih kertas terlahir
Coretan aneka warna terukir
Membentuk gugusan karakter
Tinta mengayun mengikuti waktu

                Merajut tinta tak tentu
                Warna gelap kesedhanmu
                Warna terang kebahagiaanmu
                Menyatu padu dalam kisahmu

Setiap torehan warna
Membekas penuh warna
Tak temukan waktu
Ataupun luput oleh ingatan

                Hingga waktu pertanggungjawaban datang
                Tak sepatah katapun terlupakan
                Tak segelintir hurufpun terlewatkan
                Karena dia maha tahu


nb: hidup bagaikan bolpoin dan penghapus, tulislah kebaikan dalam hidupmu tetapi  
       semua kebaikan pasti ada kejelekan maka hapuslah kejelekan itu.

Wednesday, 26 November 2014


Salam buat pengunjung Karya_iQ.

Dalam sebuah aplikasi website, fungsi utamanya website yaitu untuk memberikan suatu informasi secara online dengan mudah dan cepat, cepat untuk memberikan/create, mengubah menjadi lebih efektif/update dan menghapus/delete jika ada kesalahan yang mendadak, itu semua dinamakan CRUD”Create Update Delete”.
Untuk login, sangat dibutuhkan dalam mengoperasikan website. Fungsi login untuk membedakan antara admin dan user, admin untuk mengoperasikan keseluruhan website tanpa kecuali, user hanya melihat data pribadi dan informasi yang sudah di upload oleh admin.
Bagi pemula/newbie dalam pembelajaran membuat website, jangan putus asa… disini saya akan berbagi ilmu tentang pembuatan “ CRUD ” dan “ LOGIN dua Level” yang sangat sederhana .

 Langkah – langkah membuat CRUD :
1.       Membuat Database.
New database dengan nama crud, tebel db_user dan field seperti gambar dibawah ini !

Auto increment “Ekstra” digunakan untuk insert dengan otomatis. Cara nya klik primary-edit-centang auto increment-save. Untuk password kalau bisa lebih dari 50 karakter karena nantinya data akan di encripsi .
2.       Membuat koneksi database.
Membuat folder Crud, yang nantinya untuk penyimpanan semua file.
Script koneksi.php
<?php
   $mysql_host = "localhost";
    $mysql_user = "root";
    $mysql_password = "";

                //samakan nama database"crud"
    $mysql_db = "crud";
    $koneksi = mysql_connect($mysql_host,$mysql_user,$mysql_password)     
                                or die (" Koneksi Gagal ");
                                $db = mysql_select_db($mysql_db,$koneksi);
                                return $koneksi
?>

3.       Script class form insert.
Kita simpan di folder Crud/admin/insert.php
<?php
//koneksi data base
include '../koneksi.php';

//menyimpan data
//a,b,c sebagai variable
$a = $_POST['id_user'];
$b = $_POST['nama'];
$c = $_POST['username'];
//md5 untuk encripsi
$d = md5($_POST['password']);
$e = $_POST['level'];

//membuat query untuk menyimpan
$sql= "INSERT INTO  db_user(id_user,nama,username,password,level)
 VALUES ('$a','$b','$c','$d','$e')";

//menyimpan data ke database
mysql_query($sql);
echo"<h2>Data Telah Di Simpan</h2>";
?>
<a href="form.php">Tambah Data</a> <br><a href="view.php">View Data</a>

4.       Script class form insert.
Kita simpan di folder Crud/admin/form.php
<html>
          <head>
          <title>Belajar Koneksi Database</title>
 </head>
 <body>
<h3> Masukkan Data </h3>
<form action="insert.php" method="post">
<table>
<tr>
<td>Nama</td>
<td>:</td>
<td><input type="text" name="nama" ></td>
</tr>
<tr>
<td>Username</td>
<td>:</td>
<td><input type="text" name="username"></td>
</tr>
<tr>
<td>Password</td>
<td>:</td>
<td><input type="password" name="password"></td>
</tr>
<tr>
<td> Level</td>
<td>:</td>
<td><select name="level">
<option value="admin">Admin</option>
<option value="user">User</option>
</select></td>
</tr>
</table>
<input type="submit" value="Daftar"> <input type="reset" value="Reset">
</form>
</body>
   </html>

5.       Script view.php
Kita simpan di folder Crud/admin/view.php
<table border="5" >
<a href="form.php">Create Data</a>
           <thead>
            <tr>
                                                 <th>No</th>
             <th>Id useer</th>
                                     <th>Nama</th>
                                                 <th>Username</th>
                                                 <th>Level</th>
                                                 <th>Action</th>
           </tr>
    </thead>
                <tbody>
 <?php
include '../koneksi.php';
                               
                $sql ="SELECT * FROM  db_user";
                $no=1;
                //untuk menyeleksi data error
                $query =mysql_query($sql) or die("select data menu error :".mysql_error());
                while($record =mysql_fetch_array($query)){
?>
 <tr>
                 <td>
                 <?php echo $no++?>
                </td>
     <td>
                 <?php echo $record['id_user'] ?>
                </td>
                <td>
                 <?php echo $record['nama'] ?>
                </td>
                <td>
                 <?php echo $record['username'] ?>
                </td>
                <td>
                 <?php echo $record['level'] ?>
                </td>
                <td>
                 <button><a href="<?php echo" edit.php?id=".$record[id_user]."";?>">Edit</a></button>
                 <button><a href="<?php echo" delete.php?id=".$record[id_user]."";?>">Delete</a></button>
                </td>
<tr>
<?php } ?>
</tbody>
</table>
6.       Script update/edit.
Kita simpan di folder Crud/admin/editaksi.php
<?php
include "../koneksi.php";

$id_user = $_POST['id_user'];
$nama = $_POST['nama'];
$username = $_POST['username'];
//md5 untuk encripsi
$password =md5($_POST['password']);
$level = $_POST['level'];

 $sql = "UPDATE db_user SET nama='$nama',username='$username',password='$password',level='$level' WHERE id_user='$id_user'";

 $result = mysql_query($sql);

 if ($result){
                header ("location:view.php");
 } else {
                echo "Terjadi kesalahan";
 }
?>

7.       Form update.
Kita simpan di folder Crud/admin/edit.php
<?php
 include "../koneksi.php";
 $id = $_GET['id'];
 $sql = "SELECT * FROM db_user WHERE id_user='$id'";
 $result = mysql_query($sql);
 $dt = mysql_fetch_array($result);
?>
<html>
          <head>
                      <title>Belajar Koneksi Database</title>
          </head>
          <body>
                    <h3> Masukkan Data </h3>
        <form action="editaksi.php" method="post">
       <input type="hidden" value="<?php echo $dt['id_user'];?>" name="id_user">
       <table>
       <tr>
       <td>Nama</td>
       <td>:</td>
       <td><input type="text" name="nama" value="<?php echo $dt['nama'];?>"></td>
       </tr>
       <tr>
       <td>Username</td>
       <td>:</td>
       <td><input type="text" name="username" value="<?php echo $dt['username'];?>"></td>
       </tr>
       <tr>
       <td>Password</td>
       <td>:</td>
       <td><input type="password" name="password"></td>
       </tr>
       <tr>
      <td> Level</td>
      <td>:</td>
      <td><select name="level">
      <option value="admin">Admin</option>
      <option value="user">User</option>
       </select></td>
</tr>
</table>
<input type="submit" value="Daftar"> <input type="reset" value="Reset">
</form>
</body>
   </html>
8.       Script delete.
Kita simpan di folder Crud/admin/delete.php
<?php
 include "../koneksi.php";

 $id = $_GET['id'];
 $sql = "DELETE FROM db_user WHERE id_user='$id'";
 $result = mysql_query($sql);

 if ($result){
                header ("location: view.php");
 } else {
                echo "Terjadi kesalahan";
 }
?>

9.       Membuat login, script html form login.
File penyimpanan di folder Crud/login/login.php
<html>
          <head>
                      <title>Belajar Koneksi Database</title>
          </head>
          <body>
                    <h3> Silahkan Login </h3>
        <form action="ceklogin.php" method="post">
                                        <table>
                     <tr>
                           <td>Username</td>
                           <td>:</td>
                           <td><input type="text" name="username"></td>
                     </tr>
                     <tr>
                           <td> Password</td>
                           <td>:</td>
                           <td><input type="text" name="password"></td>
                    </tr>
                  
               
                </table>
            <input type="submit" value="Login"> <input type="reset" value="Reset">
       </form>
       <a href='../admin/form.php'>Register ?</a>
        </body>
   </html>

10.   Script cek login/class login.
Disimpan di folder login/ceklogin.php
<?php
session_start();

//sambungkan ke database
$koneksi=mysql_connect("localhost","root","");

//memilih database yang akan dipakai
mysql_select_db("crud",$koneksi);

//mengambil data dari form login
$username=$_POST['username'];
$password=md5($_POST['password']);

//query untuk mengambil data yang sesuai
$query="select * from db_user where username='$username' and password='$password'";
$hasil=mysql_query("$query");

$kode = mysql_fetch_array($hasil);

$cek=mysql_num_rows($hasil);

if ($cek==1){
$_SESSION['username']=$kode[username];
$_SESSION['password']=$kode[password];
   
    if ($kode['level']=='admin') {
        header("Location:../admin/admin.php");
    }
    elseif ($kode['level']=='user') {
        header("Location:../user/user.php");
    }
   
}
else{
 echo("User dan password salah");
}
?>
<br>
<a href="../login/login.php">Coba Lagi</a>

Selesai… silahkan newbie, semoga berhasil !!!

Silahkan download di sini karya_IQ bagi yang kurang faham, langsung semua file yang diatas serta database nya.

Silahkan comment bagi pengunjung, karena saya masih membutuhkan komentar anda ???
Subscribe to RSS Feed Follow me on Twitter!