BLOG PRODUKTIF EVI

Sample Table: empinfo
first	last	id	age	city	state
John	Jones	99980	45	Payson	Arizona
Mary	Jones	99982	25	Payson	Arizona
Eric	Edwards	88232	32	San Diego	California
Mary Ann	Edwards	88233	32	Phoenix	Arizona
Ginger	Howell	98002	42	Cottonwood	Arizona
Sebastian	Smith	92001	23	Gila Bend	Arizona
Gus	Gray	22322	35	Bagdad	Arizona
Mary Ann	May	32326	52	Tucson	Arizona
Erica	Williams	32327	60	Show Low	Arizona
Leroy	Brown	32380	22	Pinetop	Arizona
Elroy	Cleaver	32382	22	Globe	Arizona

1. Instalasi software

Dreamweaver 8.0

Tunggu hingga loading selesai

Pilih Next untuk menginstall

Pilih "I Accept" Lalu pilih Next

Pada tampilan dibawah ini pilih Next

Pilih Next untuk melanjutkan

Pilih Install

Tunggu hingga proses selesai..

Pilih Finish dan Instalasi Dreamweaver 8.0 sudah selesai.

Setelah selesai instalasi Langkah selanjutnya adalah menjalankan servicenya, maka Jalankan file xampp
Caranya:
1. klik kiri2x XAMPP Control Panel yang ada di desktop. Atau anda juga dapat menjalankan XAMPP Control Panel dari menu Start -> All Programs -> apachefriends -> xampp -> xampp control panel

Tekan Start pada Apache dan MySql

2. Buka web browser anda, lalu ketikkan ---> http://localhost <lalu tekan enter>. Jika tampilannya seperti di bawah ini, maka apache sudah terinstall dengan benar

3. Dari tampilan yang muncul Anda dapat melakukan berbagai administrasi untuk server Anda termasuk membuat database SQL di Phpmyadmin, pilih English

4. Untuk menonaktifkan server lokal Anda, keluar dari XAMPP Control Panel. Caranya, pada XAMPP Control Panel, klik [Stop] pada masing-masing [Apache] dan [MySql], lalu tutup jendela kontrol panel (klik X pada pojok kanan atas)

5. Agar terbaca pada server maka kita harus meletakkan file - file php kita di document root milik XAMPP terletak pada folder
(jika anda menginstal di directory file C) maka C:\Program Files\apachefriends\xampp\htdocs\(folder web anda)\index.php
Contoh: disini saya membuat offline www.ilmugrafis.com , maka di dalam htdocs saya membuat folder bernama "www.ilmugrafis.com" untuk project saya
(catatan penting: index.php --> file pertama yang dibaca oleh browser adalah index jadi untuk halaman utama wajib diberi nama index.php)

Pembuatan Database

Cara Pembuatan Database

11. Aktifkan Xamp server tau Wamp server

22. Buka Google Chrome atau mozilla firefox

33. Search http://localhost/phpmyadmin/

44. Buat Nama database

5. setelah itu buat tabel

6. isi nama fields yang ada di Adobe Dreamwever CS4.

7. Tamplan Database Barang

8. Tamplan Database Bukutamu

9. Tamplan Database Complaint

10. Tamplan Database Piutang

11. Tamplan Database Produk

12. Tamplan Database Registrasi

13. Tamplan Database Transaksi

Cara Pembuatan Tugas Akhir

1. Sediakan software Adobe Dreamwever CS4

2. Run-kan softtware Adobe Dreamwever CS4, klik PHP

3. Sebelum membuat web yang anda inginkan, anda harus terlebih dahulumembuat site agar memudahkan anda saat menjalankan aplikasi tersebut, langkah-langkahnya:

a. Klik site

b. new site

c. isi nama site

d. isi lokasi site”localhost/nama site/”

e. pilih yes

f. kemudian pilih PHP MySQL

g. isi lokasi folder web yang dibuat

h. pilih Local/Network

i. kemudian isi lokasi folder web yang anda buat

j. lalu isi dengan “http://localhost/nama site

k. klik test

l. maka site baru sudah selesai dibuat.

24. Setelah site dibuat. Maka desain web terlebih dahulu, contohnya seperti ini yang memakai CSS :

5. Coding CSSnya:

html, body {

height: 100%;

}

body {

margin: 0px;

padding: 0px;

background:#FFFFFF;

font-family: Arial, Helvetica, sans-serif;

font-size: 13px;

color: #000;

}

h1, h2, h3 {

margin-top: 0px;

}

p, ol, ul {

margin-top: 0px;

}

p {

line-height: 170%;

}

ul {

margin: 0px;

padding: 0px;

list-style: none;

}

strong {

}

a {

color: #A5C35C;

}

a:hover {

text-decoration: none;

}

a img {

border: none;

}

img.border {

}

img.alignleft {

float: left;

padding-right: 25px;

}

img.alignright {

float: right;

}

img.aligncenter {

margin: 0px auto;

}

hr {

display: none;

}

/** WRAPPER */

#wrapper {

}

.container {

width: 980px;

margin: 0px auto;

}

.clearfix {

clear: both;

}

/** HEADER */

#header {

width: 960px;

height: 292px;

margin: 0px auto;

background: url(images/img02.jpg) no-repeat left top;

}

/** LOGO */

#logo {

width: 960px;

height: 80px;

margin: 0px auto;

text-transform: uppercase;

}

#logo h1 a {

display: block;

margin: 0px;

padding: 10px 0px 0px 0px;

font-size: 36px;

}

#logo p {

margin: -28px 0px 0px 5px;

padding: 0px;

font-size: 12px;

}

#logo a {

text-decoration: none;

}

/** MENU */

#menu {

width: 960px;

height: 48px;

margin: 0px auto;

