IT4EDUCATION

Script Input,Edit,Delete di PHP Version1

IT FOR EDUCATION 0 Elearning, IT, Web 23.44

<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiUZxMNAu2NzkGfQBYd4KxmSpq9pASgPeFtJA-0qaSchk2DxDs2S5ss8N0-1JNcZjNraiVKM5bdMqwvuk6c51YZog_fR-I4dQ9kuMjnM1QILEJZ0-wtmVqJbVGz_P9ZbaTNooML6-wJLPY/s1600/web_ver1.png"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiUZxMNAu2NzkGfQBYd4KxmSpq9pASgPeFtJA-0qaSchk2DxDs2S5ss8N0-1JNcZjNraiVKM5bdMqwvuk6c51YZog_fR-I4dQ9kuMjnM1QILEJZ0-wtmVqJbVGz_P9ZbaTNooML6-wJLPY/s1600/web_ver1.png" /></a><br />
<br />
Satu lagi nih,, cara membuat web sederhana dengan php untuk input, edit 
delete. saya postingkan langkah-langkahnya sampai selesai dibawah ini :<br />
bagi yang baru belajar pemrograman web (PHP) baca langkah-langkahnya 
dari awal sampai selesai,, jangan dulu praktek. tetapi pahami dlu sob.<br />
<br />
Sebelumnya saya mau ngasih atensyen dulu. Pada tutorial kali ini saya 
menerapkan Captcha Operasi Matematika, saya juga menerapkanInput Tanggal
 dengan menggunakan javascript , dan tidak lupa juga saya menerapkan 
fungsi untuk mengubah format penulisan tanggal ke Format Tanggal 
Indonesia, tujuannya biar supaya kelihatan lebih keren dikit aja.<br />
<br />
<br />
<br />
<ol style="text-align: left;">
<li>Pertama kita buat databasenya dulu. <b>tambahhapusedit</b></li>
<li>Kemudian bikin tabelnya. <b>data</b></li>
<li>Next kita buat file css biar tampilannya keliatan lebih keren dikit. Kita beri nama dengan <b>style.css</b></li>
<li>Kemudian kita bikin file php buat menghubungkan antara file php kita dengan database yang kita buat. Kita beri nama dengan <b>koneksi.php</b></li>
<li>Selanjutnya kita buat file <b>index.php</b>. Pada index.php ini terdapat form untuk mengisi data dan tabel yang menampilkan data dari database.</li>
<li>Kemudian kita membuat skrip untuk melakukan penyimpanan data ke dalam database. Kita namai dengan <b>simpan.php</b></li>
<li>Selanjutnya kita membuat halaman untuk mengedit entry data dari database. Kita beri nama dengan <b>edit.php</b></li>
<li>Kemudian kita buat file php untuk melakukan eksekusi penyimpanan data yang kita edit kedalam database. Kita beri nama <b>simpanedit.php</b></li>
<li>Terakhir kita membuat skrip untuk melakukan eksekusi hapus data dari database. Kita beri nama <b>hapus.php</b></li>
<li>Pastikan semua file yang telah dibuat dalam terletak dalam satu folder.</li>
</ol>
<br />
<br />
<b>Catatan :</b><br />
<br />
Semua File Disimpan didalam 1 folder<br />
<br />
Yang Mw Simple, Silahkan Download database dan semua file script webnya dibawah ini, Gratis<br />
<br />
Tapi sebelumnya Download Dulu Tutorialnya, biar lengkap..<br />
<br />
<a href="http://adf.ly/PxHjf">Download Tutorialnya (Server Tusfiles)</a><br />
<br />
<a href="http://adf.ly/PxHui">Download Database (Server Tusfiles)</a><br />
<br />
<a href="http://adf.ly/PxHoQ">Download Script WEB (Server Tusfiles)</a><br />
<br />
<i>Atau </i><br />
<br />
<a href="http://adf.ly/PxGt9">Download Tutorialnya (Server Ziddu)</a><br />
<br />
<a href="http://adf.ly/PxH4w">Download Database (Server Ziddu)</a><br />
<br />
<a href="http://adf.ly/PxH07">Download Script WEB (Server Ziddu</a>)<br />
<br />
<br />
Bila ada file yang rusak/tidak bisa di download, silahkan comentar<br />
<br />
agar saya secepatnya memperbaiki. Thanks

Script Input,Edit,Delete di PHP Version1

Satu lagi nih,, cara membuat web sederhana dengan php untuk input, edit delete. saya postingkan langkah-langkahnya sampai selesai dibawah...

Baca selengkapnya »

WEB Sederhana, Input,Update,Delete

IT FOR EDUCATION 1 Elearning, IT, Web 23.42

Bagi teman-teman yang sedang gemar membuat/belajar bahasa pemrograman 
WEB, pada posting kali ini saya uploadkan file web sederhana yang sangat
 mudah untuk dipelajarai, pada halaman web tersebut dapatt melakukan 
beberapa manipulasi data ke databasenya, diantaranya menampilkan data, 
menginput data serta edit dan hapus data.<br />
Dibawah ini tampilan dari halaman web nya :<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmwEA_COj2PDGQgA1aJ84d1DVghhRJKucDcCElEGQor0imKe4A6NP57pdh-qlsZKJAlb8pp7GfsTBnDHeMeB_x82U4eH6W2keril6bJ__7dfrxMOFtkdZd2JC3OkjRW0ExHLvOX_vv09w/s1600/web_sederhana2.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="119" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmwEA_COj2PDGQgA1aJ84d1DVghhRJKucDcCElEGQor0imKe4A6NP57pdh-qlsZKJAlb8pp7GfsTBnDHeMeB_x82U4eH6W2keril6bJ__7dfrxMOFtkdZd2JC3OkjRW0ExHLvOX_vv09w/s1600/web_sederhana2.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjktNjbPwOgOqY7wEHp4qSE-qu8CHM0jCytDu9WvWUzxKNlMrDTeiHeC_JARaXlaue2tv_hxiu0t6SYx8DCh86sRyB80j4R89oq3QkfPf01fftjjvqCEiRt7SO8dm-X9WEA8zPPbHfavI4/s1600/web_sederhana1.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="170" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjktNjbPwOgOqY7wEHp4qSE-qu8CHM0jCytDu9WvWUzxKNlMrDTeiHeC_JARaXlaue2tv_hxiu0t6SYx8DCh86sRyB80j4R89oq3QkfPf01fftjjvqCEiRt7SO8dm-X9WEA8zPPbHfavI4/s1600/web_sederhana1.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
Tidak panjang lebar, silahkan download file database dan file web nya di link dibawah ini :<br />
<br />
<div style="text-align: center;">
<b>Download Melalui Tusfiles</b><br />
<br />
File Database: Data</div>
<div style="text-align: center;">
Size : 1 kb</div>
<div>
<div style="text-align: center;">
Web Server : Xampp</div>
<div style="text-align: center;">
<u><a href="http://adf.ly/4214430/database-web2"><img src="http://www.soppeng.com/img/download.gif" /></a></u></div>
</div>
<div style="text-align: center;">
</div>
<div>
<div style="text-align: center;">
File WEB: web2</div>
<div style="text-align: center;">
Size : 337 kb</div>
<div>
<div style="text-align: center;">
Web Server : Xampp</div>
<div style="text-align: center;">
<a href="http://adf.ly/4214430/file-web2"><img src="http://www.soppeng.com/img/download.gif" /></a><br />
<br />
<div>
<b>Download Melalui Ziddu</b><br />
<br />
File Database: Data</div>
<div>
Size : 1 kb</div>
<div style="text-align: left;">
<div style="text-align: center;">
Web Server : Xampp</div>
<div style="text-align: center;">
<u><a href="http://adf.ly/Px96L"><img src="http://www.soppeng.com/img/download.gif" /></a></u></div>
</div>
<div>
</div>
<div style="text-align: left;">
<div style="text-align: center;">
File WEB: web2</div>
<div style="text-align: center;">
Size : 337 kb</div>
<div>
<div style="text-align: center;">
Web Server : Xampp</div>
<div style="text-align: center;">
<a href="http://adf.ly/Px9Cq"><img src="http://www.soppeng.com/img/download.gif" /></a><br />
<br />
<div style="text-align: left;">
Bila ada file yang rusak/file tidak bisa di download, silahkan masukan komentar agar file segera saya perbaiki.</div>
</div>
</div>
</div>
</div>
</div>
</div>

WEB Sederhana, Input,Update,Delete

Bagi teman-teman yang sedang gemar membuat/belajar bahasa pemrograman WEB, pada posting kali ini saya uploadkan file web sederhana yang san...

Baca selengkapnya »

Backup Database dan Memasukan Database dari PhpMyadmin

IT FOR EDUCATION 0 Elearning, IT, Web 23.39

<div style="text-align: justify;">
Bagi para pembuat web, atau berbisnis di bidang webyang menggunakan 
database. biasanya setelah selesai melakukan pembuatan halaman webnya, 
pasti akan menyerahkan file web beserta database ke orang yang 
memesannya. ataupun pada saat pengerjaan tugas pembuatan web disekolah, 
biasanya pengajar meminta anda untuk membackup file web dan database nya
 sebagai bukti pengerjaan tugas web tersebut.<br />
</div>
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">
nah kalau minggu kemarin saya poetingkan bagaimana cara membackup dan 
memasukan data base melalui perintah sql, kali ini saya akan membahas 
cara membackup dan memasukan database phpmyadmin berupa file sql, bukan 
script sql seperti minggu kemarin. langkah-langkahnya hampir sama dengan
 membackup dengan menggunakan script.</div>
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">
ok saya tidak akan panjang lebar, bagi teman-teman yang pengen tutorial 
cara membackup database dan memasukan database, silahkan download link 
di bawah ini.</div>
<div style="text-align: justify;">
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQJVYrarc7IUHyHoWem7QqLR6miOraO_2YYGE9GLs8S9ZJ_xXvfX_yu92zOhrg5xvOY7qC_zpzGcUni4HOIFaeUt34WLiZAaKEPUl3TKHd_rIOI_y3D13x16AZvV53jirsp5hseklmV7s/s1600/cara-backup-database-mysql.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQJVYrarc7IUHyHoWem7QqLR6miOraO_2YYGE9GLs8S9ZJ_xXvfX_yu92zOhrg5xvOY7qC_zpzGcUni4HOIFaeUt34WLiZAaKEPUl3TKHd_rIOI_y3D13x16AZvV53jirsp5hseklmV7s/s400/cara-backup-database-mysql.jpg" width="400" /></a></div>
<div class="separator" style="clear: both;">
</div>
</div>
<div style="text-align: justify;">
<a href="http://adf.ly/PeSkX" target="blank">Download Tutorial Eksport dan Import Database PHPMyadmin</a></div>
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">

jangan lupa komentar dan like nya y.......!</div>

Backup Database dan Memasukan Database dari PhpMyadmin

Bagi para pembuat web, atau berbisnis di bidang webyang menggunakan database. biasanya setelah selesai melakukan pembuatan halaman webnya,...

Baca selengkapnya »

Cara Expor dan Import Script SQL ke PHPMyadmin

IT FOR EDUCATION 0 Elearning, IT, Web 23.37

<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnYqTnSWQnUX1yqrw6Xyj3sQZbmn7vK5DPnvL3Y4iyyb3HeodQXbuD_P0vaauHcUEQrlAIWrvjUugAjrwQzVtMgCa1HEyl3segM2pper_9F3x7m5Ut88tybQeuASueXNNoro_3L97miHo/s1600/Cara-Export-Database-MySql-Dari-phpMyAdmin.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="290" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnYqTnSWQnUX1yqrw6Xyj3sQZbmn7vK5DPnvL3Y4iyyb3HeodQXbuD_P0vaauHcUEQrlAIWrvjUugAjrwQzVtMgCa1HEyl3segM2pper_9F3x7m5Ut88tybQeuASueXNNoro_3L97miHo/s400/Cara-Export-Database-MySql-Dari-phpMyAdmin.jpg" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: justify;">
</div>
<div style="text-align: justify;">
Bagi para pemula pemrograman web, sumber referensi dari internet 
sangatlah penting bagi kita untuk mendalami tentang pemrograman web. 
Tetapi terkadang banyak referensi yang menyertakan file web nya dengan 
database yang sudah di exsport dan harus kita import. bagi para pemula 
dengan hal seperti itu terkadang bingung, apa sih exsport database dan 
import database?</div>
<ul style="text-align: justify;">
<li>Exsport Database adalah cara untuk memindahkan/mengambil database dari web server</li>
<li>Import Database adalah memasukan database yang telah di exsport dari komputer lain ke Web Server yang dipilih.</li>
</ul>
<div style="text-align: justify;">
yang harus diketahui juga, bahwa banyak cara untuk exsport dan import database.</div>
<div style="text-align: justify;">
<br />
Bagaimana cara exsport dan import database?</div>
<div style="text-align: justify;">
Pada posting kali ini, saya akan membahas tentang bagaimana cara meng 
exsport dan import database. untuk posting kali ini saya akan bahas cara
 exsport dan import database dengan metode copy paste script SQL nya.</div>
