Mysql inserts data to mysql database everytime i reload page [duplicate]

Question

I have done that when I push button it should insert data into mysql database but it only inserts it when I reload page. Here Is the code:

<script>
function minuscredits()
{
    alert("hah");
    <?php
    mysql_query("UPDATE `users` SET credits=credits-1 WHERE user_id=".$_SESSION['user']);
    ?>
}
</script>

When I push button I get alert but not insert into database only if I reload page it inserts successfully.

you can't mix php and javaScript like that

user557846
– user557846

2016-07-28 21:58:37 +00:00
Commented Jul 28, 2016 at 21:58 — user557846
– user557846, Commented Jul 28, 2016 at 21:58
Mixing PHP and JS doesn't work.

Charlie Fish
– Charlie Fish

2016-07-28 21:58:48 +00:00
Commented Jul 28, 2016 at 21:58 — Charlie Fish
– Charlie Fish, Commented Jul 28, 2016 at 21:58

Gary Holiday · Accepted Answer · 2016-07-28 21:59:11Z

1

PHP runs on the server. It will run

<?php
    mysql_query("UPDATE `users` SET credits=credits-1 WHERE user_id=".$_SESSION['user']);
?>

when the page loads and only then.

To achieve what you want to do you need to make an ajax call.

answered Jul 28, 2016 at 21:59

Gary Holiday

3,6124 gold badges37 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Mysql inserts data to mysql database everytime i reload page [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related