Weird PHP MySQL error

yanuart

I cannot connect to my MySQL server using php script as it shows this error msg :

 
Warning: Host '207.44.130.92' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' in /home/httpd/vhosts/iplayallday.com/httpdocs/submitemail.php on line 24

what happen with my script ?? this error just happen yesterday and it happens at random.. sometime my script will work and sometimes it won't.

If I try using client tools (DBTools), it works just fine.. this is confusing.
Can somebody help me ?

here's my php script which is quite simple i guess :

 
<?php 

$db = mysql_connect("iplayallday.com","yanuar","*****");//pasword is marked for security purpose 

$dbase=mysql_select_db("iplayallday",$db); 
$query1 = "INSERT INTO daftaremail (email) VALUES ('$email')"; 
$result1 = mysql_query($query1); 
mysql_close($db); 
?>

help me please as I'm stump here and I feel sorry for people in my site who couldn't save their scores

zhabala

You should take care about the content of the $email variable. Try to use addslashes function to escape dangerous characters. What is the usual content of that variable ? Is it an e-mail address or the text of some mail message ?

Zdenek

yanuart

what about it ? $email is a variable containing email address..
do you think that someone can do a harmful thing by entering some dangerous character in $email ?

zhabala

Probably not so harmful, but for example some apostrophes or double quotes can be the cause of errors. But if it really contains the email address then it should not be the problem, because email addresses usually contain only alphabetical characters and @ and . characters. Then unfortunatelly I have no idea, why so many errors are occuring.

Zdenek