<div style="text-align: left;">
</div>
<div style="text-align: left;">
Download Tutorialnya <a href="http://adf.ly/Peg3c" target="blank">DISINI</a></div>

Cara Expor dan Import Script SQL ke PHPMyadmin

Bagi para pemula pemrograman web, sumber referensi dari internet sangatlah penting bagi kita untuk mendalami tentang pemrograman web. ...

Baca selengkapnya »

Cara Membuat Form Entry Data, Edit/Update, Hapus Di PHP

IT FOR EDUCATION 0 Elearning, IT, Web 23.34

<div dir="ltr" style="text-align: left;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgU4l5xp6Y-AMmMj5cFNAsDjaPKYp3f6FwhDbJWKYWkhOqEtWew5J8H-yEHwSZd7EB3kSzrxBJfQQC9PEQFbGZXvDbBO3ErYxFuswjWrbdq4L56QH5kxG0ATiRADS_iNQHoDTF5JOBTkkY/s1600/manipulasi.jpg" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: inherit;"><img border="0" height="145" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgU4l5xp6Y-AMmMj5cFNAsDjaPKYp3f6FwhDbJWKYWkhOqEtWew5J8H-yEHwSZd7EB3kSzrxBJfQQC9PEQFbGZXvDbBO3ErYxFuswjWrbdq4L56QH5kxG0ATiRADS_iNQHoDTF5JOBTkkY/s400/manipulasi.jpg" width="400" /></span></a></div>
<span style="font-family: inherit;"><a href="https://www.blogger.com/null" style="background-color: white; color: #0066cc; line-height: 24px; margin: 0px; padding: 0px; text-align: justify; text-decoration: none;" target="_blank"><br /></a>
<a href="https://www.blogger.com/null" style="background-color: white; color: #0066cc; line-height: 24px; margin: 0px; padding: 0px; text-align: justify; text-decoration: none;" target="_blank">Pemprograman</a><span style="background-color: white; color: #222222; line-height: 24px; text-align: justify;"> dasar database merupakan komponen utama yang ada untuk dapat membuat suatu </span>aplikasi berjalan dengan penyimpanan<span style="background-color: white; color: #222222; line-height: 24px; text-align: justify;">. Oke, kita dalam kesempatan ini akan belajar bagaimana  membuat fungsi </span>edit<span style="background-color: white; color: #222222; line-height: 24px; text-align: justify;">, </span>tambah<span style="background-color: white; color: #222222; line-height: 24px; text-align: justify;"> dan edit di </span>bahasa pemprograman <a href="http://bloger-tkj-dos-q28.blogspot.com/2013/05/mengenal-php.html" target="_blank">PHP</a><span style="background-color: white; color: #222222; line-height: 24px; text-align: justify;">. Ini adalah fungsi dasar yang terlebih dahulu dipelajari sebelum lebih lanjut </span><a href="https://www.blogger.com/null" style="background-color: white; color: #0066cc; line-height: 24px; margin: 0px; padding: 0px; text-align: justify; text-decoration: none;" target="_blank">belajar PHP</a><span style="background-color: white; color: #222222; line-height: 24px; text-align: justify;"> dengan fungsi penyimpanan yang lain.</span></span><br />
<span style="font-family: inherit;"><br style="background-color: white; color: #222222; line-height: 12px; margin: 0px; padding: 0px; text-align: justify;" /></span>
<span style="font-family: inherit;"><span style="background-color: white; color: #222222; line-height: 24px; text-align: justify;">Pertama yang perlu diketahui yaitu bagaimana membuat database dengan nama "</span><strong style="background-color: white; color: #222222; line-height: 24px; margin: 0px; padding: 0px; text-align: justify;">data_siswa</strong><span style="background-color: white; color: #222222; line-height: 24px; text-align: justify;">" dan tabel " </span><strong style="background-color: white; color: #222222; line-height: 24px; margin: 0px; padding: 0px; text-align: justify;">mhs</strong><span style="background-color: white; color: #222222; line-height: 24px; text-align: justify;">", yang berisi field </span><em style="background-color: white; color: #222222; line-height: 24px; margin: 0px; padding: 0px; text-align: justify;">nim,nama, alamat, agama dan nomor telepon</em><span style="background-color: white; color: #222222; line-height: 24px; text-align: justify;">. Atau inport saja code sql dibawah ini kedalam </span><em style="background-color: white; color: #222222; line-height: 24px; margin: 0px; padding: 0px; text-align: justify;"><strong style="margin: 0px; padding: 0px;">phpmyadmin</strong></em><span style="background-color: white; color: #222222; line-height: 24px; text-align: justify;"> anda agar lebih cepat dan mudah.</span></span><br />
<span style="font-family: inherit;"><span style="background-color: white; color: #222222; line-height: 24px; text-align: justify;"><br /></span>
<span style="background-color: white; color: #222222; line-height: 24px; text-align: justify;">1. import code sql di bawah ini ke phpmyadmin</span></span><br />
<span style="font-family: inherit;"><br /></span>
<div style="background-color: #eeeeee; border: 3px solid rgb(221, 221, 221); color: #550000; font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 24px; margin: 0px; padding: 5px; text-align: justify;">
<span style="font-family: inherit;">-- phpMyAdmin SQL Dump</span><br />
<span style="font-family: inherit;">-- version 2.11.1</span><br />
<span style="font-family: inherit;">-- http://www.phpmyadmin.net</span><br />
<span style="font-family: inherit;">--</span><br />
<span style="font-family: inherit;">-- Host: localhost</span><br />
<span style="font-family: inherit;">-- Generation Time: Apr 16, 2013 at 09:48 PM</span><br />
<span style="font-family: inherit;">-- Server version: 5.0.45</span><br />
<span style="font-family: inherit;">-- PHP Version: 5.2.4</span><br />
<span style="font-family: inherit;">SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";</span><br />
<span style="font-family: inherit;">--</span><br />
<span style="font-family: inherit;">-- Database: `data_siswa`</span><br />
<span style="font-family: inherit;">--</span><br />
<span style="font-family: inherit;">-- --------------------------------------------------------</span><br />
<span style="font-family: inherit;">--</span><br />
<span style="font-family: inherit;">-- Table structure for table `mhs`</span><br />
<span style="font-family: inherit;">--</span><br />
<span style="font-family: inherit;">CREATE TABLE `mhs` (</span><br />
<span style="font-family: inherit;">`nim` int(5) NOT NULL auto_increment,</span><br />
<span style="font-family: inherit;">`nama` varchar(20) collate latin1_general_ci default NULL,</span><br />
<span style="font-family: inherit;">`alamat` varchar(30) collate latin1_general_ci default NULL,</span><br />
<span style="font-family: inherit;">`agama` varchar(10) collate latin1_general_ci default NULL,</span><br />
<span style="font-family: inherit;">`notlpn` varchar(10) collate latin1_general_ci default NULL,</span><br />
<span style="font-family: inherit;">PRIMARY KEY (`nim`)</span><br />
<span style="font-family: inherit;">) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;</span><br />
<span style="font-family: inherit;">--</span><br />
<span style="font-family: inherit;">-- Dumping data for table `mhs`</span><br />
<span style="font-family: inherit;">--</span></div>
<div>
<span style="font-family: inherit;"><br /></span></div>
<div style="text-align: justify;">
<b><span style="font-family: inherit;"><span style="color: #222222;"><span style="line-height: 24px;">atau </span></span><span style="background-color: white; color: #222222; line-height: 24px;">  <a href="http://adf.ly/PeSLo" rel="nofollow" target="_blank">Download Script SQL nya</a></span></span></b></div>
<div style="text-align: justify;">
<span style="background-color: white; color: #222222; font-family: inherit; line-height: 24px;"><br /></span></div>
<div style="text-align: justify;">
<span style="font-family: inherit;"><span style="background-color: white; color: #222222; line-height: 24px;">2. </span><span style="background-color: white; color: #222222; line-height: 24px;">Setelah langkah pembuatan database selesai maka yang perlu dibuat yaitu buat folder baru di server local semisal </span><a href="https://www.blogger.com/null" style="background-color: white; color: #0066cc; line-height: 24px; margin: 0px; padding: 0px; text-decoration: none;" target="_blank">wamp server</a><span style="background-color: white; color: #222222; line-height: 24px;">.seperti ini caranya masuk ke local disk c cari Xampp buat seperti berikut </span><strong style="background-color: white; color: #222222; line-height: 24px; margin: 0px; padding: 0px;">Xampp/htdoch/namafolder yang akan dibuat. </strong><span style="background-color: white; color: #222222; line-height: 24px;">Kemudian buat file </span><strong style="background-color: white; color: #222222; line-height: 24px; margin: 0px; padding: 0px;">koneksi.php </strong><span style="background-color: white; color: #222222; line-height: 24px;">untuk koneksi ke database.</span></span></div>
<span style="font-family: inherit;"><br style="background-color: white; color: #222222; line-height: 12px; margin: 0px; padding: 0px; text-align: justify;" /></span>
<div style="background-color: #eeeeee; border: 3px solid rgb(221, 221, 221); color: #550000; font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 24px; margin: 0px; padding: 5px; text-align: justify;">
<span style="font-family: inherit;"><?php</span><br />
<span style="font-family: inherit;">$host="localhost";</span><br />
<span style="font-family: inherit;">$user="root";</span><br />
<span style="font-family: inherit;">$pass="";</span><br />
<span style="font-family: inherit;">$db="data_siswa";</span><br />
<span style="font-family: inherit;">$sambung=mysql_connect($host,$user,$pass);</span><br />
<span style="font-family: inherit;">mysql_select_db($db,$sambung);</span><br />
<span style="font-family: inherit;">?></span></div>
<span style="font-family: inherit;"><br style="background-color: white; color: #222222; line-height: 12px; margin: 0px; padding: 0px; text-align: justify;" /></span>
<span style="font-family: inherit;"><span style="background-color: white; color: #222222; line-height: 24px; text-align: justify;">3. Kita selanjutnya akan membuat </span><strong style="background-color: white; color: #222222; line-height: 24px; margin: 0px; padding: 0px; text-align: justify;">index.php </strong><span style="background-color: white; color: #222222; line-height: 24px; text-align: justify;">yang digunakan sebagai file utama sbb:</span></span><br />
<span style="font-family: inherit;"><br style="background-color: white; color: #222222; line-height: 12px; margin: 0px; padding: 0px; text-align: justify;" /></span>
<div style="background-color: #eeeeee; border: 3px solid rgb(221, 221, 221); color: #550000; font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 24px; margin: 0px; padding: 5px; text-align: justify;">
<span style="font-family: inherit;"><html></span><br />
<span style="font-family: inherit;"><head></span><br />
<span style="font-family: inherit;"><title>Daftar Mahasiswa</title></span><br />
<span style="font-family: inherit;"></head></span><br />
<span style="font-family: inherit;"><body></span><br />
<span style="font-family: inherit;"><?php</span><br />
<span style="font-family: inherit;">$sambung = mysql_connect("localhost", "root", "") or die ("Gagal konek ke server.");</span><br />
<span style="font-family: inherit;">mysql_select_db("data_siswa") or die ("Gagal membuka database.");</span><br />
<span style="font-family: inherit;">?></span><br />
<span style="font-family: inherit;"><table border="5"></span><br />
<span style="font-family: inherit;"><tr></span><br />
<span style="font-family: inherit;"><th>NIM</th></span><br />
<span style="font-family: inherit;"><th>Nama Mahasiswa</th></span><br />
<span style="font-family: inherit;"><th>Alamat</th></span><br />
<span style="font-family: inherit;"><th>Agama</th></span><br />
<span style="font-family: inherit;"><th>No_tlpn</th></span><br />
<span style="font-family: inherit;"><th colspan="3">Aksi</th></span><br />
<span style="font-family: inherit;"></tr></span><br />
<span style="font-family: inherit;"><?php</span><br />
<span style="font-family: inherit;">$query = "select * from mhs";</span><br />
<span style="font-family: inherit;">$result = mysql_query($query, $sambung);</span><br />
<span style="font-family: inherit;">//$no = 0;</span><br />
<span style="font-family: inherit;">while ($buff = mysql_fetch_array($result)){</span><br />
<span style="font-family: inherit;">//$no++;</span><br />
<span style="font-family: inherit;">?></span><br />
<span style="font-family: inherit;"><tr></span><br />
<span style="font-family: inherit;"><td><?php echo $buff['nim']; ?></td></span><br />
<span style="font-family: inherit;"><td><?php echo $buff['nama']; ?></td></span><br />
<span style="font-family: inherit;"><td><?php echo $buff['alamat']; ?></td></span><br />
<span style="font-family: inherit;"><td><?php echo $buff['agama']; ?></td></span><br />
<span style="font-family: inherit;"><td><?php echo $buff['notlpn']; ?></td></span><br />
<span style="font-family: inherit;"><td><a href="edit.php?nim=<?php echo $buff['nim']; ?>">Edit</a></td></span><br />
<span style="font-family: inherit;"><td><a href="hapus.php?nim=<?php echo $buff['nim']; ?>">Hapus</a></td></span><br />
<span style="font-family: inherit;"></tr></span><br />
<span style="font-family: inherit;"><?php</span><br />
<span style="font-family: inherit;">}</span><br />
<span style="font-family: inherit;">mysql_close($sambung);</span><br />
<span style="font-family: inherit;">?></span><br />
<span style="font-family: inherit;"></table></span><br />
<span style="font-family: inherit;"><p align="left"><a href="tambah.html">Tambah Data</a></p></span><br />
<span style="font-family: inherit;"></body></span><br />
<span style="font-family: inherit;"></html></span></div>
<span style="font-family: inherit;"><br style="background-color: white; color: #222222; line-height: 12px; margin: 0px; padding: 0px; text-align: justify;" /></span>
<span style="font-family: inherit;"><span style="background-color: white; color: #222222; line-height: 24px; text-align: justify;">4. File utama sudah jadi sekarang fungsi untuk memasukan data buat dengan nama </span><strong style="background-color: white; color: #222222; line-height: 24px; margin: 0px; padding: 0px; text-align: justify;">entry.php </strong><span style="background-color: white; color: #222222; line-height: 24px; text-align: justify;">sbb:</span></span><br />
<span style="font-family: inherit;"><br style="background-color: white; color: #222222; line-height: 12px; margin: 0px; padding: 0px; text-align: justify;" /></span>
<div style="background-color: #eeeeee; border: 3px solid rgb(221, 221, 221); color: #550000; font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 24px; margin: 0px; padding: 5px; text-align: justify;">
<span style="font-family: inherit;"><?php</span><br />
<span style="font-family: inherit;">include("koneksi.php");</span><br />
<span style="font-family: inherit;">$nim = $_POST['nim'];</span><br />
<span style="font-family: inherit;">$nama = $_POST['nama'];</span><br />
<span style="font-family: inherit;">$alamat = $_POST['alamat'];</span><br />
<span style="font-family: inherit;">$agama = $_POST['agama'];</span><br />
<span style="font-family: inherit;">$notlpn = $_POST['notlpn'];</span><br />
<span style="font-family: inherit;">$query = mysql_query("insert into mhs values  ('$nim','$nama','$alamat','$agama','$notlpn')");</span><br />
<span style="font-family: inherit;">echo "Data Telah disimpan<br></span><br />
<span style="font-family: inherit;"><a href=\"index.php\">Kembali</a>";</span><br />
<span style="font-family: inherit;">?></span></div>
<span style="font-family: inherit;"><br style="background-color: white; color: #222222; line-height: 12px; margin: 0px; padding: 0px; text-align: justify;" /></span>
<span style="font-family: inherit;"><br style="background-color: white; color: #222222; line-height: 12px; margin: 0px; padding: 0px; text-align: justify;" /></span>
<span style="font-family: inherit;"><span style="background-color: white; color: #222222; line-height: 24px; text-align: justify;">5. Kita perlu membuat file tampilan tambah data dengan nama </span><strong style="background-color: white; color: #222222; line-height: 24px; margin: 0px; padding: 0px; text-align: justify;">tambah.html </strong><span style="background-color: white; color: #222222; line-height: 24px; text-align: justify;">sbb:</span></span><br />
<span style="font-family: inherit;"><br style="background-color: white; color: #222222; line-height: 12px; margin: 0px; padding: 0px; text-align: justify;" /></span>
<span style="font-family: inherit;"><br style="background-color: white; color: #222222; line-height: 12px; margin: 0px; padding: 0px; text-align: justify;" /></span>
<div style="background-color: #eeeeee; border: 3px solid rgb(221, 221, 221); color: #550000; font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 24px; margin: 0px; padding: 5px; text-align: justify;">
<span style="font-family: inherit;"><html></span><br />
<span style="font-family: inherit;"><head><title>Tambah Data</title></head></span><br />
<span style="font-family: inherit;"><body></span><br />
<span style="font-family: inherit;"><h3><p align="left">Tambah Data Mahasiswa</p></h3></span><br />
<span style="font-family: inherit;"><form name="form1" method="post" action="entry.php"></span><br />
<span style="font-family: inherit;"><table></span><br />
<span style="font-family: inherit;"><tr></span><br />
<span style="font-family: inherit;"><td>NIM</td></span><br />
<span style="font-family: inherit;"><td><input type="text" name="nim" size="12"></td></span><br />
<span style="font-family: inherit;"></tr></span><br />
<span style="font-family: inherit;"><tr></span><br />
<span style="font-family: inherit;"><td>Nama</td></span><br />
<span style="font-family: inherit;"><td><input type="text" name="nama" size="30"></td></span><br />
<span style="font-family: inherit;"></tr></span><br />
<span style="font-family: inherit;"><tr></span><br />
<span style="font-family: inherit;"><td>Alamat</td></span><br />
<span style="font-family: inherit;"><td><input type="text" name="alamat" size="50"></td></span><br />
<span style="font-family: inherit;"></tr></span><br />
<span style="font-family: inherit;"><tr></span><br />
<span style="font-family: inherit;"><td>Agama</td></span><br />
<span style="font-family: inherit;"><td><input type="text" name="agama" size="10"></td></span><br />
<span style="font-family: inherit;"></tr></span><br />
<span style="font-family: inherit;"><tr></span><br />
<span style="font-family: inherit;"><td>No. Tlpn</td></span><br />
<span style="font-family: inherit;"><td><input type="text" name="notlpn" size="15"></td></span><br />
<span style="font-family: inherit;"></tr></span><br />
<span style="font-family: inherit;"><tr></span><br />
<span style="font-family: inherit;"><td><input value="Simpan" name="submit" type="submit" /></td></span><br />
<span style="font-family: inherit;"></tr></span><br />
<span style="font-family: inherit;"><tr></span><br />
<span style="font-family: inherit;"><td><input value="ulangi" type="reset" /></td></span><br />
<span style="font-family: inherit;"></tr></span><br />
<span style="font-family: inherit;"><tr></span><br />
<span style="font-family: inherit;"><td><input value="Kembali" type="button"  onClick="self.history.back()"></td></span><br />
<span style="font-family: inherit;"></tr></span><br />
<span style="font-family: inherit;"></table></span><br />
<span style="font-family: inherit;"></form></span><br />
<span style="font-family: inherit;"></body></span><br />
<span style="font-family: inherit;"></html></span></div>
<span style="font-family: inherit;"><br style="background-color: white; color: #222222; line-height: 12px; margin: 0px; padding: 0px; text-align: justify;" /></span>
<span style="font-family: inherit;"><span style="background-color: white; color: #222222; line-height: 24px; text-align: justify;">6. Fungsi update data dengan file </span><strong style="background-color: white; color: #222222; line-height: 24px; margin: 0px; padding: 0px; text-align: justify;">update.php </strong><span style="background-color: white; color: #222222; line-height: 24px; text-align: justify;"> sbb:</span></span><br />
<span style="font-family: inherit;"><br style="background-color: white; color: #222222; line-height: 12px; margin: 0px; padding: 0px; text-align: justify;" /></span>
<div style="background-color: #eeeeee; border: 3px solid rgb(221, 221, 221); color: #550000; font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 24px; margin: 0px; padding: 5px; text-align: justify;">
<span style="font-family: inherit;"><?php</span><br />
<span style="font-family: inherit;">include("koneksi.php");</span><br />
<span style="font-family: inherit;">$nim = $_POST['nim'];</span><br />
<span style="font-family: inherit;">$nama = $_POST['nama'];</span><br />
<span style="font-family: inherit;">$alamat = $_POST['alamat'];</span><br />
<span style="font-family: inherit;">$agama = $_POST['agama'];</span><br />
<span style="font-family: inherit;">$notlpn = $_POST['notlpn'];</span><br />
<span style="font-family: inherit;">$query = mysql_query("update mhs set nama='$nama', alamat='$alamat', agama='$agama',notlpn='$notlpn' where nim='$nim'");</span><br />
<span style="font-family: inherit;">echo "Data Telah diupdate<br></span><br />
<span style="font-family: inherit;"><a href=\"index.php\">Kembali</a>";</span><br />
<span style="font-family: inherit;">?></span></div>
<span style="font-family: inherit;"><br style="background-color: white; color: #222222; line-height: 12px; margin: 0px; padding: 0px; text-align: justify;" /></span>
<span style="font-family: inherit;"><span style="background-color: white; color: #222222; line-height: 24px; text-align: justify;">7. Buat Fungsi hapus data dengan file </span><strong style="background-color: white; color: #222222; line-height: 24px; margin: 0px; padding: 0px; text-align: justify;">hapus.php </strong><span style="background-color: white; color: #222222; line-height: 24px; text-align: justify;">sbb:</span></span><br />
<span style="font-family: inherit;"><br style="background-color: white; color: #222222; line-height: 12px; margin: 0px; padding: 0px; text-align: justify;" /></span>
<div style="background-color: #eeeeee; border: 3px solid rgb(221, 221, 221); color: #550000; font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 24px; margin: 0px; padding: 5px; text-align: justify;">
<span style="font-family: inherit;"><?php</span><br />
<span style="font-family: inherit;">include("koneksi.php");</span><br />
<span style="font-family: inherit;">mysql_query("DELETE from mhs WHERE nim='$_GET[nim]'");</span><br />
<span style="font-family: inherit;">echo"Data Telah dihapus<br></span><br />
<span style="font-family: inherit;"><a href=\"index.php\">Kembali</a>";</span><br />
<span style="font-family: inherit;">?></span></div>
<span style="font-family: inherit;"><br style="background-color: white; color: #222222; line-height: 12px; margin: 0px; padding: 0px; text-align: justify;" /></span>
<span style="font-family: inherit;"><span style="background-color: white; color: #222222; line-height: 24px; text-align: justify;">8. Terakhir buat fungsi edit dengan file name </span><strong style="background-color: white; color: #222222; line-height: 24px; margin: 0px; padding: 0px; text-align: justify;">edit.php </strong><span style="background-color: white; color: #222222; line-height: 24px; text-align: justify;">sbb:</span></span><br />
<span style="font-family: inherit;"><br style="background-color: white; color: #222222; line-height: 12px; margin: 0px; padding: 0px; text-align: justify;" /></span>
<div style="background-color: #eeeeee; border: 3px solid rgb(221, 221, 221); color: #550000; font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 24px; margin: 0px; padding: 5px; text-align: justify;">
<span style="font-family: inherit;"><?php</span><br />
<span style="font-family: inherit;"> $sambung = mysql_connect("localhost", "root", "") or die ("Gagal konek ke server.");</span><br />
<span style="font-family: inherit;">mysql_select_db("data_siswa") or die ("Gagal membuka database.");</span><br />
<span style="font-family: inherit;">//$edit=mysql_query("SELECT * FROM mhs WHERE nim='$_GET[nim]'");</span><br />
<span style="font-family: inherit;">//$r_edit=mysql_fetch_array($edit);</span><br />
<span style="font-family: inherit;">$nim = $_GET['nim'];</span><br />
<span style="font-family: inherit;">$query = "select * from mhs where nim='$nim'";</span><br />
<span style="font-family: inherit;">$result =  mysql_query($query, $sambung) or die("gagal melakukan query");</span><br />
<span style="font-family: inherit;">     $buff = mysql_fetch_array($result);</span><br />
<span style="font-family: inherit;">                 mysql_close($sambung);</span><br />
<span style="font-family: inherit;">?></span><br />
<span style="font-family: inherit;"><html></span><br />
<span style="font-family: inherit;"><head><title>Edit Data</title></head></span><br />
<span style="font-family: inherit;"><body></span><br />
<span style="font-family: inherit;"><form name="form1" method="post" action="update.php"></span><br />
<span style="font-family: inherit;"><table></span><br />
<span style="font-family: inherit;"><tr></span><br />
<span style="font-family: inherit;"><td>Nim</td><td><input
 type="text" name="nim" value="<?php echo $buff['nim']; 
