Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- вывод
- <?php
- include 'setting.php';
- $charset = 'SET NAMES utf8';
- mysqli_query($db_server, $charset);
- $select = 'SELECT * FROM `my_news` WHERE `activ`=\'1\';';
- $query = mysqli_query($db_server, $select);
- $row = mysqli_fetch_assoc($query);
- do {
- echo '<h3>'.$row['name'].'</h3>';
- echo '<div ><img class="newsfoto" src="'.$row['img'].'"></div>';
- echo '<div>'.$row['text'].'</div>';
- echo '<strong>Дата публикации:'.$row['date'].'</strong>';
- }while ($row = mysqli_fetch_assoc($query));
- ?>
- плдключение
- <?php
- $db_hostname='mysql.hostinger.ru';
- $db_username= 'u258403992_raisa';
- $db_password ='xfhkbxfgkby';
- $db_database='u258403992_news';
- $db_server = mysqli_connect($db_hostname, $db_username,$db_password);
- if (!$db_server) die("Unable to connect to MYSQL:" . mysqli_error());
- mysqli_select_db($db_server, $db_database)
- or die("Unable to select database:".mysqli_error());
- $charset = 'SET NAMES utf8';
- mysqli_query($db_server, $charset);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement