Tiny PHP Address Book: Manage address book stored in a database with PDO

Recommend this page to a friend!

Download .zip

Info

Example

View files (35)

Download .zip

Reputation

Support forum

Blog

Links

Ratings				Unique User Downloads		Download Rankings
Not enough user ratings				Total: 242		All time: 8,001 This week: 83

Version		License		PHP version		Categories
`tiny-address-book` 1.0.0		BSD License		5.4		PHP 5, Databases, AJAX

Description

Author

Vallo Reima

This package can manage address book stored in a database with PDO.

It can store in a database contact information records with first and last name, street, post code and city.

The package provides a AJAX based user interface to display and edit the contacts in an address book database table.

Innovation Award

March 2017
Number 10

Address books are useful to keep track of user contacts in a database.

This package provides an AJAX based user interface to manage the information of an address book.

Manuel Lemos

Vallo Reima

Performance

Level

Level 4

Innovation award

Nominee: 3x

Example


<?php





/**


 * the entry


 *


 * @package     System


 * @author      Vallo Reima


 * @copyright   (C)2013


 */


define('SGN', 'aBook');                     /* signature */


define('APP', 'abk');                       /* application token */


define('DEV', 1);                           /* development status */





if (version_compare(PHP_VERSION, '5.4', '<')) {


  die('System requires PHP 5.4 or newer version');


} else {


  error_reporting(-1);


  ini_set('display_errors', true);


  ini_set('log_errors', false);


}





define('DS', DIRECTORY_SEPARATOR);                  /* directory separator */


define('PRID', 'pri' . DS);                         /* system directory */


define('PUBD', 'pub' . DS);                         /* assets directory */


define('EXT', '.php');                              /* default extension */





require_once(PRID . 'startup' . EXT);               /* bootstrap */


$application = new Frontal();                       /* front controller */


$application->Run();                                /* perform action */


?>

Details

Tiny Address Book

This demo application shows the design and programming techniques used in my projects. Some of the components of vRegistry framework are used. All the code is original (except some standard functions).

Functionality

The database consists of contacts and towns tables containing First & Last Name, Street, Postcode and Town data. The records can be added, deleted or modified. The table can be browsed and saved in XML format. Double-clicking on the row selects the record for editing. The towns list must be edited outside.

The demo is uploaded on [arc.vregistry.com].

Design & programming

OOP MVC principles are followed both on the back and front end. The AJAX is used for client-server communications. See [app.vregistry.com] regarding the techniques.

Requirements

Webserver: Apache or IIS supporting PHP and MySql
PHP: version 5.4+, PDO mysql and sqlite extensions
MySql: version 5+, Innodb engine
JavaScript: 1.5+ version
Browser: any common (IE, FF, Chrome, Safari, Opera,...), newer version

Installation

Unpack the abk.zip to your local/remote webserver retaining the folder structure. Create and load the MySql database from the sql files supplied. Find/change the connection properties in the configuration file /pri/abk/abk.xml (node db):

nme - database name
usr - access username
pwd - access password
pfx - database and username prefix (if hosting requires)

File structure

The files are arranged in folders according to their scope and functionality.

Folders

The root folder contains default startup. The folders:

pri - private server-side files; subfolders: + abk - application files + sys - framework files + tmp - temporary workfiles
pub - public client-side files; subfolders: + js - JavaScript code + css - stylesheets + pic - images
dev - miscellaneous development data

The abk and sys folders (may) have the subfolders:

_act - actions PHP code *.php
_css - dynamic CSS code *.css
_js - dynamic JavaScript code *.js
_lib - PHP classes *.php
_srv - action's PHP services *.inc
_tpl - htm templates *.phtml

Files