?>"></td></tr></span><br />
<span style="font-family: inherit;"><tr><td>Nama</td><td><input
 type="text" name="nama" value="<?php echo $buff['nama']; 
?>"></td></tr></span><br />
<span style="font-family: inherit;"><tr><td>Alamat</td><td><input
 type="text" name="alamat" value="<?php echo $buff['alamat']; ?>" 
size="50"></td></tr></span><br />
<span style="font-family: inherit;"><tr><td>Agama</td><td><input
 type="text" name="agama" value="<?php echo $buff['agama']; 
?>"></td></tr></span><br />
<span style="font-family: inherit;"><tr><td>No. 
tlpn</td><td><input type="text" name="notlpn" 
value="<?php echo $buff['notlpn']; ?>"></td></tr></span><br />
<span style="font-family: inherit;"><tr></span><br />
<span style="font-family: inherit;"><input value="Simpan" type="submit" name="submit"/></span><br />
<span style="font-family: inherit;"><input type="button" value="Kembali" onClick="self.history.back()"></td></tr></span><br />
<span style="font-family: inherit;"></table></span><br />
<span style="font-family: inherit;"></form></span><br />
<span style="font-family: inherit;"></body></span><br />
<span style="font-family: inherit;"></html></span></div>
<span style="font-family: inherit;"><br style="background-color: white; color: #222222; line-height: 12px; margin: 0px; padding: 0px; text-align: justify;" /></span>
<span style="font-family: inherit;"><span style="background-color: white; color: #222222; line-height: 24px; text-align: justify;">Setelah semua file dibuat jalan kan localhost dan ketik dengan format </span>localhost/nama folder/index.php<span style="background-color: white; color: #222222; line-height: 24px; text-align: justify;">.</span></span><br />
<span style="background-color: white; color: #222222; font-family: inherit; line-height: 24px; text-align: justify;">Selamat berjuang membuat fungsi edit, tambah, hapus di php.</span><br />
<span style="font-family: inherit;"><br style="background-color: white; color: #222222; line-height: 12px; margin: 0px; padding: 0px; text-align: justify;" /></span>
<span style="background-color: white; color: #222222; font-family: inherit; line-height: 24px; text-align: justify;">Semoga sukses.<br /><br />Atau Download Script nya <a href="http://adf.ly/PeSOg" rel="nofollow" target="blank">Disini</a></span><span style="background-color: white; color: #222222; font-family: Verdana, 'Open Sans', sans-serif; font-size: 12px; line-height: 24px; text-align: justify;"><br /></span></div>

