Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $current_time = time();
- $req = $bdd->prepare('SELECT * FROM flowers WHERE id_account = ?');
- $req->execute(array($_SESSION['id']));
- while ($result = $req->fetch())
- {
- $difference = $current_time - $result['born'];
- if ($difference >= 10)
- {
- $difference / 10;
- $cm = $result ['cm'] + 10;
- $req1 = $bdd->prepare('UPDATE flowers SET cm = :cm, born = :born WHERE id_account = :id_account AND id = :id');
- $req1->execute(array(
- 'cm' => $cm,
- 'born' => $current_time,
- 'id_account' => $_SESSION['id'],
- 'id' => $result['id']
- ));
- }
- else
- {
- }
- }
- $req->closeCursor();
- ?>
Add Comment
Please, Sign In to add comment