[color="red"]E aí galera!!! Tudo bem???!!!
Espero que alguém possa me ajudar... estou testando a parte de inserção do meu sistema e ocorre um erro na formação do xml (pelo menos foi isso que entendi...)
Alguém se habilita??? :oops: :oops: :oops: [/color]
Laszlo
<canvas bgcolor="#D4D0C8">
<dataset name="dsSendData" request="false" src="http://10.96.168.4/teste.php"/>
<class name="contactview" extends="view" visible="false" x="20" height="120">
<!-- 2 -->
<text name="pk" visible="false" datapath="@email"/>
<text y="10">First Name:</text>
<edittext name="firstName" datapath="@firstName" x="80" y="10"/>
<text y="35">Last Name:</text>
<edittext name="lastName" datapath="@lastName" x="80" y="35"/>
<text y="60">Phone:</text>
<edittext name="phone" datapath="@phone" x="80" y="60"/>
<text y="85">Email:</text>
<edittext name="email" datapath="@email" x="80" y="85"/>
<method name="sendData" args="action">
var d=canvas.datasets.dsSendData; // 3
var p=new LzParam(); // 3a
p.addValue("action", action, true);
p.addValue("pk", pk.getText(), true);
p.addValue("firstName", firstName.getText(), true);
p.addValue("lastName", lastName.getText(), true);
p.addValue("phone", phone.getText(), true);
p.addValue("email", email.getText(), true); // 3b
d.setQueryString(p); // 3c
d.doRequest(); // 3d
</method>
<!-- 4 -->
</class>
<simplelayout axis="y"/>
<view>
<simplelayout axis="y"/>
<text onclick="parent.newContact.setVisible(!parent.newContact.visible);">New Entry...</text>
<contactview name="newContact" datapath="new:/contact">
<button width="80" x="200" y="10">Add
<handler name="onclick">
parent.sendData("insert"); // 5
<!--parent.datapath.updateData();-->
var dp=canvas.datasets.dset.getPointer();
dp.selectChild();
dp.addNodeFromPointer( parent.datapath );
parent.setVisible(false);
parent.setDatapath("new:/contact");
</handler>
</button>
</contactview>
</view>
</canvas>
PHP - teste.php
<?php
foreach( $HTTP_GET_VARS as $key => $value )
{
$$key = $value;
}
foreach( $HTTP_POST_VARS as $key => $value )
{
$$key = $value;
}
$conex1 = pg_connect("dbname=postgres port=5432 host=localhost user=postgres password=postgres");
if ($conex1) {
//Caso queira Imprimir na Tela a mensagem, retirar o comentário
//echo "Conectado com: " . pg_host($conex1) . "<br/> ";
}
else {
echo pg_last_error($conex1);
exit;
}
$result = pg_exec ($conex1, "INSERT INTO contact values ('$firstName','$lastName','$phone','$email')");
pg_close ($conex1);
?>