Pomoc - Szukaj - Użytkownicy - Kalendarz
Pełna wersja: [PHP]Zapisanie adresu ip podczas logowania.
Forum PHP.pl > Forum > Przedszkole
woxala123
18.03.2011, 11:13:29
Witam prosze o pomoc.
Jak napisac skrypt by podczas logowania zapisywał adres ip i datę do odpowiednich komórek.
ylk
18.03.2011, 11:20:14 
[PHP] pobierz, plaintext 
  1. function getRealIpAddr()
  2. {
  3.     if (!empty($_SERVER['HTTP_CLIENT_IP'])) $ip=$_SERVER['HTTP_CLIENT_IP'];
  4.     elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) $ip=$_SERVER['HTTP_X_FORWARDED_FOR'];
  5.     else $ip=$_SERVER['REMOTE_ADDR'];
  6.     return $ip;
  7. }
[PHP] pobierz, plaintext

woxala123
18.03.2011, 11:38:08
Może inaczej mam oto taki skrypt logowania
[PHP] pobierz, plaintext 
  1. <?php require_once('Connections/ko.php'); ?>
  2. <?php
  3. if (!function_exists("GetSQLValueString")) {
  4. function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
  5. {
  6.   if (PHP_VERSION < 6) {
  7.     $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  8.   }
  9.  
  10.   $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
  11.  
  12.   switch ($theType) {
  13.     case "text":
  14.       $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
  15.       break;    
  16.     case "long":
  17.     case "int":
  18.       $theValue = ($theValue != "") ? intval($theValue) : "NULL";
  19.       break;
  20.     case "double":
  21.       $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
  22.       break;
  23.     case "date":
  24.       $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
  25.       break;
  26.     case "defined":
  27.       $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
  28.       break;
  29.   }
  30.   return $theValue;
  31. }
  32. }
  33.  
  34. mysql_select_db($database_ko, $ko);
  35. $query_Recordset1 = "SELECT ip_add FROM users";
  36. $Recordset1 = mysql_query($query_Recordset1, $ko) or die(mysql_error());
  37. $row_Recordset1 = mysql_fetch_assoc($Recordset1);
  38. $totalRows_Recordset1 = mysql_num_rows($Recordset1);
  39. ?>
  40. <?php
  41. // *** Validate request to login to this site.
  42. if (!isset($_SESSION)) {
  43.   session_start();
  44. }
  45.  
  46. $loginFormAction = $_SERVER['PHP_SELF'];
  47. if (isset($_GET['accesscheck'])) {
  48.   $_SESSION['PrevUrl'] = $_GET['accesscheck'];
  49. }
  50.  
  51. if (isset($_POST['myusername'])) {
  52.   $loginUsername=$_POST['myusername'];
  53.   $password=$_POST['mypassword'];
  54.   $MM_fldUserAuthorization = "";
  55.   $MM_redirectLoginSuccess = "lista.php";
  56.   $MM_redirectLoginFailed = "login_failed.php";
  57.   $MM_redirecttoReferrer = true;
  58.   mysql_select_db($database_ko, $ko);
  59.  
  60.   $LoginRS__query=sprintf("SELECT user_login, user_password FROM users WHERE user_login=%s AND user_password=%s",
  61.     GetSQLValueString($loginUsername, "text"), GetSQLValueString($password, "text")); 
  62.  
  63.   $LoginRS = mysql_query($LoginRS__query, $ko) or die(mysql_error());
  64.   $loginFoundUser = mysql_num_rows($LoginRS);
  65.   if ($loginFoundUser) {
  66.      $loginStrGroup = "";
  67.  
  68. 	if (PHP_VERSION >= 5.1) {session_regenerate_id(true);} else {session_regenerate_id();}
  69.     //declare two session variables and assign them
  70.     $_SESSION['MM_Username'] = $loginUsername;
  71.     $_SESSION['MM_UserGroup'] = $loginStrGroup;	      
  72.  
  73.     if (isset($_SESSION['PrevUrl']) && true) {
  74.       $MM_redirectLoginSuccess = $_SESSION['PrevUrl'];	
  75.     }
  76.     header("Location: " . $MM_redirectLoginSuccess );
  77.   }
  78.   else {
  79.     header("Location: ". $MM_redirectLoginFailed );
  80.   }
  81. }
  82. ?>
  83. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  84. <html xmlns="http://www.w3.org/1999/xhtml">
  85. <head>
  86. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  87. <title>Untitled Document</title>
  88. </head>
  89.  
  90. <body>
  91. <form id="form1" name="form1" method="POST" action="<?php echo $loginFormAction; ?>">
  92.   <table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
  93.     <tr>
  94.       <td colspan="3"><strong>Member Login </strong></td>
  95.     </tr>
  96.     <tr>
  97.       <td width="78">Username</td>
  98.       <td width="6"> </td>
  99.       <td width="294"><input name="myusername" type="text" id="myusername" /></td>
  100.     </tr>
  101.     <tr>
  102.       <td>Password</td>
  103.       <td> </td>
  104.       <td><input name="mypassword" type="password" id="mypassword" /></td>
  105.     </tr>
  106.     <tr>
  107.       <td> </td>
  108.       <td> </td>
  109.       <td> </td>
  110.     </tr>
  111.     <tr>
  112.       <td> </td>
  113.       <td> </td>
  114.       <td><p>
  115.         <input type="submit" name="Submit" value="Login" /td>
  116.       </p>
  117.       <p>  </p></td>
  118.     </tr>
  119.   </table>
  120. </form>
  121. </body>
  122. </html>
  123. <?php
  124. mysql_free_result($Recordset1);
  125. ?>
[PHP] pobierz, plaintext

Teraz chodzi mnie oto jak dopisac funkcję zapisywania adresu ip do tabeli users w kolumnie ip_add
bubusek
18.03.2011, 17:27:32
Cytat(woxala123 @ 18.03.2011, 11:38:08 ) *
Teraz chodzi mnie oto jak dopisac funkcję zapisywania adresu ip do tabeli users w kolumnie ip_add


kod do IP kolega podał wyżej a do tego dodaj

[SQL] pobierz, plaintext 
  1. $query = "INSERT INTO users SET ip_add='$ip'";
[SQL] pobierz, plaintext

woxala123
18.03.2011, 20:30:36
To jak wstawić to wszystko razem by zadziałało? razem
To jest wersja lo-fi głównej zawartości. Aby zobaczyć pełną wersję z większą zawartością, obrazkami i formatowaniem proszę kliknij tutaj.
Invision Power Board © 2001-2025 Invision Power Services, Inc.