Variable not refreshing after submit

Question

I have token system where every time you submit the form it take -1 from your total tokens.

I'm using common.php

$ses_sql="Select * from users where name='testuser' and id='1'";
$result = $conn->query($ses_sql);
$row = $result->fetch_assoc();
$token = $row['tokens'];

So beside the menu bar it views your total Credit so you can see it, no matter which page you are in.

Now come the form part. Page name adduser.php

<? 
// Included on all pages.
include 'include/common.php';
echo $token; 
?>
<form method="post" action="adduser.php?save=all">
<input type="text" name="username">
</form>
<?
$kalk = $token - 1;
if (isset($_GET['save']) && $_GET['save'] == 'all'{
$sqllog = "UPDATE `reseller` set `tokens`='$kalk' where id='1'";
$check1 = mysqli_query($conn,$sqllog);
}
?>

So all this working, perfect. BUT remember the callout on top of the page $token this is not refreshing after the submit, but going into other page OR refreshing the browser the value gets updated. Help is appreciated.

Answer 1

Sidenote edit: This answer is based on OP's original post https://stackoverflow.com/revisions/33807477/1 and 2nd revision https://stackoverflow.com/revisions/33807477/2 and did an edit after this was posted.

---

Ok, I'm submitting this since I'm not getting any other feedback from the OP in comments and to point out the syntax error.

This line of code:

$sqllog = 'UPDATE `reseller` set `tokens`='$kalk' where id='1'";
          ^ single                                            ^ double

You are opening your statement with a single quote, then closing it with a double quote.

Error checking would have thrown you a syntax error message.

• http://php.net/manual/en/mysqli.error.php

and needs to read as:

$sqllog = "UPDATE `reseller` set `tokens`='$kalk' where id='1'";
// or where id=1 but doubt that would make a difference.

and having done

$check1 = mysqli_query($conn,$sqllog) or die(mysqli_error($conn));

to signal the syntax error.

"$token this is not refreshing after the submit"

That's because you need to refresh the page yourself or use a redirection method.

Have a look at this Q&A on Stack:

• How to make a redirect in PHP?

You're also open to an SQL injection. Use a prepared statement.

• https://en.wikipedia.org/wiki/Prepared_statement

---

Add error reporting to the top of your file(s) which will help find errors.

<?php 
error_reporting(E_ALL);
ini_set('display_errors', 1);

// rest of your code

Sidenote: Displaying errors should only be done in staging, and never production.

Additional debugging tools:

• var_dump() http://php.net/manual/en/function.var-dump.php
• print_r() http://php.net/manual/en/function.print-r.php

and echoing your query.

• Also make sure you've chosen the right database/table/column(s)