[RESOLVED] How to retrieved results stored in a session

mjgdunne

Hi i have stored variable results in $results, how would i retrieve the results from the session so i can echo out the results.
Any help would be great.

laserlight

You would need to store the contents of $results in the session, e.g.,

$_SESSION['results'] = $results;

mjgdunne

Ya i have that done, the result holds query results, i have tried to use the results in another script when the user selects edit that the details from the query appears in input boxes.
Here is what iv being trying to use to retrieve the results:

$row = mysql_fetch_array($_SESSION['result']);

laserlight

Oh, now I understand. $result is a result resource from a database query. Resources cannot be serialised, and thus cannot be stored in session variables. What you should do is process the result set and store the retrieved data in an array that is then registered in the session.

mjgdunne

How would i do that, im new to php her is my code so far:

<?php
 session_start();
 ?>
<html>
<head>
	<title>Car Rentals & Returns</title>
	<meta http-equiv="Content-Type" content="text/html" />
	<link href="style2.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="wrapper3">
<img src="images/cars.jpg" width="996" height="100"></a>

<TABLE BGCOLOR="#F0F8FF" BORDER=0 CELLPADDING=10 WIDTH=100%>
<tr>
<td align="center">
<H1>Search Results:</H1>

</td>
</table>

<TABLE BGCOLOR="#F0F8FF" BORDER=0 CELLPADDING=10 WIDTH=30%>
<tr>
<TD ALIGN=CENTER VALIGN=TOP WIDTH=50>
</TD>
<TD ALIGN=LEFT VALIGN=TOP WIDTH=83%>
<TR><TD>



<?php


ini_set( 'display_errors', '1' );
error_reporting ( 2047 );


$host="localhost"; // Host name
$username="root"; // Mysql username
$password="root"; // Mysql password
$db_name="test"; // Database name
$tbl_name="members"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "root", "root")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$myq=$_POST['myq'];



if (isset($_POST['myq'])) {
    $myq = mysql_real_escape_string($_POST['myq']);
    $result = mysql_query("SELECT * FROM members WHERE Firstname LIKE '%$myq' OR Surname LIKE '%$myq'");

$_SESSION['result'] = $result;


while ($row = mysql_fetch_assoc($result)) {

echo "<p>You searched for: &quot;" . $myq . "&quot;</p>";


echo "<table border=\"1\" align=\"center\">";

echo "<tr><th>First Name</th>";
		echo "<td>";
		echo $row['Firstname'];
echo "</td>";

echo "<tr><th>Surname</th>";
		echo "<td>";
		echo $row['Surname'];
echo "</td>";

echo "<tr><th>Username</th>";
		echo "<td>";
		echo $row['username'];
echo "</td>";

echo "<tr><th>Password</th>";
		echo "<td>";
		echo $row['password'];
echo "</td>";

echo "<tr><th>Email</th>";
		echo "<td>";
		echo $row['email'];
echo "</td>";

echo "<tr><th>Level</th>";
		echo "<td>";
		echo $row['level'];
echo "</td>";



}
}

if (!$result) {
    $message  = 'Invalid query: ' . mysql_error() . "\n";
    $message .= 'Whole query: ' . $query;
    die($message);
}

if (mysql_num_rows($result) == 0) {
    echo "No records found";
    exit;
}




?>


<TABLE BGCOLOR="#F0F8FF" BORDER=0 CELLPADDING=10 WIDTH=100%>
<tr>
<form action="edit_emp.php" method="post">
<input type="submit" value="Edit Details"/>
</form>
<form method="post" action="login_success3.php">
<td align="center"><input type="submit" value="Home"/></form>
</td>
</tr>
</table>
</table>
</td>
</tr>
</table>
</BODY>
</HTML>

And i want to use the result to display in:

<?php
session_start();
?>

<html>
<head>
	<title>Car Rentals & Returns</title>
	<meta http-equiv="Content-Type" content="text/html" />
	<link href="style2.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="wrapper3">
<img src="images/cars.jpg" width="996" height="100"></a>

<TABLE BGCOLOR="#F0F8FF" BORDER=0 CELLPADDING=10 WIDTH=100%>
<tr>
<td align="center">
<H1>Search Results:</H1>
<form action="edit_emp.php" method="post">
</td>
</table>

<TABLE BGCOLOR="#F0F8FF" BORDER=0 CELLPADDING=10 WIDTH=30%>
<tr>
<TD ALIGN=CENTER VALIGN=TOP WIDTH=50>
</TD>
<TD ALIGN=LEFT VALIGN=TOP WIDTH=83%>
<TR><TD>


<?php

$_SESSION['result'] = "$result";

ini_set( 'display_errors', '1' );
error_reporting ( 2047 );


$host="localhost"; // Host name
$username="root"; // Mysql username
$password="root"; // Mysql password
$db_name="test"; // Database name
$tbl_name="members"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "root", "root")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");



$row = mysql_fetch_array($_SESSION['result']);





echo "<table border=\"1\" align=\"center\">";

echo "<tr><th>First Name</th>";
		echo "<td>";
		echo '<input type="text" name="firstname" value="'. $row['Firstname'] .'" size="20" />';
echo "</td>";

echo "<tr><th>Surname</th>";
		echo "<td>";
		echo '<input type="text" name="surname" value="'. $row['Surname'] .'" size="20" />';
echo "</td>";

