[PHP]Jak zapisać ip logowania?

[PHP]Jak zapisać ip logowania?

woxala123 Zobacz profil	18.03.2011, 22:44:32 Post #1
Grupa: Zarejestrowani Postów: 361 Pomógł: 12 Dołączył: 9.01.2010 Ostrzeżenie: (10%)	Witam mam taki skrypt logowania gdzie zapisuje mi do bazy danych datę logowania ale także chcę dodać by zapisywał do bazy ip. Powiem że nie wiem jak do tego się zabrać. Z góry dzięki z apomoc[php][/php]<?php require_once('Connections/ko.php'); ?> <?php if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { if (PHP_VERSION < 6) { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; } $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($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; } } mysql_select_db($database_ko, $ko); $query_Recordset1 = "SELECT ip_add FROM users"; $Recordset1 = mysql_query($query_Recordset1, $ko) or die(mysql_error()); $row_Recordset1 = mysql_fetch_assoc($Recordset1); $totalRows_Recordset1 = mysql_num_rows($Recordset1); ?> <?php // *** Validate request to login to this site. if (!isset($_SESSION)) { session_start(); } $loginFormAction = $_SERVER['PHP_SELF']; if (isset($_GET['accesscheck'])) { $_SESSION['PrevUrl'] = $_GET['accesscheck']; } if (isset($_POST['myusername'])) { $loginUsername=$_POST['myusername']; $password=$_POST['mypassword']; $MM_fldUserAuthorization = ""; $MM_redirectLoginSuccess = "lista.php"; $MM_redirectLoginFailed = "login_failed.php"; $MM_redirecttoReferrer = true; mysql_select_db($database_ko, $ko); $LoginRS__query=sprintf("SELECT user_login, user_password FROM users WHERE user_login=%s AND user_password=%s", GetSQLValueString($loginUsername, "text"), GetSQLValueString($password, "text")); $LoginRS = mysql_query($LoginRS__query, $ko) or die(mysql_error()); $loginFoundUser = mysql_num_rows($LoginRS); if ($loginFoundUser) { $loginStrGroup = ""; if (PHP_VERSION >= 5.1) {session_regenerate_id(true);} else {session_regenerate_id();} //declare two session variables and assign them $_SESSION['MM_Username'] = $loginUsername; $_SESSION['MM_UserGroup'] = $loginStrGroup; if (isset($_SESSION['PrevUrl']) && true) { $MM_redirectLoginSuccess = $_SESSION['PrevUrl']; } header("Location: " . $MM_redirectLoginSuccess ); } else { header("Location: ". $MM_redirectLoginFailed ); } } ?> <!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=utf-8" /> <title>Untitled Document</title> </head> <body> <form id="form1" name="form1" method="POST" action="<?php echo $loginFormAction; ?>"> <table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF"> <tr> <td colspan="3"><strong>Member Login </strong></td> </tr> <tr> <td width="78">Username</td> <td width="6"> </td> <td width="294"><input name="myusername" type="text" id="myusername" /></td> </tr> <tr> <td>Password</td> <td> </td> <td><input name="mypassword" type="password" id="mypassword" /></td> </tr> <tr> <td> </td> <td> </td> <td><?php $username = $_POST['myusername']; $password = $_POST['mypassword']; $search_user_query = "SELECT * FROM " . users . " WHERE `" . user_login . "`='$username' AND `" . user_password . "`='$password'"; $search_user_result = @mysql_query($search_user_query); $query = mysql_query("UPDATE ". users ." SET date_last_login=NOW() WHERE ". user_login . "='$username'") ?>  </td> </tr> <tr> <td> </td> <td> </td> <td><p> <input type="submit" name="Submit" value="Login" /td> </p> <p>  </p></td> </tr> </table> </form> </body> </html> <?php mysql_free_result($Recordset1); ?>