stupid mysql 5 connect issue??? dumbfounded :-)
Posted: Mon Mar 31, 2008 1:35 pm
Code: Select all
$ip = getenv(REMOTE_ADDR);
mysql_query("INSERT INTO `".$config['db']['pre']."banip` ( `user_ip` ) VALUES ( `$ip` )");
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
$ip = getenv(REMOTE_ADDR);
mysql_query("INSERT INTO `".$config['db']['pre']."banip` ( `user_ip` ) VALUES ( `$ip` )");
Code: Select all
mysql_query("INSERT INTO `".$config['db']['pre']."banip` ( `user_ip` ) VALUES ( `$ip` )") or die("You had an Error in your Mysql Code: <br/>\n" . mysql_error());Code: Select all
$viewed = mysql_num_rows(mysql_query("SELECT 1 FROM ".$config['db']['pre']."banip WHERE user_id='".validate_input($_GET['i'])."' AND user_ip='".validate_input(ip2long($user_ip))."' LIMIT 1"));
if(!$viewed)
{
mysql_query("INSERT INTO `".$config['db']['pre']."banip` ( `user_ip` , `user_id` ) VALUES ( '".validate_input(ip2long($ip))."' , user_id='".validate_input($_GET['i'])."' )") or die("You had an Error in your Mysql Code: <br/>\n" . mysql_error());
}
else
{
mysql_query("UPDATE `".$config['db']['pre']."users` SET `views` = views+1 WHERE `user_id`=".addslashes($_GET['id'])." LIMIT 1;");
mysql_query("UPDATE ".$config['db']['pre']."banip SET `user_id` = '".validate_input($_GET['id'])."' WHERE user_ip='".validate_input(ip2long($user_ip))."'");
}
Code: Select all
mysql_query("UPDATE ".$config['db']['pre']."banip SET `user_id` = '".validate_input($_GET['id'])."' WHERE user_ip='".validate_input(ip2long($user_ip))."'");
$viewed = mysql_num_rows(mysql_query("SELECT 1 FROM ".$config['db']['pre']."banip WHERE user_id='".validate_input($_GET['i'])."' AND user_ip='".validate_input(ip2long($user_ip))."' LIMIT 1"));
if(!$viewed)
{
}
else
{
mysql_query("INSERT INTO `".$config['db']['pre']."banip` ( `user_ip` , `user_id` ) VALUES ( '".validate_input(ip2long($ip))."' , user_id='".validate_input($_GET['i'])."' )");
mysql_query("UPDATE `".$config['db']['pre']."users` SET `views` = views+1 WHERE `user_id`=".addslashes($_GET['id'])." LIMIT 1;");
}