MySQL Ajax Database Access Layer - MADAL 1.0

MADAL allows one to quickly generate ajax enabled web-pages.

MADAL is an Ajax based database access layer for MySQL written in PHP and Javascript. It generates PHP and Javascript/jQuery source code that is well documented, so you can use your IDE's auto-completion against database tables and fields. The documentation was designed with PHP Eclipse in mind, but should work for any IDE that recognizes PHP doc.

Downloading: PHP Classes has only example and main classes, for the full working code, please download from the Google code project link:

Here's how simple using MADAL is:

This will give you an input field (text, checkbox, textarea, or datepicker) that updates the database FieldName of the row represented by $table_name onblur (see attached images). Pretty simple, right? MADAL also generates Javascript objects that allow you to update the database based on your own custom fields.

For example:
This will make an ajax call to the MADAL web service. Much simpler than writing a custom update page for every field of the database, and custom classes for every table.

Core components:
* Javascript (with jQuery)

* PHP Model - generates a set of PHP classes that mirror your database format
* Javascript Model - generates a set of javascript/jQuery classes that mirror your database and allows for easy client side display and modification
* MADAL Web Service - generates an easy to use web-service for accessing your database (includes instructions for implementing security)
* Easy ajax - simply print the input field and you've got an ajax enabled field
* Field validation - input fields are validated for their type
* jQuery ui themes - MADAL includes the whole set of default jQuery ui themes for easy styling of your pages. You can also add more using the jQuery ui theme roller.
* Optimistic concurrency - if more than one user is accessing a piece of data, and one of the users updates a field, then the other user updates the same field (but has out of date information), the second user will receive a notification that the field is in use, and the page will auto-refresh thus retrieving the most up-to-date data.

License type: MIT/X Consortium License
Date added: 5 years, 6 months 20 days ago | Last updated: 5 years, 3 months 11 days ago

More popular Database Tool

This is actually one of the most advanced image hosting script. The imagetize key features: SEO, Ads Ready, Admin

Listing Files

  • example_usage_simple
  • 1.4 KB
  • 04/01/2010 20:43:09
  • date_example.png
  • 25.3 KB
  • 04/01/2010 20:43:09
  • wysiwyg_example.jpg
  • 22.2 KB
  • 04/01/2010 20:43:09
  • example_usage_relational
  • 4.6 KB
  • 04/01/2010 20:43:09
  • example_interface_simple
  • 6.5 KB
  • 04/01/2010 20:43:09
  • example_interface_db_schema
  • 6.0 KB
  • 04/01/2010 20:43:09
  • madal-2010-04-01
  • 116.7 KB
  • 09/19/2010 23:40:43
  • example_interface_detailed
  • 47.7 KB
  • 04/01/2010 20:43:09
Hot Scripts