[flexcoders] Insert simple record into PostgreSQL using AMFPHP + Flex

[Harry Saputra]

Dear all, 

 

I have retrieve a record from PostgreSQL and now  try to insert simple
record into PostgreSQL using AMFPHP like that :

 

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

<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml"; layout="absolute"
creationComplete="onInit()">

                <mx:Script>

                

                [Bindable]

                public var dataProvider:Array;

 

                [Bindable]

                public var errorMsg:String;

 

                import flash.net.Responder;

 

                public var gateway:NetConnection;

 

                public function onInit():void

                                {

                                                gateway = new
NetConnection();

 
gateway.connect("../../amfphp/gateway.php");

                                                getPerson();

 

                                }

                                

                                public function getPerson():void {

 
gateway.call("PersonService.getPerson", new Responder(getResult, onFault));

                                }

 

                                public function getResult(result:Array):void
{

                                                dataProvider = result;

                                }

 

                                public function insertPerson():void {

                                                var newUser:Object = new
Object();

                                                newUser.id=txtId.text;

                                                newUser.first=txtFirst.text;

                                                newUser.last=txtLast.text;

                                                newUser.age=txtAge.text;

 
gateway.call("PersonService.insertPerson", new Responder(null, onFault),
newUser );

                                }

 

                                                

                                public function onFault( fault : String ) :
void

                                                {

                                                                trace( fault
);

                                                }

                

 

                </mx:Script>

                <mx:DataGrid id="dgPersons" dataProvider="{dataProvider}"
width="382" x="10" height="154" y="10">

                                <mx:columns>

                                                <mx:DataGridColumn
headerText="id" dataField="pid"/>

                                                <mx:DataGridColumn
headerText="first" dataField="first_name"/>

                                                <mx:DataGridColumn
headerText="last" dataField="last_name"/>

                                                <mx:DataGridColumn
headerText="age" dataField="age"/>

                                </mx:columns>

                </mx:DataGrid>

                

                <mx:Form x="10" y="172">

                                <mx:FormItem label="Person ID">

                                                <mx:TextInput id="txtId" />

                                </mx:FormItem>

                                

                                <mx:FormItem label="First">

                                                <mx:TextInput id="txtFirst"
/>

                                </mx:FormItem>

                                

                                <mx:FormItem label="Last">

                                                <mx:TextInput id="txtLast"
/>

                                </mx:FormItem>

                                

                                <mx:FormItem label="Age">

                                                <mx:TextInput id="txtAge" />

                                </mx:FormItem>

                                

                                <mx:Button click="insertPerson()" label="Go
!!" />

                </mx:Form>

                

</mx:Application>

 

 

And on server side ( PHP ) :

 

<?php

class PersonService

{

                function PersonService()

                {

                                

                                include("PersonService.methodTable.php");


                                $dbase = pg_connect("dbname=amfphp
user=postgres password=root");

                }

                

                function getPerson()

                {

                                

                                $sql = "SELECT * FROM PERSON ";

                                $result = pg_query($sql);

                                

                                                while ($row =
pg_fetch_object($result)) 

                                                                {

                                                                $return[] =
$row;

                                                                }

 

                                return($return);

                }

                

                function InsertPerson($user)

                {

                                $id = $user['id'];

                                $first = $user['first'];

                                $last = $user['last'];

                                $age = $user['age'];

                                $sql = sprintf("INSERT INTO PERSON VALUES (
%d, '%s', '%s', %d ) ", $id, $first, $last, $age);

                                return pg_query($sql);

                }

}

 

?>

 

I can retrieve correctly, but can't insert and retrieve again after insert.

 

Please help me. Thanks J