Aug

Using Flex, PHP, and JSON to Modify a MySQL Database

To follow-up on the Flex and PHP tutorial we did earlier I thought it would be nice to do a complete tutorial on php, mysql, flex, and json. This tutorial should show a decent way to send data in a database to and from flex to php using json. I will explain this in more detail in just a moment.

First lets take a look at what will be the result of this tutorial and see what it does. Below we have a simple flex app with a datagrid component and a button. The datagrid is filled with some sample data, which, in this case, is some information about a few of the tutorials on this site. The info includes the title, the author, and a rating for the tutorial, and all of this information is pulled from a database on the webserver when the app loads.

The app allows you to change the rating for each tutorial, but does not allow you to change the other columns. Go ahread and change a few ratings. Once you are done, you can click the "Update Database" button, and the ratings you entered will be sent to the webserver using json, and stored in a database.

So how is all of this done? Well lets start by taking a thousand foot view of how the communication between the application and the webserver will work. On the top of the diagram below we have the process of getting the data from the database to the flex application. As you can see we start over at the client block, where it sends a message to the php page on the webserver requesting data. The php in turn sends a query to the database and get the results (or error) back from MySql. This information is then encoded in json and sent back to the client. The flow at the bottom of the diagram describes how data from the flex app is pushed back up into the database. The client encodes its data in json, and proceeds to send it to the php page on the webserver. The php page takes this data, decodes it into php objects, and updates the database. the php page then sends back a success or failure message to the client.

Now lets get going into some code. First things first we need to make sure we have a database, mine is called 'testDB'. I am not going to go over creating the database itself in MySql but if you need help with this MySQL's site has some great reference material, including tutorials and examples. Once you have the database setup we want to add a table to it. In MySQL you can run the command below to get the table we are going to use in this tutorial. We are using a very simple table that just holds an id, title, author, and rating for our tutorials.

DROP TABLE IF EXISTS `testDb`.`Tutorials`;
CREATE TABLE `testDb`.`Tutorials` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`author` varchar(255) NOT NULL,
`rating` double NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

The next step we are going to do is create our php file that will sit between the database and flex app. This file is actually a fairly simple script. We start off by creating a few variables that we use for our database connection: the database name, username, password, and address of the server. The values for those variables in the script below are just placeholders - you should fill them in with the values correct for your setup. We also setup two cases in our script which are executed depending on the "GET" parameters we receive from our client. One is for getting the data from the database, and one is for updating the data. And so we start with the following php code:

Next we fill out our getTutorials if statement. The first thing we want to do is connect to the database. These functions are part of the base php install. We then build our query to get all the tutorials from our table and create an array for our results. We can now run our query and get our results back. You could check for errors at this point, but I do not (in order to make the code simpler to read). We then take each row from our results using mysql_fetch_assoc statement and add each of them to the $returnArray. Once we have added all the rows we then close our connection to the database. Finally, we encode the $returnArray into JSON and send it on to the client.

mysql_connect($URL, $USERNAME, $PASSWORD);
mysql_select_db($DATABASE) or die('Cannot connect to database.');

$returnArray = array();

$query = 'SELECT * FROM Tutorials';
$result = mysql_query($query);

while($row = mysql_fetch_assoc($result))
{
array_push($returnArray, $row);
}

mysql_close();
echo json_encode($returnArray);

Now we have to fill in the second if block. We start a little different in this one because here we are getting data back from our client. The data we are getting back is through a "GET" parameter so the first thing I do is use urldecode on the data to change any %-- (where -- is a hex number) back to the actual symbol. Now this string should be the JSON encoded data sent from the client, but for some reason the data sent by our client has a few extra slashes in it, so I just get rid of those with a str_replace and we are ready to decode the info.

We can now decode using the function json_decode. You may notice that we pass two parameters to the function, the first is our data and the second tells the function that we want the data back as an associative array (which makes our job easier later). Now we open up a connection to our database just like before. Next we loop through the array we got back from json_decode, running an update query on each entry. We create the query this time using sprintf to insert our variables from our array of data, and we use mysql_real_escape_string to properly escape any data in the query. The result of an "Update" statement in php is "true" if it is successful and "false" if not, so we check to make sure we successfully update the database, and if not we close the connection and return the error to our client. The last thing we do is if all the data updates successfully we close the database connection and return a "database updated" message back to the client. And here is how it all looks:

$jsonString = urldecode($_GET['jsonSendData']);
$jsonString = str_replace("\\", "", $jsonString);
$data = json_decode($jsonString, true);

mysql_connect($URL, $USERNAME, $PASSWORD);
mysql_select_db($DATABASE) or die('Cannot connect to database.');

foreach ($data as $tutorialEntry) {
$query = sprintf(
'UPDATE Tutorials SET rating = "%s" WHERE id = "%s"',
mysql_real_escape_string($tutorialEntry['rating']),
mysql_real_escape_string($tutorialEntry['id']));

$result = mysql_query($query);

if(!$result)
{
mysql_close();
echo mysql_error();
return;
}
}
mysql_close();
echo "database updated";

And all that php code together looks like this:

<?php
$USERNAME = 'yourusername'; //database username
$PASSWORD = 'yourpassword'; //database password
$DATABASE = 'testDb'; //database name
$URL = 'localhost'; //database location

if(isset($_GET['getTutorials']))
{
mysql_connect($URL, $USERNAME, $PASSWORD);
mysql_select_db($DATABASE) or
die('Cannot connect to database.');

$returnArray = array();

$query = 'SELECT * FROM Tutorials';
$result = mysql_query($query);

while($row = mysql_fetch_assoc($result))
{
array_push($returnArray, $row);
}

mysql_close();
echo json_encode($returnArray);
}
elseif(isset($_GET['setTutorials']))
{
$jsonString = urldecode($_GET['jsonSendData']);
$jsonString = str_replace("\\", "", $jsonString);
$data = json_decode($jsonString, true);

mysql_connect($URL, $USERNAME, $PASSWORD);
mysql_select_db($DATABASE) or
die('Cannot connect to database.');

foreach ($data as $tutorialEntry) {
$query = sprintf(
'UPDATE Tutorials SET rating = "%s" WHERE id = "%s"',
mysql_real_escape_string($tutorialEntry['rating']),
mysql_real_escape_string($tutorialEntry['id']));

$result = mysql_query($query);

if(!$result)
{
mysql_close();
echo mysql_error();
return;
}
}
mysql_close();
echo "database updated";
}
?>

On to the Flex now. We have our backend ready to go, so next up is building the client. We start off by building a simple interface in flex, nothing spectacular. We add a panel, datagrid to hold our data, a button to send updated data to php, and a label to put status updates in. We set some specific widths on our datagridcolumn tags just to make our data look a little nicer. This should produce some code that looks like the following:

<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml"
layout="absolute" width="535" height="345"
viewSourceURL="../files/FlexPHPMysqlUpdate.mxml">
<mx:Panel x="0" y="0" width="535" height="345"
layout="absolute"
title="Flex, PHP, Mysql - Updating through JSON">
<mx:DataGrid id="dgData" x="10" y="10"
width="495" height="241">
<mx:columns>
<mx:DataGridColumn headerText="Name"
dataField="name"/>
<mx:DataGridColumn headerText="Author"
dataField="author" width="115"/>
<mx:DataGridColumn headerText="Rating"
dataField="rating" width="50"/>
</mx:columns>
</mx:DataGrid>
<mx:Button x="10" y="259" label="UpdateDatabase"
id="butUpdate"/>
<mx:Label x="140" y="261" id="lblStatus"/>
</mx:Panel>
</mx:Application>

Now we can work on getting data from php and into our datagrid. The first thing we do is create an HTTPService to go out to our php page and get the data. We specify a couple attributes in our <mx:HTTPService> tag to define our service. We give it an id to reference it by and set the url property to the url of the php page. Also we say we don't want to use a proxy, the method we are going to use is "GET", and we want the result back as text. The final parameter that we set is result, and here we set the function we want called when the request returns - in this case, getPHPData. We have not yet defined this function, but don't worry, we will talk about it in just a few moments. After the opening tag for the HTTPService is completed, we create a request tag, where we specify that we want the GET parameter "getTutorials" to have a value of true in the request. And this code will go right below the opening application tag.