Cara Membuat Form Entry Data, Edit/Update, Hapus Di PHP

Pemprograman dasar database merupakan komponen utama yang ada untuk dapat membuat suatu aplikasi berjalan dengan penyimpanan . Oke, ki...

Baca selengkapnya »

Template Blog/Website Keren

IT FOR EDUCATION 0 Elearning, IT, Web 23.33

<div style="text-align: left;">
Untuk para penggemar/pembuat blog/website, pada kesempatan ini saya akan
 sharing tentang template blog dan website yang keren yang bisa kalian 
download secara gratis. silahkan download template nya dibawah ini:</div>
<div style="text-align: left;">
</div>
<ul style="text-align: left;">
<li>Sound & Techno</li>
</ul>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjs_Rg7v_BXXT9NdFQU_ClVD8cmMHRcoGQvTo7LXAVM6FdoPlQeFjvgVKytxhDfGqNMUubdUjh3Qk35Xop_BjFYwF0Rrq1Rbeutn1E-ei9zF-Enz5X4Hlkz4QSy3xUvdEAYiaR32XS5ivg/s1600/soud.jpg" style="margin-left: auto; margin-right: auto;"><img border="0" height="270" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjs_Rg7v_BXXT9NdFQU_ClVD8cmMHRcoGQvTo7LXAVM6FdoPlQeFjvgVKytxhDfGqNMUubdUjh3Qk35Xop_BjFYwF0Rrq1Rbeutn1E-ei9zF-Enz5X4Hlkz4QSy3xUvdEAYiaR32XS5ivg/s320/soud.jpg" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><a href="http://adf.ly/Pent2" target="blank">Download Template WEB</a><br />
<a href="http://adf.ly/PenvY" target="_blank">Download Template Blog</a></td></tr>
</tbody></table>
<ul style="text-align: left;">
<li>Fresh Natural</li>
</ul>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="clear: left; margin-bottom: 1em; margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgNGUaEcd36Dte1oCev-F98rbjb8azkIBn_3DBZJKsNteEkh6869OkW1l2vubiUFXIGEFG7YTtljYz-USCRtSWWiBEZ_5JC6TJCWjBjfnIXb0dMVWiqTgA1tIerFVqhClNB1Lkv8UDNDdY/s1600/fresh_actual.jpg" style="margin-left: auto; margin-right: auto;"><img border="0" height="197" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgNGUaEcd36Dte1oCev-F98rbjb8azkIBn_3DBZJKsNteEkh6869OkW1l2vubiUFXIGEFG7YTtljYz-USCRtSWWiBEZ_5JC6TJCWjBjfnIXb0dMVWiqTgA1tIerFVqhClNB1Lkv8UDNDdY/s320/fresh_actual.jpg" width="320" /></a></td></tr>
<tr><td class="tr-caption"><a href="http://adf.ly/PenxS" target="blank">Download Template WEB</a>
<br />
<a href="http://adf.ly/Penzd" target="blank">Download Template Blog</a></td></tr>
</tbody></table>
<ul style="text-align: left;">
<li>Technology</li>
</ul>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhxZywTyGIS0ro2-znx8lqZcorljRv9r5Gkg0fp-N7WdSGumobLpTtvGYLCkXd_H8tMsbar6qqksv8zJhHdAG8wiZUAOFo9ganCwbDGnrEuDlmOoVQSNKVOYdkd4Hx5-xOdKtzEvjw-5nA/s1600/tech1.jpg" style="margin-left: auto; margin-right: auto;"><img border="0" height="312" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhxZywTyGIS0ro2-znx8lqZcorljRv9r5Gkg0fp-N7WdSGumobLpTtvGYLCkXd_H8tMsbar6qqksv8zJhHdAG8wiZUAOFo9ganCwbDGnrEuDlmOoVQSNKVOYdkd4Hx5-xOdKtzEvjw-5nA/s320/tech1.jpg" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><a href="http://adf.ly/Peo1L" target="blank">Download Template WEB</a><br />
<a href="http://adf.ly/Peo3C" target="blank">Download Template Blog</a></td></tr>
</tbody></table>

Template Blog/Website Keren

Untuk para penggemar/pembuat blog/website, pada kesempatan ini saya akan sharing tentang template blog dan website yang keren yang bisa ka...

Baca selengkapnya »

Toolkit Membuat WEB CS

IT FOR EDUCATION 0 Elearning, IT, Web 23.31

<div style="text-align: justify;">
Dalam merancang sebuah web, selain ilmu/tutorial yang harus kita pahami,
 kita juga harus mempunyai toolkit/peralatan pendukung dalam pembuatan 
web. pada kesempatan posting kali ini saya akan membagikan toolkit yang 
sering digunakan dalam merancang WEB CS. silahkan download aplikasinya 
di bawah ini:</div>
<div style="text-align: justify;">
<br />
</div>
<div>
<b>1. Aplikasi WEB Editor</b></div>
<div style="text-align: left;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUMpxFv0ONXeAThaecBJzxXgLfFjgkPjjhp9WXrzhN9lElc5YxygW8Unx-63YOQhj1bexXl6V1lLmN2RXtVFlr3TeHV_WakTkcH6_aXm5gOEsWKO9ZKxjhYtQNgeEHEPFtWEJQdweOUPE/s1600/notepad++.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUMpxFv0ONXeAThaecBJzxXgLfFjgkPjjhp9WXrzhN9lElc5YxygW8Unx-63YOQhj1bexXl6V1lLmN2RXtVFlr3TeHV_WakTkcH6_aXm5gOEsWKO9ZKxjhYtQNgeEHEPFtWEJQdweOUPE/s200/notepad++.jpg" width="200" /></a></div>
<ul style="text-align: left;">
<li><a href="http://adf.ly/Peo6R" target="blank">Download Notepad++</a></li>
</ul>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJW5oCbdAMdGvzo4EzpxROGC4FcqKmkntnYiqcfDl9tSJwaMYg3K0dWuzqY88SDwanuDgFfkLnMABRT709sOyZZnArvXJBn_hRT3siK5DVlACoeHCC08IFBqtRcqMciOuKRuhayp9bX24/s1600/Adobe_Dreamweaver_8_ai.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJW5oCbdAMdGvzo4EzpxROGC4FcqKmkntnYiqcfDl9tSJwaMYg3K0dWuzqY88SDwanuDgFfkLnMABRT709sOyZZnArvXJBn_hRT3siK5DVlACoeHCC08IFBqtRcqMciOuKRuhayp9bX24/s200/Adobe_Dreamweaver_8_ai.png" width="200" /></a></div>
<ul style="text-align: left;">
<li><a href="http://adf.ly/Peo7j" target="blank">Download Dreamweaver</a></li>
</ul>
</div>
<div>
<b>2. Aplikasi WEB Browser</b></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjVRxV37NLZEBNdnzSuExfiWi4CS4C8Zo7oN5pv9GK2RUZatqaIdLKRGmZoHRTit8DAOaSKDU7cvFBfr8nhNgVl2aI3sABtQGHwQcscpJv4tPIVPxJ0FzK144a42K5N-IkRj5XOIDvOqkU/s1600/firefox.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjVRxV37NLZEBNdnzSuExfiWi4CS4C8Zo7oN5pv9GK2RUZatqaIdLKRGmZoHRTit8DAOaSKDU7cvFBfr8nhNgVl2aI3sABtQGHwQcscpJv4tPIVPxJ0FzK144a42K5N-IkRj5XOIDvOqkU/s200/firefox.jpg" width="200" /></a></div>
<div style="text-align: left;">
<br />
<ul style="text-align: left;">
<li><a href="http://adf.ly/Peo9l" target="blank">Download Firefox</a></li>
</ul>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgi3egsZtNRtK0hEu-qoUW37tNI658SH_uN4ozJ-zkuQZy3JyyoI0d6KkkeiZFj6hUWMGKaKsEqTfQsfO0emsvDrB3TgOpXVsqPKYGE1YG7UjWeb7SnY3A_W6YqVCcaKaraWXjBLAEE-Ik/s1600/googlechrome.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="149" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgi3egsZtNRtK0hEu-qoUW37tNI658SH_uN4ozJ-zkuQZy3JyyoI0d6KkkeiZFj6hUWMGKaKsEqTfQsfO0emsvDrB3TgOpXVsqPKYGE1YG7UjWeb7SnY3A_W6YqVCcaKaraWXjBLAEE-Ik/s200/googlechrome.jpg" width="200" /></a></div>
<div style="text-align: left;">
</div>
<br />
<ul style="text-align: left;">
<li><a href="http://adf.ly/PeoBB" target="blank">Download GoogleChrome</a></li>
</ul>
</div>
<div>
<b>3. Aplikasi WEB Server</b></div>
<div style="text-align: left;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjatFZbnMW3IMioD-_mn5NQyWEk2PEDvLZ76RfuhqWVOQRpNYQfpodr6PPNpLqAXW_NPKCCl4CybXCYor8G6MGKucOf3moKySxfDig47-Tsro3iSZsyXGGxNCeiJC3GYD7SnNiMBbsKxsc/s1600/XAMPP+%25281%2529.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="175" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjatFZbnMW3IMioD-_mn5NQyWEk2PEDvLZ76RfuhqWVOQRpNYQfpodr6PPNpLqAXW_NPKCCl4CybXCYor8G6MGKucOf3moKySxfDig47-Tsro3iSZsyXGGxNCeiJC3GYD7SnNiMBbsKxsc/s200/XAMPP+%25281%2529.jpg" width="200" /></a></div>
<br />
<ul style="text-align: left;">
<li><a href="http://adf.ly/PeoCq" target="blank">Download Xampp</a></li>
</ul>
</div>

Toolkit Membuat WEB CS

Dalam merancang sebuah web, selain ilmu/tutorial yang harus kita pahami, kita juga harus mempunyai toolkit/peralatan pendukung dalam pembu...

Baca selengkapnya »

Input Data Ke Database Melalui Halaman WEB

IT FOR EDUCATION 0 Elearning, IT, Web 23.29

