Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $pdo = new PDO('mysql:host=localhost;dbname=rma', 'root', 'root');
- $pdo -> setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- try {
- $pdo -> query('ALTER TABLE `rma` ADD `timestamp` INT NOT NULL');
- echo PHP_EOL.date('d.m.Y H:i:s').': Dodane pole timestamp';
- } catch(PDOException $e)
- {
- die('Nie mogę edytować bazy. Pole już istnieje? Błąd: '. $e -> getMessage());
- }
- echo PHP_EOL.date('d.m.Y H:i:s').': Pobieranie dat z bazy...'.PHP_EOL.PHP_EOL;
- $q = $pdo -> query('select id,date from rma');
- foreach($q as $now)
- {
- echo date('d.m.Y H:i:s').': > Rekord '.$now['id'].', data: '.$now['date'].PHP_EOL;
- $date = date_create_from_format('d-m-y H:i:s', $now['date']);
- echo date('d.m.Y H:i:s').': >> timestamp z daty: '.$date -> getTimestamp().PHP_EOL;
- echo date('d.m.Y H:i:s').': >> aktualizuję pole timestamp='.$date->getTimestamp().PHP_EOL;
- $pdo -> query('UPDATE rma SET timestamp='.$date->getTimestamp().' WHERE id='.$now['id']);
- }
- echo date('d.m.Y H:i:s').': Zakończono.';
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement