Example Mysql

a$agida ornek 1 mysql dosyasi bulabilirsiniz.




Kod:
<?php
$thispage = $SCRIPT_NAME;
$forwardpage = $SCRIPT_NAME; //SET THIS TO THE PAGE YOU WANT YOUR USER TO BE FORWARDED AFTER LOGIN/LOGOUT

//CHECK FOR LOGIN STATUS
$myid = $HTTP_COOKIE_VARS["Unique ID Alan Adi"];
$myusername = $HTTP_COOKIE_VARS["Kullanici Alan Adi"];

//IF LOGGED IN, SHOW USER ID
if ($action=="logout") {
setcookie("Unique ID Alan Adi",$Unique ID Alan Adi,time()-1,"/",".yourdomain.com",0);
setcookie("Kullanici Alan Adi",$Kullanici Alan Adi,time()-1,"/",".yourdomain.com",0);

?>
<<?php echo "meta ";?> <?php echo"http-equiv";?>="refresh" content="3; Url=<?php echo $forwardpage; ?>?">
Please wait while we log you out...
<?
} else {
if ($Unique ID Alan Adi > "") {
/*------------------------------------------------------------
IF USER IS LOGGED IN, THEY SEE THE FOLLOWING
------------------------------------------------------------*/
echo "Your User ID is: $myid";
echo "<BR>Your Username is: $myusername";
?>
<BR><BR><a href="<?php echo $thispage; ?>?action=logout&myid=<?php echo $myid; ?>">Click Here to Logout</a>
<?
/*------------------------------------------------------------
END OF USER IS LOGGED IN
------------------------------------------------------------*/
} else {

//IF NOT LOGGED IN
if ($login == "") {

if ($myid == "") {
/*------------------------------------------------------------
IF USER IS NOT LOGGED IN, THEY SEE THE FOLLOWING LOGIN FORM
------------------------------------------------------------*/
?>

<FORM METHOD="POST" ACTION="<?php echo $thispage ?>">


<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="0" ALIGN="CENTER">
<TR>
<TD ALIGN="CENTER">
&nbsp;
</TD>
<TD ALIGN="LEFT">
<FONT FACE="ARIAL" SIZE="3">
<B>&nbsp;&nbsp;&nbsp;Login:</B>
</FONT>

</TD>
</TR>
<TR>
<TD><B><FONT SIZE="2" FACE="ARIAL">Username:&nbsp;&nbsp;</FONT></B></TD>
<TD><INPUT TYPE="TEXT" NAME="username" SIZE="12"></TD>
</TR>
<TR>
<TD><B><FONT SIZE="2" FACE="ARIAL">Password:&nbsp;&nbsp;</FONT></B></TD>
<TD><INPUT TYPE="password" NAME="password" SIZE="12"></TD>
</TR>
<TR>
<TD></TD>
<INPUT TYPE="HIDDEN" VALUE="yes" NAME="login">
<TD ALIGN="center"><INPUT TYPE="submit" VALUE="Login"></TD>
</TR>
</TABLE>
</CENTER>
</DIV>
</FORM><?
/*------------------------------------------------------------
END OF THE LOGIN FORM
------------------------------------------------------------*/
} //end if myid == nothing
} //END IF LOGIN == ""


if ($login == "yes") {
//CONNECTION STRING
mysql_connect("Baglanilacak ip/host", "Veritabani Kullanici Adi", "Veritabani $ifresi")
or die ("UNABLE TO CONNECT TO DATABASE");
mysql_select_db("Veritabani Adi")
or die ("UNABLE TO SELECT DATABASE");


// $_GET VARIABLES
foreach($_GET as $a=>$b){$$a=$b; echo "<BR>$a: $b";}

// $_POST VARIABLES
foreach($_POST as $a=>$b){$$a=$b; echo "<BR>$a: $b";}

$sqllogin = "SELECT * FROM Table Adi WHERE Kullanici Alan Adi = '$username' and $ifre Alan Adi = '$password'";
$result = mysql_query($sqllogin);

if ($result > 1) {
if ($myrow = mysql_fetch_array($result)) {
do
{

$Unique ID Alan Adi = $myrow["Unique ID Alan Adi"];
$Kullanici Alan Adi = $myrow["Kullanici Alan Adi"];

setcookie("Kullanici Alan Adi",$Kullanici Alan Adi,time()+28800,"/",".yourdomain.com",0);
setcookie("Unique ID Alan Adi",$Unique ID Alan Adi,time()+28800,"/",".yourdomain.com",0);

echo "Welcome $Kullanici Alan Adi!
<BR>Please wait 2-3 seconds while we process your login...<BR>";
?>
<<?php echo "meta ";?> <?php echo"http-equiv";?>="refresh" content="3; Url=<?php echo $forwardpage; ?>">
<?
} while ($myrow = mysql_fetch_array($result));
} else {
echo "That Username or Password was Not Found";
?>
<a href="<?php echo $thispage; ?>?">Click Here to Login</a>
<?
} //END IF MYROW RESULT
} else {
echo "No Results Returned";
} //END IF RESULT = 1
} //END IF LOGIN == YES
} //END IF NOT LOGGED IN.....
} //END IF NOT LOGGING OUT...
?>