<br />
<br />
<div class="MsoBodyTextIndent3" style="margin-left: 72.0pt; text-indent: 0cm;">
Pada Posting kali ini, saya akan membahas bagaimana cara membuat halaman web untuk memasukan/input data ke database.</div>
<div class="MsoBodyTextIndent3" style="margin-left: 72.0pt; text-indent: 0cm;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqU-T9I6Qf39N9nad92i89cOlA5RLHOv5jiL7RKPnTdakzU3Pot4Zyl9-nBgvKGSNWawz_tcMjXu0JtBdGtdbd5fQFiWNZOHjGNlLFQD9S3tijW4fQTLY6AT-jLL9-dVOPYepSrtYYY0w/s1600/input.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="188" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqU-T9I6Qf39N9nad92i89cOlA5RLHOv5jiL7RKPnTdakzU3Pot4Zyl9-nBgvKGSNWawz_tcMjXu0JtBdGtdbd5fQFiWNZOHjGNlLFQD9S3tijW4fQTLY6AT-jLL9-dVOPYepSrtYYY0w/s320/input.jpg" width="320" /></a></div>
</div>
<div class="MsoBodyTextIndent3" style="margin-left: 72.0pt; text-indent: 0cm;">
Untuk
memasukan data ke dalam database melalui  desain web, ada beberapa hal
yang harus diperhatikan diantaranya:<br />
<b>1.<span style="font-size: 7pt;">      </span>System
Database</b><br />
<b>        <i>a.<span style="font-size: 7pt;">       </span>Nama
database</i></b><br />
<b><i>        b.<span style="font-size: 7pt;">      </span>Nama
tabel</i></b><br />
<b><i>       c.<span style="font-size: 7pt;">       </span>Struktur
dari tabel</i></b><br />
<b>2.<span style="font-size: 7pt;">      </span>Web
desain</b><br />
<b>      <i>a.<span style="font-size: 7pt;">       </span>Form
inputan</i></b><br />
<b><i>      b.<span style="font-size: 7pt;">      </span>Koneksi
ke database</i></b><br />
<b><i>      c.<span style="font-size: 7pt;">       </span>Query
ke database</i></b><br />
<b><i>      d.<span style="font-size: 7pt;">      </span>Pengiriman
data dari form ke query</i></b></div>
<div class="MsoBodyTextIndent3" style="margin-left: 126.0pt; mso-list: l0 level2 lfo1; text-indent: -18.0pt;">
</div>
<div class="MsoBodyTextIndent3" style="margin-left: 126.0pt; mso-list: l0 level2 lfo1; text-indent: -18.0pt;">
</div>
<div class="MsoBodyTextIndent3" style="margin-left: 54pt; text-align: left; text-indent: -18pt;">
<b><i>1.<span style="font-size: 7pt;">      </span>System
Database</i></b></div>
<div class="MsoBodyTextIndent3" style="margin-left: 54pt; text-align: left; text-indent: 0cm;">
-
Buatlah database dengan nama anda masing-masing</div>
<div class="MsoBodyTextIndent3" style="margin-left: 54pt; text-align: left; text-indent: 0cm;">
- Buat
tabel anggota di dalam database yang anda buat, dengan struktur sebagai
berikut:</div>
<div align="center">
<table border="1" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="border-collapse: collapse; border: none;">
 <tbody>
<tr>
  <td style="background-color: #cccccc; background-position: initial initial; background-repeat: initial initial; border: 1pt solid windowtext; padding: 0cm 5.4pt; width: 109.65pt;" valign="top" width="146"><div align="center" class="MsoBodyTextIndent3" style="text-align: center; text-indent: 0cm;">
<b>Nama Field</b></div>
</td>
  <td style="background-color: #cccccc; background-position: initial initial; background-repeat: initial initial; border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: solid solid solid none; border-top-color: windowtext; border-top-width: 1pt; padding: 0cm 5.4pt; width: 109.65pt;" valign="top" width="146"><div align="center" class="MsoBodyTextIndent3" style="text-align: center; text-indent: 0cm;">
<b>Type Data</b></div>
</td>
  <td style="background-color: #cccccc; background-position: initial initial; background-repeat: initial initial; border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: solid solid solid none; border-top-color: windowtext; border-top-width: 1pt; padding: 0cm 5.4pt; width: 109.65pt;" valign="top" width="146"><div align="center" class="MsoBodyTextIndent3" style="text-align: center; text-indent: 0cm;">
<b>Panjang Karakter</b></div>
</td>
 </tr>
<tr>
  <td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-left-color: windowtext; border-left-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid; padding: 0cm 5.4pt; width: 109.65pt;" valign="top" width="146"><div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
Kd_Anggota</div>
</td>
  <td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; padding: 0cm 5.4pt; width: 109.65pt;" valign="top" width="146"><div align="center" class="MsoBodyTextIndent3" style="text-align: center; text-indent: 0cm;">
INT</div>
</td>
  <td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; padding: 0cm 5.4pt; width: 109.65pt;" valign="top" width="146"><div align="center" class="MsoBodyTextIndent3" style="text-align: center; text-indent: 0cm;">
7</div>
</td>
 </tr>
<tr>
  <td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-left-color: windowtext; border-left-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid; padding: 0cm 5.4pt; width: 109.65pt;" valign="top" width="146"><div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
Nama</div>
</td>
  <td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; padding: 0cm 5.4pt; width: 109.65pt;" valign="top" width="146"><div align="center" class="MsoBodyTextIndent3" style="text-align: center; text-indent: 0cm;">
VARCHAR</div>
</td>
  <td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; padding: 0cm 5.4pt; width: 109.65pt;" valign="top" width="146"><div align="center" class="MsoBodyTextIndent3" style="text-align: center; text-indent: 0cm;">
20</div>
</td>
 </tr>
<tr>
  <td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-left-color: windowtext; border-left-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid; padding: 0cm 5.4pt; width: 109.65pt;" valign="top" width="146"><div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
Alamat</div>
</td>
  <td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; padding: 0cm 5.4pt; width: 109.65pt;" valign="top" width="146"><div align="center" class="MsoBodyTextIndent3" style="text-align: center; text-indent: 0cm;">
VARCHAR</div>
</td>
  <td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; padding: 0cm 5.4pt; width: 109.65pt;" valign="top" width="146"><div align="center" class="MsoBodyTextIndent3" style="text-align: center; text-indent: 0cm;">
30</div>
</td>
 </tr>
<tr>
  <td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-left-color: windowtext; border-left-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid; padding: 0cm 5.4pt; width: 109.65pt;" valign="top" width="146"><div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
Tgl_Lahir</div>
</td>
  <td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; padding: 0cm 5.4pt; width: 109.65pt;" valign="top" width="146"><div align="center" class="MsoBodyTextIndent3" style="text-align: center; text-indent: 0cm;">
VARCHAR</div>
</td>
  <td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; padding: 0cm 5.4pt; width: 109.65pt;" valign="top" width="146"><div align="center" class="MsoBodyTextIndent3" style="text-align: center; text-indent: 0cm;">
15</div>
</td>
 </tr>
</tbody></table>
</div>
<div class="MsoBodyTextIndent3" style="text-align: left; text-indent: 0cm;">
</div>
<div class="MsoBodyTextIndent3" style="text-align: left; text-indent: 0cm;">
</div>
<div class="MsoBodyTextIndent3" style="margin-left: 36pt; text-align: left; text-indent: 36pt;">
-
Masukkan data berikut kedalam tabel anggota:</div>
<table border="1" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; border: none; margin-left: 36pt; text-align: left;">
 <tbody>
<tr>
  <td style="border: 1pt solid black; padding: 0cm 5.4pt; width: 69.5pt;" valign="top" width="93"><div align="center" class="MsoBodyTextIndent3" style="text-align: center; text-indent: 0cm;">
Kd_anggota</div>
</td>
  <td style="border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: solid solid solid none; border-top-color: black; border-top-width: 1pt; padding: 0cm 5.4pt; width: 152.4pt;" valign="top" width="203"><div align="center" class="MsoBodyTextIndent3" style="text-align: center; text-indent: 0cm;">
Nama</div>
</td>
  <td style="border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: solid solid solid none; border-top-color: black; border-top-width: 1pt; padding: 0cm 5.4pt; width: 109.85pt;" valign="top" width="146"><div align="center" class="MsoBodyTextIndent3" style="text-align: center; text-indent: 0cm;">
Alamat</div>
</td>
  <td style="border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: solid solid solid none; border-top-color: black; border-top-width: 1pt; padding: 0cm 5.4pt; width: 111.15pt;" valign="top" width="148"><div align="center" class="MsoBodyTextIndent3" style="text-align: center; text-indent: 0cm;">
Tgl_lahir</div>
</td>
 </tr>
<tr>
  <td style="border-bottom-color: black; border-bottom-width: 1pt; border-left-color: black; border-left-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid; padding: 0cm 5.4pt; width: 69.5pt;" valign="top" width="93"><div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
1001</div>
</td>
  <td style="border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 0cm 5.4pt; width: 152.4pt;" valign="top" width="203"><div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
Valentino Rossi</div>
</td>
  <td style="border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 0cm 5.4pt; width: 109.85pt;" valign="top" width="146"><div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
Italia</div>
</td>
  <td style="border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 0cm 5.4pt; width: 111.15pt;" valign="top" width="148"><div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
27 April 1975</div>
</td>
 </tr>
<tr>
  <td style="border-bottom-color: black; border-bottom-width: 1pt; border-left-color: black; border-left-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid; padding: 0cm 5.4pt; width: 69.5pt;" valign="top" width="93"><div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
1002</div>
</td>
  <td style="border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 0cm 5.4pt; width: 152.4pt;" valign="top" width="203"><div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
Jorge Lorenzo</div>
</td>
  <td style="border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 0cm 5.4pt; width: 109.85pt;" valign="top" width="146"><div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
Spanyol</div>
</td>
  <td style="border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 0cm 5.4pt; width: 111.15pt;" valign="top" width="148"><div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
14 April 1980</div>
</td>
 </tr>
<tr>
  <td style="border-bottom-color: black; border-bottom-width: 1pt; border-left-color: black; border-left-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid; padding: 0cm 5.4pt; width: 69.5pt;" valign="top" width="93"><div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
1003</div>
</td>
  <td style="border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 0cm 5.4pt; width: 152.4pt;" valign="top" width="203"><div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
Nicky Hayden</div>
</td>
  <td style="border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 0cm 5.4pt; width: 109.85pt;" valign="top" width="146"><div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
Amerika Serikat</div>
</td>
  <td style="border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 0cm 5.4pt; width: 111.15pt;" valign="top" width="148"><div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
20 Pebruari 1978</div>
</td>
 </tr>
<tr>
  <td style="border-bottom-color: black; border-bottom-width: 1pt; border-left-color: black; border-left-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid; padding: 0cm 5.4pt; width: 69.5pt;" valign="top" width="93"><div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
1004</div>
</td>
  <td style="border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 0cm 5.4pt; width: 152.4pt;" valign="top" width="203"><div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
Casey Stoner</div>
</td>
  <td style="border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 0cm 5.4pt; width: 109.85pt;" valign="top" width="146"><div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
Australia</div>
</td>
  <td style="border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 0cm 5.4pt; width: 111.15pt;" valign="top" width="148"><div class="MsoBodyTextIndent3" style="margin-left: 36pt; text-indent: -18pt;">
19<span style="font-size: 7pt;">    </span>aret
  1980</div>
</td>
 </tr>
</tbody></table>
<div class="MsoBodyTextIndent3" style="margin-left: 18pt; text-align: left; text-indent: 0cm;">
</div>
<br />
<div class="MsoBodyTextIndent3" style="margin-left: 126.0pt; mso-list: l0 level2 lfo1; text-indent: -18.0pt;">
</div>
<div class="MsoBodyTextIndent3" style="margin-left: 18.0pt; text-indent: 0cm;">
   <b><i> 2</i></b><b><i><span style="text-indent: -18pt;">.</span><span style="font-size: 7pt; text-indent: -18pt;">      </span><span style="text-indent: -18pt;">Desain
WEB</span></i></b></div>
<div class="MsoBodyTextIndent3" style="margin-left: 54.0pt; mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
</div>
<div class="MsoBodyTextIndent3" style="margin-left: 54.0pt; text-indent: 0cm;">
Setelah selesai merancang database, selanjutnya adalah membuat script 
untuk Form input data dan Insert data. Berikut ini adalah ke-2 script 
yang harus dibuat</div>
<div class="MsoBodyTextIndent3" style="margin-left: 54.0pt; text-indent: 0cm;">
<b>a. Form Input</b></div>
<div class="MsoBodyTextIndent3" style="margin-left: 54.0pt; text-indent: 0cm;">
<b>    Ketikan
script berikut dan simpan dengan nama form_input.php</b></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_Zhp2yoxkye48zbFw3nafVT2aeEOOE2FGZQML37xCr_mBgUVXxbVIiTQeABPAUetMmP98wyX3MiJ__CKVih2Nz_VJCw55mHJ5ITwFDmMHocOyq76m5FrwMzMTkwWiWDswkAOCwL8qivY/s1600/fi.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_Zhp2yoxkye48zbFw3nafVT2aeEOOE2FGZQML37xCr_mBgUVXxbVIiTQeABPAUetMmP98wyX3MiJ__CKVih2Nz_VJCw55mHJ5ITwFDmMHocOyq76m5FrwMzMTkwWiWDswkAOCwL8qivY/s640/fi.jpg" width="587" /></a></div>
<div class="MsoBodyTextIndent3" style="margin-left: 54.0pt; text-indent: 0cm;">
<b><br /></b></div>
<div class="MsoBodyTextIndent3" style="margin-left: 54.0pt; text-indent: 0cm;">
<b>b. Insert Data</b></div>
<div class="MsoBodyTextIndent3" style="margin-left: 54.0pt; text-indent: 0cm;">
<b>    </b><b>Ketikan script berikut dan simpan dengan nama insert_data.php</b></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_Zhp2yoxkye48zbFw3nafVT2aeEOOE2FGZQML37xCr_mBgUVXxbVIiTQeABPAUetMmP98wyX3MiJ__CKVih2Nz_VJCw55mHJ5ITwFDmMHocOyq76m5FrwMzMTkwWiWDswkAOCwL8qivY/s1600/fi.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_Zhp2yoxkye48zbFw3nafVT2aeEOOE2FGZQML37xCr_mBgUVXxbVIiTQeABPAUetMmP98wyX3MiJ__CKVih2Nz_VJCw55mHJ5ITwFDmMHocOyq76m5FrwMzMTkwWiWDswkAOCwL8qivY/s640/fi.jpg" width="588" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<div class="separator" style="clear: both; text-align: left;">
Untuk Hasil dan Pembahasan yang lainnya dapat di download di link di bawah ini</div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<div class="separator" style="clear: both; text-align: left;">
<a href="http://adf.ly/PeoGG" target="blank">Download Tutorial Input Data</a></div>
<div class="MsoBodyTextIndent3" style="margin-left: 54.0pt; text-indent: 0cm;">
<b><br /></b></div>

