Pages

Senin, 14 Mei 2012

PHP – SQL Server – Dreamweaver : Halaman Login

Posted by Bayu Aji On 01.54 1 komentar


Sales Activity
Kali ini saya coba bahas bagaimana membuat halaman login untuk web site dinamis yg berhubungan dengan database. bahasa pemrograman yang saya gunakan adalah bahasa pemrograman PHP dgn databasenya SQL Server.Mungkin mencoba langsung ada baiknya paling tidak dengan copy paste dari syntax yg sudah saya posting, dengan begitu anda bisa terlibat bagaimana membuat suatu form dsbnya, jadi tidak langsung ambil source kode lalu jalan… wekss..
Ok Berikut hal-hal yg ada harus siapkan untuk membuat halaman login :
1. Siapkan database Sql Server : Buat database dgn nama Sales
2. Buat Table “STAFF” dengan kriteria sbb :
0 StaffID varchar 50 (Primary Key)
0 StaffName varchar 50
0 Div varchar 10
0 [Position] int
0 Password varchar 50
0 Levelusr int 4
3. Buat Folder di Web Root anda (misal : inetpub/wwwroot/sales)
4. Didalam folder sales , buat kembali folder dgn nama includes
5. didalam folder includes, buatlah satu file text berakhiran “inc” dengan nama conn.inc
6. Berikut isi dari file conn.inc
<?php
$conn = mssql_connect(“komnet”, “sa”, “marlboro”);
if ($conn<=0){
$info = “Cannot connect to database server”;
echo $info;
return;
}

if (!mssql_select_db(“sales”, $conn))
{
$info = “”;
return;
}
else
{
$info = “”;
}
?>

Ket : ganti nama servernya sesuai dengan nama server anda,
File ini digunakan untuk melakukan koneksi ke database
7. Masih dalam folder includes, buat file validsession.php Berikut isi dari file validsession.php
<?php
if (!isset($_SESSION['UserID']))
{
$strUser=”";
}
else
{
$strUser=$_SESSION['UserID'];
}
if ($strUser== “”)
{ print “<HTML><HEAD><TITLE> CMS Session Expired </TITLE>”;
print “<SCRIPT LANGUAGE=\”JAVASCRIPT\”>\n” ;
print “<!–\n” ;
print “function onLoad1()\n”;
print “{\n\t”;
print “alert(‘Your session is expired. Please logon again’)\n\t” ;

print “setTimeout(\”parent.location=’” . $strRootpath . “Logon.php’\”,1000)\n” ;
print “}”;
print “// –>\n” ;
print “</SCRIPT>\n</HEAD><BODY onLoad=\”JavaScript:onLoad1();\”></BODY></HTML>”;
end;
}
?>

8 . didalam folder sales, buatkan file dgn nama index.php
dan copy kan script dibawah lalu pastekan di dalam file index.php melalu aplikasi dreamweaver
<?php
session_start();
include(“Includes/conn.inc”);
if (!isset($_REQUEST["txtUserID"]))
{
$strUserID=”";
}
else
{
$strUserID= $_REQUEST["txtUserID"];
}
$strErrorMessages=”";

if ($strUserID != “”)
{
$strPassword=$_REQUEST["txtPassword"];
$strUserID= strtoupper($strUserID);
$sql = “select * from Staff where StaffID=’$strUserID’”;
$sql .= ” and Password=’$strPassword’”;
$result=mssql_query($sql, $conn);
if (!mssql_fetch_row($result))
{
$strErrorMessages=”Invalid user id/password combination”;
}
else
{
$strErrorMessages=”";
$_SESSION['UserID']= $strUserID;
$_SESSION['DivBran']=mssql_result($result, 0, “Div”);
$posstaf =mssql_result($result, 0, “Levelusr”);
$_SESSION['Admin']=$posstaf;
header(“Location: main.php”);
return;
}
}
?>

