forked from lwtsn/bitcoin-directory
-
Notifications
You must be signed in to change notification settings - Fork 0
/
listing.php
57 lines (51 loc) · 1.15 KB
/
listing.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
<?php
require ('lib/common.php');
require('inc/blocks/header.php');
require('inc/blocks/menu.php');
?>
<div class='cointainer'>
<?
require('inc/blocks/sidebar.php');
$sql = ("SELECT * FROM listing WHERE id_site = ? AND bool_approved = 1 LIMIT 1");
$stm = $conn->prepare($sql);
$stm->execute(array($_GET['id']));
$listing = $stm->fetchAll();
foreach($listing as $listing_row)
{
$site_name = $listing_row['nm_site_name'];
$tx_site_description = $listing_row['tx_site_description'];
$tx_site_image = $listing_row['tx_site_image'];
$url_site_address = $listing_row['url_site_address'];
}
?>
<div class='col-lg-8 well pull-right'>
<div class='row'>
<center>
<div class='col-8'>
<a target='_blank' href='<?=$url_site_address ?>'>
<h4>
<strong>
<?= $site_name ?>
</strong>
</h4>
</a>
<div class='row'>
<div class='col-12'>
<img class='img-responsive' src='<?= $tx_site_image ?>'>
</div>
<div class='col-9'>
<p>
<?= $tx_site_description ?>
</p>
</div>
</div>
</div>
</center>
</div>
</div>
</div>
<?php
require('inc/blocks/footer.php');
?>
</div>
</body>