Input Data Ke Database Melalui Halaman WEB

Pada Posting kali ini, saya akan membahas bagaimana cara membuat halaman web untuk memasukan/input data ke database. Untuk memasuka...

Baca selengkapnya »

Koneksi Database dan Menampilkan Data dari Tabel ke File WEB

IT FOR EDUCATION 0 Elearning, IT, Web 23.28

<div class="MsoBodyTextIndent3">
<a href="http://bloger-tkj-dos-q28.blogspot.com/2013/05/koneksi-database-dan-menampilkan-data.html" target="_blank">Koneksi Database dan Menampilkan Data dari Tabel ke File WEB</a>,<br /><div style="text-align: justify;">
Data adalah sekumpulan bahan yang akan diproses
menjadi sebuah informasi. Setiap data seharusnya disimpan atau didokumentasikan
sehingga jika sewaktu-waktu dibutuhkan dapat dirproses dengan mudah.<span lang="IN" style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; line-height: 115%; mso-ansi-language: IN; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-no-proof: yes;">Didalam pemrograman web cs, proses
penyimpanan data ke dalam tabel umumnya akan melibatkan dua buah script yang
saling berhubungan. Script pertama yaitu berupa form untuk pemasukan data
sesuai dengan field-field yang ada di dalam tabel serta perintah untuk membuka
tabel tempat menyimpan data tersebut. Script kedua yaitu berupa perintah SQL
untuk menyimpan data-data yang telah dimasukan lewat form tersebut ke dalam
tabel yang dituju.</span><br /><span lang="IN" style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; line-height: 115%; mso-ansi-language: IN; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-no-proof: yes;"></span><br /><span lang="IN" style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; line-height: 115%; mso-ansi-language: IN; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-no-proof: yes;"></span><span style="font-family: Calibri, sans-serif;"><span style="font-size: 15px; line-height: 17px;">Langkah
 Untuk Membuat file web yang menampilkan data dari suatu database, kita 
harus mempunyai/membuat database sebagai data yang akan ditampilkan di 
web yang kita rancang. untuk mempermudah prosesnya, ikuti 
langkah-langkah dibawah ini;</span></span></div>
</div>
<br />
<span style="font-family: Calibri, sans-serif;"><span style="font-size: 15px; line-height: 17px;">1. Membuat Database </span></span><br />
<br />
<div class="MsoBodyTextIndent3" style="margin-left: 36.0pt; mso-list: l1 level1 lfo1; text-indent: -18.0pt;">
1.<span style="font-size: 7pt;">      </span>Buat database dengan nama SEWA,
selanjutnya buat sebuah tabel dengan nama <b>Anggota</b>
yang bersisikan field-field sebagai berikut :</div>
<div align="center">
<table border="1" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="border-collapse: collapse; border: none; mso-border-alt: solid windowtext .5pt; mso-border-insideh: .5pt solid windowtext; mso-border-insidev: .5pt solid windowtext; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt;">
 <tbody>
<tr>
  <td style="background: #CCCCCC; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 109.65pt;" valign="top" width="146"><div align="center" class="MsoBodyTextIndent3" style="text-align: center; text-indent: 0cm;">
<b>Nama Field</b></div>
</td>
  <td style="background: #CCCCCC; border-left: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 109.65pt;" valign="top" width="146"><div align="center" class="MsoBodyTextIndent3" style="text-align: center; text-indent: 0cm;">
<b>Type Data</b></div>
</td>
  <td style="background: #CCCCCC; border-left: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 109.65pt;" valign="top" width="146"><div align="center" class="MsoBodyTextIndent3" style="text-align: center; text-indent: 0cm;">
<b>Panjang Karakter</b></div>
</td>
 </tr>
<tr>
  <td style="border-top: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 109.65pt;" valign="top" width="146"><div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
Kd_Anggota</div>
</td>
  <td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 109.65pt;" valign="top" width="146"><div align="center" class="MsoBodyTextIndent3" style="text-align: center; text-indent: 0cm;">
INT</div>
</td>
  <td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 109.65pt;" valign="top" width="146"><div align="center" class="MsoBodyTextIndent3" style="text-align: center; text-indent: 0cm;">
7</div>
</td>
 </tr>
<tr>
  <td style="border-top: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 109.65pt;" valign="top" width="146"><div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
Nama</div>
</td>
  <td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 109.65pt;" valign="top" width="146"><div align="center" class="MsoBodyTextIndent3" style="text-align: center; text-indent: 0cm;">
VARCHAR</div>
</td>
  <td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 109.65pt;" valign="top" width="146"><div align="center" class="MsoBodyTextIndent3" style="text-align: center; text-indent: 0cm;">
20</div>
</td>
 </tr>
<tr>
  <td style="border-top: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 109.65pt;" valign="top" width="146"><div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
Alamat</div>
</td>
  <td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 109.65pt;" valign="top" width="146"><div align="center" class="MsoBodyTextIndent3" style="text-align: center; text-indent: 0cm;">
VARCHAR</div>
</td>
  <td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 109.65pt;" valign="top" width="146"><div align="center" class="MsoBodyTextIndent3" style="text-align: center; text-indent: 0cm;">
30</div>
</td>
 </tr>
<tr>
  <td style="border-top: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 109.65pt;" valign="top" width="146"><div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
Tgl_Lahir</div>
</td>
  <td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 109.65pt;" valign="top" width="146"><div align="center" class="MsoBodyTextIndent3" style="text-align: center; text-indent: 0cm;">
VARCHAR</div>
</td>
  <td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 109.65pt;" valign="top" width="146"><div align="center" class="MsoBodyTextIndent3" style="text-align: center; text-indent: 0cm;">
15</div>
</td>
 </tr>
</tbody></table>
</div>
<div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
</div>
<div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
</div>
<div class="MsoBodyTextIndent3" style="margin-left: 36.0pt; mso-list: l1 level1 lfo1; text-indent: -18.0pt;">
2.<span style="font-size: 7pt;">      </span>Masukkan
data berikut kedalam tabel anggota:</div>
<table border="1" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; border: none; margin-left: 36.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; mso-yfti-tbllook: 1184;">
 <tbody>
<tr>
  <td style="border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.5pt;" valign="top" width="93"><div align="center" class="MsoBodyTextIndent3" style="text-align: center; text-indent: 0cm;">
Kd_anggota</div>
</td>
  <td style="border-left: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-themecolor: text1; mso-border-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 152.4pt;" valign="top" width="203"><div align="center" class="MsoBodyTextIndent3" style="text-align: center; text-indent: 0cm;">
Nama</div>
</td>
  <td style="border-left: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-themecolor: text1; mso-border-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 109.85pt;" valign="top" width="146"><div align="center" class="MsoBodyTextIndent3" style="text-align: center; text-indent: 0cm;">
Alamat</div>
</td>
  <td style="border-left: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-themecolor: text1; mso-border-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 111.15pt;" valign="top" width="148"><div align="center" class="MsoBodyTextIndent3" style="text-align: center; text-indent: 0cm;">
Tgl_lahir</div>
</td>
 </tr>
<tr>
  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.5pt;" valign="top" width="93"><div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
1001</div>
</td>
  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 152.4pt;" valign="top" width="203"><div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
Valentino Rossi</div>
</td>
  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 109.85pt;" valign="top" width="146"><div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
Italia</div>
</td>
  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 111.15pt;" valign="top" width="148"><div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
27 April 1975</div>
</td>
 </tr>
<tr>
  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.5pt;" valign="top" width="93"><div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
1002</div>
</td>
  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 152.4pt;" valign="top" width="203"><div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
Jorge Lorenzo</div>
</td>
  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 109.85pt;" valign="top" width="146"><div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
Spanyol</div>
</td>
  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 111.15pt;" valign="top" width="148"><div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
14 April 1980</div>
</td>
 </tr>
<tr>
  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.5pt;" valign="top" width="93"><div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
1003</div>
</td>
  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 152.4pt;" valign="top" width="203"><div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
Nicky Hayden</div>
</td>
  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 109.85pt;" valign="top" width="146"><div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
Amerika Serikat</div>
</td>
  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 111.15pt;" valign="top" width="148"><div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
20 Pebruari 1978</div>
</td>
 </tr>
<tr>
  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.5pt;" valign="top" width="93"><div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
1004</div>
</td>
  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 152.4pt;" valign="top" width="203"><div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
Casey Stoner</div>
</td>
  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 109.85pt;" valign="top" width="146"><div class="MsoBodyTextIndent3" style="text-indent: 0cm;">
Australia</div>
</td>
  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 111.15pt;" valign="top" width="148"><div class="MsoBodyTextIndent3" style="margin-left: 36.0pt; mso-list: l0 level1 lfo2; text-indent: -18.0pt;">
19<span style="font-size: 7pt;">    </span>aret
  1980</div>
</td>
 </tr>
</tbody></table>
<br />
2. Membuat File WEB<br />
<br />
<div class="MsoBodyTextIndent3" style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
1.<span style="font-size: 7pt;">      </span>Ketikanlah
script sebagai berikut:</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidcEvkWMK9m3PFXx5ffqjeQ6KkVlwhcl1X9XrIFAuTMCmAcQedUaTRom5lYcAKKHDEk5JjSwCeQyH2Kuhs_V2gO4IohgdzS6Uu8PdvujHA8slB_54sUyBYsn6EWBan6_3wWMwXJP1fSlU/s1600/tamp.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidcEvkWMK9m3PFXx5ffqjeQ6KkVlwhcl1X9XrIFAuTMCmAcQedUaTRom5lYcAKKHDEk5JjSwCeQyH2Kuhs_V2gO4IohgdzS6Uu8PdvujHA8slB_54sUyBYsn6EWBan6_3wWMwXJP1fSlU/s640/tamp.jpg" width="601" /></a></div>
<div class="MsoBodyTextIndent3" style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
</div>
<div class="MsoBodyTextIndent3" style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
</div>
<div class="MsoBodyTextIndent3" style="margin-left: 36.0pt; text-indent: 0cm;">

</div>
<div class="MsoBodyTextIndent3" style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<span style="font-size: 14.0pt; line-height: 150%; mso-bidi-font-size: 12.0pt;">2.<span style="font-size: 7pt; line-height: normal;">     </span></span>Jalankan
script diatas</div>
<div class="MsoBodyTextIndent3" style="margin-left: 36.0pt; text-indent: 0cm;">
<b><span style="font-size: 14.0pt; line-height: 150%; mso-bidi-font-size: 12.0pt; mso-no-proof: yes;">
 
</span></b><b><span style="font-size: 14.0pt; line-height: 150%; mso-bidi-font-size: 12.0pt;"></span></b></div>
<div class="MsoBodyTextIndent3" style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<span style="font-size: 14.0pt; line-height: 150%; mso-bidi-font-size: 12.0pt;">3.<span style="font-size: 7pt; line-height: normal;">     </span></span>Amati
script diatas..!<b><span style="font-size: 14.0pt; line-height: 150%; mso-bidi-font-size: 12.0pt;"></span></b></div>
<div class="MsoBodyTextIndent3" style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
</div>
<div class="MsoBodyTextIndent3" style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<a href="http://adf.ly/PeoJb" rel="nofollow" target="blank">Download Tutorial Menampilkan Data dari Database ke WEB</a></div>

Koneksi Database dan Menampilkan Data dari Tabel ke File WEB

Koneksi Database dan Menampilkan Data dari Tabel ke File WEB , Data adalah sekumpulan bahan yang akan diproses menjadi sebuah informasi. S...

Baca selengkapnya »

Perintah Dasar Query

IT FOR EDUCATION 0 Elearning, IT, Web 23.27

