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