Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- // umesto log verovatno ide npr logpwc(kada korisnik promeni pw)
- $lang['logpwc'] = 'Password je promenjen!';
- $lang['logemc'] = 'Email je promenjen!';
- $mysqli = new mysqli('localhost', 'root', 'password', 'lang');
- if($mysqli -> connect_errno)
- {
- echo 'MySQL Greska';
- exit();
- }
- $query = $mysqli->query("SELECT * FROM logs ORDER BY id DESC");
- while($row = $query->fetch_array(MYSQLI_BOTH))
- {
- echo 'id '.$row['id'].'<br>
- user_id '.$row['user_id'].'<br>
- opis '.$lang[$row['opis']].'<br>
- time '.date("d.m.Y H:i", $row['time']/1000).'<br>';
- }
- /* Tabela:
- CREATE TABLE IF NOT EXISTS `logs` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `user_id` int(10) NOT NULL,
- `opis` text NOT NULL,
- `time` bigint(30) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
- Unosenje podataka:
- INSERT INTO `logs` (`id`, `user_id`, `opis`, `time`) VALUES (NULL, '21', 'logpwc', '1392126726574');
- INSERT INTO `logs` (`id`, `user_id`, `opis`, `time`) VALUES (NULL, '33', 'logemc', '1392126726574');
- */
- ?>
Advertisement
Add Comment
Please, Sign In to add comment