index.php - startup
php.php - check PHP version
pri/.htaccess - deny access
pri/gateway - common data gateway
pri/startup - bootstrap
dev/abook_data.sql - MySql data loading queries
dev/abook_struc.sql - MySql structure queries
pri/abk/abk.db - dictionary
pri/abk/abk.xml - configuration
pri/abk/_act/abook.php - main panel creator
pri/abk/_act/browse.php - browse panel creator
pri/abk/_act/finish.php - bye panel creator
pri/abk/_act/shell.php - layout creator
pri/abk/_css/shell.css - layout style
pri/abk/_js/abook.js - editor/browser class
pri/abk/_lib/Frontal.php - front controller class
pri/abk/_srv/abook.inc - data manipulation
pri/abk/_srv/browse.inc - browse services
pri/abk/_tpl/abook.phtml - panel template
pri/abk/_tpl/browse.phtml - browse template
pri/abk/_tpl/shell.phtml - layout template
pri/sys/_act/download.php - file download dialogue
pri/sys/_lib/Base.php - base functionality class
pri/sys/_lib/Common.php - common methods & properties class
pri/sys/_lib/Database.php - database abstraction layer class
pri/sys/_lib/IData.php - database I/O layer interface
pri/sys/_lib/Mypdo.php - PDO I/O layer
pri/sys/_lib/Texts.php - multilingual texts class
pri/sys/_tpl/exit.phtml - finish/error panel template
pri/sys/_tpl/exits.phtml - exit panel shell template

ChangeLog

Mar 2017 - shell design correction

[app.vregistry.com]: http://app.vregistry.com/hlp/en/spgm [arc.vregistry.com]: http://arc.vregistry.com/abk/

Files

File	Role	Description
`dev` (2 files)
`pri` (3 files, 2 directories)
`pub` (3 directories)
`index.php`	Example	Example script
`php.php`	Aux.	Auxiliary script
`readme.md`	Doc.	Documentation

File	Role	Description
`abook_data.sql`	Data	Auxiliary data
`abook_stru.sql`	Data	Auxiliary data

File	Role	Description
`abk` (1 file, 6 directories)
`sys` (3 directories)
`.htaccess`	Data	Auxiliary data
`gateway.php`	Class	Class source
`startup.php`	Aux.	Auxiliary script

File	Role	Description
`_act` (4 files)
`_css` (1 file)
`_js` (1 file)
`_lib` (1 file)
`_srv` (2 files)
`_tpl` (3 files)
`abk.xml`	Data	Auxiliary data

File	Role	Description
`abook.php`	Example	Example script
`browse.php`	Example	Example script
`finish.php`	Aux.	Auxiliary script
`shell.php`	Example	Example script

File	Role	Description
`shell.css`	Data	Auxiliary data

File	Role	Description
`abook.js`	Data	Auxiliary data

File	Role	Description
`Frontal.php`	Class	Class source

File	Role	Description
`abook.inc`	Example	Example script
`browse.inc`	Data	Auxiliary data

File	Role	Description
`abook.phtml`	Example	Example script
`browse.phtml`	Example	Example script
`shell.phtml`	Example	Example script

File	Role	Description
`_act` (1 file)
`_lib` (6 files)
`_tpl` (2 files)

File	Role	Description
`download.php`	Aux.	Auxiliary script

File	Role	Description
`Base.php`	Class	Class source
`Common.php`	Class	Class source
`Database.php`	Class	Class source
`IData.php`	Class	Class source
`Mypdo.php`	Class	Class source
`Texts.php`	Class	Class source

File	Role	Description
`exit.phtml`	Data	Auxiliary data
`exits.phtml`	Data	Auxiliary data

File	Role	Description
`css` (2 files)
`js` (2 files)
`pic` (1 file)

File	Role	Description
`base.css`	Data	Auxiliary data
`msie.css`	Data	Auxiliary data

File	Role	Description
`base.js`	Data	Auxiliary data
`common.js`	Data	Auxiliary data

File	Role	Description
`favicon.ico`	Data	Auxiliary data

	tiny-address-book-2017-06-11.zip 51KB
	tiny-address-book-2017-06-11.tar.gz 42KB
	Install with Composer

Version Control

Unique User Downloads

Download Rankings

100%

Total:	242
This week:	0

All time:	8,001
This week:	83

Applications that use this package

No pages of applications that use this class were specified.

If you know an application of this package, send a message to the author to add a link here.

About us

Advertise on this site

For more information send a message to info at phpclasses dot org.