MySQL's "UPDATE" being called twice.. And others

SineCosine

I'm still looking for my Tangent
Reaction score
77
Yea..
I think MySQL is deliberately screwing with my mind -____-
I've been trying to figure out the problem for the past hour.

Okay, here's what I am trying to do:
When a task is complete, a form is sent to a php and the php increases the value of a counter, Complete, by 1.
When a task is incomplete, same thing, but Incomplete goes up by 1.

And when a task starts, Started goes up by 1.

When I submit the 'Started' form..
All seems well.
Until I close the webpage that holds the form.
Then, it seems that it gets called AGAIN.

Ugh.
Also, calls are being made to increase the value of a variable when it should not be possible.. At All.

Here's the code, maybe I did something wrong =/

Code:
<?php
	include('Config.php');

	$Report_Type = $_POST['Report'];
	$Report_User = $_POST['User'];

	if ($Report_Type == 'Start') {
		mysql_query("UPDATE EZ_Registered SET Started=Started+1 WHERE Username='$Report_User'");
	} else if ($Report_Type == 'Incomplete') {
		mysql_query("UPDATE EZ_Registered SET Incomplete=Incomplete+1 WHERE Username='$Report_User'");		
	} else if ($Report_Type == 'Complete') {
		mysql_query("UPDATE EZ_Registered SET Complete=Complete+1 WHERE Username='$Report_User'");	
	}
?>

When I submit 'Start', Start goes up by 1.
Then, I close the webpage that holds the form.
Then, Start and Incomplete go up by 1.

So, the end result is: Start = 1, Incomplete = 1
But Incomplete should still be zero because no call was made to it.. Ever.

I even ran a few checks, the php that processes the form will display an 'alert' whenever it is loaded.
An alert will run whenever I press submit.
I added a counter to see how many calls the database was getting.

End result:
PHP processes: 2
Forms submitted: 2
MySQL Counter: 4

It seems that everything get's called twice when it should only happen once =(
 

perkeyone

something clever
Reaction score
71
when ever i get really crazy errors it tends to be because i used the same variable name in two places
or i forgot to put quotes around something
or i forgot the $ in front of a variable name.
the code you posted looks pretty solid so im guessing the error is somewhere else.
 

SineCosine

I'm still looking for my Tangent
Reaction score
77
Actually, I did find it.. eventually.
It wasn't the codes, but some weird buggy issue with DOM Content.

I thought the update was being called the second time when I remove the form.
But that's because I move the form, then close it.

Turns out, the very act of moving it caused it to get sent again (For reasons I'll never understand).
So, I just stopped moving it.. And anything that would cause it to move.
(I gave it an absolute position xD)
 
General chit-chat
Help Users
  • No one is chatting at the moment.
  • The Helper The Helper:
    So what it really is me trying to implement some kind of better site navigation not change the whole theme of the site
  • Varine Varine:
    How can you tell the difference between real traffic and indexing or AI generation bots?
  • The Helper The Helper:
    The bots will show up as users online in the forum software but they do not show up in my stats tracking. I am sure there are bots in the stats but the way alot of the bots treat the site do not show up on the stats
  • Varine Varine:
    I want to build a filtration system for my 3d printer, and that shit is so much more complicated than I thought it would be
  • Varine Varine:
    Apparently ABS emits styrene particulates which can be like .2 micrometers, which idk if the VOC detectors I have can even catch that
  • Varine Varine:
    Anyway I need to get some of those sensors and two air pressure sensors installed before an after the filters, which I need to figure out how to calculate the necessary pressure for and I have yet to find anything that tells me how to actually do that, just the cfm ratings
  • Varine Varine:
    And then I have to set up an arduino board to read those sensors, which I also don't know very much about but I have a whole bunch of crash course things for that
  • Varine Varine:
    These sensors are also a lot more than I thought they would be. Like 5 to 10 each, idk why but I assumed they would be like 2 dollars
  • Varine Varine:
    Another issue I'm learning is that a lot of the air quality sensors don't work at very high ambient temperatures. I'm planning on heating this enclosure to like 60C or so, and that's the upper limit of their functionality
  • Varine Varine:
    Although I don't know if I need to actually actively heat it or just let the plate and hotend bring the ambient temp to whatever it will, but even then I need to figure out an exfiltration for hot air. I think I kind of know what to do but it's still fucking confusing
  • The Helper The Helper:
    Maybe you could find some of that information from AC tech - like how they detect freon and such
  • Varine Varine:
    That's mostly what I've been looking at
  • Varine Varine:
    I don't think I'm dealing with quite the same pressures though, at the very least its a significantly smaller system. For the time being I'm just going to put together a quick scrubby box though and hope it works good enough to not make my house toxic
  • Varine Varine:
    I mean I don't use this enough to pose any significant danger I don't think, but I would still rather not be throwing styrene all over the air
  • The Helper The Helper:
    New dessert added to recipes Southern Pecan Praline Cake https://www.thehelper.net/threads/recipe-southern-pecan-praline-cake.193555/
  • The Helper The Helper:
    Another bot invasion 493 members online most of them bots that do not show up on stats
  • Varine Varine:
    I'm looking at a solid 378 guests, but 3 members. Of which two are me and VSNES. The third is unlisted, which makes me think its a ghost.
    +1
  • The Helper The Helper:
    Some members choose invisibility mode
    +1
  • The Helper The Helper:
    I bitch about Xenforo sometimes but it really is full featured you just have to really know what you are doing to get the most out of it.
  • The Helper The Helper:
    It is just not easy to fix styles and customize but it definitely can be done
  • The Helper The Helper:
    I do know this - xenforo dropped the ball by not keeping the vbulletin reputation comments as a feature. The loss of the Reputation comments data when we switched to Xenforo really was the death knell for the site when it came to all the users that left. I know I missed it so much and I got way less interested in the site when that feature was gone and I run the site.
  • Blackveiled Blackveiled:
    People love rep, lol
    +1
  • The Helper The Helper:
    The recipe today is Sloppy Joe Casserole - one of my faves LOL https://www.thehelper.net/threads/sloppy-joe-casserole-with-manwich.193585/

      The Helper Discord

      Staff online

      Members online

      Affiliates

      Hive Workshop NUON Dome World Editor Tutorials

      Network Sponsors

      Apex Steel Pipe - Buys and sells Steel Pipe.
      Top