Thursday, September 17, 2009

Ajaxed MySQL Table Editor

Mysql Ajax Table Editor is an open source web application for easily editing MySQL tables & creating admin pages almost instantly.
Besides the standard "add, edit, copy, delete, view" functionality, records can be paged, searched & exported to CSV.


It is possible to JOIN multiple tables to generate a custom view (+ apply any other functions on this view) with the help of a configuration file. Also, column names displayed can be customized for a better presentation.
MySQL Ajax Table Editor has permissions support which can be set on a per column or table basis for limiting functions.
Users can hide/show & re-order columns which is very useful when working with the data.
The application works with both PHP4 & PHP5 and comes with 5 ready-to-use languages where new ones can be created.

Requirements: PHP4 or PHP5
Compatibility: All Major Browsers
Website: http://www.mysqlajaxtableeditor.com/
Demo: http://www.mysqlajaxtableeditor.com/Example1.php
Symfony, one of the most popular PHP frameworks around, is sharing several standalone PHP classes (under the Symfony Components website) which can ease the job of a PHP developer.
They don’t require Symfony to be used & can be used with any PHP code.

Currently, 3 classes are ready to be used:

YAML
It parses YAML strings and converts them to PHP arrays. It can also converts PHP arrays to YAML strings.
Event Dispatcher
It’s a good way to make your code more flexible. It’s also a great way to make your code easily extensible by others.
Symfony Event Dispatcher is a PHP library that provides a lightweight implementation of the Observer design pattern.
Dependency Injection
It provides a lightweight and robust Dependency Injection Container for classes that implements the Dependency Injection pattern.

And, 2 new classes are on the way:

  • Templating
  • Request Handler
All the code provided is very well-documented & totally free to use.

Requirements: PHP
Website: http://components.symfony-project.org/
Tuesday, September 8, 2009

Simple & Powerful PHP Image Gallery: Plogger

Plogger is an open source image gallery application, built with PHP-MySQL, that offers a simple usage with powerful features.
The application comes with an attractive admin interface for managing the galleries & can be integrated into any website by adding three lines of PHP code.


Using Plogger, it is possible to create unlimited albums that can include unlimited images. And, uploading the images is a breeze as they can be sent one at a time or as a .zip file in bulk.
Thumbnails are created automatically & there is caching support for faster loading.

Some other features of Plogger:

  • commenting on images (optional)
  • RSS feed on every level (single album, gallery..)
  • an integrated JavaScript slideshow
  • template based theme system
  • valid XHTML output
Also, each gallery has a full XML generator built-in that enables anyone to create widgets in any language.

Requirements: PHP4+, MySQL v3.23+ & GD1.0
Compatibility: All Major Browsers
Website: http://www.plogger.org/
Demo: http://www.plogger.org/demo/