PhiTodo

A simple but effective way to organize your tasks, visit http://phitodo.com.

About AS3FlexDB

AS3FlexDB project is a open source library that allows Adobe Flex applications to connect to a MySQL server.This library use AMFPHP to access a MySQL server.

Download the source code. You can learn how to use FlexDB by following the steps in this tutorial.

For any questions email us at: as3flexdb@gmail.com

Take a look at FlexDB Tutorial 1 tutorial from iTutorials.ro

News

Check the new tutorial on http://www.sephiroth.it

Version changes

• 1.0.0

1. - Repackaged zip

• 1.1.2

1. - Add getDefaultConnection(), setDefaultConnection();

• 1.2.0

1. - Add query stack for oreder execute.

• 1.3.0

1. - Add isStackEmpty();
2. - Change setBusyCursor() whith "cool" preloader :D

• 1.4.0

1. - Add support for use in MXML (ConnectionData, Query, Database)
2. - Add set/get Records (bindable support)
3. - Add QueryExecute class for use in MXML

Simple example

All you need to load a table (for ex. "users") into a datagrid after you have install amfphp and set "services-config.xml" correctly is :

<?xml version="1.0" encoding="utf-8"?>
<mx:Application
	layout="vertical"
	xmlns:phi="phi.db.*"
	xmlns:mx="http://www.adobe.com/2006/mxml">

	<mx:DataGrid
		id="dg1"
		width="100%"
		height="100%"
		dataProvider="{q1.Records}">
		<mx:columns>
			<mx:DataGridColumn dataField="fname" headerText="First Name"/>
			<mx:DataGridColumn dataField="lname" headerText="Last Name"/>
			<mx:DataGridColumn dataField="password" headerText="Password"/>
		</mx:columns>
	</mx:DataGrid>
	
	<phi:ConnectionData id="c1" name="mxml_conn1" host="localhost" db="test" username="root" password="root" />
	<phi:Database id="db1" connection="{c1}" />
	<phi:Query id="q1" database="{db1}" q="SELECT * FROM users WHERE 1" />
	<phi:QueryExecute id="q1ex" query="{q1}" />
</mx:Application>

Table structures is:

CREATE TABLE `users` (
  `id` int(5) NOT NULL auto_increment,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `fname` varchar(255) NOT NULL,
  `lname` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1;