PHPize Online / SQLize Online  /  SQLtest Online

<?php $_POST['click'] = 1; //require_once 'vendor/connect.php'; $connect = &$mysqli; $_SESSION["login"] = 'user1@gmail.com'; /* prepare statement */ $stmt = $connect->prepare("SELECT `balance` FROM `users` WHERE login = ? "); /* bind parameters for login */ $stmt->bind_param("s", $_SESSION["login"]); /* execute query */ $stmt->execute(); $stmt->bind_result($balance); /* fetch value */ $stmt->fetch(); /* free result to next use */ $stmt->free_result(); echo 'Balance:' . $balance . PHP_EOL; if(isset($_POST['click'])) { /* prepare statement */ $stmt = $connect->prepare("UPDATE `users` SET `balance`=`balance`+0.001 WHERE login = ? "); /* bind parameters for login */ $stmt->bind_param("s", $_SESSION["login"]); /* execute query */ $stmt->execute(); echo 'New balance:' . ($balance['balance'] + 0.001) . PHP_EOL; } echo file_get_contents('http://erhk-museum.tls.muzkult.ru/v14'); ?>