如何在登录时插入/更新用户IP地址 [英] How to insert/update users IP address on log in

问题描述

在登录页面上，我希望用户登录并在我的数据库的last_login列中记录他们的IP地址。我可以获取用户的IP地址并回显它，但我无法将其更新为UPDATE甚至INSERT INTO数据库。这就是我的尝试：

On the log in page i want the user to log in and record their ip address in the 'last_login' column of my database. I can get the users IP address and echo it but i can't get it to UPDATE or even INSERT INTO the database. This is what i tried :

<?php
$con=mysql_connect("host","username","password","database");

if (mysql_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysql_connect_error();
  }
$username = $_POST['username'];;
$ip = $_SERVER['REMOTE_ADDR'];
mysql_query($con,"UPDATE users SET last_login='$ip' WHERE username='$username'");
?>

推荐答案

con = mysql_connect（< span class =code-string> host， 用户名， password， database）;

if （mysql_connect_errno（））
{
echo 无法连接到MySQL：。 mysql_connect_error（）;
}

con=mysql_connect("host","username","password","database"); if (mysql_connect_errno()) { echo "Failed to connect to MySQL: " . mysql_connect_error(); }

用户名 =

username =

_POST [< span class =code-string>' username'] ;;

_POST['username'];;

这篇关于如何在登录时插入/更新用户IP地址的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！