PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
-- Hint: use Ctrl+Enter for SQL autocomplete create table `bes` ( `name` varchar(64), `many` int, `activation` int ); insert into `bes` values ('Name1', 50, 1), ('Name2', 1, 1), ('Name3', 50, 0); SELECT `name`, `many` FROM `bes` WHERE `activation`=1;
Copy Clear
Copy Format Clear
<?php $update = 'UPDATE `bes` SET `many` = IF (`many` >= :cena, `many` - :cena, `many`), `activation` = IF (`many` >= :cena, 1, 0) WHERE `activation` = 1'; $stmt = $pdo->prepare($update); $stmt->execute([':cena'=>3]); $query = "SELECT * FROM `bes`;"; $stmt = $pdo->prepare($query); $stmt->execute(); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); print_r($rows);
Show:  
Copy Clear