<mx:HTTPService id="getData"
url="../files/phpdb_json_tutorial.php"
useProxy="false" method="GET"
resultFormat="text" result="getPHPData(event)">
<mx:request xmlns="">
<getTutorials>"true"</getTutorials>
</mx:request>
</mx:HTTPService>

Next we setup the functions that will trigger the getData request and the function that will handle the result of that request (getPHPData). So in a <mx:Script> tag we create two functions, one is called "initDataGrid" and other is "getPHPData". At this point we also add a [Bindable] ArrayCollection to hold the data. Now in our "initDataGrid" function we initialize our ArrayCollection to an empty new one and also we tell our HTTPService trigger the request for data. Once we get the data back from php we will handle it in the "getPHPData" function. This will take the raw data from the result event and decode it using JSON.decode. The decoded data is saved as an Array and then we create an ArrayCollection from this array and set our "dataArray" variable equal to this. All of this goes in right after the opening application tag.

<mx:Script>
<![CDATA[
import mx.rpc.events.ResultEvent;
import mx.collections.ArrayCollection;
import com.adobe.serialization.json.JSON;

[Bindable]
private var dataArray:ArrayCollection;

private function initDataGrid():void
{
dataArray = new ArrayCollection();
getData.send();
}

private function getPHPData(event:ResultEvent):void
{
var rawArray:Array;
var rawData:String = String(event.result);
rawArray = JSON.decode(rawData) as Array;
dataArray = new ArrayCollection(rawArray);
}
]]>
</mx:Script>

The data still isn't showing up in our DataGrid, but this is because we haven't hooked up our "initDataGrid" function and bound our "dataArray" yet. This is a simple task - all we do is update our DataGrid tag with a dataProvider property and creationComplete event which calls our initialize function. Our new tag look like this:

<mx:DataGrid id="dgData" x="10" y="10"
width="495" height="241"
dataProvider="{dataArray}"
creationComplete="{initDataGrid()}">

Wallah! We now have data from the MySQL database showing up in the datagrid. Lets now work on updating our data in our flex client and getting it back to the database. The first thing we want to do is make our datagrid editable, and this is just a property we set in the tag. But because we only want the rating column to be editable, we add an editable tag to each column, which we set to false for the title and author and true for the rating. The new datagrid component code is below:

<mx:DataGrid id="dgData" x="10" y="10"
width="495" height="241"
dataProvider="{dataArray}"
creationComplete="{initDataGrid()}"
editable="true">
<mx:columns>
<mx:DataGridColumn headerText="Name"
dataField="name" editable="false"/>
<mx:DataGridColumn headerText="Author"
dataField="author" width="115" editable="false"/>
<mx:DataGridColumn headerText="Rating"
dataField="rating" width="50" editable="true" />
</mx:columns>
</mx:DataGrid>

Now we can update our datagrid but the changed data isn't actually getting back into our ArrayCollection - for this we add a <mx:Binding> tag just before our opening panel tag. We set the source of the binding to the data provider of our datagrid and the destination as our "dataArray" variable. This will make sure that as the datagrid gets updated the ArrayCollection is updated as well.

<mx:Binding source="dgData.dataProvider as ArrayCollection"
destination="dataArray"/>

Now it's time to get this updated data back to the database. In order to do this we need another HTTPService, and we set this one up exactly like before, except this one has a different id and a different function is called when the results are returned. We also do NOT send a "getTutorials" parameter. So this new HTTPService tag looks like the following and goes right below our other service tag.

<mx:HTTPService id="sendData"
url="../files/phpdb_json_tutorial.php"
useProxy="false" method="GET"
resultFormat="text" result="updatedPHPDataResult(event)">
</mx:HTTPService>

We also update our button at this point to call a function when clicked, which in this case will be

sendPHPData.




<mx:Button x="10" y="259" label="UpdateDatabase" 

  id="butUpdate" click="{sendPHPData()}"/>


Now we need to create the function referred to by the previous two blocks of code. First, lets work on sendPHPData.  This function will be called when the "Update Database" button is clicked, and will take the data from the datagrid, encode it as json, and push it back up to the database. We first declare an object which we use for our url parameters (name/value pairs). Next we actually encode the data of our ArrayCollection, note we use the getArray function to get the data as an Array out of the collection. Once we have encoded the data we pass it through a helper function, escape. Basically this function checks for certain symbols and replaces them with the url hex codes, making the data url safe. Now we set our parameters we want to pass, first being "setTutorials" which will let our php know we want to update the database, and second the JSON data itself. All that is left is to send the request out with our parameter object. Below you will see the "sendPHPData" function, this goes in our <mx:Script> tag.




private function sendPHPData():void

{

  var objSend:Object = new Object();

  var dataString:String = JSON.encode(dataArray.toArray());

  dataString = escape(dataString);

  objSend.setTutorials = "true";

  objSend.jsonSendData = dataString;

  sendData.send(objSend);

}


The second function is updatedPHPDataResult, which is called when the sendData request returns. All it does is display the result of the request on the screen. We do this by setting the text of our status label to the result we get back from php. Again this function goes in our script tag.




private function updatedPHPDataResult(event:ResultEvent):void

{

  lblStatus.text = String(event.result);

}


Bam! We now have a working client that can update the database. You can stop here and everything should work. But its always nice to do a little error checking, so lets see about checking the rating being entered before we let the edit complete. This can be done by using an event in the DataGrid tag, itemEditEnd. This event is fired at the end of the edit but before the value is put into the data provider. So I changed the DataGrid tag to the following:




<mx:DataGrid id="dgData" x="10" y="10" 

  width="495" height="241" 

  dataProvider="{dataArray}" 

  creationComplete="{initDataGrid()}" 

  editable="true" itemEditEnd="{checkRating(event)}">


And also I added the function defined by the event to the script tag in our mxml. This function does the following: It grabs the value that is being changed (the new value) and checks to make sure it is a number between 0 and 10. If it isn't I show an error message in the status label. And by calling the function preventDefault on the edit event I keep the edit box open restoring the original value. I added this just to make sure no ugly data gets pushed back to the database. So the function looks like:




private function checkRating(event:DataGridEvent):void

{

  var txtIn:TextInput = 

    TextInput(event.currentTarget.itemEditorInstance);

  var curValue:Number = Number(txtIn.text);

  if(isNaN(curValue) || curValue <0 || curValue> 10)

  {

    event.preventDefault();

    lblStatus.text = 

      "Please enter a number rating between 0 and 10";

  }

}


We are now left with the following code in our mxml file. This takes care of our client. 




<?xml version="1.0" encoding="utf-8"?>

<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" 

  layout="absolute" width="535" height="345" 

  viewSourceURL="../files/FlexPHPMysqlUpdate.mxml">

<mx:Script>

  <![CDATA[

    import mx.events.DataGridEvent;

    import mx.controls.TextInput;

    import mx.rpc.events.ResultEvent;

    import mx.collections.ArrayCollection;

    import com.adobe.serialization.json.JSON;

    

    [Bindable]

    private var dataArray:ArrayCollection;

    

    private function initDataGrid():void

    {

      dataArray = new ArrayCollection();

      getData.send();

    }

    

    private function getPHPData(event:ResultEvent):void

    {

      var rawArray:Array;

      var rawData:String = String(event.result);

      rawArray = JSON.decode(rawData) as Array;

      dataArray = new ArrayCollection(rawArray);

    }

    

    private function sendPHPData():void

    {

      var objSend:Object = new Object();

      var dataString:String = 

        JSON.encode(dataArray.toArray());

      dataString = escape(dataString);

      objSend.setTutorials = "true";

      objSend.jsonSendData = dataString;

      sendData.send(objSend);

    }

    

    private function updatedPHPDataResult(event:ResultEvent):void

    {

      lblStatus.text = String(event.result);

    }

    

    private function checkRating(event:DataGridEvent):void

    {

      var txtIn:TextInput = 

        TextInput(event.currentTarget.itemEditorInstance);

      var curValue:Number = Number(txtIn.text);

      if(isNaN(curValue) || curValue <0 || curValue> 10)

      {

        event.preventDefault();

        lblStatus.text = 

          "Please enter a number rating between 0 and 10";

      }

    }

  ]]>

</mx:Script>

<mx:HTTPService id="getData" 

  url="../files/phpdb_json_tutorial.php" 

  useProxy="false" method="GET" 

  resultFormat="text" result="getPHPData(event)">

  <mx:request xmlns="">

    <getTutorials>"true"</getTutorials>

  </mx:request>

