Blogs : Khmer

A simple script which creates a sortable form based on a MySQL table. User can update or delete multiple records or add a new row.

Cacheton – An utility to cache pages that frequently query a db which is not updated so frequently. Script can reduce server load up to 50%. Your database will thank you. Easy installation, just create a cache dir and include the script. Configurable cache life, use page compression if you will.

AbstractDB is a PHP database abstraction layer, objected oriented and extensible via driver implementations which extend from a common base class.
This package encapsulates all of the basic functions required by most developers without the complexity and/or utter simplicity of many other abstraction packages.
Incorporating AbstractDB into your applications is as easy as including a single file.
AbstractDB [...]

Ever get tired of writing gets() and sets() or the same SELECT UPDATE DELETE queries day in and day out?
Check out this simple model generator.
It accepts a list of values, a forms URL, or a database connection and uses it to generate a data model and model factory.
Its free and easy to use, but does [...]

A PHP class script that demonstrates how to build the Next/Prev buttons for given MySQL query results. Easily create a paging navigation bar like Google.

Metabase is a set of PHP classes that provides DBMS independent access and management of databases. Currently it features: Set of functions that call the selected DBMS driver objects functions; DBMS Drivers classes; A parser class for interpreting DBMS independent database schemas file defined in a custom XML format; and A manager class for installing [...]

This script automatically searches for the databases within MySQL on your server. It then goes through each of the databases (it checks first to see if you have permission to those databases) and optimizes all the tables within them. The only thing you have to change in the script is your hostname, username and password [...]

The Flatfile package is designed to be a simple, light method of storing and retrieving data in tables with SQL-like features. All data is stored in tab-delimited text flat files.
It supports a very powerful and extensible WHERE clause mechanism, which can be used with SELECT, UPDATE or DELETE statements. It can do ORDER [...]

dbfConverter is a PHP script that reads data from dbase files (dbf,dbt,fpt) and convert them into the mysql or postgres tables. Initially, it create sql tables & insert data, and then updates old data. It does not support index files converting jet. Configurable feautures: join 2 or more dbf files in one mysql table, add [...]