PHP Classes
elePHPant
Icontem

Link Library: Manage collections of URLs stored in a database

Recommend this page to a friend!
  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 (10 years ago) RSS 2.0 feedNot enough user ratingsTotal: 884 All time: 3,821 This week: 1,016Up
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 <contact>
Classes: 8 packages by
Country: United Kingdom United Kingdom
Innovation award
Innovation award
Nominee: 2x

Winner: 1x

Details
Links admin readme
------------------

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

Installation:

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,
  PRIMARY KEY  (id)
);

CREATE TABLE links (
  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',
  PRIMARY KEY  (id)
);
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.
Screenshots  
  • 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

 Version Control Unique User Downloads Download Rankings  
 0%
Total:884
This week:0
All time:3,821
This week:1,016Up