PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table users ( login varchar(255), balance double ); insert into users values ('user1@gmail.com', 50);
Copy Clear
Copy Format Clear
<?php //require_once 'vendor/connect.php'; $debug = true; $connect = &$mysqli; $_SESSION["login"] = 'user1@gmail.com1'; $login = mysqli_real_escape_string($connect, $_SESSION["login"]); $query = mysqli_query($connect, "SELECT * FROM `users` WHERE login = '$login'"); if(!$query){ die( $debug ? mysqli_error($connect) : 'Something went wrong'); } $balance = mysqli_fetch_assoc($query); echo $balance['balance']; if(isset($_POST['click'])) { mysqli_query($connect, "UPDATE `users` SET `balance`=`balance`+0.001 WHERE login = '$login'"); } ?>
Show:  
Copy Clear