Advertisement
Guest User

Untitled

a guest
May 31st, 2016
158
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.98 KB | None | 0 0
  1. вывод
  2. <?php
  3.  
  4. include 'setting.php';
  5. $charset = 'SET NAMES utf8';
  6. mysqli_query($db_server, $charset);
  7. $select = 'SELECT * FROM `my_news` WHERE `activ`=\'1\';';
  8. $query = mysqli_query($db_server, $select);
  9. $row = mysqli_fetch_assoc($query);
  10. do {
  11. echo '<h3>'.$row['name'].'</h3>';
  12. echo '<div ><img class="newsfoto" src="'.$row['img'].'"></div>';
  13. echo '<div>'.$row['text'].'</div>';
  14.  
  15. echo '<strong>Дата публикации:'.$row['date'].'</strong>';
  16.  
  17. }while ($row = mysqli_fetch_assoc($query));
  18. ?>
  19. плдключение
  20. <?php
  21. $db_hostname='mysql.hostinger.ru';
  22. $db_username= 'u258403992_raisa';
  23. $db_password ='xfhkbxfgkby';
  24. $db_database='u258403992_news';
  25.  
  26. $db_server = mysqli_connect($db_hostname, $db_username,$db_password);
  27. if (!$db_server) die("Unable to connect to MYSQL:" . mysqli_error());
  28. mysqli_select_db($db_server, $db_database)
  29. or die("Unable to select database:".mysqli_error());
  30. $charset = 'SET NAMES utf8';
  31. mysqli_query($db_server, $charset);
  32. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement