PHP Classes

Link Library: Manage collections of URLs stored in a database

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in Bookmark in
  Info   Screenshots Screenshots   View files View files (23)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2005-12-08 (9 years ago) RSS 2.0 feedNot enough user ratingsTotal: 875 All time: 3,779 This week: 1,063Up
Version License Categories  
links 1.0GNU Lesser Genera...Databases, Content management
Description Author  

This package provides an administration interface to manage a collection of link URLs stored in a database.

It can be used to add links specifying the URL, description, keywords, rating and channels to include the links in different categories.

It can also display lists of links restricted by category channel or keyword.

Picture of Mick Sear
Name: Mick Sear is available for providing paid consulting. Contact Mick Sear .
Classes: 8 packages by
Country: United Kingdom United Kingdom
Age: 42
All time rank: 362 in United Kingdom United Kingdom
Week rank: 86 Down3 in United Kingdom United Kingdom Down
Innovation award
Innovation award
Nominee: 2x

Winner: 1x

Links admin readme

A class by Mick Sear, eCreate, utilising my own simple templating
class and db connection class as well.


1) Copy files to a folder within your web root.
2) Create a database (if required)
3) Edit config.php to add in database connection details
4) Import the following SQL to create the necessary tables:

CREATE TABLE channels (
  id int(5) NOT NULL auto_increment,
  name varchar(50) NOT NULL default '',
  description text,

  id int(10) NOT NULL auto_increment,
  url varchar(254) default NULL,
  description varchar(254) default NULL,
  rating int(1) default NULL,
  channel varchar(50) default NULL,
  keywords text,
  published int(1) NOT NULL default '1',
insert into channels(id, name, description) values('', 'general', 'General Links');

5) Change the authentication mechanism if necessary, and templating if necessary.  This way, this system can
easily be integrated into your own system.  Basic form authentication is included.

6) Point your browser at http://yourdomain/somefolder/login.php

7) Log in with username 'admin', password 'password', create a few channels, and add links!

8) Use the snippets getLinksByKeyword.php and getLinksByChannel.php as a basis for your front-end code.
  • Screengrab2_snippet.jpg
  • Screengrab1_admin.jpg
  Files folder image Files  
File Role Description
Files folder imageclasses (4 files)
Files folder imageimages (9 files)
Files folder imagetemplates (2 files)
Plain text file config.php Conf. DB Config
Plain text file getLinksByChannel.php Example Display links based on channel name
Plain text file getLinksByKeyword.php Example Display links based on keyword metadata
Plain text file login.php Appl. Admin page
Plain text file manage_channels.php Appl. Admin page
Plain text file manage_links.php Appl. Admin page
Plain text file readme.htm Doc. READ ME - instructions
Plain text file style.css Data Stylesheet for admin

  Files folder image Files  /  classes  
File Role Description
  Plain text file Channels.php Class Channel class
  Plain text file Database.php Class DB class
  Plain text file Links.php Class Links class
  Plain text file Templater.php Class Templater class

  Files folder image Files  /  images  
File Role Description
  Image file 0_stars.gif Icon Image used on front-end
  Image file 1_stars.gif Icon Image used on front-end
  Image file 2_stars.gif Icon Image used on front-end
  Image file 3_stars.gif Icon Image used on front-end
  Image file 4_stars.gif Icon Image used on front-end
  Image file 5_stars.gif Icon Image used on front-end
  Image file amber.gif Icon Image used in admin interface
  Image file green.gif Icon Image used in admin interface
  Image file red.gif Icon Image used in admin interface

  Files folder image Files  /  templates  
File Role Description
  Plain text file admin.htm Data General template
  Plain text file login.htm Data Login page template

 Version Control Unique User Downloads Download Rankings  
 0%Total:875All time:3,779
 This week:0This week:1,063Up