Build a CMS in an Afternoon with PHP and MySQL

<?php
ini_set( "display_errors", true );
date_default_timezone_set( "America/Indiana/Indianapolis" );  // http://www.php.net/manual/en/timezones.php
define( "DB_DSN", "mysql:host=localhost;dbname=cms" );
define( "DB_USERNAME", "...." );
define( "DB_PASSWORD", "....." );
define( "CLASS_PATH", "classes" );
define( "TEMPLATE_PATH", "templates" );
define( "HOMEPAGE_NUM_ARTICLES", 5 );
define( "ADMIN_USERNAME", "admin" );
define( "ADMIN_PASSWORD", "pass" );
require( CLASS_PATH . "/Article.php" );
?>

<?php

/**
 * Class to handle articles
 */

class Article
{
  // Properties

  /**
  * @var int The article ID from the database
  */
  public $id = null;

  /**
  * @var int When the article is to be / was first published
  */
  public $publicationDate = null;

  /**
  * @var string Full title of the article
  */
  public $title = null;

  /**
  * @var string A short summary of the article
  */
  public $summary = null;

  /**
  * @var string The HTML content of the article
  */
  public $content = null;


  /**
  * Sets the object's properties using the values in the supplied array
  *
  * @param assoc The property values
  */

  public function __construct( $data=array() ) {
    if ( isset( $data['id'] ) ) $this->id = (int) $data['id'];
    if ( isset( $data['publicationDate'] ) ) $this->publicationDate = (int) $data['publicationDate'];
    if ( isset( $data['title'] ) ) $this->title = preg_replace ( "/[^\.\,\-\_\'\"\@\?\!\:\$ a-zA-Z0-9()]/", "", $data['title'] );
    if ( isset( $data['summary'] ) ) $this->summary = preg_replace ( "/[^\.\,\-\_\'\"\@\?\!\:\$ a-zA-Z0-9()]/", "", $data['summary'] );
    if ( isset( $data['content'] ) ) $this->content = $data['content'];
  }


  /**
  * Sets the object's properties using the edit form post values in the supplied array
  *
  * @param assoc The form post values
  */

  public function storeFormValues ( $params ) {

    // Store all the parameters
    $this->__construct( $params );

    // Parse and store the publication date
    if ( isset($params['publicationDate']) ) {
      $publicationDate = explode ( '-', $params['publicationDate'] );

      if ( count($publicationDate) == 3 ) {
        list ( $y, $m, $d ) = $publicationDate;
        $this->publicationDate = mktime ( 0, 0, 0, $m, $d, $y );
      }
    }
  }


  /**
  * Returns an Article object matching the given article ID
  *
  * @param int The article ID
  * @return Article|false The article object, or false if the record was not found or there was a problem
  */

  public static function getById( $id ) {
    $conn = new PDO( DB_DSN, DB_USERNAME, DB_PASSWORD );
    $sql = "SELECT *, UNIX_TIMESTAMP(publicationDate) AS publicationDate FROM articles WHERE id = :id";
    $st = $conn->prepare( $sql );
    $st->bindValue( ":id", $id, PDO::PARAM_INT );
    $st->execute();
    $row = $st->fetch();
    $conn = null;
    if ( $row ) return new Article( $row );
  }


  /**
  * Returns all (or a range of) Article objects in the DB
  *
  * @param int Optional The number of rows to return (default=all)
  * @param string Optional column by which to order the articles (default="publicationDate DESC")
  * @return Array|false A two-element array : results => array, a list of Article objects; totalRows => Total number of articles
  */

  public static function getList( $numRows=1000000, $order="publicationDate DESC" ) {
    $conn = new PDO( DB_DSN, DB_USERNAME, DB_PASSWORD );
    $sql = "SELECT SQL_CALC_FOUND_ROWS *, UNIX_TIMESTAMP(publicationDate) AS publicationDate FROM articles
            ORDER BY " . mysql_escape_string($order) . " LIMIT :numRows";

    $st = $conn->prepare( $sql );
    $st->bindValue( ":numRows", $numRows, PDO::PARAM_INT );
    $st->execute();
    $list = array();

    while ( $row = $st->fetch() ) {
      $article = new Article( $row );
      $list[] = $article;
    }

    // Now get the total number of articles that matched the criteria
    $sql = "SELECT FOUND_ROWS() AS totalRows";
    $totalRows = $conn->query( $sql )->fetch();
    $conn = null;
    return ( array ( "results" => $list, "totalRows" => $totalRows[0] ) );
  }


