Registering Via IP (Continuation) in PHP/MySQLi

Submitted by Yorkiebar on Wednesday, July 9, 2014 - 09:45.

Language

Introduction: This tutorial is on how to allow our users register via their unrecognised IP (Continued from http://www.sourcecodester.com/php/7539/auto-recognise-users-ip-address-through-phpmysqli.html). Important: I highly recommend that you read through the linked tutorial above, it will allow you to get the same source I am going to be using throughout this tutorial! Validation: So before we can allow them to register, we need to validate that they are not already registered and therefore IP recognised...

$q = mysqli_query($con, "SELECT * FROM `test` WHERE `ip`='$ipaddr'");
if (mysqli_num_rows($q) > 0) {
        echo 'Is your username ' . mysqli_fetch_array($q)['username'] . '?';
}else{
        echo 'No username found by that IP address!';
}

Now we can see that the else block of code above, is for if the user is not yet registered. So if the else block of code gets executed, we want to first set an integer variable to used as a boolean (1=true, 0=false), call it 'shouldShow'. Make this globally available...

$shouldShow = 0;

Now in the else block, set it to '1', true...

$shouldShow = 1;

HTML Form: To get the user information, we want a simple HTML form for their input username, we first check whether we should show the HTML form, by referring to our PHP variable earlier... -Basic HTML Template-

<html>
        <heaD>
        </head>
        <body>
 
        </body>
</html>

Now, we need to use PHP to check the PHP variable, so don't forget the PHP tags...

<?php
        if ($shouldShow > 0) {
                //True, not registered yet
                echo "
                ";
        }//Else; Already Registeted. No form.
?>

In the echo statement we put the HTML form. We simply take one text field of the username, and output their IP. Along with a submit button of course. The form automatically uses the secure POST (as opposed to GET) method, and action is the same page file name as we are currently editing...

<form action='ip.php' method='POST'>
        Username: <input type='text' name='username' />
        <br/>
        IP: ".$ipaddr."
        <br/>
        <input type='submit' value='Register!' name='submitted' />'
</form>

Form Processing: Finally we want to now check if the POST data is received/sent on the page load, so at the top of the page we check for the username POST...

if (isSet($_POST['username'])) {
 
}

And if it is there, we insert a new row in to our 'test' table with the information...

$username = $_POST['username'];
$ipaddr = $_POST['ipaddr'];
$q = mysqli_query($con, "INSERT INTO `test` VALUES ('', '$username', '$ipaddr')");

Finished! Full source:

<?php
        $con = mysqli_connect('localhost', 'root', '', 'fln'); //server, username, password, database name
        if (isSet($_POST['username'])) {
                $username = $_POST['username'];
                $ipaddr = $_POST['ipaddr'];
                $q = mysqli_query($con, "INSERT INTO `test` VALUES ('', '$username', '$ipaddr')");
        }
        $shouldShow = 0;
        $ipaddr = $_SERVER['REMOTE_ADDR'];
        $q = mysqli_query($con, "SELECT * FROM `test` WHERE `ip`='$ipaddr'");
        if (mysqli_num_rows($q) > 0) {
                echo 'Is your username ' . mysqli_fetch_array($q)['username'] . '?';
        }else{
                echo 'No username found by that IP address!';
                $shouldShow = 1;
        }
?>
<html>
        <heaD>
        </head>
        <body>
                <?php
                        if ($shouldShow > 0) {
                                //True, not registered yet
                                echo "
                                        <form action='ip.php' method='POST'>
                                                Username: <input type='text' name='username' />
                                                <br/>
                                                IP: ".$ipaddr."<input type='hidden' value='".$ipaddr."' name='ipaddr' />
                                                <br/>
                                                <input type='submit' value='Register!' name='submitted' />'
                                        </form>
                                ";
                        }//Else; Already Registered. No form.
                ?>
        </body>
</html>

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Add new comment

49 views