ASP

Building a Multi-Page Article System With ASP/PHP

Interested in building your own CMS? In this article Mitchell shows us how to build a multi-page article system that can be used in any web-based CMS...

Author Info:

By: Mitchell Harper

Poor Best

Rating:

/ 15

January 05, 2003

TABLE OF CONTENTS:

Building a Multi-Page Article System With ASP/PHP - Displaying a List of Articles
(Page 5 of 6 )

It's very easy to display a list of articles from the articles table in our database. We simply loop through the articles table and output the title and summary for each article. We also setup a link to read the entire article, which we will look at shortly. Shown below is the code for both ASP and PHP:

ASP Code


<%

objRS.Open "select * from articles order by articleId asc"

while not objRS.EOF
%>
<%=objRS("title")%> 

<%=objRS("summary")%> 
<a href="fullarticle.asp?articleId=<%=objRS("articleId")%>">Read More...</a>

<hr> 
<%
objRS.MoveNext
wend

%>

PHP Code

include("db.php");

$result = mysql_query("select * from articles order by articleId asc");

while($row = mysql_fetch_array($result))
{
?>
<?php echo $row["title"]; ?> 

<?php echo $row["summary"]; ?> 
<a href="fullarticle.asp?articleId=<?php echo $row["articleId"]; ?>">Read More...</a>

<hr> 
<?php
}

Here's the output from the code above:

The output from the showarticles.php page

The output from the showarticles.php page

Displaying an Individual Article
To display an individual article, we simply list the pages in that article as links and start by displaying the title and content of the first page:

ASP Code


<%

articleId = Request.QueryString("articleId")
pageId = Request.QueryString("pageId")

if not isNumeric(articleId) then
Response.Write "Invalid article Id"
Response.End
end if

if pageId = "" then
objRS.Open("select top 1 pageId from pages where articleId=" & articleId)
pageId = objRS("pageId")
end if

if objRS.State = 1 then objRS.Close
objRS.Open("select * from articles inner join pages on articles.articleId = pages.articleId where articles.articleId = " & articleId & " and pages.pageId = " & pageId)

if objRS.EOF then
Response.Write "Article not found"
Response.End
end if

%>
<html>
<head>
<title>Multi-Page Article System</title>
</head>

<body bgcolor="#ffffff">
<%=objRS.Fields(1)%> 
<%=objRS.Fields(6)%> 
<%=objRS.Fields(7)%> 

Article Pages:
<%

'Display the pages in this article
if objRS.State = 1 then objRS.Close
objRS.Open("select * from pages where articleId = " & articleId)

while not objRS.EOF
if CStr(objRS("pageId")) = CStr(pageId) then
Response.Write "<li>" & objRS("title") & "</li>"
else
Response.Write "<li><a href='fullarticle.asp?articleId=" & articleId & "&pageId=" & objRS("pageId") & "'>" & objRS("title") & "</a></li>"
end if

objRS.MoveNext
wend

%>

</body>
</html>

PHP Code

<?php

include("db.php");

$articleId = @$_GET["articleId"];
$pageId = @$_GET["pageId"];

if(!is_numeric($articleId))
{
die("Invalid article Id");
}

if($pageId == "")
{
$result = mysql_query("select pageId from pages where articleId=" . $articleId . " limit 1");
$row = mysql_fetch_array($result);
$pageId = $row["pageId"];
}

$result = mysql_query("select * from articles inner join pages on articles.articleId = pages.articleId where articles.articleId = " . $articleId . " and pages.pageId = " . $pageId);

if(mysql_num_rows($result) == 0)
{
die("Article not found");
}

$row = mysql_fetch_array($result);

?>
<html>
<head>
<title>Multi-Page Article System</title>
</head>

<body bgcolor="#ffffff">
<?php echo $row[1];?> 
<?php echo $row[6];?> 
<?php echo $row[7];?> 

Article Pages:
<?php

//Display the pages in this article
$result = mysql_query("select * from pages where articleId = " . $articleId);

while($row = mysql_fetch_array($result))
{
if($pageId == $row["pageId"])
echo "<li>" . $row["title"] . "</li>";
else
echo "<li><a href='fullarticle.php?articleId=" . $articleId . "&pageId=" . $row["pageId"] . "'>" . $row["title"] . "</a></li>";
}

?>

</body>
</html>

And the result? Well, take a look:

The fullarticle.php page