  /**
  * Inserts the current Article object into the database, and sets its ID property.
  */

  public function insert() {

    // Does the Article object already have an ID?
    if ( !is_null( $this->id ) ) trigger_error ( "Article::insert(): Attempt to insert an Article object that already has its ID property set (to $this->id).", E_USER_ERROR );

    // Insert the Article
    $conn = new PDO( DB_DSN, DB_USERNAME, DB_PASSWORD );
    $sql = "INSERT INTO articles ( publicationDate, title, summary, content ) VALUES ( FROM_UNIXTIME(:publicationDate), :title, :summary, :content )";
    $st = $conn->prepare ( $sql );
    $st->bindValue( ":publicationDate", $this->publicationDate, PDO::PARAM_INT );
    $st->bindValue( ":title", $this->title, PDO::PARAM_STR );
    $st->bindValue( ":summary", $this->summary, PDO::PARAM_STR );
    $st->bindValue( ":content", $this->content, PDO::PARAM_STR );
    $st->execute();
    $this->id = $conn->lastInsertId();
    $conn = null;
  }


  /**
  * Updates the current Article object in the database.
  */

  public function update() {

    // Does the Article object have an ID?
    if ( is_null( $this->id ) ) trigger_error ( "Article::update(): Attempt to update an Article object that does not have its ID property set.", E_USER_ERROR );
   
    // Update the Article
    $conn = new PDO( DB_DSN, DB_USERNAME, DB_PASSWORD );
    $sql = "UPDATE articles SET publicationDate=FROM_UNIXTIME(:publicationDate), title=:title, summary=:summary, content=:content WHERE id = :id";
    $st = $conn->prepare ( $sql );
    $st->bindValue( ":publicationDate", $this->publicationDate, PDO::PARAM_INT );
    $st->bindValue( ":title", $this->title, PDO::PARAM_STR );
    $st->bindValue( ":summary", $this->summary, PDO::PARAM_STR );
    $st->bindValue( ":content", $this->content, PDO::PARAM_STR );
    $st->bindValue( ":id", $this->id, PDO::PARAM_INT );
    $st->execute();
    $conn = null;
  }


  /**
  * Deletes the current Article object from the database.
  */

  public function delete() {

    // Does the Article object have an ID?
    if ( is_null( $this->id ) ) trigger_error ( "Article::delete(): Attempt to delete an Article object that does not have its ID property set.", E_USER_ERROR );

    // Delete the Article
    $conn = new PDO( DB_DSN, DB_USERNAME, DB_PASSWORD );
    $st = $conn->prepare ( "DELETE FROM articles WHERE id = :id LIMIT 1" );
    $st->bindValue( ":id", $this->id, PDO::PARAM_INT );
    $st->execute();
    $conn = null;
  }

}

?>

None there either. 190 lines of code

ini_set( "display_errors", true );

<?php echo session_save_path(); ?>

if ( $_GET['action'] != "login" && $_GET['action'] != "logout" && !$_SESSION['username'] ) {
  login();
  exit;
}

error_reporting(E_ALL ^ E_NOTICE);

38.   function vozaci() {
39.   $results = array();
40.   $data = Vozac::getList( VOZACI_NUM_VOZACI );
41.   $results['vozaci'] = $data['results'];
42.   $results['totalRows'] = $data['totalRows'];
43.   $results['pageTitle'] = "Vozači";
44.    require( TEMPLATE_PATH . "/vozaci.php" );
     }

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

if ( isset( $_FILES['image']['tmp_name'])) $this->image = $data['image'];

$st->bindValue( ":image", $this->image);

<img src="<?php $article->image )?>" alt="article image">

<img src="/images/<?php $article->image )?>" alt="article image">

$target_path = "images/";
$target_path = $target_path . basename( $_FILES['image']['name']); 
move_uploaded_file($_FILES['image']['tmp_name'], $target_path)

if ( isset($_FILES['image']) ) { ... }

content         mediumtext NOT NULL

content         mediumtext NOT NULL,

