Silverlight + PHP SQL CRUD Application Wizard

Last Revised On: 30/06/2009

Project Overview

The Silverlight version of the SQL CRUD Wizard for PHP generates a Silverlight UI to perform Create, Read, Update and Delete operations against a SQL Server database.  The generated PHP / Silverlight application supports paging and sorting.

 

Architecture 

 The PHP to SQL CRUD Wizard creates a template for the Silverlight user interface based on the selected database, table and columns.  The template is a PHP page containing a mix of XAML markup and PHP code.  The generated CRUD application then uses the XAML template to dynamically create a Silverlight control server side filling in table columns and corresponding data from the database. The CRUD Wizard also generates the necessary Javascript code to interact with the Silverlight control client side to provide CRUD functionality as well as a default php page to host the Silverlight control.

Note that the web server environment is Windows/IIS and requires the PHP to SQL Driver.

Screenshots

Enter database credentials

Screenshot of form in CRUD wizard to enter database credentials

Select paging and sorting options, HTML or Silverlight UI and set styles for HTML output

Screenshot of CRUD wizard form to select paging, sorting & HTML or Silverlight

Example of the Silverlight interface

Screenshot of generated CRUD app with Silverlight interface

Download Solution Package From CodePlex Now