|
connect_error!=0)
{
echo "Error: ".$connection->connect_errno;
}
else
{
if((isset($_SESSION['admin_logged']))&&($_SESSION['admin_logged'] == true)&&($_SESSION['admin_upr1'] == 1))
{
echo ' ';
if($result_post = @$connection->query(sprintf("SELECT * FROM posts ORDER BY post_date DESC")))
{
$howmany_posts = $result_post->num_rows;
if($howmany_posts>0)
{
while($row = $result_post->fetch_assoc())
{
echo '';
if($row['post_pub']=='tak') echo 'ukryj post | ';
else echo ' opublikuj | ';
echo 'edytuj | usuń
';
if($row['post_img']!=''){
echo '';
echo ' ';
echo ' ';
echo ' ';
echo ' ';
}
echo ''.$row['post_title'].' ';
echo ''.$row['post_text'].'
';
echo ''.$row['post_date'].' ';
}
$result_post->free_result();
}
}
}
else
{
if($result_post = @$connection->query(sprintf("SELECT * FROM posts WHERE post_pub='tak' ORDER BY post_date DESC")))
{
$howmany_posts = $result_post->num_rows;
if($howmany_posts>0)
{
while($row = $result_post->fetch_assoc())
{
if($row['post_img']!='')
{
echo '';
echo ' ';
echo ' ';
echo ' ';
echo ' ';
}
echo ''.$row['post_title'].' ';
echo ''.$row['post_text'].'
';
echo ''.$row['post_date'].' ';
}
$result_post->free_result();
}
}
}
}
$connection->close();
}
catch(Exception $e)
{
echo 'Błąd serwera. Przepraszamy za niedogodności.';
//echo ' Informacje developerska: '.$e;
}
?>
|
|