background: url(images/img03.jpg) no-repeat left top;

}

#menu ul {

margin: 0px;

padding: 0px;

list-style: none;

line-height: normal;

}

#menu li {

float: left;

}

#menu a {

display: block;

height: 32px;

margin: 0px 0px 0px 0px;

padding: 16px 25px 0px 25px;

text-decoration: none;

text-transform: uppercase;

font-size: 11px;

font-weight: bold;

color: #000000;

}

#menu a:hover {

background: #000000;

text-decoration: none;

color: #FFFFFF;

}

#menu .first a {

background: #000000 url(images/img04.jpg) no-repeat left top;

color: #FFFFFF;

}

/** PAGE */

#page {

width: 960px;

margin: 0px auto;

padding: 30px 0px 10px 0px;

background:#999999;

}

/** CONTENT */

#content {

float: right;

width: 610px;

padding-left: 30px;

background: url(images/img06.jpg) repeat-y left top;

}

/** SIDEBAR */

#sidebar {

float: left;

width: 300px;

}

#sidebar h2 {

padding: 0px 0px 10px 0px;

text-transform: uppercase;

font-size: 18px;

}

#sidebar li ul {

margin: 0px 0px 0px 20px;

padding: 0px 0px 20px 0px;

}

#sidebar li li {

padding: 0px 0px 5px 0px;

}

#sidebar p {

margin: 0px 0px 20px 20px;

}

/** POST */

.post {

margin-bottom: 20px;

background: url(images/img05.jpg) repeat-x left bottom;

}

.post .title {

margin: 0px;

padding-bottom: 10px;

letter-spacing: -1px;

}

.post .title a {

border: none;

text-decoration: none;

text-transform: uppercase;

font-size: 22px;

color: #000000;

}

.post .meta {

display: block;

margin-top: -15px;

padding: 5px 0px;

text-align: left;

font-family: Arial, Helvetica, sans-serif;

font-size: 11px;

font-style: italic;

}

.post .meta a {

}

.post .entry {

text-align: justify;

padding: 10px 0px 10px 0px;

}

/** FOOTER */

#footer {

width: 960px;

margin: 0px auto;

background: url(images/img05.jpg) repeat-x left top;

}

#footer p {

margin: 0px;

padding: 20px 0px 20px 0px;

text-align: center;

font-size: 11px;

}

#footer a {

color: #000000;

}

6. Jika anda ingin mengganti background web yang diinginkan, ganti coding yang dibulatkan:

7. Tampilan home

8. Codingnya:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<!--

Design by Free CSS Templates

http://www.freecsstemplates.org

Released for free under a Creative Commons Attribution 3.0 License

-->

<head>

body {

background-color: #CCC;

}

a:link {

color: #00F;

}

a:visited {

color: #00F;

}

a:hover {

color: #F00;

}

a:active {

color: #FF0;

}

.style1 {font-size: 18px}

.style4 {

font-family: Verdana, Arial, Helvetica, sans-serif;

}

.style5 {font-family: Geneva, Arial, Helvetica, sans-serif; }

.style6 {font-family: Arial, Helvetica, sans-serif}

</style>

</head>

<body>

</div>

<ul>

<li><a href="profil.php">About Us</a></li>

<li><a href="contactus.php">Contact Us</a></li>

<li><a href="guestbook.php">Guest Book</a></li>

</ul></div>

<h1 class="title"><a href="#" class="style5">Selamat datang di web penjualan pt. shasco gunakarya piranti</a></h1>

<p>

mysql_connect("localhost","root","");

mysql_select_db("rinievi");

$ambil = mysql_query("SELECT * FROM produk");

while($a = mysql_fetch_array($ambil)){

$gambar = $a['gambar'];

$nama = $a['nama'];

$jenis = $a['jenis'];

$detail = $a['detail'];

$kode = $a['kode'];

$harga = $a['harga'];

<tr>

</tr>

<tr>

<td width="139"> Nama Produk</td>

</tr>

<tr>

<td>Jenis Produk</td>

</tr>

<tr>

<td>Harga</td>

</tr>

<tr>

<td>Detail</td>

</tr>

</table>

<p>

}

</p>

</div>

<ul>

<li class="style6"><blink>Ingin membeli produk kami?</blink> Silahkan <a href="tregister.php">register</a></li>

<span class="style6">terlebih dahulu. Bagi anda yang sudah mepunyai akun silahkan langsung <a href="tlogin.php?op=in">login</a>

:) </span>

</ul>

</ul>

</div>

</p>

<p>

AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0','width','180','height','45','align','top','src','/SGP/jam','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','movie','/SGP/jam' ); //end AC code

</script><noscript><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0" width="180" height="45" align="top">

</object></noscript>

</p>

<p>

AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0','width','180','height','180','src','/haha/calender','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','movie','/haha/calender' ); //end AC code

</object></noscript>

</p>

<p><span class="style1"><blink><font color="red">Kami tidak melayani order dalam bentuk satuan</font></blink> </span></p>

</div>

</div>

</body>

</html>

9.Untuk menyimpan aplikasi yang kita buat dengan cara Ctrl+s atau file-save as.

2 10. Desain Tampilan Profil:

11. Codingnya:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<!--

Design by Free CSS Templates

http://www.freecsstemplates.org

Released for free under a Creative Commons Attribution 3.0 License

-->

<head>

body {

background-color: #CCC;

}

a:link {

color: #00F;

}

body,td,th {

color: #000;

}

a:visited {

color: #00F;

}

a:hover {

color: #F00;

}

a:active {

color: #FF0;

}

</style>

</head>

<body>

</div>

<ul>

<li><a href="profil.php">About Us</a></li>

<li><a href="contactus.php">Contact Us</a></li>

<li><a href="guestbook.php">Guest Book</a></li>

</ul></div>

