updating my table with prepare command increase the value by 2

Question

I am trying to run this simple mysqli command in php:

$query = "UPDATE config SET visit = visit + 1";
if ($stmt = $con->prepare($query)) {
    $stmt->execute();
    $stmt->close();
}

Table config only has 1 row. However, the value instead of 1, it is increasing by 2!

So if the current value is 0, the next value will be 2, and then 4, etc!

I cannot understand this.

Other combinations like visit=visit+? , etc has the same result :( — Soley, Sep 07 '15 at 11:31
This is a simple mysqli command. What is URL routing, and what it has with this issue? — Soley, Sep 07 '15 at 11:33
It works fine with phpmyadmin when I run it there. But running alone in my php case it to increase the visit value by 2 — Soley, Sep 07 '15 at 11:34
well this thing happened with me browser sends a .ico request also along with / . So because i routed all my requests to index.php file for a single request it was being evaluated twice.Better check the access log files for it — georoot, Sep 07 '15 at 11:35
Thank you for the tip. I added a favicon.ico and it solved the issue. — Soley, Sep 07 '15 at 11:42

Your Common Sense · Accepted Answer · 2015-09-07T12:03:09.483

The problem has nothing to do with prepared statements (by the way, you don't need one here) nor even with sql at all. It is your whole php script being executed twice, thanks to wrong implementation of SEO friendly urls. You have to always verify if you're processing a valid request. And never run any SQL for invalid ones.

PS. Add favicon.ico for your site.

I'll take a liberty to stress on it again. It is not favicon.ico to blame, but wrong implementation of SEO friendly urls. There will be hundreds other requests that should result in 404 response, not views increment. You have to cure the disease, not one of symptoms. You have to fix your entry point that should not process requests to image files at whole.

updating my table with prepare command increase the value by 2

1 Answers1