[WP] Prikaz thumbnail fotke

1 naročnik

2350260925541

26. apr 2015 ob 23:33

Zdravo

Pripravil sem stran, ki prikazuje določene poste, nikakor pa ne pogruntam, kako prikazati thumbnail image od določenega posta. Ostalo vse lepo pokaže

File se nahaja izven Wordpressa.

hvala za morebitne ideje ali pomoč

sedanja koda

<html>
<head>
<link rel="stylesheet" type="text/css" href="style.css"> <title>TITLE</title>
<meta charset="UTF-8">
</head>
<body>
<p><img src = "xxxxx.png" align = "middle"></p><body>
<?php
$dbhost = 'xxxxxx';
$dbuser = 'xxxxxx';
$dbpass = 'xxxxxx';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
  die('Could not connect: ' . mysql_error());
}
mysql_select_db('ime_baze');
$sql = "SELECT DISTINCT post_id, post_author, post_date_gmt, guid, post_title, post_content, meta_value, meta_id
FROM `wp_posts` inner join `wp_postmeta`
ON wp_posts.ID = wp_postmeta.post_id
WHERE post_status = 'publish' AND (meta_key = 'st_date')
"
;

$sql2 = "SELECT DISTINCT post_id, post_author, post_date_gmt, guid, post_title, post_content, meta_value, meta_id
FROM `wp_posts` inner join `wp_postmeta`
ON wp_posts.ID = wp_postmeta.post_id
WHERE post_status = 'publish' AND (meta_key = 'end_date')
"
;

$sql3 = "SELECT DISTINCT post_id, post_author, post_date_gmt, guid, post_title, post_content, meta_value, meta_id
FROM `wp_posts` inner join `wp_postmeta`
ON wp_posts.ID = wp_postmeta.post_id
WHERE post_status = 'publish' AND (meta_key = 'prizorisce')
";

$sql4 = "SELECT DISTINCT post_id, post_author, post_date_gmt, guid, post_title, post_content, meta_value, meta_id
FROM `wp_posts` inner join `wp_postmeta`
ON wp_posts.ID = wp_postmeta.post_id
WHERE post_status = 'publish' AND (meta_key = '_wp_attached_file')
Order by 'post.id'";
;

$retval = mysql_query($sql, $conn);
$retval2 = mysql_query($sql2, $conn);
$retval3 = mysql_query($sql3, $conn);
date_default_timezone_set('Slovenia/Celje');?>
<h1 class="dan">Danes dogaja: </h1>
<?php
if(! $retval)
 {
  die('Could not get data: ' . mysql_error());
}
$danes = date('d-m-Y');
while($row = mysql_fetch_array($retval, MYSQL_ASSOC))
{
 $id=$row['post_id'];
 $row2 = mysql_fetch_array($retval2, MYSQL_ASSOC);
 $row3 = mysql_fetch_array($retval3, MYSQL_ASSOC);
 $zacetek = date("d.m.Y", strtotime($row['meta_value']));
 $konec = date("d.m.Y", strtotime($row2['meta_value']));
 $dc = date("d.m.Y", strtotime($danes));
 $slika = $row4['meta_value'];
    if(($zacetek <= $dc && $konec >= $dc))
        if($row['post_id']==$row2['post_id'])
    {

    echo    
   "<a href=".$row['guid']. "> <hr/><h1 class ='naslov'>{$row['post_title']}</h1></a> <br> ";
   if(($row['post_id'] == $row2['post_id']) && $row2['post_id'] ==  $row3['post_id']){echo "<span class='lokacija'>{$row3['meta_value']}</span><br>";}
   echo "Začetek: <span class='zacetek'>$zacetek</span> ".
   "<span class='konec'><span class='crna'>Konec:</span> $konec</span>  <br> ".
   "<p class='vsebina'> {$row['post_content']}  <br> </p>".
  /*"<img src='getimage.php?id=$id></img>".*/
   "<a href=".$row['guid']. ">Več informacij</a>";
    }

}
mysql_close($conn);
?>
</body>
</html>

566

spletne strani php

[WP] Prikaz thumbnail fotke 1 naročnik

[WP] Prikaz thumbnail fotke

1 naročnik