<li><a href="sejarah.php">Sejarah</a></li>

<li><a href="kebijakanmutu.php">Kebijakan Mutu</a></li>

<li><a href="sasaranmutu.php">Sasaran Mutu</a></li>

</div>

<ul>

<li><blink>Ingin membeli produk kami?</blink> Silahkan <a href="tregister.php">register</a></li>

terlebih dahulu. Bagi anda yang sudah mepunyai akun silahkan langsung <a href="tlogin.php?op=in">login</a> :)

</ul>

</ul>

</div>

<p>

AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0','width','180','height','45','src','/SGP/jam','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','movie','/SGP/jam' ); //end AC code

</object></noscript>

</p>

<p>

AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0','width','180','height','180','src','/SGP/calender','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','movie','/SGP/calender' ); //end AC code

</object></noscript>

</p>

</div>

</div>

</body>

</html>

12. Tampilan Buku Tamu

13. Codingnya:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<!--

Design by Free CSS Templates

http://www.freecsstemplates.org

Released for free under a Creative Commons Attribution 3.0 License

-->

<head>

body {

background-color: #CCC;

}

a:link {

color: #00F;

}

body,td,th {

color: #000;

}

a:visited {

color: #00F;

}

a:hover {

color: #F00;

}

a:active {

color: #FF0;

}

</style>

</head>

<body>

</div>

<ul>

<li><a href="profil.php">About Us</a></li>

<li><a href="contactus.php">Contact Us</a></li>

<li><a href="guestbook.php">Guest Book</a></li>

</ul></div>

<tr>

</tr>

<tr>

<input type="text" name="nama" id="nama" required="required"

></td>

</tr>

<tr>

<td>Email</td>

<input type="text" name="email" id="email" required="required"

></td>

</tr>

<tr>

<td>Pesan</td>

<textarea name="pesan" id="pesan" cols="45" rows="5" required="required"

></textarea></td>

</tr>

<tr>

</tr>

</table>

</form>

mysql_connect("localhost","root","");

mysql_select_db("rinievi");

$data = mysql_query("SELECT * FROM bukutamu ORDER BY id DESC");

$w = 1;

while($d=mysql_fetch_array($data)){

if($w == 1){

$warna = "#CCC";

$w= 0;

}else{

$warna = #CCC";

$w= 1;

}

echo "<div style=\"background-color:$warna;padding:5\">";

echo "nama : ".$d['nama']."<br>";

echo "email : ".$d['email']."<br>";

echo "pesan : ".$d['pesan'];

echo "</div><p>\n";

}

</span></p>

</td>

</table>

</div>

<ul>

<li><blink>Ingin membeli produk kami?</blink> Silahkan <a href="tregister.php">register</a></li>

terlebih dahulu. Bagi anda yang sudah mepunyai akun silahkan langsung <a href="tlogin.php?op=in">login</a>

</ul>

</ul>

</div>

<p>

</object>

</noscript><br/>

<p>

AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0','width','180','height','180','src','/SGP/calender','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','movie','/SGP/calender' ); //end AC code

</object></noscript>

</p>

</div>

</div>

</body>

</html>

14. Tampilan Contact Us

15. Codingnya:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<!--

Design by Free CSS Templates

http://www.freecsstemplates.org

Released for free under a Creative Commons Attribution 3.0 License

-->

<head>

body {

background-color: #CCC;

}

a:link {

color: #00F;

}

a:visited {

color: #00F;

}

a:hover {

color: #F00;

}

a:active {

color: #FF0;

}

</style>

</head>

<body>

</div>

<ul>

<li><a href="profil.php">About Us</a></li>

<li><a href="contactus.php">Contact Us</a></li>

<li><a href="guestbook.php">Guest Book</a></li>

</ul></div>

<h2 class="title"><a href="#">Contact us</a></h2>

</div>

<p>Denah PT. Shasco Gunakarya Piranti</p>

<p>Foto Plan II PT. Shasco Gunakarya Piranti </p>

<p>PT. Shasco Gunakarya Piranti, berlokasi di Jl. Raya Jakarta-Bogor km.29 Gg. H. Icang no.12 Palsigunung, Cimanggis-Depok (Plant I) dan berlokasi di Jl. Raya Jakarta-Bogor km.30 Mekarsari, Cimanggis-Depok (Plant II)</p>

</div>

<ul>

<li><blink>Ingin membeli produk kami?</blink> Silahkan <a href="tregister.php">register</a></li>

terlebih dahulu. Bagi anda yang sudah mepunyai akun silahkan langsung <a href="tlogin.php?op=in">login</a>

</ul>

</ul>

</div>

</p>

<p>

</script>

</object>

</noscript>

</p>

<p>

AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0','width','180','height','180','src','/SGP/calender','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','movie','/SGP/calender' ); //end AC code

</object></noscript>

</p>

</div>

</div>

</body>

</html>

16. Tamilan Home Tamu

17. Codingnya:

session_start();

//cek apakah user sudah login

if(!isset($_SESSION['username'])){

}

if($_SESSION['level']!="guest"){

}

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<!--

Design by Free CSS Templates

http://www.freecsstemplates.org

Released for free under a Creative Commons Attribution 3.0 License

-->

<head>

body {

background-color: #CCC;

}

a:link {

color: #00F;

}

a:visited {

color: #00F;

}

a:hover {

color: #F00;

}

a:active {

color: #FF0;

}

.style2 {

font-family: "Courier New", Courier, monospace;

font-size: 22px;

}

.style3 {font-size: 16px}

</style>

</head>

<body>

</div>

<ul>

<li><a href="contactusguest.php">Contact Us</a></li>

<li><a href="guestbookguest.php">Guest Book</a></li>

<li><a href="complaint.php">Complaint Customer</a></li>

</ul></div>

