View Single Post

  #4 (permalink)  
Old 06-28-2003
James Sleeman
 
Posts: n/a
Default Re: Making PHP return SQL result to a different page

hex kid wrote:

> SQLinterp.php
> <?php
> // read the database
> // and output something like this
> echo "
> <data>
> <row><id>1</id><name>David</name></row>
> <row><id>4</id><name>hexkid</name></row>
> </data>
> ";
> ?>
> mypage.php
> <?php
> // ...
> $data = implode('',
> file('http://database.server/SQLinterp.php?' .
> 'q="select id, name from users"')
> );
> // and now parse $data
> // ...
> ?>


or easier...
SQLinterp.php
<?php
$data = array();
// Fill $data with rows from your query
echo serialize($data);
?>

mypage.php
<?php
$data = trim(implode('',
file('http://database.server/SQLinterp.php?' .
'q="select id, name from users"')
));
$data = unserialize($data);

// Work with $data, no parsing needed :-)
?>

--
James Sleeman
Gogo:Code http://www.gogo.co.nz/
Email domain : gogo.co.nz see user in from header!
Reply With Quote