echo "<tr><th>Username</th>";
		echo "<td>";
		echo '<input type="text" name="username" value="'. $row['username'] .'" size="20" />';
echo "</td>";

echo "<tr><th>Password</th>";
		echo "<td>";
		echo '<input type="text" name="password" value="'. $row['password'] .'" size="20" />';;
echo "</td>";

echo "<tr><th>Email</th>";
		echo "<td>";
		echo '<input type="text" name="email" value="'. $row['email'] .'" size="20" />';
echo "</td>";

echo "<tr><th>Level</th>";
		echo "<td>";
		echo '<input type="text" name="level" value="'. $row['level'] .'" size="20" />';
echo "</td>";



exit();
?>


<TABLE BGCOLOR="#F0F8FF" BORDER=0 CELLPADDING=10 WIDTH=100%>
<tr>
<input type="submit" value="Update Details"/>
</form>
<form method="post" action="login_success3.php">
<td align="center"><input type="submit" value="Home"/></form>
</td>
</tr>
</table>
</table>
</td>
</tr>
</table>
</BODY>
</HTML>

Any help would be great, thanks.

laserlight

You could do this:

$_SESSION['members'] = array();
while ($row = mysql_fetch_assoc($result)) {
	$_SESSION['members'][] = $row;
}

Now, instead of loop over the result set with mysql_fetch_assoc(), you can use the $_SESSION['members'] array, which contains the same data.

mjgdunne

Sorry i dont really follow where abouts do i add this code, and do i leave in the other session?

laserlight

Basically, instead of:

$_SESSION['result'] = $result;

while ($row = mysql_fetch_assoc($result)) {
	echo "<p>You searched for: &quot;" . $myq . "&quot;</p>";
	// ...
}

You write:

$_SESSION['members'] = array();
while ($row = mysql_fetch_assoc($result)) {
    $_SESSION['members'][] = $row;
}

foreach ($_SESSION['members'] as $row) {
	echo "<p>You searched for: &quot;" . $myq . "&quot;</p>";
	// ...
}

Then in the second script you get the member data from $_SESSION['members'] as well.

mjgdunne

Thats great thanks, but in the second script how do i get the data from the session to print out. Sorry i know this is propably very basic to you.

echo '<input type="text" name="firstname" value="'. $row['Firstname'] .'" size="20" />';

laserlight

Thats great thanks, but in the second script how do i get the data from the session to print out.

The same way you got it to print out in the first script since it is the same data.

mjgdunne

Is this wrong:

<?php
session_start();
?>

<html>
<head>
<title>Car Rentals & Returns</title>
<meta http-equiv="Content-Type" content="text/html" />
<link href="style2.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="wrapper3">
<img src="images/cars.jpg" width="996" height="100"></a>

<TABLE BGCOLOR="#F0F8FF" BORDER=0 CELLPADDING=10 WIDTH=100%>
<tr>
<td align="center">
<H1>Search Results:</H1>
<form action="edit_emp.php" method="post">
</td>
</table>

<TABLE BGCOLOR="#F0F8FF" BORDER=0 CELLPADDING=10 WIDTH=30%>
<tr>
<TD ALIGN=CENTER VALIGN=TOP WIDTH=50>
</TD>
<TD ALIGN=LEFT VALIGN=TOP WIDTH=83%>
<TR><TD>

<?php

$_SESSION['result'] = "$result";

ini_set( 'display_errors', '1' );
error_reporting ( 2047 );

$host="localhost"; // Host name
$username="root"; // Mysql username
$password="root"; // Mysql password
$db_name="test"; // Database name
$tbl_name="members"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "root", "root")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$row = mysql_fetch_array($_SESSION['members']);

echo "<table border=\"1\" align=\"center\">";

echo "<tr><th>First Name</th>";
echo "<td>";
echo '<input type="text" name="firstname" value="'. $row['Firstname'] .'" size="20" />';
echo "</td>";

echo "<tr><th>Surname</th>";
echo "<td>";
echo '<input type="text" name="surname" value="'. $row['Surname'] .'" size="20" />';
echo "</td>";

echo "<tr><th>Username</th>";
echo "<td>";
echo '<input type="text" name="username" value="'. $row['username'] .'" size="20" />';
echo "</td>";

echo "<tr><th>Password</th>";
echo "<td>";
echo '<input type="text" name="password" value="'. $row['password'] .'" size="20" />';;
echo "</td>";

echo "<tr><th>Email</th>";
echo "<td>";
echo '<input type="text" name="email" value="'. $row['email'] .'" size="20" />';
echo "</td>";

echo "<tr><th>Level</th>";
echo "<td>";
echo '<input type="text" name="level" value="'. $row['level'] .'" size="20" />';
echo "</td>";

exit();
?>

<TABLE BGCOLOR="#F0F8FF" BORDER=0 CELLPADDING=10 WIDTH=100%>
<tr>
<input type="submit" value="Update Details"/>
</form>
<form method="post" action="login_success3.php">
<td align="center"><input type="submit" value="Home"/></form>
</td>
</tr>
</table>
</table>
</td>
</tr>
</table>
</BODY>
</HTML>

Thanks, you have being a great help.

laserlight

Is this wrong:

You really should just try it and see...

but I can say that at a glance:

$row = mysql_fetch_array($_SESSION['members']);

is wrong. You want a foreach loop instead, or at the very least:

$row = $_SESSION['members'][0];

mjgdunne

Thank you so much for your help you have been great, Its working perfectly now.
Thanks 🙂