Avatar of wantabe2
wantabe2Flag for United States of America

asked on 

PHP IP Logging Question

Is there any way for me to edit this code so I can somehow log all attempts to log into this system? This code currently displays the IP address at the bottom of the login page....but is there any way I can log this somewhere or log unsuccessful & successful logons?
<html>  
<body bgcolor="#03EBA6"> 
<head> 

<?php

include("config.php");
session_start();
if($_SERVER["REQUEST_METHOD"] == "POST")
{

// username and password sent from Form 

$myusername=addslashes($_POST['username']); 
$mypassword=addslashes($_POST['password']); 

$sql="SELECT id FROM admin WHERE username='$myusername' and passcode='$mypassword'";
$result=mysql_query($sql);
$row=mysql_fetch_array($result);
$active=$row['active'];
$count=mysql_num_rows($result);

// If result matched $myusername and $mypassword, table row must be 1 row

if($count==1)
{
session_register("myusername");
$_SESSION['login_user']=$myusername;

header("location: welcome.php");
}
else 
{
$error="Your Login Name or Password is invalid";
}
}

?>

<form action="" method="post">
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<center> <h2>Eastern District</h2></center>
<center> <h2> Human Resource Employment Tracking System </h2> </center>
<br>
<br>
<center><label><b>USER NAME :</b></label>

<input type="text" name="username"/><br />

<label><b>PASSWORD :</b></label>

<input type="password" name="password"/><br/>
<br>

<input type="submit" value=" Login "/><br />
</center>
<br>
<br>
<br>
<center> <b> *** The IP address of your computer has already been logged *** </center>
<center> *** All unsuccessful & successful attempts to log onto this system is recorded *** </b> </center>

</form>

<center><b>Your IP Address is: </b><?php echo $_SERVER["REMOTE_ADDR"]; ?></center>

Open in new window

PHPHTMLJavaScript

Avatar of undefined
Last Comment
liveaspankaj
Avatar of Ray Paseur
Ray Paseur
Flag of United States of America image

Sure.  Here are the steps:

1. Create a data base table to keep the log entries.  Maybe three columns with the id, the DATETIME of the event, and the IP address
2. In the code between lines 25 and 36, make the INSERT query to put this information into the data base table.

Sidebar note:  Please see line 27 where it says this, session_register("myusername");  You might want to get rid of that before it's too late:
http://us3.php.net/manual/en/function.session-register.php
Avatar of PimOnline
PimOnline

Create a table to log the attempts. I think u need to insert 4 things. Username, IP, time, (succes/failure).
On password check insert a row. On line 27-28 succes row and line 34 a failure.

That should do it.
ASKER CERTIFIED SOLUTION
Avatar of liveaspankaj
liveaspankaj
Flag of Nepal image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
JavaScript
JavaScript

JavaScript is a dynamic, object-based language commonly used for client-side scripting in web browsers. Recently, server side JavaScript frameworks have also emerged. JavaScript runs on nearly every operating system and in almost every mainstream web browser.

127K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo