Shtimi i te dhenave ne db
Komanda INSERT
Shembull
Formular regjistrimi
Faqa login e modifikuar
<html>
<head>
<title>Login Form</title>
<script language="JavaScript">
function kontrollo()
{
if (document.loginfrm.user.value=='')
{ // begin
alert('Futni username');
document.loginfrm.user.focus();
return false;
} //end
if (document.loginfrm.pass.value=='')
{
alert('Futni password');
document.loginfrm.pass.focus();
return false;
}
return true;
}
</script>
</head>
<body>
<form name="loginfrm" method="post" action="checklogin.php" onSubmit="return kontrollo();" >
<p> Username
<input name="user" type="text" id="user">
</p>
<p>Password
<input name="pass" type="password" id="pass">
</p>
<p>
<input type="submit" name="Submit" value="---LOGIN---">
<input type="reset" name="Submit2" value="---CLEAR---">
</p>
</form>
<p>Not yet a user?</p>
<p><a href="register.php">Register here</a></p>
</body>
</html>
Faqja register.php
<html>
<head>
<title>Registration form</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<form action="registersql.php" method="post" name="registerfrm" id="registerfrm">
<p><strong>Registration form</strong></p>
<p>Username:
<input name="username" type="text" id="username" size="20" maxlength="20">
</p>
<p>Password:
<input name="password" type="password" id="password" size="20" maxlength="20">
</p>
<p>Firstname:
<input name="firstname" type="text" id="firstname" size="20" maxlength="20">
</p>
<p>Lastname:
<input name="lastname" type="text" id="lastname" size="20" maxlength="20">
</p>
<p>Email:
<input name="email" type="text" id="email" size="30" maxlength="30">
</p>
<p>Account status:
<select name="accountstatus" size="1" id="accountstatus">
<option value="1" selected >Active User</option>
<option value="0">Passive User</option>
</select>
</p>
<p>
<input type="submit" name="Submit" value="Register">
</p>
<p> </p>
</form>
</body>
</html>
Faqja registersql.php
<?php
require('db.php');
// te kontrollojme qe eshte postuar nje username
if(!isset($_REQUEST['username']))
{
echo 'mungon username';
include('register.php');
exit();
}
// te kontrollojme qe eshte postuar nje passowrd
if(!isset($_REQUEST['password']))
{
echo 'mungon passowrd';
include('register.php');
exit();
}
// te kontrollojme qe eshte postuar nje firstname
if(!isset($_REQUEST['firstname']))
{
echo 'mungon firstname';
include('register.php');
exit();
}
// te kontrollojme qe eshte postuar nje lastname
if(!isset($_REQUEST['lastname']))
{
echo 'mungon lastname';
include('register.php');
exit();
}
// te kontrollojme qe eshte postuar nje email
if(!isset($_REQUEST['email']))
{
echo 'mungon email';
include('register.php');
exit();
}
// te kontrollojme qe eshte postuar nje account status
if(!isset($_REQUEST['accountstatus']))
{
echo 'mungon accountstatus';
include('register.php');
exit();
}
$u=$_REQUEST['username'];
$p=$_REQUEST['password'];
$fn=$_REQUEST['firstname'];
$ln=$_REQUEST['lastname'];
$em=$_REQUEST['email'];
$ac=$_REQUEST['accountstatus'];
if(strlen($u)<5)
{
echo 'username nuk mund te jete me i shkurter se 5';
include('register.php');
exit();
}
// mund te kontrollojme edhe te tjeret
$komande=" INSERT INTO
'users'('username',
password,firstname,lastname,email,accountstatus)
values ('".$u."','".$p."','".$fn."','".$ln."','".$em."',".$ac.")
";
//echo $komande;
mysql_query($komande)
or die(mysql_error());
include('login.html');
?>