<blink>

<h2 class="style2"><font color="red">Kami tidak melayani order dalam bentuk satuan</font></h2>

</blink>

<p>

include "../proses.php";

$ambil = mysql_query("SELECT * FROM produk");

while($a = mysql_fetch_array($ambil)){

$id = $a['id'];

$gambar = $a['gambar'];

$kode= $a['kode'];

$nama = $a['nama'];

$jenis = $a['jenis'];

$harga = $a['harga'];

$detail = $a['detail'];

</p>

<tr bs>

</tr>

<tr>

<td width="139">Nama Produk</td>

</tr>

<tr>

<td>Jenis Produk</td>

</tr>

<tr>

<td>Harga</td>

</tr>

<tr>

<td>Detail</td>

</tr>

<tr>

</form> </td>

</tr>

</table>

<p>

}

</p>

</div>

<ul>

<li><a href="../logout.php?op=out" class="style3">Keluar</a></li>

</ul>

</ul>

</div>

</p>

<p>

</object></noscript>

</p>

<p>

AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0','width','180','height','180','src','/SGP/calender','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','movie','/SGP/calender' ); //end AC code

</object></noscript>

</p>

</div>

</div>

</body>

</html>

18. Tampilan Transaksi

19. Codingnya:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<!--

Design by Free CSS Templates

http://www.freecsstemplates.org

Released for free under a Creative Commons Attribution 3.0 License

-->

<head>

body {

background-color: #CCC;

}

a:link {

color: #00F;

}

body,td,th {

color: #000;

}

a:visited {

color: #00F;

}

a:hover {

color: #F00;

}

a:active {

color: #FF0;

}

.style2 {font-size: 12px}

</style>

</head>

<body>

</div>

<ul>

<li><a href="contactus.php">Contact Us</a></li>

<li><a href="guestbook.php">Guest Book</a></li>

<li><a href="complaint.php">Compalaint Customer</a></li>

</ul></div>

<div id="content"><td width="68%" valign="top" bgcolor="#CCCCCC" class="index"><?

include "../proses.php";

$id = $_GET['id'];

$ambil = mysql_query("SELECT * FROM produk WHERE id = '$id' ");

$r = mysql_fetch_array($ambil);

$kode= $r['kode'];

$nama = $r['nama'];

$jenis = $r['jenis'];

$harga= $r['harga'];

<tr>

<td colspan="3" align="center" background="../images/img03.jpg"><h1>Transaksi</h1></td>

</tr>

<tr>

<td width="191">Kode Pembelian</td>

</tr>

<tr>

<td>Nama Perusahaan</td>

<input type="text" name="nama" id="nama" required="required"

></td>

</tr>

<tr>

<td>Nama Produk</td>

</tr>

<tr>

<td>Jenis Produk</td>

</tr>

<tr>

<td>Harga</td>

</tr>

<tr>

<td>Jenis Pengiriman</td>

<option value="dalam kota">dalam kota</optio>

</select> </td>

</tr>

<tr>

<td>Alamat</td>

<textarea name="alamat" id="alamat" cols="45" rows="5" required="required"

></textarea></td>

</tr>

<tr>

<td>Tanggal Pembelian</td>

for($i=1; $i<32; $i++){ echo "<option value='$i'>$i</option>";

}

</select>

$arrbulan= array('','januari','februari','maret','april','mei','juni','juli','agustus','september','oktober','november','desember');

for($i=1; $i<13; $i++){ echo "<option value='$i'>$arrbulan[$i]</option>";

}

</select>

<? for($i=2012; $i>1995; $i--){ echo "<option value='$i'>$i</option>";

}

</select></td>

</tr>

<tr>

<td>Jatuh Tempo</td>

<? for($i=1; $i<32; $i++){ echo "<option value='$i'>$i</option>";

}

</select>

$arrbulan= array('','januari','februari','maret','april','mei','juni','juli','agustus','september','oktober','november','desember');

for($i=1; $i<13; $i++){ echo "<option value='$i'>$arrbulan[$i]</option>";

}

</select>

<? for($i=2012; $i>1995; $i--){ echo "<option value='$i'>$i</option>";

}

</select> </td>

</tr>

<tr>

<td>Jumlah Barang Yang di Pesan</td>

<input type="text" name="jumlah" id="jumlah" required="required"

pcs</td>

</tr>

<tr>

<td>Jenis Pembelian</td>

<option value="credit">credit</option>

</select> </td>

</tr>

<tr>

<td>No. Rekening Nama Perusahaan</td>

<td><input type="text" name="rek" id="rek" required="required"

/></td>

</tr>

<tr>

</tr>

</table>

</form>

<p></p>

</div>

<ul>

<li>Silahkan isi data transaksinya dengan benar :)</li>

</ul>

</ul>

</div>

</p>

<p>

</object></noscript>

</p>

<p>

AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0','width','180','height','180','src','/SGP/calender','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','movie','/SGP/calender' ); //end AC code

</script>

</object></noscript>

</p>

</div>

</div>

</body>

</html>

20.Tampilan Complaint Customer

21. Codingnya:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<!--

Design by Free CSS Templates

http://www.freecsstemplates.org

Released for free under a Creative Commons Attribution 3.0 License

-->

<head>

body {

background-color: #CCC;

}

a:link {

color: #000;

}

body,td,th {

color: #000;

}

a:visited {

color: #000;

}

a:hover {

color: #00F;

}

a:active {

color: #F0F;

}

.style1 {font-size: 16px}

</style>

</head>

<body>

</div>

<ul>

<li>

<li><a href="contactusguest.php">Contact Us</a></li>

<li><a href="guestbookguest.php">Guest Book</a></li>

<li><a href="complaint.php">Complaint Customer</a></li>

</ul></div>

<tr>

