submit ip

[krrose27]

i have a regestrain thing and i wanna make it so when people submit it it also ads their ip to a coulum called ip.

[bpat1434]

How about some code to go with that help request....

~Brett

[krrose27]

The forum.. what do i need to add here?

<form method="post" action="reguser.php">
Email: <input type="text" name="affiliate_email" size="15"><br>
Image Link: <input type="text" name="affiliate_image" size="15"><br>
Website Link: <input type="text" name="affiliate_link" size="15"><br>
<input type="submit" value="submit">
</form>

the reguser.php: what do i need here:

<?php
include "connect.php";
$path="http://hvc.krrose27.com";
$affiliate_email=$_POST['affiliate_email'];
$affiliate_image=$_POST['affiliate_image'];
$affiliate_link=$_POST['affiliate_link'];
$affiliate_email=$_POST['affiliate_email'];
$affiliate_email=strip_tags($affiliate_email);
if ($affiliate_image==$affiliate_image)
{

  $isaffiliate_email="SELECT * from phpb_affiliate where affiliate_email='$affiliate_email'";
  $isaffiliate_email2=mysql_query($isaffiliate_email) or die(mysql_error());
  $isaffiliate_email3=mysql_fetch_array($isaffiliate_email2);
  if(!$_POST['affiliate_email'] || !$_POST['affiliate_email'])
  {
     print "You did not enter a password";
  }
  else if($isaffiliate_email3 || strlen($affiliate_email)>100 || strlen($affiliate_email)<1)
  {
     print "Their is already an affiliate with that email or the email is less than 1 or more than 100 letters.";
  }
  else
  {
    $isaffiliate_image="SELECT * from phpb_affiliate where affiliate_image='$affiliate_image'";
    $isaffiliate_image2=mysql_query($isaffiliate_image) or die("not able to query for password");
    $isaffiliate_image3=mysql_fetch_array($isaffiliate_image2);
    if($isaffiliate_image3)
    {
      print "That image is already being displayed";
    }
    else
    {
      $date=round(date("U")/1000);
      srand($date);
      $SQL = "INSERT into phpb_affiliate(affiliate_email, affiliate_image, affiliate_link) VALUES ('$affiliate_email','$affiliate_image', '$affiliate_link')"; 
      mysql_query($SQL) or die("could not register");
      mail("$affiliate_email","HVC Affiliate system","Dear $affiliate_email,\r\nWe are glad to tell you that your site has been added to our affiliate system and is now being displayed on http://www,hvc.krrose27.com.\r\n****INFO****\r\nImage Being Displayed: $affiliate_image\r\nLink to your site: $affiliate_link\r\nIf any of this is wrong please contact us at [e-mail]\r\nSincerly,\r\nHVC AFFILIATE SYSTEM ADMIN","From: HVC affiliate system");
      print "successful<br>";
      print "Click here to <A href='http://hvc.krrose27.com'>cintinue</a>";
    }
  }
}

else
{
  print "You suck";
}
?>

[Trs2988]

The IP address of the user is stored in $SERVER['REMOTE_ADDR']. You just need to modify that INSERT query so that it also inserts $SERVER['REMOTE_ADDR'] into the IP column.

[krrose27]

so:

$date=round(date("U")/1000);
      srand($date);
      $SQL = "INSERT into phpb_affiliate(affiliate_email, affiliate_image, affiliate_link, affiliate_ip) VALUES ('$affiliate_email','$affiliate_image', '$affiliate_link','$_SERVER['REMOTE_ADDR']')";
      mysql_query($SQL) or die("could not register"); 

is that all i need to edit?

[bpat1434]

$SQL = "INSERT into phpb_affiliate(affiliate_email, affiliate_image, affiliate_link, affiliate_ip) VALUES ('$affiliate_email','$affiliate_image', '$affiliate_link','$_SERVER['REMOTE_ADDR']')"

Should probably be

$SQL = "INSERT into phpb_affiliate(affiliate_email, affiliate_image, affiliate_link, affiliate_ip) VALUES ('$affiliate_email','$affiliate_image', '$affiliate_link','".$_SERVER['REMOTE_ADDR']."')"

And as long as there is a column for it, yes, that's it.

~Brett

[Trs2988]

What are you asking me for, go try it out 😛

Although I think that it might cause errors, you might want to take that variable out of the quotes:

 $date=round(date("U")/1000);
      srand($date);
      $SQL = "INSERT into phpb_affiliate(affiliate_email, affiliate_image, affiliate_link, affiliate_ip) VALUES ('$affiliate_email','$affiliate_image', '$affiliate_link','".$_SERVER['REMOTE_ADDR']."')";
      mysql_query($SQL) or die("could not register"); 

[Trs2988]

bpat1434 wrote:

Should probably be

$SQL = "INSERT into phpb_affiliate(affiliate_email, affiliate_image, affiliate_link, affiliate_ip) VALUES ('$affiliate_email','$affiliate_image', '$affiliate_link','".$_SERVER['REMOTE_ADDR']."')"

And as long as there is a column for it, yes, that's it.

~Brett

Good call 😉