如果IP地址已经在数据库中，则很简单

Question

Hey I want to do a simple check when I'm inserting an impression into a database. I only want to determine if the IP address is already in the database ip field.

In PHP preferably, instead of the the query.

Answer 1

$check_ip = (mysql_num_rows(mysql_query("SELECT ip FROM ip_table WHERE ip='$ip'",$db)) > 0) ? true : false;