Blocking a submission to MySQL if conditions are met

Question

Hello,

The code below works well. It submits some variables into a MySQL database. How could I block the submission and redirect the user back to domain.com/index.php if the conditions below are met?

Conditions:

• $uid has been used more 11 or more times in a calendar day.
• $cleanurl has ever been used before.

Thanks in advance,

John

Code:

 if(isURL($site1)==true)
     mysql_query("INSERT INTO submission VALUES (NULL, '$uid', '$title', '$slug', '$cleanurl', '$displayurl', NULL)");
    else
     echo "<p class=\"topicu\">Not a valid URL.</p>\n";

Answer 1

You would simply need to run queries to apply these checks prior to your INSERT and if the criteria isn't met, forward them on as you mentioned.

[REMOVED STUPID COMMENT]

mysql_real_escape_string() is definitely the route to take

Answer 2

$uid has been used more 11 or more times in a calendar day:

select uid from submissions where date > '$todaysDate 00:00' and date < '$todaysDate 23:59' group by uid having count() > 11

$cleanurl has ever been used before.

SELECT count(*) from ... where cleanurl='$cleanurl'

if both conditions are met, then

Header("Location: http://domain.com/index.php");