Transfer query result to another script
| From: | C.R.Vegelin | Date: | Thu, 01 Nov 2007 16:47:53 +0000 |
| Subject: | Transfer query result to another script | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-263923@lists.php.net to get a copy of this message | ||
Hi All,
Q: Is it possible to transfer a query result to another script ?
For example with (fragments of) the following 2 scripts:
Engine.php
----------------
$result = mysqli_query($connect, $myquery);
if (!$result) error ...
if (mysqli_num_rows($result) == 0) error ...
$_SESSION['result'] = $result;
header("Location: Report.php");
Report.php
----------------
$result = $_SESSION['result'];
while ($row = mysqli_fetch_array($result)) ...
This last line gives "Couldn't fetch mysqli_result".
Is this because the result set is local to Engine.php ?
TIA, Cor