how to throw error if the name has been inserted more than 2 times in sql in php?

Question

how to throw error if the name has been inserted more than 5 times in sql in php??

$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')");

yes.....it should allow insertion bt if the same name has been inserted more than 5 times than it should not insert the value...!! it should throw error....!!!!! — Bhaskar Gariibidi, Mar 07 '15 at 09:22

I'm Geeker · Answer 1 · 2015-03-07T09:51:59.423

3

Try this

$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);

}

edited Mar 07 '15 at 09:51

answered Mar 07 '15 at 09:32

I'm Geeker

4,601
5
22
41

i tried it its not working...!! its directly showing error reagrdless of the conditions....!!! – Bhaskar Gariibidi Mar 07 '15 at 09:41
check my updated answer it ill work for you @BhaskarGariibidi – I'm Geeker Mar 07 '15 at 09:44
its also throwing error....!!! its not checking the condition...!!! whats should i do to stop it & throw error after inserting more than 5 times..!! – Bhaskar Gariibidi Mar 07 '15 at 09:49
please show the code what u tried @BhaskarGariibidi – I'm Geeker Mar 07 '15 at 09:51
$sql = mysql_query("SELECT * FROM transfer HAVING COUNT(name) > 5"); if (mysql_num_rows($sql) != 0) { //show error } else{ $sql=mysql_query("insert into transfer(t_d,name) values(NULL,'$name')"); } – Bhaskar Gariibidi Mar 07 '15 at 09:55
yes in ur database there are more then 5 times `given name` is inserted.so the code works properly what was the issue in that? – I'm Geeker Mar 07 '15 at 10:00
truncate your table and check it again @BhaskarGariibidi – I'm Geeker Mar 07 '15 at 10:03
i had tried truncating then also it's showing error – Bhaskar Gariibidi Mar 07 '15 at 10:08
where shoul i post it so you check it?? – Bhaskar Gariibidi Mar 07 '15 at 10:14

score 0 · Answer 2 · edited May 23 '17 at 11:56

Please, don't use mysql_* functions in new code. They are no longer maintained and the deprecation process has begun on it. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which.

See the above note - I'd suggest you use the mysqli_ function as the mysql_ functions have been deprecated.

$mysqli = new mysqli('localhost', 'username', 'password', 'db');

$query  = "SELECT * FROM transfer HAVING COUNT(name) > 5";
$result = $mysqli -> query($query);
$num    = $result -> num_rows();

if($num != 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);

}

score 0 · Answer 3 · answered Mar 07 '15 at 21:24

Comments re the importance of using mysqli* instead of mysql* API are quite important and should not be ignored, but since you've started with mysql* I will continue in that same route...

I believe the previous answers (using HAVING ...) were not answering your actual question. Try the code below.

$sql = mysql_query("SELECT * FROM transfer WHERE name = '$name'");

if (mysql_num_rows($sql) >= 5) {
    echo "Error - Too many occurrences of $name";
} else {
    $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);
}

how to throw error if the name has been inserted more than 2 times in sql in php?

3 Answers3