I recently took over management of a club website and needed a simple membership roster. I looked at a number of free and commercial programs, but most either required MySQL (which I did not want to use) or were non-database programs which required a seperate file for each address. I eventually stumbled on a tutorial script for using PHP and MySQL to create my own program. Other than its use of MySQL, it was very close to what I wanted. I proceeded to re-write it to use SQLite instead, making other changes as needed to serve my needs. It appears to be working well. On a whim, I decided to re-write it again, to make it a general purpose Address Book and to make it available to anyone who wants to use it.
PSWAB (Php Sqlite Web Address Book) will work fin with any operating system. You must have a web server that works with PHP and PHP 5.x. I run Linux, and use Lighttpd as my web server. For Windows, you might want to look at Mongoose (Apache is overkill). Make sure that the SQLite extension (not SQLite3) is activated in php.ini.
The only other requirement is that the web server must have read/write privileges to the directory in which the PSWAB script is located.
The script follows (a zipped copy can be found here):
A couple of years ago, I ran across a post on a gun owner's forum where the poster said that he was going to write a database program for gun owners to keep track of their firearms and make it freely available to the forum members. Unfortunately nothing came of it, and the original post seems to have disappeared. I decided to give it a shot myself. The current version is written in PHP5 and uses an SQLite2 database (For small data sets, I think SQLite is a great choice). I used my address book (PSWAB) as a starting point, but I "enhanced" the code by making use of arrays to manipulate data and functions to better compartmentalize the coding. It is still a work in progress, and I may make additional enhancements. I may also rewrite it in a compiled language as a desktop application to eliminate the need for a web server. (I have to be careful here; I know that most people use MS Windows, but I use Linux. Any compiler I use will have to support both operating systems.)
The field titled "Picture" is for a single file name such as mypicture.jpg. the picture files need to be located in a directory called "images" in the same directory in which the script is running.
© 2020 Woodlark Associates