</mx:HTTPService>

<mx:HTTPService id="sendData" 

  url="../files/phpdb_json_tutorial.php" 

  useProxy="false" method="GET" 

  resultFormat="text" result="updatedPHPDataResult(event)">

</mx:HTTPService>

<mx:Binding 

  source="dgData.dataProvider as ArrayCollection" 

  destination="dataArray"/>

  <mx:Panel x="0" y="0" width="535" height="345" 

    layout="absolute" 

    title="Flex, PHP, Mysql - Updating through JSON">

<mx:DataGrid id="dgData" x="10" y="10" 

  width="495" height="241" 

  dataProvider="{dataArray}" 

  creationComplete="{initDataGrid()}" 

  editable="true" itemEditEnd="{checkRating(event)}">

      <mx:columns>

        <mx:DataGridColumn headerText="Name" 

          dataField="name" editable="false"/>

        <mx:DataGridColumn headerText="Author" 

          dataField="author" width="115" editable="false"/>

        <mx:DataGridColumn headerText="Rating" 

          dataField="rating" width="50" editable="true" />

      </mx:columns>

    </mx:DataGrid>

    <mx:Button x="10" y="259" label="UpdateDatabase" 

      id="butUpdate" click="{sendPHPData()}"/>

    <mx:Label x="140" y="261" id="lblStatus"/>

  </mx:Panel>

</mx:Application>


So this should give you a pretty good handle on getting data from MySQL to Flex and back again. If you have any questions or concerns please leave a comment and we will try and reply as quickly as possible.



A few quick notes: Data concurrency is not taken into account in this tutorial, this could be handled on the php side when we try to update, though. Also we send all the data back to php when we update, we could have done this a couple different ways. We could have sent individual data pieces back everytime something is updated, we could just send back what was updated when the button was pressed by keeping track of what was changed since the last update.  Both of those (and other possible methods) require more code and our more complex, but can be implemented with the same flex<->json<->php techniques used here.




Update: Check out the new tutorial that adds on to the functionality of this one.



Posted in MySQL,  PHP,  Flex,  All Tutorials by The Fattest |  



	34 Responses 

	

	
				
			david Says:

			
			August 3rd, 2007 at 5:06 pm 
			
			Thanks for the great tutorial. Rather than sending everything back to the server, how would you suggest keeping track of what has changed and only sending that back?
Thanks!
			
		
		
		
	
				
			The Fattest Says:

			
			August 3rd, 2007 at 5:55 pm 
			
			Well my first thought is to use the ArrayCollection event “collectionChange”. We can use this event because we have the data bound to our datagrid dataProvider. Thus this event is fired when any of the data is changed, and at this point you could do many things. For one you could just simply throw the object to be updated into a new array or you could dig into the event object and find out what property was modified and keep track of specific information that needs to be sent back. Now instead of sending our original updated array collection of data back we can send our smaller list of items or information that needs updated back.
Does this make sense? If you need more info I can write up a quick example of what I am talking about.
			
		
		
		
	
				
			david Says:

			
			August 3rd, 2007 at 7:44 pm 
			
			That’s what I had in mind, though the actual implementation still escapes me since the handling for add, change, deletes are different for the event object.  Yes, an actual example will be very helpful indeed, if you have the chance.  That will make for a great follow-up tutorial.
Many thanks.
			
		
		
		
	
		
				
			The Fattest Says:

			
			August 3rd, 2007 at 8:19 pm 
			
			Yeah sure I will come up with a small follow-up to show how to do this. Look for this in the next week or so.
			
		
		
		
	
				
			Anonymous Says:

			
			August 4th, 2007 at 8:20 am 
			
			What would you do if the update fails?
			
		
		
		
	
				
			The Fattest Says:

			
			August 4th, 2007 at 7:31 pm 
			
			Well in this case you would get an error in your status box notifying you why the update failed. And also your data on the client side wouldn’t change so you could try updating again.
