Re: [PHP] XML Next 25 Results

2001-08-07 Thread Girish Nath 

Hi Gerry

The XML isn't coming directly from a database, it's coming from an IIS
server that i query (i generate XML file containing the parameters of the
query, POST it to the IIS machine, it runs some .ASP to query an inhouse
database, then POST the XML results back to me)

I then parse the XML to generate a HTML table, however sometimes i may end
up with a massive table, and i'm trying to find a way to break that table
into pages of 25 results. However, i'm completely stumped how to do this :(

Regards


Girish

--

 function fetchXML($parameters, $request) {

 $appserverIP = 123.456.789.10;
 $appserverPort = 8080;
 $appserverPacketSize = 4096;
 $phpServer = aeris;

  $header .= POST /directory/ . $request .  HTTP/1.1\r\n;
  $header .= Host:  . $phpServer . \r\n;
  $header .= User-Agent: PHP\r\n;
  $header .= Content-type: application/x-www-form-urlencoded\r\n;
  $header .= Content-length:  . strlen($parameters).\r\n;
  $header .= Connection: close\r\n\r\n;

  $fp = fsockopen($appserverIP,$appserverPort);

   if ($fp) {
   fputs($fp, $header . $parameters);

   while (!feof($fp)) {
   $response .= fgets($fp,$appserverPacketSize);
   }

   fclose($fp);
   }

  return cleanXML($response);// custom function to strip HTTP
headers from fetched data.

 }





- Original Message -
From: Gerry Kirk [EMAIL PROTECTED]
To: Girish Nath [EMAIL PROTECTED]
Sent: Tuesday, August 07, 2001 5:22 AM
Subject: Re: [PHP] XML Next 25 Results


Hello Girish,

I can't help you with your problem, as I am just getting acquainted with
XML myself. I've been doing some research to assess the feasibility of
using PHP and XML for a web-based database-driven application.

If you don't mind, could you share with me how you are using XML? Are you
retrieving / querying / storing data from a database?

Thanks,
Gerry Kirk



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP] XML Next 25 Results

2001-08-07 Thread Girish Nath 

Hi

I'd thought of specifying the limit in the request but unfortunately that
option isn't available to me :(

I've just downloaded an xpath class from phpxml.org, looks really kewl, and
i hope it can allow me to do this.

Thanks



Girish


- Original Message -
From: Gerry Kirk [EMAIL PROTECTED]
To: Girish Nath [EMAIL PROTECTED]
Sent: Tuesday, August 07, 2001 8:19 AM
Subject: Re: [PHP] XML Next 25 Results


I think the best approach would be if you could specify in your query the
number of rows you want and the starting row number. In MySQL, you can do
that with LIMIT(row_num, #_rows).

Otherwise, it may be possible to use an XPath function that matches against
the current index of a particular XML element. Are you using XSLT at all?

Gerry

At 07:37 AM 07/08/01 +0100, you wrote:
Hi Gerry

The XML isn't coming directly from a database, it's coming from an IIS
server that i query (i generate XML file containing the parameters of the
query, POST it to the IIS machine, it runs some .ASP to query an inhouse
database, then POST the XML results back to me)

I then parse the XML to generate a HTML table, however sometimes i may end
up with a massive table, and i'm trying to find a way to break that table
into pages of 25 results. However, i'm completely stumped how to do this :(

Regards


Girish

--

  function fetchXML($parameters, $request) {

  $appserverIP = 123.456.789.10;
  $appserverPort = 8080;
  $appserverPacketSize = 4096;
  $phpServer = aeris;

   $header .= POST /directory/ . $request .  HTTP/1.1\r\n;
   $header .= Host:  . $phpServer . \r\n;
   $header .= User-Agent: PHP\r\n;
   $header .= Content-type: application/x-www-form-urlencoded\r\n;
   $header .= Content-length:  . strlen($parameters).\r\n;
   $header .= Connection: close\r\n\r\n;

   $fp = fsockopen($appserverIP,$appserverPort);

if ($fp) {
fputs($fp, $header . $parameters);

while (!feof($fp)) {
$response .= fgets($fp,$appserverPacketSize);
}

fclose($fp);
}

   return cleanXML($response);// custom function to strip HTTP
headers from fetched data.

  }





- Original Message -
From: Gerry Kirk [EMAIL PROTECTED]
To: Girish Nath [EMAIL PROTECTED]
Sent: Tuesday, August 07, 2001 5:22 AM
Subject: Re: [PHP] XML Next 25 Results


Hello Girish,

I can't help you with your problem, as I am just getting acquainted with
XML myself. I've been doing some research to assess the feasibility of
using PHP and XML for a web-based database-driven application.

If you don't mind, could you share with me how you are using XML? Are you
retrieving / querying / storing data from a database?

Thanks,
Gerry Kirk



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP] XML Next 25 Results

2001-08-06 Thread Girish Nath 

Hi

I have a script which receives and processes XML product information and
displays it as a table in html.
However, sometimes the html table can contain over 200 rows.

Does anyone know of any xml parse examples which limit the output and
possibly make a Display Next 25 results link at the base of the table ?

Thank you


Gish


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]