PHP whois lookup script stores request in database

ivosteen

I want a whois lookup script that is written in PHP that writes the output of a request to a database (i.e. MySQL) with the ip address of the requestor.

Does a script like this excists or could somebody make it, I can't unfortunately.

--IS

okuto1973

index.php

index2.php

<?
$db_name='databasename';
$db_user='user';
$db_password='password';

// connessione al DATABASE
$db_conn = mysql_connect("localhost",$db_user,$db_password);
if (!$db_conn)
{
die ("ERRORE !! non riesco a collegarmi al database!");
//exit();
}

$ip = $REMOTE_ADDR;
$insert="insert tabella (name,ipaddress) VALUES ('$name','$ip')";
$db_query=mysql_db_query($db_name,$insert);
?>

Supposing you have a MYSQL database with:
DATABASE NAME=databasename
and to enter the user and password

talldarkmystere

<?php

if(!$name) {
print("
<form name=\"\" action=\"$PHP_SELF\" method=\"post\">
<input type=\"text\" name=\"name\">
</form>");

$db_name='databasename';
$db_user='user';
$db_password='password';
$table='whoistracker';

// Connect to the database
$db_conn = mysql_connect("localhost",$db_user,$db_password);
if (!$db_conn)
{
die ("ERROR: Cannot connect to the database.");
//exit();
}

$ip = $REMOTE_ADDR;
$insert="INSERT INTO $table (name,ipaddress) VALUES ('$name','$ip')";
$db_query=mysql_db_query($db_name,$insert);

if($dbquery) { print("Done."); } ELSE { print("Didn't work.");
?>

Just a little improvement(?) on the prior post...

talldarkmystere

oops. forgot to make a condition on the sql statement... Basically, you want to ensure that the form has been submitted.

if($name) {
if($dbquery) { print("Done."); } ELSE { print("Didn't work."); }

ivosteen

This is the error I get when I run the script.

Parse error: parse error, unexpected $ in /home/think/public_html/whois/index.php on line 32

Line 32 is empty, because the script as you posted is only 31 lines... help me out, please!

I am an amateur so how do I include the whois action in this script??

--IS

talldarkmystere

Well, I'm not quite sure exactly how you plan to impliment this - if you require visitors to login for this, or what....

With the script that was provided - you can either use it with a login, or same page...

make sure you have mySQL installed, a database, and a table sert up for this. You'll need two fields; name and ip.

Once you have that done, change the connection variables so they work with your setup.

Let's try the script again.

<?php

if(!$name) {
print("
<form name=\"\" action=\"$PHP_SELF\" method=\"post\">
<input type=\"text\" name=\"name\">
</form>");

$db_name='databasename';
$db_user='user';
$db_password='password';
$table='whoistracker';

// Connect to the database
$db_conn = mysql_connect("localhost",$db_user,$db_password);
if (!$db_conn)
{
die ("ERROR: Cannot connect to the database.");
//exit();
}

if($name!="") {
$ip = $REMOTE_ADDR;
$insert="INSERT INTO $table (name,ipaddress) VALUES ('$name','$ip')";
$db_query=mysql_db_query($db_name,$insert);
if($dbquery) { print("Done."); } ELSE { print("Didn't work.");
} ELSE { exit; }

ivosteen

Again I get a parse error because somewehere you forgot a brace. After I corrected that the script seems to work, but nothing added to my table...

okuto1973

Write this (with the correct tablename you have created!)

$insert="INSERT INTO tablename (name,ipaddress) VALUES ('$name','$ip')";

instead of

$insert="INSERT INTO $table (name,ipaddress) VALUES ('$name','$ip')";

and let me know!

You can also add a
echo "insert=$insert";
to know the exact insert the string create.
Try it on database to check if you have written the correct insert string!

ivosteen

This is my code, but it seems it still doesn't do anything. What is wrong?

no "Done." or "Didn't work." print on screen
no data in my database-table

<?php
if(!$name)
{
print("<form name=\"\" action=\"$PHP_SELF\" method=\"post\">
<input type=\"text\" name=\"name\">
<input type=\"submit\" name=\"name\">
</form>");
$db_name='whoistracker';
$db_user='whoistracker';
$db_password='ivosteen';
$table='whoistracker';
// Connect to the database
$db_conn = mysql_connect("localhost",$db_user,$db_password);
if (!$db_conn)
{
die ("ERROR: Cannot connect to the database.");
//exit();
}
$ip = $REMOTE_ADDR;
$insert="select * from $table";
$insert="INSERT INTO whoistracker (name,ipaddress) VALUES ('$name','$ip')";
$db_query=mysql_db_query($db_name,$insert);
if($name!="")
{
if($dbquery)
{ print("Done.");
}
else
{ print("Didn't work.");
}
}
}
?>

okuto1973

You have to make two different pages......index.php that let user to write it's name......and index2.php that take the variable $name and put it to database.
It very usefull to write some echo.....to know where the program stops.......
so tell me what index2.php write in your browser after you have entered your name in index.php.

index.php

index2.php

<?
$db_name='databasename';
$db_user='user';
$db_password='password';

// connessione al DATABASE
$db_conn = mysql_connect("localhost",$db_user,$db_password);
if (!$db_conn)
{
die ("ERRORE !! non riesco a collegarmi al database!");
//exit();
}

echo "Connecting....";

$ip = $REMOTE_ADDR;
echo "IP=$ip";

$insert="insert tabella (name,ipaddress) VALUES ('$name','$ip')";
echo "insert=$insert";
$db_query=mysql_db_query($db_name,$insert);
echo "All done";
?>

ivosteen

I have still an error when I do exactly what you wrote. 😕

This is what I see in my browser:
Connecting....IP=insert=insert whoistracker (name,ipaddress) VALUES ('','')All done

okuto1973

Perhaps the problem is that your php doesn't pass variables......
BTW have you write something in the text name field?For example your name?
The strange thing is that you can't see your IP.....for that perhaps you have to check your php.ini file and figure out the problem asking someother people.
If you have write something in the text and after as you can see the insert string haven't the variable you have passed the problem isn't in your code but in the configuration of your php (php.ini file)
I haven't installed my php and Apache on linux (i'm a programmer....and for that thing i have an help from another people......)

As you can see all seems work fine only the insert string is incorrect!

Try to change the string insert in:

$insert="INSERT INTO whoistracker (name,ipaddress) VALUES ('Myname','125.0.0.0')";

If i 'm not in wrong now you have to see something in your db!

If also this check works the problem is sure in varibales passed from a page to page with browser.......