|
|
phpsoa |
One way you could achieve this is:
XSD:
<xsd:complexType name="EmployeeList">
<xsd:complexType name="EmployeeList_T">
PHP
$sth = $this->PDO->prepare("SELECT employeeID, employeeName, employeeAddress FROM EMPLOYEE;");
$employeeList = SCA::createDataObject('your/xsd/namespace', 'EmployeeList');
while($row = $sth->fetch(PDO::FETCH_OBJ)){ HTH
dali
Hi all,
I have not found any examples that handle multiple rows of data
I have a service that returns multiple rows of result from a database
SELECT employeeID, employeeName, employeeAddress FROM EMPLOYEE;
Say the returned result is
1 | John | One Road
How can I represent that in xsd and how those results are going to put
Thanks in advance for any help.
<xsd:sequence>
<xsd:element name="Employee" type="EmployeeList_T" minOccurs="0" maxOccurs="unbounded" />
</xsd:sequence>
</xsd:complexType>
<xsd:sequence>
<xsd:element name="employeeID" type="xsd:integer" />
<xsd:element name="employeeName" type="xsd:string" />
<xsd:element name="employeeAddress" type="xsd:string" />
</xsd:sequence>
</xsd:complexType>
$sth->execute();
$employee = $employeeList->createDataObject('Employee');
$employee->employeeID = $row->employeeID;
$employee->employeeName = $row->employeeName;
$employee->employeeAddress = $row->employeeAddress;
}
There is probably a nicer way to merge the resulting row object into the SDO object, but you get the idea.
-----Original Message-----
From: phpsoa@googlegroups.com [mailto:phpsoa@googlegroups.com] On Behalf Of Alex
Sent: Sunday, 5 July 2009 5:08 a.m.
To: phpsoa
Subject: [phpsoa] multiple rows return ?
returned from database. Anyone can please show me an example? What I
have is this
query, for example
2 | Mark | Two Road
3 | Luke | Three Road
into the array to return the result from the services and at the
client side getting and displaying these results?