ok first this is my function in flex, to connect tp my mobile db get the
parameters and using a http service to connect with my code in php
protected function sinc_button_clickHandler():void
{
// TODO Auto-generated method stub
var contactListStatement:SQLStatement = new
SQLStatement();
contactListStatement.sqlConnection =
DataModel.getInstance().connection;
contactListStatement.text = "SELECT * FROM
GASTOS";
contactListStatement.execute();
var result:SQLResult =
contactListStatement.getResult();
if( result.data!=null)
{
DataModel.getInstance().contactList.removeAll();
for(var
count:uint=0;count<result.data.length;count++)
{
var contactVO:ContactVO = new
ContactVO();
contactVO.idgasto =
result.data[count].idgasto;
contactVO.concepto =
result.data[count].concepto;
contactVO.fecha =
result.data[count].fecha;
contactVO.monto =
result.data[count].monto;
contactVO.observaciones =
result.data[count].observaciones;
contactVO.recurso =
result.data[count].recurso;
var inserta_bd:HTTPService=new
HTTPService();
//inserta_bd.url =
"http://localhost/web/insertargasto_flex_bd.php";;
inserta_bd.url =
"http://www.mobileintegrationlab.com/autosfin/web/insertargasto_flex_bd.php";;
inserta_bd.method = "POST";
var parameters_bd:Object=new
Object();
parameters_bd ["concepto"] =
result.data[count].concepto;
parameters_bd ["from"]
=result.data[count].fecha;
parameters_bd ["monto"] =
result.data[count].monto;
parameters_bd ["observaciones"]
= result.data[count].observaciones;
parameters_bd ["recurso"] =
result.data[count].recurso;
inserta_bd.send(parameters_bd) ;
DataModel.getInstance().contactList.addItem(contactVO);
}
}
2) this is my php that catches the parameters
<?php
include("dbconnect.php");
$table_name="gastos";
$concepto=$_POST['concepto'];
$fecha=$_POST['from'];
$monto=$_POST['monto'];
$observaciones=$_POST['observaciones'];
$recurso=$_POST['recurso'];
$sql_con="select * from gastos WHERE concepto='".$concepto."' AND
fecha='".$fecha."' AND recurso='".$recurso."'";
$result_con=mysql_query($sql_con);
if ($data=mysql_fetch_array($result_con))
{
$idgasto=$data[idgasto];
$upd_gasto=" update $table_name set concepto='".$concepto."',
fecha='".$fecha."', monto='".$monto."', observaciones='".$observaciones."',
recurso='".$recurso."' where idgasto=".$idgasto;
$result_upd=mysql_query($upd_gasto);
}
else
{
$ins_usuario2="insert into gastos values
(NULL,'$concepto','$fecha','$monto','$observaciones','$recurso')";
$result2=mysql_query($ins_usuario2);
}
?>
so what i need to do is to do the opposite wich is now to retrieve the data in
my phone, in short words a get in flex