Fatal error: Uncaught exception 'PDOException' with message 'could not find driver' in C:\Program Files\EasyPHP5.3.0\www\cms-in-an-afternoon-php-mysql\classes\Article.php:103 Stack trace: #0 C:\Program Files\EasyPHP5.3.0\www\cms-in-an-afternoon-php-mysql\classes\Article.php(103): PDO->__construct('mysql:host=loca...', 'root', '') #1 C:\Program Files\EasyPHP5.3.0\www\cms-in-an-afternoon-php-mysql\index.php(40): Article::getList(5) #2 C:\Program Files\EasyPHP5.3.0\www\cms-in-an-afternoon-php-mysql\index.php(14): homepage() #3 {main} thrown in C:\Program Files\EasyPHP5.3.0\www\cms-in-an-afternoon-php-mysql\classes\Article.php on line 103

public $slika = null;

if ( isset( $data['slika'] ) ) $this->slika = $data['slika'];

  /**
  * Inserts the current Article object into the database, and sets its ID property.
  */

  public function insert() {

    // Does the Article object already have an ID?
    if ( !is_null( $this->id ) ) trigger_error ( "Article::insert(): Attempt to insert an Article object that already has its ID property set (to $this->id).", E_USER_ERROR );

    // Insert the Article
    $conn = new PDO( DB_DSN, DB_USERNAME, DB_PASSWORD );
	$slikica = $_SESSION['s'];
    $sql = "INSERT INTO articles ( publicationDate, title, summary, content, slika ) VALUES ( FROM_UNIXTIME('$this->publicationDate'), '$this->title', '$this->summary', '$this->content', '$slikica' )";
    $st = $conn->prepare ( $sql );
   
    $st->execute();
    $this->id = $conn->lastInsertId();
    $conn = null;
  }


  /**
  * Updates the current Article object in the database.
  */

  public function update() {

    // Does the Article object have an ID?
    if ( is_null( $this->id ) ) trigger_error ( "Article::update(): Attempt to update an Article object that does not have its ID property set.", E_USER_ERROR );
   
    // Update the Article
    $conn = new PDO( DB_DSN, DB_USERNAME, DB_PASSWORD );
	$slikica = $_SESSION['s'];
    $sql = "UPDATE articles SET publicationDate=FROM_UNIXTIME('$this->publicationDate'), title='$this->title', summary='$this->summary', content='$this->content', slika='$slikica' WHERE id = '$this->id'";
    $st = $conn->prepare ( $sql );
		$st->execute();
  
    $conn = null;
  }

