php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #16668 Mysql query executed two times, although called only once
Submitted: 2002-04-17 15:41 UTC Modified: 2002-04-18 02:31 UTC
From: avaly at rol dot ro Assigned:
Status: Not a bug Package: MySQL related
PHP Version: 4.1.2 OS: Linux
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: avaly at rol dot ro
New email:
PHP Version: OS:

 

 [2002-04-17 15:41 UTC] avaly at rol dot ro
I'm sorry I'm opening this bug again, but I was told that my bug was something like 
http://bugs.php.net/bug.php?id=10599&edit=1
but I don't think it's true because the problem there was in HTML; I don't have any HTML code here.

I have the following script: 

function log_query($q) {
    echo $q."<br/>\n";
    return mysql_db_query('logs', $q);
}

global $REMOTE_ADDR, $HTTP_USER_AGENT, $HTTP_SESSION_VARS;
$agent = addslashes($HTTP_USER_AGENT);
$logged_user = $HTTP_SESSION_VARS['userinfo']['username'];

$query = "update ichb_hits set count = count + 1 where ip =
'$REMOTE_ADDR' and user = '$logged_user' and agent = '$agent' and
 date > (now() - INTERVAL 1 HOUR)";
$res = log_query($query);
if (@mysql_affected_rows() <= 0) {
    $query = "insert into ichb_hits (ip, count, date, user, agent)
values ('$REMOTE_ADDR', 1, now(), '$logged_user', '$agent
')";
    log_query($query);
}

This script is in a file called 'log.php'; I include this log.php only
once. The update query is displayed only once, but the count increases
two times; not by 2, but two times at an interval of a quarter of a
second.
If I access the file log.php by itself it executes the query corectly!

Configure Command : './configure' '--with-mysql' '--with-gd'
'--with-zlib' '--with-apxs' 
Try http://db.lumina.ro/info.php for details about PHP installation.

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2002-04-18 02:12 UTC] avaly at rol dot ro
I figured it out. It was because of an image with a blank src attribute, which made the browser load the index.php file again which included log.php again.
Sorry for the trouble !
 [2002-04-18 02:31 UTC] derick@php.net
Not a bug > Bogus
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Mar 28 18:01:29 2024 UTC