If it is a php mysql problem you could have something on the server side to save the data that needs to be updated and it could try to update it at a later time. 
But most likely the problem is going to be no access to the server in that case you could save the data in a Shared Object and save the data to it. Then when access to the server is available again you could send it over, whether it be the same session or a later one.
If you lose access to database then you could again save the data in php to be updated later.
Let me know if this is what you’re looking for? If you need more info please ask?
			
		
		
		
	
				
			sf Says:

			
			August 6th, 2007 at 3:38 pm 
			
			Use PDO… not mysql_*.
			
		
		
		
	
				
			The Fattest Says:

			
			August 6th, 2007 at 4:24 pm 
			
			Yeah it could have been implemented using PDO or mysqli. PDO would be a good solution if your looking to support multiple database engines. But in this example we used mysql extensions because they are simple and very common.
			
		
		
		
	
				
			George Says:

			
			August 8th, 2007 at 4:29 pm 
			
			Can this be done without the JSON? and instead of PHP use ColdFusion?
			
		
		
		
	
				
			The Fattest Says:

			
			August 8th, 2007 at 4:44 pm 
			
			This could absolutely be done without JSON, you could simply use xml to send the data. And there is no reason why you can’t use ColdFusion, I am not a ColdFusion person myself but we are not doing anything that is specific to PHP.
If you need any more details let me know.
			
		
		
		
	
				
			colombia Says:

			
			August 14th, 2007 at 9:44 am 
			
			hummm, i’m still not sure about the best way to send and receive data from a MYSQL database, JSON, amf-php remoting, XML ??? comparison?
			
		
		
		
	
				
			Sean O Says:

			
			August 14th, 2007 at 10:46 am 
			
			re: “Wallah!”

_snicker_ Um, I think you might mean “Voila!”
			
		
		
		
	
				
			The Fattest Says:

			
			August 14th, 2007 at 11:24 am 
			
			Colombia,

I have to say I have not put enough time into all of these services to give a real good answer, but Mike Potter has a good look into them right here: http://blogs.adobe.com/mikepotter/2006/07/php_and_flex_js.html
Also WebOrb is an option for communicating with php and you can find some information about it here: http://themidnightcoders.com/weborb/php/index.htm

 and http://riapedia.com also has some good information on weborb. I will however make some time to look into weborb because it seems like a interesting solution. Hope that helps.
Sean O,

Well you haven’t seen anything until you seen the exclamation at the end of the new flex tutorial on amazon web services,  here.
			
		
		
		
	
				
			The Fattest Says:

			
			August 27th, 2007 at 8:42 am 
			
			I have put up a follow up tutorial which should answer your questions somewhat David. Check it out over at Advanced Updating.
			
		
		
		
	
				
			L Jay Adams Says:

			
			August 28th, 2007 at 3:06 pm 
			
			I added a link to your tuturial in my blog, but I usually like to successfully go through the tutorials that I post.

I’m using Flex Builder 2, but I had to download the corelib.swc to get the JSON calls to compile.  This compiles fine, and I get no errors running, but does not update my datagrid.

I attempted the JSONLite.swc earlier, but that gives me errors compiling.

My server is running PHP 5.1.6.

Any suggestions?
			
		
		
		
	
				
			The Fattest Says:

			
			August 28th, 2007 at 3:15 pm 
			
			Ok starting at the top, do you get any php errors showing up in your server log? A great way to check to make sure your php code is working correctly is to go straight to the address and append the query string variable to the end of the url. For example, mine would be http://blog.pfp.com/page.php?getTutorials=true (not real url) and this should echo out the data that would be send to your flex page. So if nothing is showing up here something is screwy between the php and mysql. And if this is showing up correctly then we move onto the flex. Let me know if the php is working correctly then we can take it from there.
			
		
		
		
	
				
			The Fattest Says:

			
			August 28th, 2007 at 9:31 pm 
			
			One of my colleagues pointed out that your are only using php 5.1.6 and JSON wasn’t automatically included until 5.2. Check out this tutorial and it will have a link to the json for php < 5.2.
			
		
		
		
	
				
			L Jay Adams Says:

			
			August 29th, 2007 at 8:43 pm 
			
			Thank you!  It looks like I need to upgrade PHP on my server.  I appreciate your help!
			
		
		
		
	
				
			George Smith Says:

			
			October 12th, 2007 at 12:26 pm 
			
			I so stumped I have to ask. I have posted this at adobe and was wondering if you can look at it.