<div dir="ltr" style="text-align: left;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjb_lJ7EeHFHIEBpwCpsVjC9ANrIjkeykC8oNLDJzPW4tdy_vCadecTAn9W-RbvHHnniq5IrFK0Kr_Y49nHduusvcyPRadxbjQsivbyaQ3CZtNhFq5WZHjJ1cWBEdM0CZv1U0cUb7Aifo8/s1600/t11.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="171" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjb_lJ7EeHFHIEBpwCpsVjC9ANrIjkeykC8oNLDJzPW4tdy_vCadecTAn9W-RbvHHnniq5IrFK0Kr_Y49nHduusvcyPRadxbjQsivbyaQ3CZtNhFq5WZHjJ1cWBEdM0CZv1U0cUb7Aifo8/s400/t11.jpg" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div>
<b><i><br /></i></b></div>
<br />
<b><i>1. SELECT</i></b><br />
<div>
Perintah select digunakan untuk memanggil data/menampilkan data dari suatu tabel.<br />
Contoh :</div>
<div>
<i>select * from tbl_anggota;</i></div>
<div>
<i>ket: menampilkan semua record dari tbl_anggota</i></div>
<div>
<i><br /></i></div>
<div>
<i>select * from tbl_anggota where kd_anggota='1001';</i></div>
<div>
<i>ket: menampilkan semua record dari tbl_nggota yang kd_anggota nya 1001</i></div>
<div>
<br />
<b><i>2. INSERT</i></b></div>
<div>
perintah ini digunakan untuk memasukan data ke tabel</div>
<div>
contoh :</div>
<div>
<i>insert into tbl_anggota values('field1','field2','fieldN',..);</i></div>
<div>
<i>ket: memasukan data ke tbl_anggota dengan nilai field....</i></div>
<div>
<br />
<b><i>3. UPDATE</i></b></div>
<div>
perintah query update digunkan untuk merubah data/record dari suatu tabel dengan data/record yang baru yang ditentukan.</div>
<div>
contoh:</div>
<div>
<i>update tgl_anggota set name='Simonceli' where kd_anggota='20973';</i></div>
<div>
<i>ket: merubah record nama menjadi Simonceli dari tbl_anggota yang kd_anggota nya 20973</i></div>
<div>
<br />
<b><i>4. DELETE</i></b></div>
<div>
yaitu perintah yang digunakan untuk menghapus data dari suatu tabel.</div>
<div>
contoh :</div>
<div>
<i>delete from tbl_anggota;</i></div>
<div>
<i>ket: menghapus semua record dari tbl_anggota</i></div>
<div>
<i><br /></i></div>
<div>
<i>delete from tbl_anggota where kd_anggota='1001';</i></div>
<div>
<i>ket : menghapus record dari tbl_anggota yang kd_anggota nya 1001</i></div>
<div>
<i><br /></i></div>
<div>
<i><a href="http://adf.ly/PeoMY" target="blank">Link Tutorial Query</a></i></div>
</div>

Perintah Dasar Query

1. SELECT Perintah select digunakan untuk memanggil data/menampilkan data dari suatu tabel. Contoh : select * from tbl_anggota;...

Baca selengkapnya »

Membuat Database "phpMyadmin"

IT FOR EDUCATION 0 Elearning, IT, Web 23.25

<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEFnTfhLj9tleKWY_VHDFtfmwIre8OcEHuTGJKZyO0n5YXwWZFO8bK4fuUe7R4to9qZYkR65rUvzf8HmJUS2ThiP-279SYsq74aeV6_EeeBrDHLABwVmWiZdwb3YLkmEw_RE6w9MN6KOM/s1600/phpmyadmin+logo.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="282" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEFnTfhLj9tleKWY_VHDFtfmwIre8OcEHuTGJKZyO0n5YXwWZFO8bK4fuUe7R4to9qZYkR65rUvzf8HmJUS2ThiP-279SYsq74aeV6_EeeBrDHLABwVmWiZdwb3YLkmEw_RE6w9MN6KOM/s400/phpmyadmin+logo.png" width="400" /></a></div>
<div class="MsoNormal" style="line-height: 150%; text-align: justify; text-indent: 45.0pt;">
<i><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 150%; mso-bidi-font-size: 11.0pt;">phpMyAdmin </span></i><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 150%; mso-bidi-font-size: 11.0pt;">merupakan tool database yang dibuat
secara visual sehingga lebih memudahkan user dalam melakukan operasi database.
Software ini dibuat khusus oleh mysql untuk menangani database pada PHP,
sehingga setiap user melakukan operasi database dengan software ini maka secara
otomatis akan diarahkan pada direktori yang mampu dibaca oleh MySQL maupun oleh
PHP.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 150%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt;"></span></div>
<div class="MsoNormal" style="line-height: 150%; text-align: justify; text-indent: 45.0pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 150%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt;">Pada Pertemuan
sebelumnya, kita sudah mempelajari tentang perintah-perintah dasar mysql dan
berinteraksi dengan database dengan bahasa basis data melalui command prompt.
Hal tersebut diberikan pertamakali pada siswa agar siswa lebih memahami dan
mengerti tentang perintah DBMS. </span></div>
<span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN; mso-bidi-font-size: 11.0pt; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-no-proof: yes;">Untuk </span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-no-proof: yes;">mempermudah dalam pembuatan database, ada cara lain
yang lebih mudah dipahami dan dilakukan oleh siswa, yaitu tidak melalui </span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN; mso-bidi-font-size: 11.0pt; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-no-proof: yes;">MS-DOS prompt, tetapi tinggal
masuk ke web browser, kemudian pad address ketik <b>http://localhost/phpmyadmin/</b>, maka akan muncul tampilan sebagai
berikut :</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgaD_4uE-QWVRRrsYU3goLGrg9UuZWcxehhcaSS4YfecmtPz1a_qTTzzYWZMhaeunSY25i1vhBu3k7o4IT0kl_vqv06Hg5hYnthXz5vgVvanSfbdUjF3d2ZfsChoOHXKr7fvgOHPPAq9vs/s1600/p1.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="273" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgaD_4uE-QWVRRrsYU3goLGrg9UuZWcxehhcaSS4YfecmtPz1a_qTTzzYWZMhaeunSY25i1vhBu3k7o4IT0kl_vqv06Hg5hYnthXz5vgVvanSfbdUjF3d2ZfsChoOHXKr7fvgOHPPAq9vs/s320/p1.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<ul style="text-align: justify;">
<li><span style="font-family: 'Times New Roman', serif; font-size: 12pt; line-height: 115%;">Pada bagian kiri terdapat
nama-nama database yang sudah ada di dalam phpMyAdmin, dan pada bagian kanan
terdapat menu untuk melakukan operasi pada software ini.</span></li>
<li><span style="font-family: 'Times New Roman', serif; font-size: 12pt; line-height: 115%;"><span lang="IN" style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; line-height: 115%; mso-ansi-language: IN; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-no-proof: yes;">Untuk memasuki sebuah database Anda tinggal mengklik pada database
tertentu yang diinginkan, maka pada bagian kanan akan tampil nama database
dan tabel-tabel yang ada di dalamnya serta keterangan jumlah record
dari tiap tabel tersebut.</span></span></li>
</ul>
<div>
<span style="font-family: Calibri, sans-serif;"><span style="font-size: 15px; line-height: 17px;">lebih lengkapnya tentang tutorial membuat database phpmyadmin dapat di download di link dibawah ini:</span></span></div>
<div>
<span style="font-family: Calibri, sans-serif;"><span style="font-size: 15px; line-height: 17px;"><br /></span></span></div>
<div>
<span style="font-family: Calibri, sans-serif;"><span style="font-size: 15px; line-height: 17px;"><a href="http://adf.ly/PeoR2" target="blank">Download Tutorial Membuat Database</a></span></span></div>

Membuat Database "phpMyadmin"

phpMyAdmin merupakan tool database yang dibuat secara visual sehingga lebih memudahkan user dalam melakukan operasi database. Software ...

Baca selengkapnya »

Bahasa Basis Data

IT FOR EDUCATION 0 Elearning, IT, Web 23.22

