INSERT电子邮件地址，但忽略（如果存在||，如果后缀=现有后缀&&发件人名称=现有名称）MYSQL

Question

I'm trying to insert a query into mysql using php, but to have restrictions.

$sql_insert = "
INSERT IGNORE 
    into `email` 
        (`message`,`useremail`,`senderemail`) 
    VALUES 
        ('$emailmessage','$email_address','$fromaddress') 
WHERE
";

$fromaddress is the value I want to make the constraints.

Here's an example

"Zazzle" <[e-mail]>

Don't insert if [e-mail] is in the senderemail field Don't insert if "Zazzle" is in the field and if @zazzle.com is also in the field.

Answer 1

you can pull the email apart and then check the database to see if it exists in the database using preg_match. If using the example:

--"Zazzle" <[e-mail]>

---

$atIndex = strrpos($fromaddress, "@");
$nameIndex = strrpos($fromaddress, "<");
$domain = substr($fromaddress, $atIndex+1); # returns zazzle.com
$local = substr($fromaddress, $nameIndex+1, $atIndex); # returns sender-123
$name = substring($fromaddress, 0, $nameIndex-1); # returns "Zazzle"

from there all you have to do is do a select/where query and if no results then to insert.

$query = "SELECT * FROM email WHERE senderemail like '".$domain."'";
$result=mysql_query($query);
$num=mysql_num_rows($result);

---

OR

$query = "SELECT * FROM email";
$result=mysql_query($query);
while($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
     if(preg_match($domain, $row['senderemail'])) { $isPresent = true; }
} 

---

Preg match will look for the strings in the individual returned value and if present set a value to true. Then you can compare that value to be true/false and then to update your database.