Web-Based Multiple MySQL Manager – AeroSQL

AeroSQL is an open source web application, for managing MySQL databases.

It can control databases from different servers in a single, desktop-like interface where records can be easily browsed or edited within a grid.

The application displays every query executed & can run a batch of sql queries to save you time.
It is possible to select the columns to be displayed while editing a table which will help reaching the data in an organized way.

AeroSQL is built with PHP & uses ExtJS to provide the desktop-like functionality.

Requirements: PHP & ExtJS
Website: http://www.burlaca.com/aerosql/
Demo: http://www.burlaca.com/aerosql-demo/

Open Source PHP-Based News Aggregator: Lilina

Lilina is an open source PHP application for aggregating feeds from a web-based interface.
It supports RSS, Atom & podcasts inside them. It is also possible to import/export feeds with an OPML file.

The application only requires PHP(5) to run & makes use of 2 built-in libraries: HTML Purifier and SimplePie.
Lilina has a plugin system for extending its capabilities & the look/feel can be customized with the theming support.

Requirements: PHP5
Website: http://getlilina.org/
Download: http://getlilina.org/download/

Cross-Domain JavaScript With Simple PHP Proxy

Using JavaScript, it is possible to load HTML, XML or JSON data with XMLHttpRequest.
However cross-domain JavaScript requests (reaching remote pages) are not possible due to browser security limitations except JSONP-formatted JSON data.

Simple PHP Proxy is a PHP script which aims to fill this gap by creating a layer between your JavaScript code and the remote domain to get data in HTML, XML or JSON formats.

Some features of Simple PHP Proxy:

• requested URLs can be white-listed & validated against a regex.
• optionally forward client cookies / SID to the remote server.
• optionally forward configurable User Agent to the remote server.
• requests can use either GET or POST request methods.
• remote data can be delivered as-is with all remote headers intact.
• remote data can be wrapped in a JSON/P structure that includes status codes & remote headers.
• if using JSON/P & remote data is valid JSON, it will be merged into the resulting data object.

There is also a demo which you can request any URL.

Requirements: PHP
Website: http://benalman.com/projects/php-simple-proxy/
Demo: http://benalman.com/code/projects/php-simple-proxy/e...

A PHP Interface For Cloud Services: Simple Cloud API

As the number of cloud storage services increases & projects may require using multiple services at the same time, it becomes complicated for a developer to learn the details of each provider.

Simple Cloud API is an open source project that aims to create a common PHP interface for using cloud services.

It currently supports the storage API for:

• Amazon S3
• Windows Azure Blob Storage
• Nirvanix
• Local

and, in the near future, aims to support Rackspace Cloud Files, GoGrid Cloud Storage besides the queue & document APIs of all services.

The project is backed by Zend & supported by IBM, Microsoft, Rackspace, Nirvanix, and GoGrid.

Website: http://simplecloudapi.org/
Download: http://simplecloudapi.org/download

JPEGCam: Capture Images From A Webcam & Submit To Any Server

JPEGCam is an open source Flash + JavaScript library that enables you to insert a custom-sized Flash movie in a webpage that captures Webcam snapshots.

After capturing the snapshots, it can submit them to any server in JPEG format (download package includes sample PHP 5 code).

The webcam is activated with the Flash movie which includes a full-canvas camera control with no flash user interface elements. User can decide when to take the snapshot & click a button to do it.

Every control for displaying the Flash device configuration panel & taking snapshots is handled from Javascript which makes:

• controlling the user interface
• using your own buttons and layout

possible.

Requirements: No Requirements (demo requires PHP 5)
Website: http://code.google.com/p/jpegcam/
Demo: http://bowser.macminicolo.net/~jhuckaby/jpegcam/
Download: http://code.google.com/p/jpegcam/downloads/list

Open Source Invoice Manager: MyClientBase

MyClientBase is a web-based, free & open source invoice management application which is built with PHP (using the CodeIgniter framework) & MySQL.
It enables anyone to create invoices, view payments, get reports & more..

The application is flexible & variables like:

• currency symbol
• date format
• next Invoice ID
• tax rate

can be customized easily.
It is possible to define tax rates per invoice or globally & create multiple invoice templates.

Requirements: PHP, MySQL
Website: http://www.myclientbase.com/
Download: http://www.myclientbase.com/myclientbase/download

Create Gallery-Themed Websites Using W-Script 10 Jan

W-Script is an open source application which is originally aimed at creating "wallpaper download websites".
But, it is a very ideal resource for building any gallery-themed or image-oriented website like CSS galleries, photo galleries ,etc.

The application is built with PHP-MySQL & it can handle large number of images.

Some features of W-Script:

• unlimited categories, subcategories
• visitors can submit images (and optionally register)
• images can be rated & commented
• advanced search
• auto-thumbnails in various sizes

It has a Smarty-based template engine which makes creating new templates pretty easy.
Also, W-Script can be extended with modules like tag clouds, color browser, user stats or anything custom.

Requirements: PHP & MySQL
Website: http://www.wallpaperscript.net/
Demo: http://www.wallspaper.net/

Powerful And Open Source CMS: Symphony

Symphony is a XSLT-powered open source CMS that is created with PHP & uses MySQL for storing data.

It offers a very flexible usage as the data, logic & templating layers are all independent, meaning that whatever you implement can be modified, added or removed with minimum effort.

When compared to other popular CMS applications, the biggest difference is the template engine used. It is XSLT-based which makes it possible to output much more than just web pages (dynamic CSS & JavaScript, PDFs, SVGs..).

Symphony has a light & elegant backend that helps you focus on your work with features like bulk editing, drag'n drop ordering of items & much more.

The application has a growing library of extensions (130+) which can help you improve the functionality it offers.

Requirements: PHP 5.2+, MySQL 4.1+, PHP's LibXML module with the XSLT extension enabled
Website: http://symphony-cms.com/
Download: http://symphony-cms.com/download/

PHP HTTP Streaming: xmoovStream Server

xmoovStream Server is an open source http streaming server built with PHP.

It creates a layer between the web & your files to provide you control over them in many ways like:

• stream Flash videos
• force file downloads
• logging of every action
• hot link protection
• hide original file locations
• bandwidth throttling & burst loading
• & more..

xmoovStream is a centralized server which can manage different kinds of content from different urls under a single installation.

Like mentioned, it is not limited to streaming Flash videos, it can simply stream any file type including the video player itself or a thumbnail.

The server also comes with a lightweight video player & an audio player for streaming your content.
P.S. The resource is free for non-commercial website & requires a license for any other usage.