momca96

Untitled

Feb 11th, 2014
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.04 KB | None | 0 0
  1. <?php
  2. // umesto log verovatno ide npr logpwc(kada korisnik promeni pw)
  3. $lang['logpwc'] = 'Password je promenjen!';
  4. $lang['logemc'] = 'Email je promenjen!';
  5.  
  6. $mysqli = new mysqli('localhost', 'root', 'password', 'lang');
  7. if($mysqli -> connect_errno)
  8. {
  9.     echo 'MySQL Greska';
  10.     exit();
  11. }
  12.  
  13. $query = $mysqli->query("SELECT * FROM logs ORDER BY id DESC");
  14. while($row = $query->fetch_array(MYSQLI_BOTH))
  15. {
  16.     echo 'id '.$row['id'].'<br>
  17.     user_id '.$row['user_id'].'<br>
  18.     opis '.$lang[$row['opis']].'<br>
  19.     time '.date("d.m.Y H:i", $row['time']/1000).'<br>';
  20. }
  21. /* Tabela:
  22. CREATE TABLE IF NOT EXISTS `logs` (
  23.   `id` int(10) unsigned NOT NULL auto_increment,
  24.   `user_id` int(10) NOT NULL,
  25.   `opis` text NOT NULL,
  26.   `time` bigint(30) NOT NULL,
  27.   PRIMARY KEY  (`id`)
  28. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
  29.  
  30. Unosenje podataka:
  31. INSERT INTO `logs` (`id`, `user_id`, `opis`, `time`) VALUES (NULL, '21', 'logpwc', '1392126726574');
  32. INSERT INTO `logs` (`id`, `user_id`, `opis`, `time`) VALUES (NULL, '33', 'logemc', '1392126726574');
  33. */
  34. ?>
Advertisement
Add Comment
Please, Sign In to add comment