【php开源代码栏目提醒】:文章导读:在新的一年中,各位网友都进入紧张的学习或是工作阶段。网学会员整理了php开源代码-publish.php的相关内容供大家参考,祝大家在新的一年里工作和学习顺利!
<?php
include_once('include_fns.php');
if (!check_auth_user())
{
login_form();
}
else
{
$handle = db_connect();
$writer = get_writer_record($_SESSION['auth_user']);
echo '<p>Welcome, '.$writer['full_name'];
echo ' (<a href="logout.php">Logout</a>) (<a href="index.php">Menu</a>) (<a href="../">Public Site</a>) </p>';
$query = "select * from stories s, writer_per
missions wp
where wp.writer = '{$_SESSION['auth_user']}' and
s.page = wp.page
order by modified desc";
$result = $handle->query($query);
echo '<h1>Editor admin</h1>';
echo '<table>';
echo '<tr><th>Headline</th><th>Last modified</th></tr>';
while ($story = $result->fetch_assoc())
{
echo '<tr><td>';
echo $story['headline'];
echo '</td><td>';
echo date('M d, H:i', $story['modified']);
echo '</td><td>';
if ($story[published])
{
echo '[<a href="unpublish_story.php?story='.$story['id'].'">unpublish</a>] ';
}
else
{
echo '[<a href="publish_story.php?story='.$story['id'].'">publish</a>] ';
echo '[<a href="delete_story.php?story='.$story['id'].'">delete</a>] ';
}
echo '[<a href="story.php?story='.$story['id'].'">edit</a>] ';
echo '</td></tr>';
}
echo '</table>';
}
?>