<span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN; mso-bidi-font-size: 11.0pt; mso-bidi-language: AR-SA; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">DBMS</span><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhU_ZynXY8_2-S1t0OUOKQLzQOmRPvwZ3mO2nUftTjDHbP5VTLTh6DidBBATGxBADuNBSGXBWBx7MUArAZoQx8L4eAzahJou4-b4RL4z_fnhVwcmQpwoOLDVJ-sWfTyUhHIkL2_09uUsng/s1600/databases.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhU_ZynXY8_2-S1t0OUOKQLzQOmRPvwZ3mO2nUftTjDHbP5VTLTh6DidBBATGxBADuNBSGXBWBx7MUArAZoQx8L4eAzahJou4-b4RL4z_fnhVwcmQpwoOLDVJ-sWfTyUhHIkL2_09uUsng/s400/databases.jpg" width="400" /></a></div>
<span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN; mso-bidi-font-size: 11.0pt; mso-bidi-language: AR-SA; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"><br /></span>
<div style="text-align: justify;">
<span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN; mso-bidi-font-size: 11.0pt; mso-bidi-language: AR-SA; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Merupakan perantara bagi pemakai dengan basis data dalam disk. Cara
berinteraksi/ berkomunikasi antara pemakai dengan basis data tersebut diatur
dalam suatu bahasa khusus yang dapat kita sebut sebagai bahasa basis data.
Bahasa basis data terdiri atas sejumlah perintah (statement) yang
diformulasikan dan dapat diberikan user dan dikenali/ diproses oleh DBMS untuk
melakukan suatu aksi/ pekerjaan tertentu. Sebuah bahasa basis data biasanya
dapat dipilih ke dalam tigabentuk yaitu:</span><br /><br /><span style="font-family: 'Times New Roman', serif; line-height: 18px;"></span></div>
<ul style="text-align: justify;"><span style="font-family: 'Times New Roman', serif; line-height: 18px;"><b><i>
</i></b>
<li><b><i>DML (Data Manipulation Language)</i></b></li>
</span></ul>
<div style="text-align: justify;">
<span style="font-family: 'Times New Roman', serif; line-height: 18px;">
</span></div>
<div class="MsoListParagraph" style="font-family: "Times New Roman",serif; line-height: 200%; margin: 0cm 0cm 0.0001pt 35.45pt; text-align: justify;">
<span lang="IN" style="font-size: 12pt; line-height: 200%;">Merupakan bentuk bahasa basis data yang berguna untuk melakukan
manipulasi dan pengambilan data pada suatu basis data. Manipulasi data dapat
berupa : </span></div>
<div class="MsoListParagraph" style="font-family: "Times New Roman",serif; line-height: 200%; margin: 0cm 0cm 0.0001pt 72pt; text-align: justify; text-indent: -18pt;">
<span lang="IN" style="font-size: 12pt; line-height: 200%;">-<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         
</span></span><span lang="IN" style="font-size: 12pt; line-height: 200%;">penyisipan / penambahan data baru ke suatu basis
data. </span></div>
<div class="MsoListParagraph" style="font-family: "Times New Roman",serif; line-height: 200%; margin: 0cm 0cm 0.0001pt 72pt; text-align: justify; text-indent: -18pt;">
<span lang="IN" style="font-size: 12pt; line-height: 200%;">-<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         
</span></span><span lang="IN" style="font-size: 12pt; line-height: 200%;">penghapusan data dari suatu basis data. </span></div>
<div class="MsoListParagraph" style="font-family: "Times New Roman",serif; line-height: 200%; margin: 0cm 0cm 0.0001pt 72pt; text-align: justify; text-indent: -18pt;">
<span lang="IN" style="font-size: 12pt; line-height: 200%;">-<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         
</span></span><span lang="IN" style="font-size: 12pt; line-height: 200%;">pengubahan data di suatu basis data. </span></div>
<div class="MsoListParagraph" style="font-family: "Times New Roman",serif; line-height: 200%; margin: 0cm 0cm 0.0001pt 35.45pt; text-align: justify;">
<i><span lang="IN" style="font-size: 12pt; line-height: 200%;">Data Manipulation
Language</span></i><span lang="IN" style="font-size: 12pt; line-height: 200%;"> (DML) merupakan bahasa yang bertujuan memudahkan pemakai untuk
mengakses data sebagaimana direpresentasikan oleh model data. </span><span lang="IN" style="font-size: 12pt; line-height: 200%;">(Fatansyah, Ir. (2007). “Basis Data”. Bandung:
Informatika Bandung). </span><span style="font-size: 12pt; line-height: 200%;"></span></div>
<div class="MsoListParagraph" style="font-family: "Times New Roman",serif; line-height: 200%; margin: 0cm 0cm 0.0001pt 92.15pt; text-align: justify;">
<span style="font-size: 12pt; line-height: 200%;">     Peintah-perintah
DML antara lain :</span></div>
<table border="1" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="border-collapse: collapse; border: medium none; font-family: "Times New Roman",serif; margin-left: 0px; margin-right: 0px; text-align: left;"><tbody>
<tr><td style="background: #D9D9D9; border: solid black 1.0pt; mso-border-alt: solid black .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 90.45pt;" valign="top" width="121"><div align="center" class="MsoListParagraph" style="line-height: 200%; margin-bottom: .0001pt; margin: 0cm; tab-stops: 35.45pt; text-align: center;">
<span style="font-size: 12pt; line-height: 200%;">Perintah</span></div>
</td><td style="background: #D9D9D9; border-left: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 225.05pt;" valign="top" width="300"><div align="center" class="MsoListParagraph" style="line-height: 200%; margin-bottom: .0001pt; margin: 0cm; tab-stops: 35.45pt; text-align: center;">
<span style="font-size: 12pt; line-height: 200%;">Fungsi</span></div>
</td></tr>
<tr><td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-top-alt: solid black .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 90.45pt;" valign="top" width="121"><div class="MsoListParagraph" style="line-height: 200%; margin-bottom: .0001pt; margin: 0cm; tab-stops: 35.45pt; text-align: justify;">
<b><span style="font-size: 12pt; line-height: 200%;">SELECT</span></b></div>
</td><td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-top-alt: solid black .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 225.05pt;" valign="top" width="300"><div class="MsoListParagraph" style="line-height: 200%; margin-bottom: .0001pt; margin: 0cm; tab-stops: 35.45pt; text-align: justify;">
<span style="font-size: 12pt; line-height: 200%;">Memilih data</span></div>
</td></tr>
<tr><td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-top-alt: solid black .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 90.45pt;" valign="top" width="121"><div class="MsoListParagraph" style="line-height: 200%; margin-bottom: .0001pt; margin: 0cm; tab-stops: 35.45pt; text-align: justify;">
<b><span style="font-size: 12pt; line-height: 200%;">INSERT</span></b></div>
</td><td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-top-alt: solid black .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 225.05pt;" valign="top" width="300"><div class="MsoListParagraph" style="line-height: 200%; margin-bottom: .0001pt; margin: 0cm; tab-stops: 35.45pt; text-align: justify;">
<span style="font-size: 12pt; line-height: 200%;">Menambah data</span></div>
</td></tr>
<tr><td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-top-alt: solid black .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 90.45pt;" valign="top" width="121"><div class="MsoListParagraph" style="line-height: 200%; margin-bottom: .0001pt; margin: 0cm; tab-stops: 35.45pt; text-align: justify;">
<b><span style="font-size: 12pt; line-height: 200%;">DELETE</span></b></div>
</td><td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-top-alt: solid black .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 225.05pt;" valign="top" width="300"><div class="MsoListParagraph" style="line-height: 200%; margin-bottom: .0001pt; margin: 0cm; tab-stops: 35.45pt; text-align: justify;">
<span style="font-size: 12pt; line-height: 200%;">Menghapus data</span></div>
</td></tr>
<tr><td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-top-alt: solid black .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 90.45pt;" valign="top" width="121"><div class="MsoListParagraph" style="line-height: 200%; margin-bottom: .0001pt; margin: 0cm; tab-stops: 35.45pt; text-align: justify;">
<b><span style="font-size: 12pt; line-height: 200%;">UPDATE</span></b></div>
</td><td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-top-alt: solid black .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 225.05pt;" valign="top" width="300"><div class="MsoListParagraph" style="line-height: 200%; margin-bottom: .0001pt; margin: 0cm; tab-stops: 35.45pt; text-align: justify;">
<span style="font-size: 12pt; line-height: 200%;">Mengubah data</span></div>
</td></tr>
</tbody></table>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
Tabel Perintah DML</div>
<div class="MsoNormal" style="font-family: "Times New Roman",serif; margin-bottom: 0.0001pt; text-align: justify;">
</div>
<div style="text-align: justify;">
<span style="font-family: 'Times New Roman', serif; line-height: 18px;"></span><br /></div>
<ul style="text-align: justify;"><span style="font-family: 'Times New Roman', serif; line-height: 18px;"><b><i>
</i></b>
<li><b><i>DDL(Data Definision Language)</i></b></li>
</span></ul>
<div style="text-align: justify;">
<span style="font-family: 'Times New Roman', serif; line-height: 18px;">
</span></div>
<div class="MsoListParagraph" style="font-family: "Times New Roman",serif; line-height: 200%; margin: 0cm 0cm 0.0001pt 35.45pt; text-align: justify;">
<span lang="IN" style="font-size: 12pt; line-height: 200%;">Struktur / skema basis data yang menggambarkan / mewakili desain basis
data secara keseluruhan dispesifikasikan dengan bahasa khusus yang disebut <i>Data Definition Language </i>(DDL). Dengan
bahasa ini kita dapat membuat tabel baru, membuat indeks, mengubah tabel,
menentukan struktur penyimpanan tabel, dan sebagainya. Hasil dari kompilasi
perintah DDL adalah kumpulan tabel yang disimpan dalam file khusus yang disebut
Kamus Data (<i>Data Dictionary</i>). </span><span lang="IN" style="font-size: 12pt; line-height: 200%;">(Fatansyah, Ir. (2007). “Basis Data”. Bandung:
Informatika Bandung). </span><span style="font-size: 12pt; line-height: 200%;"></span></div>
<div class="MsoListParagraph" style="font-family: "Times New Roman",serif; line-height: 200%; margin: 0cm 0cm 0.0001pt 92.15pt; text-align: justify;">
<span style="font-size: 12pt; line-height: 200%;">                 Perintah-perintah
DDL antara lain:</span></div>
<table border="1" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="border-collapse: collapse; border: medium none; font-family: "Times New Roman",serif; margin-left: 0px; margin-right: 0px; text-align: left;"><tbody>
<tr><td style="background: #D9D9D9; border: solid black 1.0pt; mso-border-alt: solid black .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.2pt;" valign="top" width="92"><div align="center" class="MsoListParagraph" style="line-height: 200%; margin-bottom: .0001pt; margin: 0cm; tab-stops: 35.45pt; text-align: center;">
<span style="font-size: 12pt; line-height: 200%;">Perintah</span></div>
</td><td style="background: #D9D9D9; border-left: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 246.3pt;" valign="top" width="328"><div align="center" class="MsoListParagraph" style="line-height: 200%; margin-bottom: .0001pt; margin: 0cm; tab-stops: 35.45pt; text-align: center;">
<span style="font-size: 12pt; line-height: 200%;">Fungsi</span></div>
</td></tr>
<tr><td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-top-alt: solid black .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.2pt;" valign="top" width="92"><div class="MsoListParagraph" style="line-height: 200%; margin-bottom: .0001pt; margin: 0cm; tab-stops: 35.45pt; text-align: justify;">
<b><span style="font-size: 12pt; line-height: 200%;">CREATE</span></b></div>
</td><td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-top-alt: solid black .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 246.3pt;" valign="top" width="328"><div class="MsoListParagraph" style="line-height: 200%; margin-bottom: .0001pt; margin: 0cm; tab-stops: 35.45pt; text-align: justify;">
<span style="font-size: 12pt; line-height: 200%;">untuk menciptakan table ataupun indeks</span><span style="font-size: 12pt; line-height: 200%;"></span></div>
</td></tr>
<tr><td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-top-alt: solid black .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.2pt;" valign="top" width="92"><div class="MsoListParagraph" style="line-height: 200%; margin-bottom: .0001pt; margin: 0cm; tab-stops: 35.45pt; text-align: justify;">
<b><span style="font-size: 12pt; line-height: 200%;">ALTER</span></b></div>
</td><td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-top-alt: solid black .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 246.3pt;" valign="top" width="328"><div class="MsoListParagraph" style="line-height: 200%; margin-bottom: .0001pt; margin: 0cm; tab-stops: 35.45pt; text-align: justify;">
<span style="font-size: 12pt; line-height: 200%;">untuk mengubah struktur table</span></div>
</td></tr>
<tr><td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-top-alt: solid black .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.2pt;" valign="top" width="92"><div class="MsoListParagraph" style="line-height: 200%; margin-bottom: .0001pt; margin: 0cm; tab-stops: 35.45pt; text-align: justify;">
<b><span style="font-size: 12pt; line-height: 200%;">DROP</span></b></div>
</td><td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-top-alt: solid black .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 246.3pt;" valign="top" width="328"><div class="MsoListParagraph" style="line-height: 200%; margin-bottom: .0001pt; margin: 0cm; tab-stops: 35.45pt; text-align: justify;">
<span style="font-size: 12pt; line-height: 200%;">Untuk menghapus table atau indeks</span></div>
</td></tr>
</tbody></table>
<div class="MsoListParagraph" style="font-family: "Times New Roman",serif; margin: 0cm 0cm 0.0001pt 92.15pt; text-align: justify;">
</div>
<div class="MsoListParagraph" style="font-family: "Times New Roman",serif; margin: 0cm 0cm 0.0001pt 92.15pt; text-align: justify;">
<i><span style="font-size: 12pt;">                             Table
Perintah DDL</span></i></div>
<div style="text-align: justify;">
<span style="font-family: Times New Roman, serif;"></span><br /></div>
<ul style="text-align: justify;"><span style="font-family: Times New Roman, serif;"><b><i>
</i></b>
<li><span style="line-height: 18px;"><b><i>DCL(Data Control Language)</i></b></span></li>
</span></ul>
<div style="text-align: justify;">
<span style="font-family: Times New Roman, serif;">
</span></div>
<div class="MsoNormal" style="font-family: "Times New Roman",serif; line-height: 200%; margin: 0cm 0cm 0.0001pt 35.45pt; text-align: justify; text-indent: -35.45pt;">
<span style="font-size: 12pt; line-height: 200%;">Data control language, dispesifikasikan dengan bahasa khusus yang
digunakan untuk mengendalikan dan mengakses aliran data. Dengan perintah ini
kita dapat memberikan pengendalian pengaksesan data, penguncian table.</span></div>
<div class="MsoListParagraph" style="font-family: "Times New Roman",serif; line-height: 200%; margin: 0cm 0cm 0.0001pt 92.15pt; text-align: justify;">
<span style="font-size: 12pt; line-height: 200%;">                 Perintah-perintah
DCL antara lain :</span></div>
<table border="1" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="border-collapse: collapse; border: medium none; font-family: "Times New Roman",serif; margin-left: 0px; margin-right: 0px; text-align: left;"><tbody>
<tr><td style="background: #D9D9D9; border: solid black 1.0pt; mso-border-alt: solid black .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 90.45pt;" valign="top" width="121"><div align="center" class="MsoListParagraph" style="line-height: 200%; margin-bottom: .0001pt; margin: 0cm; tab-stops: 35.45pt; text-align: center;">
<span style="font-size: 12pt; line-height: 200%;">Perintah</span></div>
</td><td style="background: #D9D9D9; border-left: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 225.05pt;" valign="top" width="300"><div align="center" class="MsoListParagraph" style="line-height: 200%; margin-bottom: .0001pt; margin: 0cm; tab-stops: 35.45pt; text-align: center;">
<span style="font-size: 12pt; line-height: 200%;">Fungsi</span></div>
</td></tr>
<tr><td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-top-alt: solid black .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 90.45pt;" valign="top" width="121"><div class="MsoListParagraph" style="line-height: 200%; margin-bottom: .0001pt; margin: 0cm; tab-stops: 35.45pt; text-align: justify;">
<b><span style="font-size: 12pt; line-height: 200%;">GRANT</span></b></div>
</td><td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-top-alt: solid black .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 225.05pt;" valign="top" width="300"><div class="MsoListParagraph" style="line-height: 200%; margin-bottom: .0001pt; margin: 0cm; text-align: justify;">
<span style="font-size: 12pt; line-height: 200%;">memberikan kendali pada pengaksesan data.</span></div>
</td></tr>
<tr><td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-top-alt: solid black .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 90.45pt;" valign="top" width="121"><div class="MsoListParagraph" style="line-height: 200%; margin-bottom: .0001pt; margin: 0cm; tab-stops: 35.45pt; text-align: justify;">
<b><span style="font-size: 12pt; line-height: 200%;">REVOKE</span></b></div>
</td><td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-top-alt: solid black .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 225.05pt;" valign="top" width="300"><div class="MsoListParagraph" style="line-height: 200%; margin-bottom: .0001pt; margin: 0cm; text-align: justify;">
<span style="font-size: 12pt; line-height: 200%;">mencabut kemampuan pengaksesan data.</span></div>
</td></tr>
<tr><td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-top-alt: solid black .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 90.45pt;" valign="top" width="121"><div class="MsoListParagraph" style="line-height: 200%; margin-bottom: .0001pt; margin: 0cm; tab-stops: 35.45pt; text-align: justify;">
<b><span style="font-size: 12pt; line-height: 200%;">LOCK TABLE</span></b></div>
</td><td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-top-alt: solid black .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 225.05pt;" valign="top" width="300"><div class="MsoListParagraph" style="line-height: 200%; margin-bottom: .0001pt; margin: 0cm; text-align: justify;">
<span style="font-size: 12pt; line-height: 200%;">mengunci tabel</span><span lang="IN" style="font-size: 12pt; line-height: 200%;">            </span><span style="font-size: 12pt; line-height: 200%;"></span></div>
</td></tr>
</tbody></table>
<div class="MsoListParagraph" style="font-family: "Times New Roman",serif; margin: 0cm 0cm 0.0001pt; text-align: justify;">
<span style="font-size: 12pt;">                                                </span></div>
<div class="MsoListParagraph" style="font-family: "Times New Roman",serif; margin: 0cm 0cm 0.0001pt; text-align: justify;">
<span style="font-size: 12pt;">                                                                        <i>Tabel  Perintah DCL</i></span></div>

Bahasa Basis Data

DBMS Merupakan perantara bagi pemakai dengan basis data dalam disk. Cara berinteraksi/ berkomunikasi antara pemakai dengan basis data ...

Baca selengkapnya »