<td colspan="3" align="center" background="/haha/images/img03.jpg"><h2>Complaint Customer</h2></td>

</tr>

<tr>

<td width="119">Kode Barang</td>

<td width="258"><input type="text" name="no" required="required"

/></td>

</tr>

<tr>

<td>Nama Barang</td>

<td>

<input type="text" name="nama" required="required"

/></td>

</tr>

<tr>

<td>Jenis Barang</td>

<option value="otomotif">otomotif</option>

<option value="spesial order">spesial order</option>

</select> </td>

</tr>

<tr>

<td>Compaliant</td>

<td>

<input type="text" name="com" required="required"

/></td>

</tr>

<tr>

<td>Bukti </td>

<td>

<input type="file" name="bukti" id="bukti" required="required"

/></td>

</tr>

<tr>

</tr>

</table>

</form>

</p>

</div>

<div id="sidebar"><a href="../home.php" class="style1">Keluar</a>

<ul>

</ul>

</ul>

</div>

<p>

AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0','width','180','height','45','src','/haha/jam','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','movie','/haha/jam' ); //end AC code

</object></noscript>

</p>

<p>

AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0','width','180','height','170','src','/SGP/calender','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','movie','/SGP/calender' ); //end AC code

</object></noscript>

</p>

</div>

</div>

</body>

</html>

22. Tampilan Upload Produk

23. Codingnya:

session_start();

//cek apakah user sudah login

if(!isset($_SESSION['username'])){

}

if($_SESSION['level']!="admin"){

}

?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<!--

Design by Free CSS Templates

http://www.freecsstemplates.org

Released for free under a Creative Commons Attribution 3.0 License

-->

<head>

body {

background-color: #CCC;

}

a:link {

color: #00F;

}

body,td,th {

color: #000;

}

a:visited {

color: #00F;

}

a:hover {

color: #F00;

}

a:active {

color: #FF0;

}

.style1 {font-family: "Courier New", Courier, monospace}

.style2 {

font-size: 16px;

font-family: "Courier New", Courier, monospace;

}

</style>

</head>

<body>

</div>

<ul class="style1"><li><a href="tabelbukutamu.php">Tabel Buku Tamu</a></li>

<li><a href="tabelregistrasi.php">Tabel Registrasi</a></li>

<li><a href="ttampilanbarang.php">Tabel Barang</a></li>

<li><a href="tabeltransaksi.php">Tabel Transaksi dan piutang</a></li>

</ul>

</div>

<div id="page"> <span class="style2"><a href="../logout.php?op=out?op=out">Keluar

</a></span>

<h2><span class="style2"><a href="/haha/admin/ttampilanbarang.php">Kembali</a></span><br />

</h2>

<tr>

<td colspan="3" align="center" background="/haha/images/img03.jpg"><h1><span class="style1">Upload Produk</span></h1></td>

</tr>

<tr>

<td>Kode Barang</td>

<td><input type="text" name="kode" id="kode" required="required"

/></td>

</tr>

<tr>

<td width="124">Nama Produk</td>

<td width="328"><input type="text" name="nama" id="nama" required="required"

/> </td>

</tr>

<tr>

<td>Jenis Produk</td>

<option value="otomotif">otomotif</option>

<option value="spesial order">spesial order</option>

</select> </td>

</tr>

<tr>

<td>Harga</td>

<td><input type="text" name="harga" id="harga" required="required"

/></td>

</tr>

<tr>

<td>Detail</td>

<td><input type="text" name="detail" id="detail" required="required"

/> </td>

</tr>

<tr>

<td>Gambar Produk</td>

<td><input type="file" name="gambar" id="gambar" value="" required="required"

/> </td>

</tr>

<tr>

</tr>

</table>

</form>

<tr>

<td colspan="8" align="center" background="/haha/images/img03.jpg"><h1><span class="style1">Tabel Upload</span></h1></td>

</tr>

<td width="109" align="center">nama produk</td>

<td width="95" align="center">jenis produk</td>

<td width="84" align="center">harga</td>

<td width="302" align="center">detail</td>

<td width="125" align="center">gambar produk</td>

<td width="102" align="center">pilihan</td>

include "../proses.php";

$i = 0;

$ambil = mysql_query("SELECT * FROM produk");

while($r=mysql_fetch_array($ambil)){

$i++;

$id= $r['id'];

$kode= $r['kode'];

$nama = $r['nama'];

$jenis = $r['jenis'];

$harga= $r['harga'];

$detail = $r['detail'];

$gambar = $r['gambar'];

</tr>

<tr>

<a href ="upload.php?aksi=hapus&id=<? echo $id; ?>">hapus </a><br/>

<? } ?>

</tr>

</table>

<p>

if ($_GET['aksi']=="hapus")