function editArticle() {

  $results = array();
  $results['pageTitle'] = "Mijenjaj vijest";
  $results['formAction'] = "editArticle";

  if ( isset( $_POST['saveChanges'] ) ) {

    // User has posted the article edit form: save the new article
    $article = new Article;
    $article->storeFormValues( $_POST );
    
//define a maxim size for the uploaded images
define ("MAX_SIZE","1000"); 
// define the width and height for the thumbnail
// note that theese dimmensions are considered the maximum dimmension and are not fixed, 
// because we have to keep the image ratio intact or it will be deformed
define ("WIDTH","412"); 
define ("HEIGHT","324"); 

// this is the function that will create the thumbnail image from the uploaded image
// the resize will be done considering the width and height defined, but without deforming the image
function make_thumb($img_name,$filename,$new_w,$new_h)
{
//get image extension.
$ext=getExtension($img_name);
//creates the new image using the appropriate function from gd library
if(!strcmp("jpg",$ext) || !strcmp("jpeg",$ext))
$src_img=imagecreatefromjpeg($img_name);

if(!strcmp("png",$ext))
$src_img=imagecreatefrompng($img_name);

//gets the dimmensions of the image
$old_x=imageSX($src_img);
$old_y=imageSY($src_img);

// next we will calculate the new dimmensions for the thumbnail image
// the next steps will be taken: 
// 1. calculate the ratio by dividing the old dimmensions with the new ones
//	 2. if the ratio for the width is higher, the width will remain the one define in WIDTH variable
//	 and the height will be calculated so the image ratio will not change
//	 3. otherwise we will use the height ratio for the image
// as a result, only one of the dimmensions will be from the fixed ones
$ratio1=$old_x/$new_w;
$ratio2=$old_y/$new_h;
if($ratio1<$ratio2)	{
	
$thumb_w=$new_w;
$thumb_h=$old_y/$ratio1;

}
else	{
	
$thumb_h=$new_h;
$thumb_w=$old_x/$ratio2;
}

// we create a new image with the new dimmensions
$dst_img=ImageCreateTrueColor($thumb_w,$thumb_h);

// resize the big image to the new created one
imagecopyresampled($dst_img,$src_img,0,0,0,0,$thumb_w,$thumb_h,$old_x,$old_y); 

// output the created image to the file. Now we will have the thumbnail into the file named by $filename
if(!strcmp("png",$ext))
imagepng($dst_img,$filename); 
else
imagejpeg($dst_img,$filename); 

//destroys source and destination images. 
imagedestroy($dst_img); 
imagedestroy($src_img); 
}

// This function reads the extension of the file. 
// It is used to determine if the file is an image by checking the extension. 
function getExtension($str) {
$i = strrpos($str,".");
if (!$i) { return ""; }
$l = strlen($str) - $i;
$ext = substr($str,$i+1,$l);
return $ext;
}

// This variable is used as a flag. The value is initialized with 0 (meaning no error found) 
//and it will be changed to 1 if an errro occures. If the error occures the file will not be uploaded.
$errors=0;
// checks if the form has been submitted
if(isset($_POST['saveChanges']))
{
//reads the name of the file the user submitted for uploading
$image=$_FILES['image']['name'];
// if it is not empty
if ($image) 
{
// get the original name of the file from the clients machine
$filename = stripslashes($_FILES['image']['name']);

// get the extension of the file in a lower case format
$extension = getExtension($filename);
$extension = strtolower($extension);
// if it is not a known extension, we will suppose it is an error, print an error message 
//and will not upload the file, otherwise we continue
if (($extension != "jpg") && ($extension != "jpeg") && ($extension != "png"))	
{
	print "<script type='text/javascript'> alert('Nepoznata ekstenzija!!');</script>";

$errors=1;
}
else
{
// get the size of the image in bytes
// $_FILES[\'image\'][\'tmp_name\'] is the temporary filename of the file in which the uploaded file was stored on the server
$size=getimagesize($_FILES['image']['tmp_name']);
$sizekb=filesize($_FILES['image']['tmp_name']);

//compare the size with the maxim size we defined and print error if bigger
//if ($sizekb > MAX_SIZE*1024)
//{

//$errors=1;
//}

//we will give an unique name, for example the time in unix time format
$image_name=time().'.'.$extension;
//the new name will be containing the full path where will be stored (images folder)
$newname="images/".$image_name;
$copied = copy($_FILES['image']['tmp_name'], $newname);
//we verify if the image has been uploaded, and print error instead
if (!$copied) 
{

print "<script type='text/javascript'> alert('Kopiranje slike neuspjesno!!');</script>";
$errors=1;
}
else
{
// the new thumbnail image will be placed in images/thumbs/ folder
$thumb_name='images/thumbs/thumb_'.$image_name;
// call the function that will create the thumbnail. The function will get as parameters 
//the image name, the thumbnail name and the width and height desired for the thumbnail
$thumb=make_thumb($newname,$thumb_name,WIDTH,HEIGHT);
}}	}}

//If no errors registred, print the success message and show the thumbnail image created

	

	$postArray = &$_POST ;			// 4.1.0 or later, use $_POST


foreach ( $postArray as $sForm => $value )
{
	if ( get_magic_quotes_gpc() )
		$postedValue = htmlspecialchars( stripslashes( $value ) ) ;
	else
		$postedValue = htmlspecialchars( $value ) ;

}	


	$_SESSION['s']=$image_name;
    $article->insert();
    header( "Location: admin.php?status=changesSaved" );

  } elseif ( isset( $_POST['cancel'] ) ) {

    // User has cancelled their edits: return to the article list
    header( "Location: admin.php" );
  } else {

    // User has not posted the article edit form yet: display the form
    $results['article'] = new Article;
    require( TEMPLATE_PATH . "/admin/editArticle.php" );
  }

}

