$dbh->prepare("SELECT ... WHERE This = ? AND That = ?")
$dbh->execute($this, $that);
If you are using mod_perl or fastcgi where the server process is persistent over multiple requests, global variables (which you are using in your example) may not be reset between requests, but keep their old values.
In your example, this means that the next request may see the %FORM values set by the earlier request, if the request happens to come to the same server process.
If by adding %FORM = (); at the top of your script fixes the problem, then this is your issue. You can verify by saying e.g. print $test++; and see if it increments.
Note that this is not the real solution, I would recommend putting your real code inside a function or module and using local variables and parameters there, it is more maintainable as well. And using some of the web application frameworks available (minimally CGI.pm).
You also need to fix the SQL injection security problem, rule of thumb: Never put variables in SQL statement strings, but do something like:
$dbh->prepare("SELECT ... WHERE This = ? AND That = ?")
$dbh->execute($this, $that);
I'm afraid the question is too generic and for any useful answer, a bit of code/pseudo code is going to be essential. However, based entirely on what you've asked, it does look like a browser caching issue, or perhaps a session-data caching issue. Like I say, disclosing a bit of code / pseudo code will help understand your question better
发布评论
评论（2）
如果您使用 mod_perl 或 fastcgi，其中服务器进程在多个请求中保持不变，则全局变量（您在示例中使用的）可能不会在请求之间重置，而是保留其旧值。
在您的示例中，这意味着如果请求碰巧到达同一服务器进程，则下一个请求可能会看到先前请求设置的
%FORM值。如果通过在脚本顶部添加
%FORM = ();可以解决问题，那么这就是您的问题。您可以通过说print $test++;来验证并查看它是否递增。请注意，这不是真正的解决方案，我建议将真正的代码放在函数或模块中，并在那里使用局部变量和参数，它也更易于维护。并使用一些可用的 Web 应用程序框架（至少是 CGI.pm）。
您还需要解决 SQL 注入安全问题，经验法则：永远不要将变量放在 SQL 语句字符串中，而是执行以下操作：
$dbh->prepare("SELECT ... WHERE This = ? AND That = ?") $dbh->execute($this, $that);If you are using mod_perl or fastcgi where the server process is persistent over multiple requests, global variables (which you are using in your example) may not be reset between requests, but keep their old values.
In your example, this means that the next request may see the
%FORMvalues set by the earlier request, if the request happens to come to the same server process.If by adding
%FORM = ();at the top of your script fixes the problem, then this is your issue. You can verify by saying e.g.print $test++;and see if it increments.Note that this is not the real solution, I would recommend putting your real code inside a function or module and using local variables and parameters there, it is more maintainable as well. And using some of the web application frameworks available (minimally CGI.pm).
You also need to fix the SQL injection security problem, rule of thumb: Never put variables in SQL statement strings, but do something like:
$dbh->prepare("SELECT ... WHERE This = ? AND That = ?") $dbh->execute($this, $that);恐怕这个问题太笼统了，对于任何有用的答案，一些代码/伪代码将是必不可少的。但是，完全根据您的要求，它看起来确实像是浏览器缓存问题，或者可能是会话数据缓存问题。就像我说的，公开一些代码/伪代码将有助于更好地理解你的问题
I'm afraid the question is too generic and for any useful answer, a bit of code/pseudo code is going to be essential. However, based entirely on what you've asked, it does look like a browser caching issue, or perhaps a session-data caching issue. Like I say, disclosing a bit of code / pseudo code will help understand your question better