php - 如果在 php 中的 sql 中插入名称超过 2 次，如何抛出错误？

Question

如果名称在 php 中的 sql 中插入超过 5 次，如何抛出错误？？

$sql = mysql_query("INSERT INTO `transfer`(`t_id`, `agent_id`, `agent_name`, `date`, `name`, `phone`, `email`, `tname`, `tphone`, `temail`, `status`) VALUES (NULL,'$agent_id','$agent_name','$date','$name','$phone','$email','$tname','$tphone','$temail','$cmmnt','$status')");

Answer 1

试试这个

$sql = mysql_query("SELECT * FROM transfer HAVING COUNT(name) > 5");

if (mysql_num_rows($sql) != 0) {

    // There are more than 5 - print an error.
    echo 'Error - More than 5';

}else{

    // No Error - Insert
    $insert_query = "INSERT INTO `transfer`(`t_id`, `agent_id`, `agent_name`, `date`, `name`, `phone`, `email`, `tname`, `tphone`, `temail`, `status`) VALUES (NULL,'$agent_id','$agent_name','$date','$name','$phone','$email','$tname','$tphone','$temail','$cmmnt','$status')";
    $insert_result= $mysqli -> query($insert_query);

}