<Files config.php>
Order Allow,Deny
Deny from all
</Files>

  public function storeFormValues ( $params ) {
 
    if ( get_magic_quotes_gpc() ) $params['content'] = stripslashes( $params['content'] );

    // Store all the parameters
    $this->__construct( $params );

    ...

<?php if (isset($results['articles']))  if(is_array($results['articles'])) 
	  foreach ( $results['articles'] as $article ) { ?>
	  <li><a href=".?action=viewArticle&amp;articleId=<?php echo $article->id?>"><?php echo htmlspecialchars( $article->title )?></a></li>
		<?php } ?>

<a href=".?action=viewArticle...

<a href="index.php?action=viewArticle...

  $data = Article::getList();
  $results['articles'] = $data['results'];

RewriteEngine On
RewriteRule ^articles/([^/]+)/?$ ?action=viewArticle.php?articleId=$1 [L]

RewriteRule ^articles/([^/]+)/?$ /?action=viewArticle&articleId=$1 [L]

  public function storeFormValues ( $params ) {
 
    if ( get_magic_quotes_gpc() ) $params['content'] = stripslashes( $params['content'] );

    // Store all the parameters
    $this->__construct( $params );

" array (PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8 " 

$conn = new PDO( DB_DSN, DB_USERNAME, DB_PASSWORD, array (PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8") );

new PDO('dblib:host=your_hostname;dbname=your_db;charset=UTF-8', $user, $pass);

if ( isset( $data['content'] ) ) $this->content = $data['content'];

if ( isset( $data['content2'] ) ) $this->content2 = $data['content2'];

<li>
<label for="content2">Article Content2</label>
<textarea name="content2" id="content2" placeholder="The HTML content2 of the article" required maxlength="100000" style="height: 30em;"><?php echo htmlspecialchars( $results['article']->content2 )?></textarea>
</li>

         public $id = null;
	/*
	 * @var date , publication date
	 */
	public $publicationDate = null;
	
	/*
	 * @var id , foreignkey. tells which article this comment belongs to
	 */
	public $articleId = null;
	/*
	 * @var email, email
	 */
	public $email = null;
	/*
	 * @var username, username
	 */
	public $userName = null;
	/*
	 * @var content, content of the comment.
	 */
	public $content = null;

class Comment extends Article{}

RewriteEngine On
RewriteRule ^news(/$|$) /?action=archive&category=news [L]
RewriteRule ^gigs(/$|$) /?action=archive&category=gigs [L]

  /**
  * @var string (describe property here)
  */
  public $content2 = null;

    if ( isset( $data['content2'] ) ) $this->content2 = $data['content2'];

    $sql = "INSERT INTO articles ( publicationDate, title, summary, content, content2 ) VALUES ( FROM_UNIXTIME(:publicationDate), :title, :summary, :content, :content2 )";
    $st = $conn->prepare ( $sql );
    $st->bindValue( ":publicationDate", $this->publicationDate, PDO::PARAM_INT );
    $st->bindValue( ":title", $this->title, PDO::PARAM_STR );
    $st->bindValue( ":summary", $this->summary, PDO::PARAM_STR );
    $st->bindValue( ":content", $this->content, PDO::PARAM_STR );
    $st->bindValue( ":content2", $this->content2, PDO::PARAM_STR );

public $id = null;
public $emp_first_name = null;
public $emp_last_name = null;
public $emp_number = null;

public function __construct( $data=array() ) {
if ( isset( $data['id'] ) ) $this->id = (int) $data['id'];
if ( isset( $data['first'] ) ) $this->emp_first_name = $data['first'];
if ( isset( $data['last'] ) ) $this->emp_last_name = $data['last'];
if ( isset( $data['empNumber'] ) ) $this->emp_number = $data['empNumber'];
}

public function storeFormValues ( $params ) {
// Store all the parameters
$this->__construct( $params );
}

public function insert() {

if ( !is_null( $this->id ) ) trigger_error ( "TechCard::insert(): Attempt to insert a Tech Card object that already has its ID property set (to $this->id).", E_USER_ERROR );

$conn = new PDO( DB_DSN, DB_USERNAME, DB_PASSWORD );
$sql = "INSERT INTO serials ( first, last, empNumber ) VALUES (:first, :last, :empNumber )";
$st = $conn->prepare ( $sql );
$st->bindValue( ":first", $this->emp_first_name, PDO::PARAM_STR );
$st->bindValue( ":last", $this->emp_last_name, PDO::PARAM_STR );
$st->bindValue( ":empNumber", $this->emp_number, PDO::PARAM_STR );
$st->execute();
$this->id = $conn->lastInsertId();
$conn = null;
}

<script type="text/javascript" src="js/ckeditor/ckeditor.js"></script>
<script type="text/javascript">
	window.onload = function() 
	{
		CKEDITOR.replace('content');
	};
</script>

<input type="submit" name="saveChanges" value="Save" />

if (isset($_POST['saveItem']))  

<input type="submit" name="saveChanges" value="Save Changes" />

if ( isset( $_POST['saveChanges'] ) ) {
...
}

$sql = "INSERT INTO serials ( first, last, empNumber ) VALUES (:first, :last, :empNumber )";

$sql = "INSERT INTO serials ( emp_first_name, emp_last_name, emp_number ) VALUES (:first, :last, :empNumber )";

<?php foreach ( $results['techCards'] as $techCard ) { ?>

<tr onclick="location='admin.php?action=editTechCard&amp;techCardId=<?php echo $techCard->id?>'">
<td>
<?php echo $techCard->emp_last_name ?>, <?php echo $techCard->emp_first_name ?>
</td>
</tr>

<?php } ?>

foreach ( $results['articles'] as $article )

<img src="\"http://www.musicclub.it/foto/es/big/ESCAPE_THE_FATE.png.big.jpg\"" width="\"250\"/">

ini_set ("magic_quotes_gpc", false); 

// Now get the total number of articles that matched the criteria
$sql = "SELECT FOUND_ROWS() AS totalRows";
$totalRows = $conn->query( $sql )->fetch();
$conn = null;
return ( array ( "results" => $list, "totalRows" => $totalRows[0] ) );
}

$results['totalRows'] = $data['totalRows'];

<img src=http://.... alt=Alternative id=img/>

<img src="http://...." alt="Alternative" id="img"/>

<?php
try {
    $dbh = new PDO('mysql:host=localhost;dbname=test', $user, $pass);
    foreach($dbh->query('SELECT * from FOO') as $row) {
        print_r($row);
    }
    $dbh = null;
} catch (PDOException $e) {
    print "Error!: " . $e->getMessage() . "<br/>";
    die();
}
?>

$myobj=new Article();

public static function getPaginate( $order="publicationDate DESC" ) {
	
	$per_page = 7; //set item per page
	
	$conn = new PDO( DB_DSN, DB_USERNAME, DB_PASSWORD, array (PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8") );
	$sql = 	"SELECT * FROM articles";
	$query = $conn->query( $sql )->fetchAll();
	$Num_Rows = count($query);
	
	if(empty($_GET['page']) ){
	$_GET['p'] = "";
	}
	$p= $_GET['page'];
	if(!$_GET['page']) {
		$page =1;
	}
	$Prev_Page = $page-1;
	$Next_Page = $page+1;

	$Page_Start = (($per_page*$page)-$per_page);
	if($Num_Rows <= $per_page)
	{
		$Num_Pages = 1;
	}
	else if (($Num_Rows % $per_page) == 0)
	{
		$Num_Pages = ($Num_Rows/$per_page);
	}
	else
	{
		$Num_Pages =($Num_Rows/$per_page)+1;
		$Num_Pages = (int)$Num_Pages;
	}
	
	$query = "SELECT SQL_CALC_FOUND_ROWS *, UNIX_TIMESTAMP(publicationDate) AS publicationDate FROM articles 
		ORDER BY " . mysql_escape_string($order) . " LIMIT $Page_Start, $per_page";
	$result = $conn->prepare($query);
	$result->execute();
	$list = array();
	
	while ($row = $result->fetch() ) {
		$article = new Articles( $row );		
		$list[] = $article;	
	}
	
	$conn = null;
	return ( array ( "results" => $list, "Num_Rows" =>$Num_Rows, "Num_Pages" => $Num_Pages, "page" => $page, "Prev_Page" => $Prev_Page, "Next_Page" => $Next_Page ) );
	}

function archive() {
   
   $results = array();
   $data = Articles::getPaginate(); // call paging function instead of getById.
   $results['articles'] = $data['results'];
   $results['Num_Rows'] = $data['Num_Rows'];
   $results['Num_Pages'] = $data['Num_Pages'];
   $results['Prev_Page'] = $data['Prev_Page'];
   $results['Next_Page'] = $data['Next_Page'];
   $results['page'] = $data['page'];
   $results['pageTitle'] = "Article Archive";
   require( TEMPLATE_PATH . "/archive.php" );
}

<div id="paginav">
<?php
$Current_Page = $_SERVER['SCRIPT_NAME'];
$Prev_Page =$results['Prev_Page'];
$Next_Page =$results['Next_Page'];
$Num_Pages =$results['Num_Pages'];
$page =$results['page'];
if($Prev_Page)
{
	echo "<a href = '$Current_Page?action=archive&p=$Prev_Page'><< Previous</a>";
}
for($i=1; $i<=$Num_Pages; $i++){
	if($i !=$page)
	{
		echo "<a href ='$Current_Page?action=archive&page=$i'>$i</a>";
	} else {
		echo "<span>$i</span>";
	}
}
if($p != $Num_Pages)
{
	echo "<a href ='$Current_Page?action=archive&page=$Next_Page'>Next>></a>";
}
?>
</div>