Building the View Details Page in a PEAR CMS
(Page 1 of 4 )
In the last article we looked at how the main script for the CMS system works. In this article we will explore the page that enables us to view an article in full detail. Keep reading to find out how we will make this page work.
This is the purpose of this script. The setup of this script is somewhat similar to the main script, so you won't see too much new code here. Nevertheless, it is worth going through the code that makes up the script.
The view.php script
Below is the entire code for the view script:
<?php
session_start();
if(!isset($_SESSION['author_name'])){
//redirect to login page
header("location:login.php");
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/main.dwt.php" codeOutsideHTMLIsLocked="false" -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<!-- InstanceBeginEditable name="doctitle" -->
<title>Untitled Document</title>
<!-- InstanceEndEditable -->
<!-- InstanceBeginEditable name="head" -->
<!-- InstanceEndEditable -->
<link href="Templates/pear.css" rel="stylesheet" type="text/css" />
</head>
<body>
<table width="100%" border="0" class="bord">
<tr class="header1">
<td colspan="2"><div align="center">Content Management System </div></td>
</tr>
<tr>
<td width="5%" valign="top"><!-- InstanceBeginEditable name="EditRegion4" -->
<table width="100%" border="0" cellspacing="0" class="navbord">
<tr>
<td colspan="2" bgcolor="#FFFFFF"> </td>
</tr>
<tr>
<td colspan="2" bgcolor="#0066FF" class="section"><strong>Section</strong></td>
</tr>
<tr class="navbord">
<td class="nav"><a href="logout.php">Logout</a> </td>
<td><img src="images/user.gif" width="16" height="16" alt="" /></td>
</tr>
<tr class="navbord">
<td colspan="2" class="nav"><a href="main.php">Home</a></td>
</tr>
<tr class="navbord">
<td colspan="2" class="nav"><a href="authors.php">Authors</a></td>
</tr>
<?php if($_SESSION['level']=="admin"){?>
<tr class="navbord">
<td colspan="2" class="nav"><a href="admin/index.php">Admin</a></td>
</tr>
<?php }?>
</table>
<!-- InstanceEndEditable --></td>
<td width="95%" valign="top"><!-- InstanceBeginEditable name="EditRegion3" -->
<table width="100%" border="1">
<tr>
<td colspan="2" class="title"> </td>
</tr>
<?php
include 'db.php';
include 'connx.php';
if(isset($_GET['aid'])){
if(is_numeric($_GET['aid'])){
$aid=mysql_real_escape_string($_GET['aid']);
$sql = "SELECT * FROM stories WHERE aid='".$aid."'";
}else{
echo "Error invalid format";
}
}
if(isset($_GET['sid'])){
if(is_numeric($_GET['sid'])){
$sid=mysql_real_escape_string($_GET['sid']);
$sql = "SELECT * FROM stories WHERE sid='".$sid."'";
}else{
echo "Invalid Format";
}
}
$res = $db->query($sql);
if($res){
while ($row = $res->fetchRow(DB_FETCHMODE_OBJECT)) {
?>
<tr class="title">
<td colspan="2" class="title"><?php print $row->title ?></a></td>
</tr>
<tr>
<td width="18%"> </td>
<td width="82%" class="auth"> published on: <?php print $row->s_date ?></td>
</tr>
<tr>
<td colspan="2" class="maintxt"><p><?php print $row->story ?></p></td>
</tr>
<?php }
}else{
?>
<tr>
<td colspan="2" class="maintxt"><p>No article found</p></td>
</tr>
<?php } ?>
</table>
<!-- InstanceEndEditable --></td>
</tr>
<tr class="copy">
<td colspan="2">©2008</td>
</tr>
</table>
</body>
<!-- InstanceEnd --></html>
Next: Code Explained >>
More PEAR Articles Articles
More By David Web