{

$id = $_GET['id'];

$del = mysql_query("DELETE FROM produk WHERE id = '$id' ");

if($del){

echo"<script>alert('berhasil'); window.location.href='upload.php';</script>";

}else{

echo"<script>alert('gagal dihapus'); window.location.href='upload.php';</script>";

}

if($_GET['aksi'] == "ubah")

{

$id = $_GET['id'];

$ambil = mysql_query("SELECT * FROM produk WHERE id = '$id' ");

$r = mysql_fetch_array($ambil);

$nama = $r['nama'];

$jenis = $r['jenis'];

$detail = $r['detail'];

$gambar = $r['gambar'];

</p>

<tr>

<td colspan="3" align="center" background="/haha/images/img03.jpg"><h1 class="style1">Ubah Tabel Upload</h1></td>

</tr>

<tr>

</tr>

<tr>

<td width="124">Nama Produk</td>

</tr>

<tr>

<td>Jenis Produk</td>

</tr>

<tr>

<td>Harga</td>

</tr>

<tr>

<td>Detail</td>

</tr>

<tr>

<td>Gambar Produk</td>

</tr>

<tr>

</tr>

</table>

</form>

<p>

<? }

<br/>

</p>

</div>

<ul>

</ul>

</div>

</div>

</body>

</html>

24. Tampilan Tabel Registrasi

25. Codingnya:

session_start();

//cek apakah user sudah login

if(!isset($_SESSION['username'])){

}

if($_SESSION['level']!="admin"){

}

?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<!--

Design by Free CSS Templates

http://www.freecsstemplates.org

Released for free under a Creative Commons Attribution 3.0 License

-->

<head>

body {

background-color: #CCC;

}

a:link {

color: #00F;

}

body,td,th {

color: #000;

}

a:visited {

color: #00F;

}

a:hover {

color: #F00;

}

a:active {

color: #FF0;

}

.style1 {font-family: "Courier New", Courier, monospace}

.style2 {font-size: 16px}

</style>

</head>

<body>

</div>

<ul><li><a href="tabelbukutamu.php">Tabel Buku Tamu</a></li>

<li><a href="tabelregistrasi.php">Tabel Registrasi</a></li>

<li><a href="ttampilanbarang.php">Tabel Barang</a></li>

<li><a href="tampilantranspiutang.php">Tabel Transaksi dan piutang</a></li>

</ul>

</div>

<p class="style2"><a href="../logout.php?op=out?op=out" class="style1">Keluar</a></p>

<tr>

<td height="20" colspan="9" align="center" background="/haha/images/img03.jpg"><h1><span class="style1">Tabel Registrasi</span></h1></td>

</tr>

<td width="74" align="center">username</td>

<td width="80" align="center">password</td>

<td width="74" align="center">level</td>

<td width="97" align="center">alamat</td>

<td width="131" align="center">telpon</td>

<td width="140" align="center">email</td>

<td width="187" align="center">pilihan</td>

</tr>

mysql_connect("localhost","root","");

mysql_select_db("rinievi");

$i = 0;

$ambil = mysql_query("SELECT * FROM registrasi");

while($r=mysql_fetch_array($ambil)){

$i++;

$id= $r['id'];

$username= $r['username'];

$password= $r['password'];

$level= $r['level'];

$nama= $r['nama'];

$alamat= $r['alamat'];

$telpon= $r['telpon'];

$email= $r['email'];

<tr>

<a href="tabelregistrasi.php?aksi=hapus&id=<? echo $id; ?>">Hapus </a></td>

}

</tr>

</table>

if ($_GET['aksi']=="hapus")

{

$id = $_GET['id'];

$del = mysql_query ("DELETE FROM registrasi WHERE id='$id'");

if($del){

echo"<script>alert('berhasil'); window.location.href='tabelregistrasi.php';</script>";

}else{

echo"<script>alert('gagal dihapus'); window.location.href='tabelregistrasi.php';</script>";

}

<?php

if($_GET['aksi'] == 'ubah')

{

$id = $_GET['id'];

$ambil = mysql_query("SELECT * FROM registrasi WHERE id = '$id' ");

$r = mysql_fetch_array($ambil);

$username = $r['username'];

$password = $r['password'];

$nama = $r['nama'];

$alamat = $r['alamat'];

$telpon = $r['telpon'];

$email = $r['email'];

<tr>

<td colspan="3" align="center" background="/haha/images/img03.jpg"><h1 class="style1">Ubah Register</h1></td>

</tr>

<tr>

<td width="88">Username</td>

</tr>

<tr>

<td>Password</td>

</tr>

<tr>

</label></td>

</tr>

<tr>

<td>Alamat</td>

</tr>

<tr>

<td>Telephone</td>

</tr>

<tr>

<td>Email</td>

</tr>

<tr>

</tr>

</table>

</form>

<?php } ?>

</div>

</div>

</body>

</html>

26. Tampilan Tabel Transaksi

27. Codingnya:

session_start();

//cek apakah user sudah login

if(!isset($_SESSION['username'])){

}

if($_SESSION['level']!="admin"){

}

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<!--

Design by Free CSS Templates

http://www.freecsstemplates.org

Released for free under a Creative Commons Attribution 3.0 License

-->

<head>

body {

background-color: #CCC;

}

a:link {

color: #00F;

}

body,td,th {

color: #000;

}

a:visited {

color: #00F;

}

a:hover {

color: #F00;

}

a:active {

color: #FF0;

}

.style1 {font-family: "Courier New", Courier, monospace}

.style3 {font-family: "Courier New", Courier, monospace; font-size: 16px; }

</style>

</head>

<body>

</div>

<ul class="style1"><li><a href="tabelbukutamu.php">Tabel Buku Tamu</a></li>

<li><a href="tabelregistrasi.php">Tabel Registrasi</a></li>

<li><a href="ttampilanbarang.php">Tabel Barang</a></li>

<li><a href="tampilantranspiutang.php">Tabel Transaksi dan piutang</a></li>

</ul>

</div>

<span class="style3"><a href="../logout.php?op=out">Keluar</a></span>

<p class="style3"><a href="/haha/admin/tampilantranspiutang.php">Kembali</a></p>

<tr>

<td height="28" colspan="14" align="center" background="/haha/images/img03.jpg"><h1><span class="style1">Tabel Transaksi </span></h1></td>

</tr>

<td width="71" align="center">kode pembelian</td>

<td width="84" align="center">nama perusahaan</td>

<td width="49" align="center">nama produk</td>

<td width="49" align="center">jenis produk</td>

<td width="46" align="center">harga</td>

<td width="64" align="center">jenis pengiriman</td>

<td width="48" align="center">alamat</td>

<td width="73" align="center">tanggal pembelian</td>

<td width="69" align="center">jatuh tempo</td>

<td width="83" align="center">Barang yang di pesan

<td width="59" align="center">jenis pembelian</td>

<td width="47" align="center">pilihan</td>

</tr>

mysql_connect("localhost","root","");

mysql_select_db("rinievi");

$i = 0;

$ambil = mysql_query("SELECT * FROM transaksi");

while($r=mysql_fetch_array($ambil)){

$i++;

$id= $r['id'];

$kode= $r['kode'];

$nama= $r['nama'];

$produk= $r['produk'];

$jenis= $r['jenis'];

$harga= $r['harga'];

$pengiriman= $r['pengiriman'];

$alamat= $r['alamat'];

$tanggal= $r['tanggal'];

$tempo= $r['tempo'];

$jumlah= $r['jumlah'];

$pembelian= $r['pembelian'];

$rek= $r['rek'];

<tr>

<a href="#" onClick="window.open('../prosesadmin/print_transaksi.php?id=<?php echo $id; ?>','Print Transaksi','width=640,height=480,scrollbars=yes');">Print</a><br/>

<a href="tabeltransaksi.php?aksi=hapus&id=<? echo $id; ?>"> Hapus </a></td>

</tr>

}

</table>

<p>

if ($_GET['aksi']=="hapus")

{

$id = $_GET['id'];

$del = mysql_query ("DELETE FROM transaksi WHERE id='$id'");

if($del){

echo"<script>alert('berhasil'); window.location.href='tabeltransaksi.php';</script>";

}else{

echo"<script>alert('gagal dihapus'); window.location.href='tabeltransaksi.php';</script>";

}

<?php

if($_GET['aksi'] == "ubah")

{

$id = $_GET['id'];

$ambil = mysql_query("SELECT * FROM transaksi WHERE id = '$id' ");

$r = mysql_fetch_array($ambil);

$kode = $r['kode'];

$nama = $r['nama'];

$produk = $r['produk'];

$jenis = $r['jenis'];

$harga = $r['harga'];

$pengiriman = $r['pengiriman'];

$alamat = $r['alamat'];

$tanggal = $r['tanggal'];

$tempo = $r['tempo'];

$jumlah = $r['jumlah'];

$pembelian = $r['pembelian'];

$rek = $r['rek'];

</p>

<tr>

<td colspan="3" align="center" background="/haha/images/img03.jpg"><h1><span class="style1">Ubah Transaksi</span></h1></td>

</tr>

<tr>

<td width="191">Kode Pembelian</td>

</tr>

<tr>

<td>Nama Perusahaan</td>

</tr>

<tr>

<td>Nama Produk</td>

</tr>

<tr>

<td>Jenis Produk</td>

</tr>

<tr>

<td>Harga</td>

</tr>

<tr>

<td>Jenis Pengiriman</td>

</tr>

<tr>

<td>Alamat</td>

</tr>

<tr>

<td>Tanggal Pembelian</td>

for($i=1; $i<32; $i++){ echo "<option value='$i'>$i</option>";

}

</select>

$arrbulan= array('','januari','februari','maret','april','mei','juni','juli','agustus','september','oktober','november','desember');

for($i=1; $i<13; $i++){ echo "<option value='$i'>$arrbulan[$i]</option>";

}

</select>

<? for($i=2012; $i>1995; $i--){ echo "<option value='$i'>$i</option>";

}

</select></td>

</tr>

<tr>

<td>Jatuh Tempo</td>

<? for($i=1; $i<32; $i++){ echo "<option value='$i'>$i</option>";

}

</select>

$arrbulan= array('','januari','februari','maret','april','mei','juni','juli','agustus','september','oktober','november','desember');

for($i=1; $i<13; $i++){ echo "<option value='$i'>$arrbulan[$i]</option>";

}

</select>

<? for($i=2012; $i>1995; $i--){ echo "<option value='$i'>$i</option>";

}

</select> </td>

</tr>

<tr>

<td>Jumlah Barang Yang di Pesan</td>

</tr>

<tr>

<td>Jenis Pembelian</td>

<option value="credit">credit</option>

</select> </td>

</tr>

<tr>

<td>No. Rekening Nama Perusahaan</td>

</tr>

<tr>

</tr>

</table>

<br />

</form>

<p>

<? } ?>

</p>

</div></div>

</div>

</body>

</html>

128. Coding Proses Upload

<?php

mysql_connect("localhost","root","");

mysql_select_db("rinievi");

$kode= $_POST['kode'];

$nama = $_POST['nama'];

$jenis = $_POST['jenis'];

$harga = $_POST['harga'];

$detail = $_POST['detail'];

$gambar = $_FILES ['gambar']['tmp_name'];

$gambar_name = $_FILES ['gambar']['name'];

$gambar_type = $_FILES ['gambar']['type'];

$gambar_size = $_FILES ['gambar']['size'];

$isi = mysql_query("INSERT INTO produk VALUES(null,'$nama','$kode','$jenis','$harga','$detail','$gambar_name')");

if ($isi){

$move = move_uploaded_file ($gambar,'../images/'.$gambar_name);

if ($move){

echo "<h4><b> BERHASIL </b></h4>";

echo "nama : <b> $nama </b><br>";

echo "jenis : <b> $jenis </b><br>";

echo "detail : <b> $detail </b><br>";

echo "foto: <br><b> <img src='../images/$gambar_name' style='max-width:240px;' /> </b><br>";

echo "<a href = ../admin/upload.php>kembali</a>";

}

else{

echo "gagal";

}

else{

echo "gagal";

}

229. Proses Ubah Tabel Transaksi

mysql_connect("localhost","root","");

mysql_select_db("rinievi");

$id = $_POST['id'];

$kode = $_POST['kode'];

$nama = $_POST['nama'];

$produk= $_POST['produk'];

$jenis = $_POST['jenis'];

$harga = $_POST['harga'];

$pengiriman = $_POST['pengiriman'];

$alamat = $_POST['alamat'];

$tanggal = $_POST['tahun'].'-'.$_POST['bulan'].'-'.$_POST['tanggal'];

$tempo = $_POST['tahun'].'-'.$_POST['bulan'].'-'.$_POST['tanggal'];

$jumlah = $_POST['jumlah'];

$pembelian = $_POST['pembelian'];

$rek = $_POST['rek'];

$input = mysql_query("

update transaksi set

kode='$kode',

nama='$nama',

produk='$produk',

jenis='$jenis',

harga='$harga',

pengiriman='$pengiriman',

alamat='$alamat',

tanggal='$tanggal',

tempo='$tempo',

jumlah='$jumlah',

pembelian='$pembelian',

rek='$rek'

where id='$id'

");

if($input){

echo"<script>alert('berhasil diubah'); window.location.href='../admin/tabeltransaksi.php' </script>";

}else{

echo"<script>alert('gagal diubah'); window.location.href='../admin/tabeltransaksi.php' </script>";

}

330. Tabel Ubah Registrasi

mysql_connect("localhost","root","");

mysql_select_db("rinievi");

$id = $_POST['id'];

$username = $_POST['username'];

$password = $_POST['password'];

$nama = $_POST['nama'];

$alamat = $_POST['alamat'];

$telpon = $_POST['telpon'];

$email = $_POST['email'];

$input = mysql_query("

update registrasi set

id = '$id',

username ='$username',

password ='password',

nama ='$nama',

alamat ='$alamat',

telpon ='$telpon',

email ='$email'

WHERE id = '$id'

");

if($input){

echo"<script>alert('berhasil diubah'); window.location.href='tabelregistrasi.php' </script>";

}else{

echo"<script>alert('gagal diubah'); window.location.href='tabelregistrasi.php' </script>";

}

431. Ubah Tabel Complaint

mysql_connect("localhost","root","");

include "../proses.php";

$id = $_POST['id'];

$no = $_POST['no'];

$nama = $_POST['nama'];

$barang = $_POST['barang'];

$com = $_POST['com'];

$bukti_name = $_FILES['bukti']['name'];

$bukti_tmp = $_FILES['bukti']['tmp_name'];

$bukti_type = $_FILES['bukti']['type'];

$bukti_size = $_FILES['bukti']['size'];

$input = mysql_query("

update complaint set

id = '$id',

no ='$no',

nama ='$nama',

barang ='$barang',

com ='$com',

bukti ='$bukti_name'

WHERE id = '$id'

");

if($input){

$move = move_uploaded_file($bukti_tmp,'../images/'.$bukti_name);

echo"berhasil<a href='../admin/tabelcomplaint.php'>lihat</a>";

}else{

echo"gagal";

}

532. Tabel Ubah Buku Tamu

<?php

mysql_connect("localhost","root","");

mysql_select_db("rinievi");

$nama = ($_POST['nama']);

$email = ($_POST['email']);

$pesan = ($_POST['pesan']);

$isi = mysql_query("INSERT INTO bukutamu VALUES(null,'$nama','$email','$pesan')");

if ($isi){

echo"<script>alert('Berhasil'); window.location.href='../haha/guestbook.php' </script>";

return false; break;

}else{

echo"<script>alert('gagal'); window.location.href='../haha/home.php' </script>";

return false; break;

}

6. Proses Login

<?php

include "proses.php";

session_start(); //memulai session

$username = $_POST['username'];

$password = $_POST['password'];

$op = $_GET['op'];

if($op=="in"){

$cek = mysql_query("SELECT * FROM registrasi WHERE username='$username' AND password='$password'");

if(mysql_num_rows($cek)==1){

$c = mysql_fetch_array($cek);

$_SESSION['username'] = $c['username'];

$_SESSION['level'] = $c['level'];

if ($c['level'] == 'admin'){

echo "<script>alert('selamat datang admin'); window.location.href='admin/homeadmin.php'</script>";

return false; break;

}else if($c['level'] == "guest" ){

echo "<script>alert('selamat datang $username'); window.location.href='guest/homeguest.php'</script>";

return false; break;

}

}else{

echo"<script>alert('anda belum terdaftar'); window.location.href='register.php' </script>";

return false; break;

}

}else if($op=="out"){

unset($_SESSION['username']);

unset($_SESSION['level']);

unset($_SESSION['nama']);

header("location:login.php");

}

733. Proses Registrasi

<html>

<body>

<?php

mysql_connect("localhost","root","");

mysql_select_db("rinievi");

$username = $_POST['username'];

$password = $_POST['password'];

$level = $_POST['guest'];

$nama = $_POST['nama'];

$alamat = $_POST['alamat'];

$telpon = $_POST['telpon'];

$email = $_POST['email'];

$input = mysql_query("INSERT INTO registrasi VALUES(null,'$username','$password','guest','$nama','$alamat','$telpon','$email')");

if($input){

echo"<script>alert('anda terdaftar, silahkan login terlebih dahulu :)'); window.location.href='tlogin.php' </script>";

return false; break;

}else{

echo"<script>alert('daftar kembali dan cek ulang'); window.location.href='register.php' </script>";

return false; break;

}

</body>

</html>

834. Proses connection:

<?php

mysql_connect("localhost","root","");

mysql_select_db("rinievi");

BLOG PRODUKTIF EVI

Kamis, 31 Januari 2013

Tugas Minggu ke 3

Kamis, 24 Januari 2013

Tugas Minggu ke 2

Rabu, 23 Januari 2013

Kamis, 17 Januari 2013

Tugas Minggu 1 Pengertian SQL

Rabu, 05 Desember 2012

Tutorial Tugas Akhir

Mengenai Saya