Kodingnya :
<html>
<head>
<title>Login ke PHP&MySql.com</title>
<style type="text/css">
.auto-style1 {
color: #FF0000;
}
.auto-style2 {
text-align: left;
}
.auto-style3 {
color: #FF0000;
text-align: center;
}
.auto-style4 {
color: #FF0000;
text-align: right;
}
.auto-style5 {
background-color: #FFFF00;
}
.auto-style6 {
background-color: #000000;
}
.auto-style7 {
color: #FF0000;
background-color: #000000;
}
</style>
</head>
<body style="background-image: url('computer_0033.jpg')">
<form action="LoginPeriksa.php" method="post" name="form1" target="_self">
<table width="400" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#00FFFF">
<tr bgcolor="#000000">
<td colspan="2"><div class="auto-style3">Please Insert Your Name
& Password First : </div></td>
</tr>
<tr bgcolor="#000000">
<td width="118" align="right" class="auto-style1">User Name : </td>
<td width="271">
<input name="txtKode" type="text" size="9" maxlength="9" style="width: 213px" /></td>
</tr>
<tr bgcolor="#000000">
<td class="auto-style4">Password : </td>
<td>
<input name="txtPass" type="password" size="30" maxlength="30" style="width: 210px" /></td>
</tr>
<tr bgcolor="#000000">
<td style="height: 31px"></td>
<td style="height: 31px">
<input name="Submit" type="submit" value="Login" class="auto-style1" /></td>
</tr>
</table>
</form>
<p class="auto-style2"><span class="auto-style5">
<b class="auto-style1" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;">
<span class="auto-style6">Pengertian PHP</span></b></span><b class="auto-style1" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(245, 245, 245);"><span class="auto-style6"> </span></b><br class="auto-style1" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(245, 245, 245);">
<br class="auto-style1" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(245, 245, 245);">
<span class="auto-style7" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; display: inline !important; float: none;">
PHP adalah singkatan dari "PHP: Hypertext Preprocessor". </span></p>
<p class="auto-style2">
<span class="auto-style7" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; display: inline !important; float: none;">
yang merupakan sebuah bahasa scripting yang terpasang pada HTML. </span></p> <p class="auto-style2">
<span class="auto-style7" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; display: inline !important; float: none;">
Sebagian besar sintaks mirip dengan bahasa C, Java dan Perl, ditambah beberapa fungsi PHP yang spesifik. </span></p>
<p class="auto-style2">
<span class="auto-style7" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; display: inline !important; float: none;">
Tujuan utama penggunaan bahasa ini adalah untuk memungkinkan perancang web</span><span class="auto-style1" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(245, 245, 245); display: inline !important; float: none;"><span class="auto-style6"> </span></span></p>
<p class="auto-style2">
<br class="auto-style7" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;">
<span class="auto-style7" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; display: inline !important; float: none;">
menulis halaman web dinamik dengan cepat.</span></p>
<p class="auto-style2"> </p>
<p class="auto-style2"><span class="auto-style6">
<b class="auto-style1" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;">
Kelebihan PHP</b></span><b class="auto-style1" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(245, 245, 245);"><span class="auto-style6"> </span></b><br class="auto-style7" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;">
<br class="auto-style7" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.59375px; orphans:
auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;">
<span class="auto-style7" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; display: inline !important; float: none;">
Ketika e-commerce semakin berkembang, situs-situs yang statispun semakin ditinggalkan, </span></p>
<p class="auto-style2">
<span class="auto-style7" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; display: inline !important; float: none;">
karena dianggap sudah tidak memenuhi keinginan pasar, padahal situs tersebut harus tetap dinamis. </span></p>
<p class="auto-style2">
<span class="auto-style7" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; display: inline !important; float: none;">
Pada saat ini bahasa PERL dan CGI sudah jauh ketinggalan jaman </span></p>
<p class="auto-style2">
<span class="auto-style7" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; display: inline !important; float: none;">
sehingga sebagian besar designer web banyak beralih ke bahasa server-side scripting yang lebih dinamis seperti PHP. </span></p>
<p class="auto-style2">
<span class="auto-style7" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; display: inline !important; float: none;">
Seluruh aplikasi berbasis web dapat dibuat dengan PHP. </span></p>
<p class="auto-style2">
<span class="auto-style7" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; display: inline !important; float: none;">
Namun kekuatan yang paling utama PHP adalah pada konektivitasnya dengan system database di dalam web. </span></p>
<p class="auto-style2">
<span class="auto-style7" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; display: inline !important; float: none;">
Sistem database yang dapat didukung oleh PHP adalah :</span><span class="auto-style1" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(245, 245, 245); display: inline !important; float: none;"><span class="auto-style6"> </span></span>
<br class="auto-style7" style="font-family: 'Segoe UI',
Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;">
<br class="auto-style7" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;">
<span class="auto-style7" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; display: inline !important; float: none;">
1. Oracle</span><span class="auto-style1" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(245, 245, 245); display: inline !important; float: none;"><span class="auto-style6"> </span></span><br class="auto-style7" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;">
<span class="auto-style7" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space:
normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; display: inline !important; float: none;">
2. MySQL</span><span class="auto-style1" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(245, 245, 245); display: inline !important; float: none;"><span class="auto-style6"> </span></span><br class="auto-style7" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;">
<span class="auto-style7" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; display: inline !important; float: none;">
3. Sybase</span><span class="auto-style1" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(245, 245, 245); display: inline !important; float: none;"><span class="auto-style6"> </span></span><br class="auto-style7" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;">
<span class="auto-style7" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-
variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; display: inline !important; float: none;">
4. PostgreSQL</span><br class="auto-style7" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;">
<span class="auto-style7" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; display: inline !important; float: none;">
5. dan lainnya</span><br class="auto-style7" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;">
<br class="auto-style7" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;">
<span class="auto-style7" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.59375px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; display: inline !important; float: none;">
PHP dapat berjalan di berbagai system operasi seperti windows 98/NT,</span>
<span class="auto-style1" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro', Myriad,
'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant:
normal; font-weight: normal; letter-spacing: normal; line-height: 19.59375px; orphans:
auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal;
widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color:
rgb(245, 245, 245); display: inline !important; float: none;"><span class="auto-
style6"> </span></span></p>
<p class="auto-style2">
<span class="auto-style7" style="font-family: 'Segoe UI', Calibri, 'Myriad Pro',
Myriad, 'Trebuchet MS', Helvetica, sans-serif; font-size: 14px; font-style: normal; font-
variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.59375px;
orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space:
normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; display:
inline !important; float: none;">
UNIX/LINUX, solaris maupun macintosh.</span></p>
</body>
</html>
Form Awal :
Kodingnya :
<?php
include "SessionEmerer.php";
?>
<html>
<head>
<title>PHP&MySql.com | Dian Arif Mahardi raharjo</title>
<style type="text/css">
.auto-style2 {
font-family: Impact, Haettenschweiler, "Arial Narrow Bold", sans-serif; color: #FF0000;
text-align: left;
}
.auto-style4 {
border-style: solid;
border-width: 5px;
background-color: #000000;
}
.auto-style5 {
text-align: center;
}
.auto-style6 {
text-align: left;
}
.auto-style7 {
color: #FF0000;
}
</style>
</head>
<body bgcolor="#000000">
<table width="100%" height="100%" class="auto-style4">
<tr bgcolor="Black">
<td colspan="2" style="height: 16%" class="auto-style5">
<span class="auto-style7">
<?php
// Memanggil header.php
include ("header.php");
?>
</span><img src="images.jpg" class="auto-style7" width="259"></td>
</tr>
<tr height="80%" valign="top" bordercolor="#000000">
<td bgcolor="#000000" style="width: 178px" bordercolor="#000000" bordercolordark="#000000" bordercolorlight="#000000" class="auto-style7">
<?php
// Memanggil menu.php
include ("menu.php");
?>
</td>
<td class="auto-style5">
<?php
// ISI
?>
<h1 class="auto-style2">wellcome</h1>
<div class="auto-style6">
<span class="auto-style7">Selamat datang di web
design yang dinamis dengan menggunakan database MySql.</span><br class="auto-style7">
<br class="auto-style7"><span class="auto-style7">Semoga bermanfaat.</span><br class="auto-style7">
<br class="auto-style7">
<span class="auto-style7">:-)
</span>
<br class="auto-style7"><br class="auto-style7"><br class="auto-style7">
<span class="auto-style7">Dian Arif Mahardi Raharjo || 103410190<br> <br></span></div>
<form method="post">
<div class="auto-style5">
<img src="Dian Arif MR.jpg" height="134" style="float: left"
width="168"><img src="putra.gif" height="137" width="164"></div>
</form>
</td>
</tr>
<tr height="10%" bgcolor="Black">
<td colspan="2" align="center" class="auto-style7">
<?php
// Memanggil footer.php
include ("footer.php");
?>
</td>
</tr>
</table>
</body>
</html>
Input Data :
Kodingnya :
<html>
<head>
<title>PHP&MySql.com | Dian Arif Mahardi Raharjo</title>
<style type="text/css">
.auto-style1 {
color: #0000FF;
}
.auto-style2 {
color: #FF0000;
}
.auto-style3 {
color: #FF0000;
text-align: left;
}
</style>
</head>
<body bgcolor="#000000" style="background-image: url('abstract_0043.jpg')"> <table width="100%" height="100%" border="5">
<tr height="10%" bgcolor="Black">
<td colspan="2" align="center">
<?php
// Memanggil header.php
include ("header.php");
?>
</td>
</tr>
<tr valign="top">
<td width="150" bgcolor="Black" style="height: 69%">
<?php
// Memanggil menu.php
include ("menu.php");
?>
</td>
<td style="height: 69%">
<?php
// ISI
?>
<form method="post" action="simpanbarang.php">
<h3 class="auto-style3">Input Data Barang</h3>
<table style="width: 100%">
<tr>
<td class="auto-style2" style="width: 100px" >Kode Barang</td>
<td><input name="KodeBarang" type="text" /></td>
</tr>
<tr>
<td class="auto-style2" style="width: 100px" >Nama Barang</td>
<td><input name="NamaBarang" type="text" /></td>
</tr>
<tr>
<td class="auto-style2" style="width: 100px" >Satuan</td>
<td><input name="Satuan" type="text" /></td>
</tr>
<tr>
<td class="auto-style2" style="height: 26px; width: 100px" >Quantity</td> <td style="height: 26px"><input name="Qty" type="text" /></td>
</tr>
<tr>
<td style="width: 100px" > </td>
<td>
<input name="Submit1" type="submit" value="Simpan" class="auto-style1" /></td> </tr>
<tr>
<td style="width: 100px" > </td>
<td> </td>
</tr>
<tr>
<td style="width: 100px" > </td>
<td> </td>
</tr>
</table>
</form>
</td>
</tr>
<tr height="10%" bgcolor="Black">
<td colspan="2" align="center">
<?php
// Memanggil footer.php
include ("footer.php");
?>
</td>
</tr>
</table>
<p class="auto-style2">Di bawah ini merupakan koding untuk penginputan ke database :)</p>
<p><span class="auto-style2"><html></span><br class="auto-style2">
<span class="auto-style2"><head></span><br class="auto-style2">
<span class="auto-style2"><title>PHP&MySql.com | Dian Arif Mahardi Raharjo</title></span><br class="auto-style2"><span class="auto-style2"><style type="text/css"></span><br class="auto-style2"><span class="auto-style2"> .auto-style1
{
</span><br class="auto-style2"><span class="auto-style2">color: #0000FF;</span><br class="auto-style2">}<br class="auto-style2">
<span class="auto-style2">.auto-style2 {</span><br class="auto-style2">
<span class="auto-style2">color: #FF0000;</span><br class="auto-style2">}<brclass="auto-style2">
<span class="auto-style2">.auto-style3 {</span><br class="auto-style2">
<span class="auto-style2">color: #FF0000;</span><br class="auto-style2">
<span class="auto-style2">text-align: left;</span><br class="auto-style2">}<br class="auto-style2">
<span class="auto-style2"></style></span><br class="auto-style2">
<span class="auto-style2"></head></span><br class="auto-style2">
<br class="auto-style2"><span class="auto-style2"><Brody bgcolor="#000000"></span><br class="auto-style2">
<br class="auto-style2"><span class="auto-style2"><table width="100%"
height="100%" border="5"></span><br class="auto-style2"><br class="auto-style2"> <span class="auto-style2"><tr height="10%" bgcolor="Black"></span><brclass="auto-style2">
<span class="auto-style2"><td colspan="2" align="center"></span><br class="auto-style2">
<span class="auto-style2"><?php</span><br class="auto-style2">
<span class="auto-style2">// Memanggil header.php</span><br class="auto-style2"> <span class="auto-style2">include ("header.php");</span><br class="auto-style2"> <span class="auto-style2">?></span><br class="auto-style2">
<span class="auto-style2"></td></span><br class="auto-style2">
<span class="auto-style2"></tr></span><br class="auto-style2">
<br class="auto-style2"><span class="auto-style2"><tr height="80%" valign="top"></span><br class="auto-style2">
<span class="auto-style2"><td width="150" bgcolor="Black"></span><br class="auto- style2">
<span class="auto-style2"><?php</span><br class="auto-style2">
<span class="auto-style2">// Memanggil menu.php</span><br class="auto-style2"> <span class="auto-style2">include ("menu.php");</span><br class="auto-style2"> <span class="auto-style2">?></span><br class="auto-style2">
<span class="auto-style2"></td></span><br class="auto-style2">
<span class="auto-style2"><td></span><br class="auto-style2">
<span class="auto-style2"><?php</span><br class="auto-style2">
<span class="auto-style2">// ISI</span><br class="auto-style2">
<br class="auto-style2"><span class="auto-style2">?></span><br class="auto-style2"> <br class="auto-style2"><span class="auto-style2"><form method="post"
action="simpanbarang.php"></span><br class="auto-style2">
<span class="auto-style2"><h3 class="auto-style3">Input Data Barang</h3></span><br class="auto-style2">
<span class="auto-style2"><table style="width: 100%"></span><br class="auto- style2">
<span class="auto-style2"><tr></span><br class="auto-style2">
<span class="auto-style2"><td class="auto-style2" style="width: 100px" >Kode Barang</td></span><br class="auto-style2"><span class="auto- style2"><td><input
name="KodeBarang" type="text" /></td></span><br class="auto-style2"> <span class="auto-style2"></tr></span><br class="auto-style2">
<span class="auto-style2"><tr></span><br class="auto-style2">
<span class="auto-style2"><td class="auto-style2" style="width: 100px" >Nama Barang</td></span><br class="auto-style2"><span class="auto-
style2"><td><input name="NamaBarang" type="text" /></td></span>
<br class="auto-style2">
<span class="auto-style2"></tr></span><br class="auto-style2">
<span class="auto-style2"><tr></span><br class="auto-style2">
<span class="auto-style2"><td class="auto-style2" style="width: 100px" >Satuan</td></span>
<br class="auto-style2"><span class="auto- style2"><td><input name="Satuan" type="text" /></td></span><br class="auto-style2">
<span class="auto-style2"></tr></span><br class="auto-style2">
<span class="auto-style2"><tr></span><br class="auto-style2">
<span class="auto-style2"><td class="auto-style2" style="height: 26px; width: 100px" >Quantity</td></span><br class="auto-style2"><span class="auto-style2"> <td style="height: 26px"><input name="Qty" type="text" /></td></span><br class="auto-style2">
<span class="auto-style2"></tr></span><br class="auto-style2">
<span class="auto-style2"><tr></span><br class="auto-style2">
<span class="auto-style2"><td style="width: 100px" >&nbsp;</td></span><br class="auto-style2">
<span class="auto-style2"><td></span><br class="auto-style2">
<span class="auto-style2"><input name="Submit1" type="submit" value="Simpan" class="auto-style1" /></td></span><br class="auto-style2">
<span class="auto-style2"></tr></span><br class="auto-style2">
<span class="auto-style2"><tr></span><br class="auto-style2">
<span class="auto-style2"><td style="width: 100px" >&nbsp;</td></span><br class="auto-style2">
<span class="auto-style2"><td>&nbsp;</td></span><br class="auto- style2">
<span class="auto-style2"></tr></span><br class="auto-style2">
<span class="auto-style2"><tr></span><br class="auto-style2">
<span class="auto-style2"><td style="width: 100px">&nbsp;</td></span><br class="auto-style2">
<span class="auto-style2"><td>&nbsp;</td></span><br class="auto- style2">
<span class="auto-style2"></tr></span><br class="auto-style2">
<span class="auto-style2"></table></span><br class="auto-style2">
<span class="auto-style2"></form></span><br class="auto-style2">
<br class="auto-style2"><br class="auto-style2"><br class="auto-style2">
<span class="auto-style2"></td></span><br class="auto-style2">
<span class="auto-style2"></tr></span><br class="auto-style2">
<br class="auto-style2">
<span class="auto-style2"><tr height="10%" bgcolor="Black"></span><br class="auto-style2"><span class="auto-style2"><td colspan="2" align="center"></span><br class="auto-style2">
<span class="auto-style2"><?php</span><br class="auto-style2">
<span class="auto-style2">// Memanggil footer.php</span><br class="auto-style2"> <span class="auto-style2">include ("footer.php");</span><br class="auto-style2"> <span class="auto-style2">?></span><br class="auto-style2">
<span class="auto-style2"></td></span><br class="auto-style2">
<span class="auto-style2"></tr></span><br class="auto-style2">
<br class="auto-style2"><br class="auto-style2"><span class="auto-style2">
</table></span><br class="auto-style2"><span class="auto- style2"></body></span><br class="auto-style2">
<span class="auto-style2"></html></span><br class="auto-style2"></p>
</body>
</html>
Menampilkan Data Pada Database MySql :
Kodingnya :
<?php
// tentukan nama tabel dan database
$db_name = "dbbarang";
$table_name = "barang";
//koneksi ke server dan pilihdatabase
$connection = @mysql_connect("localhost" , "root" , "" ) or die (mysql_error());
$db = @mysql_select_db ($db_name, $connection ) or die (mysql_error());
//membangun query
$sql= "select KodeBarang, NamaBarang, Satuan, Qty from $table_name order Bay KodeBarang"; $result = @mysql_query($sql,$connection) or die (mysql_error());
// buat daftar hasil yang ditemukan
?>
<html>
<head>
<title>eMeReR.com | Dian Arif M.R</title>
<!--Membuat Fungsi konfirmasi penghapusan data-->
<script language="javascript">
function konfirmasi(KodeBarang)
{
tanya=confirm('Apakah anda yakin Data tersebut akan dihapus ?');
if (tanya==true) return true;
else return false;
}
</script>
<!--End fungsi-->
<style type="text/css">
.auto-style1 {
color: #FF0000;
}
</style>
</head>
<body style="background-color: #000000; background-image: url('abstract_0043.jpg');">
<table width="100%" height="100%" border="5">
<tr height="10%" bgcolor="lime">
<td colspan="2" align="center" bgcolor="#000000" bordercolor="#000000" bordercolordark="#000000" bordercolorlight="#000000">
<?php
// Memanggil header.php
include ("header.php");
?>
</td>
</tr>
<tr valign="top">
<td width="150" bgcolor="#000000" style="height: 31%">
<?php
// Memanggil menu.php
include ("menu.php");
?>
</td>
<td style="height: 31%">
<?php
// ISI
?>
<center><h3 class="auto-style1">Laporan Data Barang</h3></center> <table style="width: 100%" border="1">
<tr>
<td class="auto-style1">Kode Barang</td>
<td class="auto-style1">Nama Barang</td>
<td class="auto-style1">Satuan</td>
<td class="auto-style1" style="width: 102px">Quantity</td> <td class="auto-style1">Menu</td>
</tr>
<?php
while($row = mysql_fetch_array($result)) {
$KodeBarang= $row['KodeBarang'];
$NamaBarang = $row['NamaBarang'];
$Satuan = $row['Satuan'];
$Qty = $row['Qty'];
?>
<tr bgcolor="#000000" bordercolor="#000000" bordercolordark="#000000"
bordercolorlight="#000000">
<td class="auto-style1"><?php echo $KodeBarang ?></td>
<td class="auto-style1"><?php echo $NamaBarang ?></td>
<td class="auto-style1"><?php echo $Satuan ?></td>
<td class="auto-style1" style="width: 102px"><?php echo $Qty ?></td> <td>
<a href="editbarang.php?KodeBarang=<?php echo$KodeBarang?>">
<span class="auto-style1">Edit</span></a>
<span class="auto-style1">
</span>
<a href="deletebarang.php?KodeBarang=<?php echo $KodeBarang ; ?> "
onClick="return konfirmasi(<?php echo $KodeBarang ; ?>)">
<span class="auto-style1">Hapus</span></a>
</tr>
<?php
}
?>
</table>
</td>
</tr>
<tr bgcolor="lime">
<td colspan="2" align="center" bgcolor="#000000" style="height: 10%">
<?php
// Memanggil footer.php
include ("footer.php");
?>
</td>
</tr>
</table>
<p class="auto-style1">Berikut adalah kode design yang menampilkan isi dari
database MySql pada gamba diatas :)</p>
<p> <span class="auto-style1"><?php</span><br class="auto-style1">
<span class="auto-style1">
// tentukan nama tabel dan database</span>
<br class="auto-style1">
<span class="auto-style1">$db_name = "dbbarang";</span><br class="auto-style1"> <span class="auto-style1">$table_name = "barang";</span><br class="auto-style1"> <br class="auto-style1"><span class="auto-style1">//koneksi ke server dan pilihdatabase </span>
<br class="auto-style1"><span class="auto-style1">
$connection = @mysql_connect("localhost" , "root" , "" ) or die (mysql_error());</span><br
class="auto-style1">
<span class="auto-style1">$db = @mysql_select_db ($db_name, $connection ) or die (mysql_error());</span><br class="auto-style1">
<br class="auto-style1">
<span class="auto-style1">//membangun query</span><br class="auto-style1">
<span class="auto-style1">$sql= "select KodeBarang, NamaBarang, Satuan, Qty from $table_name order by KodeBarang"; </span><br class="auto-style1">
<span class="auto-style1">$result = @mysql_query($sql,$connection) or die (mysql_error());</span>
<br class="auto-style1"><br class="auto-style1">
<span class="auto-style1">// buat daftar hasil yang ditemukan</span><br class="auto-style1">
<span class="auto-style1">?></span><br class="auto-style1">
<br class="auto-style1">
<span class="auto-style1"><html></span><br class="auto-style1">
<span class="auto-style1"><head></span><br class="auto-style1">
<span class="auto-style1"><title>eMeReR.com | Dian Arif M.R</title></span>
<br class="auto-style1">
<span class="auto-style1"><!--Membuat Fungsi konfirmasi penghapusan data--
></span><br class="auto-style1">
<span class="auto-style1"><script language="javascript"></span><br class="auto-
style1">
<span class="auto-style1">function konfirmasi(KodeBarang)</span><br class="auto-style1">
<span class="auto-style1">tanya=confirm('Apakah anda yakin Data tersebut akan dihapus ?');</span>
<br class="auto-style1">
<span class="auto-style1">if (tanya==true) return true;</span>
<br class="auto-style1">
<span class="auto-style1">else return false;</span><br class="auto-style1">
<span class="auto-style1"></script></span><br class="auto-style1">
</p>
<p>
<span class="auto-style1"><!--End fungsi--></span>
<br class="auto-style1">
<span class="auto-style1"><style type="text/css"></span>
<br class="auto-style1">
<span class="auto-style1">.auto-style1 {</span>
<br class="auto-style1">
<span class="auto-style1">color: #FF0000;</span>
<br class="auto-style1">
<span class="auto-style1"></style></span>
<br class="auto-style1">
<span class="auto-style1"></head></span>
<br class="auto-style1">
<span class="auto-style1"><body style="background-color: #000000"></span>
<br class="auto-style1">
<span class="auto-style1"><table width="100%" height="100%" border="5"></span>
<br class="auto-style1">
<span class="auto-style1"><tr height="10%" bgcolor="lime"></span>
<br class="auto-style1">
<span class="auto-style1"><td colspan="2" align="center" bgcolor="#000000" bordercolor="#000000"
bordercolordark="#000000" bordercolorlight="#000000"></span>
<br class="auto-style1">
</p>
<p>
<span class="auto-style1"><?php</span>
<br class="auto-style1">
<span class="auto-style1">
// Memanggil header.php</span>
<br class="auto-style1">
<span class="auto-style1">include ("header.php");</span>
<br class="auto-style1"> <span class="auto-style1">?></span>
<br class="auto-style1">
<span class="auto-style1"></td></span>
<br class="auto-style1">
<span class="auto-style1"></tr></span>
<br class="auto-style1">
<span class="auto-style1"><tr height="80%" valign="top"></span>
<br class="auto-style1">
<span class="auto-style1"><td width="150" bgcolor="#000000"></span>
<br class="auto-style1">
</p>
<p><span class="auto-style1"><?php</span>
<br class="auto-style1">
<span class="auto-style1">// Memanggil menu.php</span>
<br class="auto-style1">
<span class="auto-style1">include ("menu.php");</span>
<br class="auto-style1">
<span class="auto-style1">?></span>
<br class="auto-style1">
<span class="auto-style1"></td></span>
<br class="auto-style1">
<span class="auto-style1"><td></span>
<br class="auto-style1">
<span class="auto-style1"><?php</span>
<br class="auto-style1">
<span class="auto-style1">// ISI</span>
<br class="auto-style1">
<span class="auto-style1">?></span>
<br class="auto-style1">
<span class="auto-style1"><center><h3
class="auto-style1">Laporan Data Barang</h3></center></span>
<br class="auto-style1">
<span class="auto-style1"><table style="width: 100%" border="1"></span>
<br class="auto-style1">
<span class="auto-style1"><tr></span>
<br class="auto-style1">
<span class="auto-style1"><td class="auto-style1">Kode Barang</td></span>
<br class="auto-style1">
<span class="auto-style1"><td class="auto-style1">Nama Barang</td></span>
<br class="auto-style1">
<span class="auto-style1"><td class="auto-style1">Satuan</td></span>
<br class="auto-style1">
<span class="auto-style1"><td class="auto-style1" style="width:
102px">Quantity</td></span>
<br class="auto-style1">
<span class="auto-style1"><td class="auto-style1">Menu</td></span>
<br class="auto-style1">
<span class="auto-style1"></tr></span>
<br class="auto-style1">
<br class="auto-style1">
<span class="auto-style1"><?php
</span>
<br class="auto-style1">
<span class="auto-style1">while($row = mysql_fetch_array($result))
</span>
<br class="auto-style1">
<span class="auto-style1">$KodeBarang= $row['KodeBarang'];
</span>
<br class="auto-style1">
<span class="auto-style1">$NamaBarang = $row['NamaBarang'];
</span>
<br class="auto-style1">
<span class="auto-style1">$Satuan = $row['Satuan'];
</span>
<br class="auto-style1">
<span class="auto-style1">$Qty = $row['Qty'];
</span>
<br class="auto-style1">
<span class="auto-style1">?>
</span>
<br class="auto-style1"><br class="auto-style1">
<span class="auto-style1"><tr bgcolor="#000000" bordercolor="#000000"
bordercolordark="#000000" bordercolorlight="#000000">
</span>
<br class="auto-style1">
<span class="auto-style1"><td class="auto-style1"><?php echo $KodeBarang ?></td>
</span>
<br class="auto-style1">
<span class="auto-style1"><td class="auto-style1"><?php echo $NamaBarang
?></td></span>
<br class="auto-style1">
<span class="auto-style1"><td class="auto-style1"><?php echo $Satuan
?></td></span>
<br class="auto-style1">
<span class="auto-style1"><td class="auto-style1" style="width: 102px"><?php echo $Qty ?></td>
</span>
<br class="auto-style1">
<span class="auto- style1"><td>
</span>
<br class="auto-style1">
<span class="auto-style1"><a href="editbarang.php?KodeBarang=<?php echo$KodeBarang?>">
</span>
<br class="auto-style1">
<span class="auto-style1"> <span class="auto-style1">Edit</span></a><span class="auto-style1">
</span>
<br class="auto-style1">
<span class="auto-style1"></span>
</span>
<br class="auto-style1">
<span class="auto-style1"><a href="deletebarang.php?KodeBarang=<?php echo $KodeBarang ; ?> " onClick="return konfirmasi(<?php echo $KodeBarang ;
?>)">
</span>
<br class="auto-style1">
<span class="auto-style1"><span class="auto-style1">Hapus</span></a></span>
<br class="auto-style1">
<span class="auto-style1"></tr>
</span>
<br class="auto-style1">
<span class="auto-style1"><?php
</span>
<br class="auto-style1">
<span class="auto-style1">}
</span>
<br class="auto-style1">
<span class="auto-style1">?>
</span>
<br class="auto-style1">
<span class="auto-style1"></table>
</span>
<br class="auto-style1">
<span class="auto-style1"></td>
</span>
<br class="auto-style1">
<span class="auto-style1"></tr>
</span>
<br class="auto-style1">
<br class="auto-style1">
<span class="auto-style1"><tr height="10%" bgcolor="lime">
</span>
<br class="auto-style1">
<span class="auto-style1"><td colspan="2" align="center" bgcolor="#000000">
</span>
<br class="auto-style1">
</p>
<p><span class="auto-style1"><?php
</span>
<br class="auto-style1">
<span class="auto-style1">
// Memanggil footer.php</span>
<br class="auto-style1">
<span class="auto-style1">include ("footer.php");
</span>
<br class="auto-style1">
<span class="auto-style1">?>
</span>
<br class="auto-style1">
<span class="auto-style1"></td>
</span>
<br class="auto-style1">
<span class="auto-style1"></tr>
</span>
<br class="auto-style1">
<span class="auto-style1">
</table>
</span>
<br class="auto-style1">
<span class="auto-style1"></body>
</span>
<br class="auto-style1">
<span class="auto-style1"></html>
</span>
<br class="auto-style1">
</p>
</body>
</html>
Memasukkan data karyawan ke DataBase MySql
Kodingnya :
<html>
<head>
<title>PHP&MySql.com | Dian Arif Mahardi Raharjo</title>
<style type="text/css">
.auto-style1 {
color: #FF0000;
}
.auto-style2
{
color: #FF0000;
text-align: left;
}
.auto-style3
{
background-color: #000000;
}
.auto-style4
{
background-color: #000000;
color: #FF0000;
}
</style>
</head>
<body bgcolor="#000000" style="background-image: url('abstract_0043.jpg')">
<table width="100%" height="100%" border="5">
<tr height="10%" bgcolor="lime">
<td colspan="2" align="center" bgcolor="#000000" class="auto-style1"> <?php
// Memanggil header.php
include ("header.php");
?>
</td>
</tr>
<tr valign="top">
<td bgcolor="#000000" class="auto-style1" style="width: 5px; height: 75%;">
<?php
// Memanggil menu.php
include ("menu.php");
?>
</td>
<td style="width: 271px; height: 75%;">
<?php
// ISI
?>
<form method="post" action="simpankaryawan.php">
<h3 class="auto-style2">Input Data Karyawan</h3>
<table style="width: 100%">
<tr>
<td class="auto-style1" style="width: 126px" >Kode Karyawan</td> <td><input name="KodeKaryawan" type="text" class="auto-style1" /></td> </tr>
<tr>
<td class="auto-style1" style="width: 126px" >Nama Karyawan</td> <td><input name="NamaKaryawan" type="text" class="auto-style1" /></td> </tr>
<tr>
<td class="auto-style1" style="width: 126px" >Alamat</td>
<td><input name="Alamat" type="text" class="auto-style1" /></td>
</tr>
<tr>
<td class="auto-style1" style="width: 126px" >HP</td>
<td><input name="HP" type="text" class="auto-style1" /></td>
</tr>
<tr>
<td class="auto-style1" style="width: 126px" > </td>
<td>
<input name="Submit1" type="submit" value="Simpan" class="auto-style1"</td>
</tr>
<tr>
<td class="auto-style1" style="width: 126px" > </td>
<td class="auto-style1"> </td>
</tr>
<tr>
<td class="auto-style1" style="width: 126px" > </td>
<td class="auto-style1"> </td>
</tr>
</table>
</form>
</td>
</tr>
<tr bgcolor="lime">
<td colspan="2" bgcolor="#000000" class="auto-style2" style="height: 6%">
<?php
// Memanggil footer.php
include ("footer.php");
?>
<br><br><br class="auto-style3">
</td>
</tr>
</table>
<p><span class="auto-style1">Berikut merupakan </span> <span class="auto-style3"> <span class="auto-style1">design kode pada php di atas :)</span><br class="auto-style1"><br class="auto-style1"
<span class="auto-style1"><html></span>
</span>
<br class="auto-style4">
<span class="auto-style4"><head></span>
<br class="auto-style4">
<span class="auto-style4"><title>PHP&MySql.com | Dian Arif Mahardi Raharjo</title></span>
<br class="auto-style4">
<span class="auto-style4">
<style type="text/css"></span>
<br class="auto-style4">
<span class="auto-style4">.auto-style1
{
</span><br class="auto-style4">
<span class="auto-style4">color: #FF0000;</span>
<br class="auto-style4">
}
<br class="auto-style4"><span class="auto-style4">.auto-style2
{
</span>
<br class="auto-style4">
<span class="auto-style4">color: #FF0000;</span>
<br class="auto-style4">
<span class="auto-style4">text-align: left;</span><br class="auto-style4">
}
<br class="auto-style4">
<span class="auto-style4"></style></span>
<br class="auto-style4">
<span class="auto-style4"></head></span>
<br class="auto-style4">
<span class="auto-style4"><body bgcolor="#000000"></span>
<br class="auto-style4">
<span class="auto-style4"><table width="100%" height="100%"
border="5"></span>
<br class="auto-style4">
<span class="auto-style4"><tr height="10%" bgcolor="lime"></span>
<br class="auto-style4">
<span class="auto-style4"><td colspan="2" align="center"
bgcolor="#000000" class="auto-style1"></span>
<br class="auto-style4">
<span class="auto-style4"><?php</span>
<br class="auto-style4">
<span class="auto-style4">
// Memanggil header.php</span>
<br class="auto-style4">
<span class="auto-style4">include ("header.php");</span>
<br class="auto-style4">
<span class="auto-style4">?></span>
<br class="auto-style4">
<span class="auto-style4"></td></span>
<br class="auto-style4">
<span class="auto-style4"></tr></span>
<br class="auto-style4">
<span class="auto-style4"><tr height="80%" valign="top"></span>
<br class="auto-style4">
<span class="auto-style4"><td width="150" bgcolor="#000000"
class="auto-style1"></span>
<br class="auto-style4">
<span class="auto-style4"><?php</span>
<br class="auto-style4">
<span class="auto-style4">
// Memanggil menu.php</span>
<br class="auto-style4">
<span class="auto-style4">include ("menu.php");</span>
<br class="auto-style4"> <span class="auto-style4">?></span>
<br class="auto-style4">
<span class="auto-style4"></td></span>
<br class="auto-style4">
<span class="auto-style4"><td></span>
<br class="auto-style4">
<span class="auto-style4"><?php</span>
<br class="auto-style4">
<span class="auto-style4">
// ISI</span>
<br class="auto-style4">
<span class="auto-style4">?></span>
<br class="auto-style4">
<span class="auto-style4"><form method="post" action="simpankaryawan.php"></span>
<br class="auto-style4">
<span class="auto-style4"><h3 class="auto-style2">Input Data Karyawan</h3></span>
<br class="auto-style4">
<span class="auto-style4">
<table style="width: 100%"></span>
<br class="auto-style4">
<span class="auto-style4"><tr></span>
<br class="auto-style4">
<span class="auto-style4"><td class="auto-style1" style="width: 126px" >Kode Karyawan</td></span>
<br class="auto-style4">
<span class="auto-style4"><td><input name="KodeKaryawan" type="text" class="auto-style1" /></td></span>
<br class="auto-style4">
<span class="auto-style4"></tr></span>
<br class="auto-style4">
<span class="auto-style4"><tr></span>
<br class="auto-style4">
<span class="auto-style4"><td class="auto-style1" style="width: 126px" >Nama Karyawan</td></span>
<br class="auto-style4">
<span class="auto-style4"><td><input name="NamaKaryawan" type="text" class="auto-style1" /></td></span>
<br class="auto-style4">
<span class="auto-style4"></tr></span>
<br class="auto-style4">
<span class="auto-style4"><tr></span>
<br class="auto-style4">
<span class="auto-style4"><td class="auto-style1" style="width: 126px" >Alamat</td></span>
<br class="auto-style4">
<span class="auto-style4">
<td><input name="Alamat" type="text" class="auto-style1" /></td></span>
<br class="auto-style4">
<span class="auto-style4"></tr></span>
<br class="auto-style4">
<span class="auto-style4"><tr></span>
<br class="auto-style4">
<span class="auto-style4"><td class="auto-style1" style="width: 126px" >HP</td></span>
<br class="auto-style4">
<span class="auto-style4">
<td><input name="HP" type="text" class="auto-style1"
/></td></span>
<br class="auto-style4">
<span class="auto-style4"></tr></span>
<br class="auto-style4">
<span class="auto-style4"><tr></span>
<br class="auto-style4">
<span class="auto-style4"><td class="auto-style1" style="width: 126px" >&nbsp;</td></span>
<br class="auto-style4">
<span class="auto-style4">
<td></span>
<br class="auto-style4">
<span class="auto-style4"><input name="Submit1" type="submit" value="Simpan" class="auto-style1"/></td></span><br class="auto-style4">
<span class="auto-style4"></tr></span>
<br class="auto-style4">
<span class="auto-style4"><tr></span>
<br class="auto-style4">
<span class="auto-style4"><td class="auto-style1" style="width: 126px" >&nbsp;</td></span>
<br class="auto-style4">
<span class="auto-style4">
<td class="auto-style1">&nbsp;</td></span><br class="auto-style4">
<span class="auto-style4"></tr></span>
<br class="auto-style4">
<span class="auto-style4"><tr></span>
<br class="auto-style4">
<span class="auto-style4"><td class="auto-style1" style="width: 126px" >&nbsp;</td></span>
<br class="auto-style4">
<span class="auto-style4">
<td class="auto-style1">&nbsp;</td></span>
<br class="auto-style4">
<span class="auto-style4"></tr></span>
<br class="auto-style4">
<span class="auto-style4"></table></span>
<br class="auto-style4">
<span class="auto-style4"></form></span>
<br class="auto-style4">
<span class="auto-style4"></td></span>
<br class="auto-style4">
<span class="auto-style4"></tr></span>
<br class="auto-style4">
<span class="auto-style4"><tr height="10%" bgcolor="lime"></span>
<br class="auto-style4">
<span class="auto-style4"><td colspan="2" align="center" bgcolor="#000000" class="auto-style1"></span>
<br class="auto-style4">
<span class="auto-style4"><?php</span>
<br class="auto-style4">
<span class="auto-style4">
// Memanggil footer.php</span>
<br class="auto-style4">
<span class="auto-style4">include ("footer.php");</span>
<br class="auto-style4">
<span class="auto-style4">?></span>
<br class="auto-style4">
<span class="auto-style4"></td></span>
<br class="auto-style4">
<span class="auto-style4"></tr></span>
<br class="auto-style4">
<span class="auto-style4"></table></span>
<br class="auto-style4"> <span class="auto-style4"></body></span>
<br class="auto-style4"> <span class="auto-style4"></html></span>
</p>
</body>
</html>
Memanggil data karyawan pada Mysql dengan PHP :
Kodingnya :
<?php
// tentukan nama tabel dan database
$db_name = "dbbarang";
$table_name = "karyawan";
//koneksi ke server dan pilihdatabase
$connection = @mysql_connect("localhost" , "root" , "" ) or die (mysql_error());
$db = @mysql_select_db ($db_name, $connection ) or die (mysql_error());
//membangun query
$sql= "select KodeKaryawan, NamaKaryawan, Alamat, HP from $table_name order
by KodeKaryawan";
$result = @mysql_query($sql,$connection) or die (mysql_error());
// buat daftar hasil yang ditemukan
?>
<html>
<head>
<title>PHP&MySql.com | Dian Arif M.R</title>
<style type="text/css">
.auto-style1 {
color: #FF0000;
}
</style>
</head>
<body bgcolor="#000000" style="background-image: url('abstract_0043.jpg')">
<table width="100%" height="100%" border="5">
<tr height="10%" bgcolor="Black">
<td colspan="2" align="center" bgcolor="#000000" class="auto-style1">
<?php
// Memanggil header.php
include ("header.php");
?>
</td>
</tr>
<tr height="80%" valign="top">
<td width="150" bgcolor="#000000" class="auto-style1">
<?php
// Memanggil menu.php
include ("menu.php");
?>
</td>
<td>
<?php
// ISI
?>
<center><h3 class="auto-style1">Laporan Data Karyawan</h3></center> <table style="width: 100%" border="1">
<tr>
<td class="auto-style1">Kode Karyawan</td>
<td class="auto-style1">Nama Karyawan</td>
<td class="auto-style1">Alamat</td>
<td class="auto-style1">HP</td>
<td class="auto-style1">Menu</td>
</tr>
<?php
while($row = mysql_fetch_array($result))
{
$KodeKaryawan= $row['KodeKaryawan'];
$NamaKaryawan = $row['NamaKaryawan'];
$Alamat = $row['Alamat'];
$HP = $row['HP'];
?>
<tr>
<td class="auto-style1"><?php echo $KodeKaryawan ?></td>
<td class="auto-style1"><?php echo $NamaKaryawan ?></td>
<td class="auto-style1"><?php echo $Alamat ?></td>
<td class="auto-style1"><?php echo $HP ?></td>
<td>
<a href="editKaryawan.php?KodeKaryawan=<?php echo$KodeKaryawan?>"> <span class="auto-style1">Edit</span></a><span class="auto-style1"> </span>
<a href="deleteKaryawan.php?KodeKaryawan=<?php echo$KodeKaryawan?>"> <span class="auto-style1">Delete</span></a><span class="auto-style1"> </span> </td>
</tr>
<?php
}
?>
</table>
</td>
</tr>
<tr height="10%" bgcolor="Black">
<td colspan="2" align="center" bgcolor="#000000" class="auto-style1">
<?php
// Memanggil footer.php
include ("footer.php");
?>
</td>
</tr>
</table>
</body>
</html>
LogOut di PHP
System keluar dari program
Kodingnya :
<?php
session_start();
session_unregister("SES_ADMIN");
echo "<meta http-equiv='refresh' content='0; url=index.php'>"; exit;
?>
Tidak ada komentar:
Posting Komentar