<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd“>
<html xmlns=”
http://www.w3.org/1999/xhtml“>
<head>
< meta http-equiv=”Content-Type” content=”text/html; charset=iso-8859-1″ />
< title>e-komfreight</title>
< style type=”text/css”>
< !–
.style5 {
font-family: Arial, Helvetica, sans-serif;
color: #00CC00;
font-weight: bold;
}
body,td,th {
color: #FF9900;
}
body {
background-color: #FFFFFF;
}
.style6 {
color: #006600;
font-family: “Trebuchet MS”, Tahoma, “Estrangelo Edessa”;
font-size: 14px;
}
.style20 {font-family: Arial, Helvetica, sans-serif; color: #006600; font-weight: bold; }
.style29 {font-family: Arial, Helvetica, sans-serif; font-size: 10; }
.style38 {font-family: Tahoma; font-size: 12; font-weight: bold; }
.style39 {color: #0000FF}
.style40 {color: #660000}
.style41 {
font-size: 12px;
color: #666666;
}
.style45 {font-size: 24px}
–>
< /style>
< /head>

<body>
<table width=”750″ border=”0″ align=”center” cellpadding=”0″ cellspacing=”0″>
<tr>
<td width=”213″ height=”73″><p align=”left” class=”style5″> </p> </td>
<td width=”352″ height=”73″> </td>
<td width=”185″ height=”73″><table width=”185″ border=”0″ cellspacing=”1″ cellpadding=”1″>
<tr>
<td width=”165″> </td>
<td width=”13″> </td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan=”2″><div align=”center”>
<?php
print $strErrorMessages;
?>
</div></td>
</tr>
</table></td>
</tr>
<tr>
<td colspan=”3″><hr /></td>
</tr>
<tr>
<td height=”13″ colspan=”3″><div align=”right”></div></td>
</tr>
<tr>
<td height=”13″ colspan=”3″ bgcolor=”#f7f7f7″><form method=POST id=frmLogon name=frmLogon>
<table width=”389″ border=”0″ align=”center” cellpadding=”1″ cellspacing=”1″>
<tr>
<td colspan=”5″ valign=”top”><div align=”center”><span class=”style45″><br />
Login System</span>
<hr />
< /div></td>
</tr>
<tr>
<td width=”70″ valign=”top”> </td>
<td width=”89″><div align=”center”></div></td>
<td width=”42″> </td>
<td width=”175″ colspan=”2″> </td>
</tr>
<tr>
<td valign=”top”> </td>
<td class=”style6″><div align=”left” class=”style38″>
<div align=”left” class=”style20″>User ID </div>
</div></td>
<td class=”style20″><div align=”center”>:</div></td>
<td colspan=”2″><span class=”style29″>
<label> <span class=”style39″>
<input type=”text” id=”txtUserID” name=”txtUserID” class=”style39″ />
</span></label>
</span></td>
</tr>
<tr>
<td valign=”top”> </td>
<td class=”style6″><div align=”left” class=”style38″>
<div align=”left” class=”style20″>Password</div>
</div></td>
<td class=”style20″><div align=”center”>:</div></td>
<td colspan=”2″><span class=”style29″>
<label>
<input type=”password” id=”txtPassword” name=”txtPassword” class=”style39″ />
</label>
</span></td>
</tr>
<tr>
<td valign=”top”> </td>
<td class=”style6″><div align=”center”></div></td>
<td class=”style20″> </td>
<td colspan=”2″> </td>
</tr>
<tr>
<td valign=”top”> </td>
<td><div align=”center”></div></td>
<td> </td>
<td colspan=”2″><label></label></td>
</tr>
<tr>
<td valign=”top”> </td>
<td><div align=”center”></div></td>
<td> </td>
<td colspan=”2″><hr align=”left” width=”75%” /></td>
</tr>
<tr>
<td valign=”top”> </td>
<td><div align=”center”></div></td>
<td> </td>
<td colspan=”2″ valign=”top”><label>
<div align=”center”>
<input class=”button” onMouseOver=”this.className=’buttonover’” onMouseOut=”this.className=’button’” type=”button” value=”Login” id=”cmdLogin” name=”cmdLogin” onclick = “myLogin();” />
</div>
</label></td>
</tr>
<tr>
<td valign=”top”> </td>
<td><div align=”center”></div></td>
<td> </td>
<td colspan=”2″> </td>
</tr>
<tr>
<td valign=”top”> </td>
<td><div align=”center”></div></td>
<td> </td>
<td colspan=”2″><div align=”left”></div></td>
</tr>
<tr>
<td valign=”top”> </td>
<td><div align=”center”></div></td>
<td> </td>
<td colspan=”2″> </td>
</tr>
</table>
</form> </td>
</tr>
<tr>
<td height=”13″ colspan=”3″> </td>
</tr>
<tr>
<td height=”13″ colspan=”3″> </td>
</tr>
<tr>
<td height=”13″ colspan=”3″><div align=”center”>Global Putera International Group </div></td>
</tr>
<tr>
<td height=”13″ colspan=”3″><div align=”center”>IT – Departement </div></td>
</tr>
<tr>
<td height=”13″ colspan=”3″><div align=”center”>March 2007 </div></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
< /table>
< SCRIPT LANGUAGE=javascript>
< !–
function myLogin() {
var strUserID = document.frmLogon.txtUserID.value;
if (!strUserID ) {
document.frmLogon.txtUserID.focus();
alert(“User ID cannot be Empty !!”);
return;
}
var strPassword=document.frmLogon.txtPassword.value;
if (!strPassword) {
document.frmLogon.txtPassword.focus();
alert(“Password cannot be Empty !!”);
return;
}
document.frmLogon.submit();
}
function myCancel() {
document.frmLogon.txtUserID.value=”;
document.frmLogon.txtPassword.value=”;
}

</SCRIPT>
< /body>
< /html>

9. Buatkan file dengan nama main.php di folder sales
berikut isi dari file main.php
<?php
session_start();
include_once (“Includes/conn.inc”);
include_once (“Includes/validsession.php”);
?>
< !DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd“>
<html xmlns=”
http://www.w3.org/1999/xhtml“>
<head>
< meta http-equiv=”Content-Type” content=”text/html; charset=iso-8859-1″ />
< title>Untitled Document</title>
< /head>

<body>
< p>Sucess….</p>
< p> </p>
< p><a href=”logout.php” mce_href=”logout.php” ><span class=”style31″>Logout</span></a> </p>
< /body>
< /html>

10. Terakhir buatkan program logoutnya (logout.php) difolder sales
berikut isi dari file logout.php
<?php
session_start();

$_SESSION["UserID"]=”";
$_SESSION["UserName"]=”";
$_SESSION["Admin"]=”";
// Destroy session data
session_destroy();
print “<HTML><HEAD><TITLE> CMS Logged out </TITLE>\n”;
print “<SCRIPT LANGUAGE=\”JAVASCRIPT\”>\n”;
print “<!–\n” ;
print “function onLoad1()\n”;
print “{\t\n”;
print “setTimeout(\”parent.location=’index.php’\”,10)\n”;

print “}\n”;
print “// –>\n”;
print “</SCRIPT>\n”;
include (“Includes/Styles.php”);
print “</HEAD>\n<BODY onLoad=\”JavaScript:onLoad1();\”>\n”;

?>

1 komentar:

Are you paying over $5 per pack of cigs? I buy my cigarettes over at Duty Free Depot and this saves me over 60% from cigs.

Posting Komentar