On 12/11/05, Christopher Jordan <[EMAIL PROTECTED]> wrote:
>
> Hi folks,
>
> I'm a ColdFusion developer, but I'm branching out into PHP because alot
> of my smaller clients don't want to pay for CF.
>
> Anyway, a bit of background:
>
> I've got a page that does a search on one of my tables. I'm
> using Justin Vincent's ezSQL (http://php.justinvincent.com) to fetch
> the result set into an object that can be referenced nicely. Here's
> what his example code looks like:
>
> // Select multiple records from the database and print them
> out..
> $users = $db->get_results("SELECT name, email FROM users");
> foreach ( $users as $user ){
> // Access data using object syntax
> echo $user->name;
> echo $user->email;
> }
>
> So far so good. So I've got an iframe on the page which (I hope)
> will eventually display the results of the search. The user will then
> click on the search result for which they want to view the details, and
> the information from that row will be populated inside the main page
> (the one that houses the iframe).
>
> Hope that makes sense.
>
> Okay, so my trouble is that I don't know how to enable the page
> inside the iframe to have access to the result object created by
> Justin Vincent's nifty little class. In CF I can just say:
>
> session.oResults = queryname
>
> CF automatically returns any query as an object with the name of
> the query as the object name (i.e. queryname.MyIdField, or
> queryname.EmployeeNumber, etc.) Using a line like the one
> above (assigning the query object to a session variable) all of my
> subsequent requests would have access to that result set simply by using
> the object.
>
> I'm *sure* there's a way to do this in PHP. I'm just falling short of
> finding the answer. I've tried:
>
> $_SESSION["SearchResult"] = $db->get_results($query);
>
> But it doesn't seem to work. I may have some other problem using the
> object. I just re-read my error and it says:
>
> Fatal error: Call to a member function get_results() on a non-object in
> inventorymanager.php on line 93
>
> hmm... I sure would appreciate a little guidence here. Even if
> my problem is with the way I'm using the object, is the idea of
> assigning that object to the session scope the right way to do this or is
> there a better approach. To that end, I suppose I'm looking for an idea of
> the best practice.
>
> Thanks!
> Christopher Jordan
> Planet Access
> Arlington, TX
Fatal error: Call to a member function get_results() on a non-object in
inventorymanager.php on line 93
This means what it says. When you call $db->get_results it is saying the
class $db isn't set. If this is inside of your IFRAME and not the search
page (or however you have this set up), make sure to get an instance of db
before you call session_start(). Otherwise php will cry about having an
object in the session with no name.
If db->get_results returns an array then you can access your data like this:
page 1:
$_SESSION["SearchResult"] = $db->get_results("SELECT name, email FROM
users");
page 2:
foreach ($_SESSION["SearchResult"] as $user ){
I hope some of that helps or might point you in the right direction.
