Questions from a ColdFusion Developer

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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
  

			
---------------------------------
Yahoo! Shopping
 Find Great Deals on Holiday Gifts at Yahoo! Shopping 

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux