Databases
StackOverflow2013
Postsdbo
POCheck for IP address in table - mySQL PHP
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCheck for IP address in table - mySQL PHP
    primarykey
    data
    text
    <p>Alright. I have this contest signup form with 3 fields that inserts it into a mySQL DB... as well as emailing it. I am adding this code that will check the form for the users current IP, and disallow the submission if it exists.</p> <p>This seems to be executing without error now... but it allows multiple submissions from the same IP. Anything jump out as incorrect?</p> <p>FULL CODE BELOW:</p> <pre><code>&lt;?php //include the connection file require_once('connection.php'); function sanitize($value, $type) { $value = (!get_magic_quotes_gpc()) ? addslashes($value) : $value; switch ($type) { case "text": $value = ($value != "") ? "'" . $value . "'" : "NULL"; break; case "long": case "int": $value = ($value != "") ? intval($value) : "NULL"; break; case "double": $value = ($value != "") ? "'" . doubleval($value) . "'" : "NULL"; break; case "date": $value = ($value != "") ? "'" . $value . "'" : "NULL"; break; } return $value; } //save the data on the DB and send the email if(isset($_POST['action']) &amp;&amp; $_POST['action'] == 'submitform') { //recieve the variables $firstname = $_POST['firstname']; $lastname = $_POST['lastname']; $email = $_POST['email']; $ip = gethostbyname($_SERVER['REMOTE_ADDR']); mysql_select_db($database, $connection); $QUERY = "SELECT COUNT(IP) AS `count` FROM `contest` WHERE IP = 'value'"; $RESULT = mysql_query($QUERY) or die(mysql_error()); // Read the firs row $row = mysql_fetch_assoc($RESULT); // Check how many rows MySQL counted if($row['count'] &gt; 0) { echo "value already exists"; } else { //save the data on the DB mysql_select_db($database, $connection); $insert_query = sprintf("INSERT INTO contest (First_Name, Last_Name, Email_Address, Date, ip) VALUES (%s, %s, %s, NOW(), %s)", sanitize($firstname, "text"), sanitize($lastname, "text"), sanitize($email, "text"), sanitize($ip, "text")); $result = mysql_query($insert_query, $connection) or die(mysql_error()); if($result) { //send the email $to = "EMAIL ADDY"; $subject = "SUBJECT LINE"; //headers and subject $headers = "MIME-Version: 1.0rn"; $headers .= "Content-type: text/html; charset=iso-8859-1rn"; $headers .= "From: ".$firstname." &lt;".$email."&gt;rn"; $body = "New contact "; $body .= "First Name: ".$firstname." "; $body .= "Last Name: ".$lastname." "; $body .= "Email: ".$email." "; $body .= "IP: ".$ip." "; mail($to, $subject, $body, $headers); //ok message header ('Location: thanks.html'); exit (); } } } ?&gt; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USsilenc3xx
    1. USsilenc3xx
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COWhat kind of problems do you have? (And why are these single-quotes there in that line?)
      singulars
      1. POCheck for IP address in table - mySQL PHP
      1. USjohannes
    2. COUse of the inet MySQL functions might be something to look into too. [See this](http://dev.mysql.com/doc/refman/5.0/en/miscellaneous-functions.html#function_inet-aton).
      singulars
      1. POCheck for IP address in table - mySQL PHP
      1. USJon Stirling
    3. COThat might not be a good idea. I live in a university town; all the students who live on campus share a single, public-facing IP address.
      singulars
      1. POCheck for IP address in table - mySQL PHP
      1. USMike Sherrill 'Cat Recall'
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload