Php文件使用htaccess重定向执行2次

Question

I have htaccess file which contain:

RewriteRule . index.php [L]

index.php:

mysql_query("UPDATE users SET Views = Views + 1 WHERE SteamID = '" . mysql_real_escape_string($steamid) . "'", $db);

When I opening index.php, mysql_query executes 2 times, and column Views every time increases in 2. Why?

added:

I made test.php with content:

<?
$db = mysql_connect('localhost', '****', '******');
mysql_select_db("*****", $db);
mysql_query("UPDATE users SET Views = Views + 1 WHERE SteamID = '76561198037192367'", $db);
?>
loaded

this code is executing 3 times!! when I delete .htaccess everything is working properly. It's really strange...

Answer 1

The rules aren't directly causing the index.php file to get loaded twice. There's probably something in index.php, or the HTML content that is returned, that makes the browser load something (like an image, script, style, etc?) that the rule is catching and rewriting back to index.php. This makes it so when you load a page in a browser that gets routed to index.php, index.php actually gets ran twice.

You're either going to have to modify the HTML content that index.php outputs, modify the index.php script so that the query only gets executed when specific _SERVER['REQUEST_URI']'s are requested, or add restriction conditions to the RewriteRule . index.php [L] rule so that it only loads once.