Hai gan kalini aku kan bagii..** sintakk nie
yaitu sintak log in ……
sekarang sudah marak itu sintak log in …
malah setiap web kanyak nya pake sintakk log in
nah sekarang aku kan mkemberikann tutorial nya .,.,.,,..,.
Nah pertama yang harus agan** laku kan yaitu
bikin databases nya di mysql …..
yang nama databases kalini aku pake nama “pangeran” dan nama table nya “admin”
Yang isi nya .,.
| No | Nama flied | ket |
| 1 | id | Int(4)key |
| 2 | username | Vharchar(40) |
| 3 | password | Vharchar(40) |
Sudah di buat databases nya
mari kita buatt
pertama agan** bikin sintak koneksi yang kayak begini
<?php
# FileName=”Connection_php_mysql.htm”
# Type=”MYSQL”
# HTTP=”true”
$hostname_koneksi = “localhost”;
$database_koneksi = “pangeran”;
$username_koneksi = “root”;
$password_koneksi = “”;
$koneksi = mysql_pconnect($hostname_koneksi, $username_koneksi, $password_koneksi) or trigger_error(mysql_error(),E_USER_ERROR);
?>
Sitak di atas berguna untuk koneksi MYSQL
save dengan nama .. koneksi.php
Tulis sintakk di bwah nie
<?php require_once(‘koneksi.php’); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = “”, $theNotDefinedValue = “”)
{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;
switch ($theType) {
case “text”:
$theValue = ($theValue != “”) ? “‘” . $theValue . “‘” : “NULL”;
break;
case “long”:
case “int”:
$theValue = ($theValue != “”) ? intval($theValue) : “NULL”;
break;
case “double”:
$theValue = ($theValue != “”) ? “‘” . doubleval($theValue) . “‘” : “NULL”;
break;
case “date”:
$theValue = ($theValue != “”) ? “‘” . $theValue . “‘” : “NULL”;
break;
case “defined”:
$theValue = ($theValue != “”) ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= “?” . htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == “form1″)) {
$insertSQL = sprintf(“INSERT INTO admin (username, password) VALUES (%s, %s)”,
GetSQLValueString($_POST['username'], “text”),
GetSQLValueString($_POST['password'], “text”));
mysql_select_db($database_koneksi, $koneksi);
$Result1 = mysql_query($insertSQL, $koneksi) or die(mysql_error());
}
?><!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>
<form method=”post” name=”form1″ action=”<?php echo $editFormAction; ?>”>
<table align=”center”>
<tr valign=”baseline”>
<td nowrap align=”right”>Username:</td>
<td><input type=”text” name=”username” value=”" size=”32″></td>
</tr>
<tr valign=”baseline”>
<td nowrap align=”right”>Password:</td>
<td><input type=”password” name=”password” value=”" size=”32″></td>
</tr>
<tr valign=”baseline”>
<td nowrap align=”right”> </td>
<td><input type=”submit” value=”tambah “></td>
</tr>
</table>
<input type=”hidden” name=”MM_insert” value=”form1″>
</form>
<p> </p>
</body>
</html>
Lalu save dengan nama tambah.php
Sitak di atas berfunsi untuk menabah kan … data bases
Dan sudahh ituu kita buat form untuk login nya
<?php require_once(‘koneksi.php’); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = “”, $theNotDefinedValue = “”)
{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;
switch ($theType) {
case “text”:
$theValue = ($theValue != “”) ? “‘” . $theValue . “‘” : “NULL”;
break;
case “long”:
case “int”:
$theValue = ($theValue != “”) ? intval($theValue) : “NULL”;
break;
case “double”:
$theValue = ($theValue != “”) ? “‘” . doubleval($theValue) . “‘” : “NULL”;
break;
case “date”:
$theValue = ($theValue != “”) ? “‘” . $theValue . “‘” : “NULL”;
break;
case “defined”:
$theValue = ($theValue != “”) ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= “?” . htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == “form1″)) {
$insertSQL = sprintf(“INSERT INTO admin (username, password) VALUES (%s, %s)”,
GetSQLValueString($_POST['username'], “text”),
GetSQLValueString($_POST['password'], “text”));
mysql_select_db($database_koneksi, $koneksi);
$Result1 = mysql_query($insertSQL, $koneksi) or die(mysql_error());
}
?><!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>
<form method=”post” name=”form1″ action=”<?php echo $editFormAction; ?>”>
<table align=”center”>
<tr valign=”baseline”>
<td nowrap align=”right”>Username:</td>
<td><input type=”text” name=”username” value=”" size=”32″></td>
</tr>
<tr valign=”baseline”>
<td nowrap align=”right”>Password:</td>
<td><input type=”password” name=”password” value=”" size=”32″></td>
</tr>
<tr valign=”baseline”>
<td nowrap align=”right”> </td>
<td><input type=”submit” value=”tambah “></td>
</tr>
</table>
<input type=”hidden” name=”MM_insert” value=”form1″>
</form>
<p> </p>
</body>
</html>
Lau agan sve dengan nma index.php
Nah di atas ada sintak seperini
$MM_redirectLoginSuccess = “home.php”;
Itu befungsi jika agan success loginn agan mau kemna misal kan home.php
$MM_redirectLoginFailed = “index.php”;
Dansitak diatas befungsi jika gagal login agan mau kemana …
dan diharap kan ke index.php
Nah udah semuanya
Marii kita jalan kan
Pertama yang agan jalan kan yaitu tambah.php
Di kolom username agan isi dengan username yang agan mau
di kolom password agan isi dengan password yang agan inginkan
sudah di isi lalu agan buka
Index.php
Dan coba username dan password yang agan isikan tadi
Masukan ke klom
Lalu klik loginnn
berhasilll deh
selamat mencoba
No comments:
Post a Comment