http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?catid=585&threadid=1306225&forumid=60. 
Im updating the db table with the form elements just not the Checkboxs from the datagrid. I have been at this for a month. And could use some assistance.
Thanks
			
		
		
		
	
				
			Wesley Workman Says:

			
			December 20th, 2007 at 12:08 pm 
			
			I’ve been tinkering with using JSON integration over the past week or so and I saw that you had a blog post about it, followed your example and fix my issue. Thanks for another great tutorial!!!!
			
		
		
		
	
				
			Kommander_SER Says:

			
			January 12th, 2008 at 3:00 pm 
			
			Hello,
i’ve noticed that JSON Library  automaticli sorts my JSON String in Alphabetical order  It is possibly to permit this sorting?
			
		
		
		
	
				
			The Fattest Says:

			
			January 12th, 2008 at 4:18 pm 
			
			Kommander_SER,
I am going to assume this is because the JSON encoder simply loops through the properties of an object and encodes them. You could randomize the JSON string after it has been encoded. The only other option would be to encode the individual properties in whatever order you wanted and then send them.
			
		
		
		
	
				
			Shep the Dog Says:

			
			January 15th, 2008 at 11:30 pm 
			
			Hi,
I’m having a problem with flex parsing the php. I’m running PHP Version 5.2.1, I’ve added the corelib.swc to the project and tested the direct address appneded with the query string variable. The reults were fine and just as i expected.
 This is my error:
Error: Unexpected
			
		
		
		
	
				
			The Fattest Says:

			
			January 16th, 2008 at 9:56 am 
			
			If you run the debugger with a breakpoint at the beginning of the getPHPData function what is the rawData equal to? And step through until it breaks so you have a better idea of exactly where it is breaking. This information would help troubleshoot your issue.
			
		
		
		
	
				
			SanjV Says:

			
			January 30th, 2008 at 4:49 am 
			
			Hi! Ive seen the above and it looks amazing! I planning to become a Flex user but wanted to know; Is flex really strong when working with a database with about 20k rows, each with about 100 fields? i currently use a .net/sql20005/aspose.cells solution.  Yay or Nay?
			
		
		
		
	
				
			marcos Says:

			
			March 5th, 2008 at 5:07 pm 
			
			I tried to testt but I’m having the message: 1120: Access of undefined property JSON

Somebody can help me
			
		
		
		
	
				
			The Fattest Says:

			
			March 5th, 2008 at 5:22 pm 
			
			macros this sounds like you do not have the JSON library added to your flex project. Check out this post for directions on how to do this.
			
		
		
		
	
				
			Fanch Says:

			
			March 12th, 2008 at 11:21 am 
			
			Thanks a lot for your tutorial, I learned so much with it.
Wallah and Bam are a good way to captivate the french speaker I am  
			
		
		
		
	
				
			Pradeep Says:

			
			June 4th, 2008 at 4:41 am 
			
			hi,
i am having the error,
1120: Access of undefined property JSON
i have imported corelib to project and bin and projectbuildpath->libraries

Please help
			
		
		
		
	
				
			Omid Says:

			
			June 27th, 2008 at 4:42 pm 
			
			TNX
			
		
		
		
	
				
			Katy Says:

			
			July 8th, 2008 at 4:38 am 
			
			Hi,

I’ve just started out with Flex 3 and I want to retrieve some information for a database and display it as links. Is it possible to retrieve data from a database without using the datagrid?
			
		
		
		
	
				
			devilkin Says:

			
			July 11th, 2008 at 6:05 am 
			
			Thanks a lot!
			
		
		
		
	
				
			Alex Says:

			
			September 20th, 2008 at 2:38 pm 
			
			i am getting this error
1120: Access of undefined property JSON
I added corelibs to project path.
Can someone help?. 
thanks.
			
		
		
		
	
	

 
Tracebacks / Pingbacks




Using Flex, PHP, and JSON to Modify a MySQL Database « FlashColony webmaster’s blog

August 3rd, 2007 at 7:53 pm 


																	     




Leave a Comment





Name


Mail (will not be published)


Website









	Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.




Powered by WP Hashcash

Using Flex, PHP, and JSON to Modify a MySQL Database

34 Responses

Tracebacks / Pingbacks

Leave a Comment

Search Posts

Pages

Categories

Recent Posts

Archives

Meta