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