need PEAR DB help - Codewalkers

Codewalkers Forums Sponsor:

July 20th, 2005, 02:27 AM

Anonymous

Registered User

Codewalkers God 35th Plane (22000 - 22499 posts)

Join Date: Apr 2007

Posts: 22,309

Time spent in forums: < 1 sec
Reputation Power: 25

need PEAR DB help

Hi,

I need help on using PEAR and PEAR DB. Please help me out.

------------------------------
First of all, these are the steps I have already taken.

I installed PEAR on my website via ftp (with go-pear.php that is on pear.php.net) because Network Solutions, (my host) does not allow me to access php.ini

I am 80% sure that PEAR DB came with go-pear. I see DB.php and DB folder in my /htdocs/libs/PEAR directory as I chose.

I read examples from a book and wrote DBManager class and did some queries.

***** Note: My site uses PHP 4, not PHP 5. So, I wrote my classes without __CONSTRUCTOR, private and public keywords
------------------------------

Okay, so here is my problem.

My website is going to be online store and well, the departments aren't displaying! (This is driving me nutz.)

I get no errors and none of my database connection error messages are printed on the website so I assume DB connected fine.

-----------------------------

Here is some of my code that is relevant to this. (I use the SMARTY template engine which I had no problems with so far)

// config.inc.php

php Code:

Original - php Code

 
 
<?php        
// SITE_ROOT contains the full path to the tshirtshop folder
define("SITE_ROOT", dirname(dirname(__FILE__)));
// Settings needed to configure the Smarty template engine
define("SMARTY_DIR", SITE_ROOT."/libs/smarty/");
define("TEMPLATE_DIR", SITE_ROOT."/templates");
define("COMPILE_DIR", SITE_ROOT."/templates_c");
define("CONFIG_DIR", SITE_ROOT."/configs");
 
if ((substr(strtoupper(PHP_OS), 0, 3)) == "WIN") 
  define("PATH_SEPARATOR", ";");
else      
  define("PATH_SEPARATOR", ":");
ini_set('include_path', SITE_ROOT . '/libs/PEAR' . 
         PATH_SEPARATOR . ini_get('include_path'));
// database login info
define("USE_PERSISTENT_CONNECTIONS", "true");
define("DB_SERVER", "214.298.196.65");
define("DB_USERNAME", "scrooge");
define("DB_PASSWORD", "bah");
define("DB_DATABASE", "humbug");
define("MYSQL_CONNECTION_STRING", "mysql://" . DB_USERNAME . ":" . 
        DB_PASSWORD . "@" . DB_SERVER . "/" . DB_DATABASE);
 
 
?>

// database.php

php Code:

Original - php Code

<?php

// reference the PEAR DB library
require_once SITE_ROOT.'/libs/PEAR/DB.php';
// class providing generic data access functionality
class DbManager
{         
  var $db;

// open database connection in the constructor  
  function DbManager($connectionString)         
  {                                               
    $this->db = DB::connect($connectionString,    
                                USE_PERSISTENT_CONNECTIONS);
    if (DB::isError($this->db))                   
       trigger_error($this->db->getMessage(), E_USER_ERROR);
    $this->db->setFetchMode(DB_FETCHMODE_ASSOC);  
  }     
  // close the connection                         
  function DbDisconnect()                  
  {                                               
    $this->db->disconnect();                      
  }    
  function DbQuery($queryString)           
  {                                               
    $result = $this->db->query($queryString);     
    if (DB::isError($result))                     
       trigger_error($result->getMessage(), E_USER_ERROR);
    return $result;                               
  }  
  // wrapper class for PEAR DB's getAll() method  
  function DbGetAll($queryString)          
  {                                               
    $result = $this->db->getAll($queryString);    
    if (DB::isError($result))                     
       trigger_error($result->getMessage(), E_USER_ERROR);
    return $result;                               
  }    
  // wrapper class for PEAR DB's getRow() method
  function DbGetRow($queryString)
  {     
    $result = $this->db->getRow($queryString);
    if (DB::isError($result))
       trigger_error($result->getMessage(), E_USER_ERROR);
    return $result;
  }     
  // wrapper class for PEAR DB's getOne() method
  function DbGetOne($queryString)
  {     
    $result = $this->db->getOne($queryString);
    if (DB::isError($result))
       trigger_error($result->getMessage(), E_USER_ERROR);
    return $result;
  }     
                     
                       
}
                                                 
?>

 
<?php     
 
// reference the PEAR DB library
require_once SITE_ROOT.'/libs/PEAR/DB.php';
// class providing generic data access functionality
class DbManager
{         
  var $db;  
 
  // open database connection in the constructor  
  function DbManager($connectionString)         
  {                                               
    $this->db = DB::connect($connectionString,    
                                USE_PERSISTENT_CONNECTIONS);
    if (DB::isError($this->db))                   
       trigger_error($this->db->getMessage(), E_USER_ERROR);
    $this->db->setFetchMode(DB_FETCHMODE_ASSOC);  
  }     
  // close the connection                         
  function DbDisconnect()                  
  {                                               
    $this->db->disconnect();                      
  }    
  function DbQuery($queryString)           
  {                                               
    $result = $this->db->query($queryString);     
    if (DB::isError($result))                     
       trigger_error($result->getMessage(), E_USER_ERROR);
    return $result;                               
  }  
  // wrapper class for PEAR DB's getAll() method  
  function DbGetAll($queryString)          
  {                                               
    $result = $this->db->getAll($queryString);    
    if (DB::isError($result))                     
       trigger_error($result->getMessage(), E_USER_ERROR);
    return $result;                               
  }    
  // wrapper class for PEAR DB's getRow() method
  function DbGetRow($queryString)
  {     
    $result = $this->db->getRow($queryString);
    if (DB::isError($result))
       trigger_error($result->getMessage(), E_USER_ERROR);
    return $result;
  }     
  // wrapper class for PEAR DB's getOne() method
  function DbGetOne($queryString)
  {     
    $result = $this->db->getOne($queryString);
    if (DB::isError($result))
       trigger_error($result->getMessage(), E_USER_ERROR);
    return $result;
  }     
                     
                       
}
                                                 
?>

July 20th, 2005, 02:30 AM

Anonymous

Registered User

Join Date: Apr 2007

Posts: 22,309

Time spent in forums: < 1 sec
Reputation Power: 25

RE: need PEAR DB help

// department_list.tpl
// using SMARYY template engine

{* departments_list.tpl *}
{load_departments_list assign="departments_list"}
{* start departments list *}
<table border="0" cellpadding="0" cellspacing="1" width="200">
<tr>
<td class="DepartmentListHead"> Choose a Department </td>
</tr>
<tr>
<td class="DepartmentListContent">
{* loop through the list of departments *}
{section name=i loop=$departments_list->mDepartments}
{* verify if the department is selected
to decide what CSS style to use *}
{if ($departments_list->mSelectedDepartment ==
$departments_list->mDepartments[i].department_id)}
{assign var=class_d value="DepartmentSelected"}
{else}
{assign var=class_d value="DepartmentUnselected"}
{/if}
{* generate a link for a new department in the list *}
<a class="{$class_d}"
href="{$departments_list->mDepartments[i].onclick}">
» {$departments_list->mDepartments[i].name}
</a>
<br/>
{/section}
</td>
</tr>
</table>
{* end departments list *}

July 20th, 2005, 02:32 AM

Anonymous

Registered User

Join Date: Apr 2007

Posts: 22,309

Time spent in forums: < 1 sec
Reputation Power: 25

RE: need PEAR DB help

// do_catalog.php

php Code:

Original - php Code

 
<?php  
// data tier class
class DoCatalog 
{      
  // class constructor
  function DoCatalog()
  {    
    // get the global DbManager instance (created in app_top.php)
    $this->dbManager = $GLOBALS['gDbManager'];
  }    
  // retrieves all departments
  function GetDepartments()
  {    
    $query_string = "SELECT department_id, name FROM department";
    $result = $this->dbManager->DbGetAll($query_string);
    return $result;
  }    
} //end DoCatalog
?>

// bo_catalog.php

php Code:

Original - php Code

<?php                                             
// reference the data tier                        
require_once SITE_ROOT.'/data_objects/do_catalog.php';
// business tier class for reading product catalog information
class BoCatalog                                   
{                                                                              
  var $mDoCatalog;                            
  // class constructor initializes the data tier object
  function BoCatalog()
  {    
    $this->mDoCatalog = new DoCatalog();
  }    
  // retrieves all departments
  function GetDepartments()
  {    
    $result = $this->mDoCatalog->GetDepartments();
    return $result;
  }    
} //end BoCatalog
?>

July 20th, 2005, 02:33 AM

Anonymous

Registered User

Join Date: Apr 2007

Posts: 22,309

Time spent in forums: < 1 sec
Reputation Power: 25

RE: need PEAR DB help

// function.load_departments_list.php

php Code:

Original - php Code

<?php           
// plugin functions inside plugin files must be named: smarty_type_name
function smarty_function_load_departments_list($params, $smarty)
{               
  $departments_list = new DepartmentsList();
  $departments_list->init();
  // assign template variable
  $smarty->assign($params['assign'], $departments_list);
}               
// Manages the departments list
class DepartmentsList
{               
  /* public variables available in departments_list.tpl Smarty template */
  var $mDepartments;                           
  var $mSelectedDepartment;                    
  /* private members */                           
  var $mBoCatalog;                            
  // constructor initializes business tier object 
  // and reads query string parameter             
  function DepartmentsList()                          
  {                                               
    // creating the middle tier object            
    $this->mBoCatalog = new BoCatalog();          
    // if DepartmentID exists in the query string, we're visiting a department
    if (isset($_GET['DepartmentID']))             
       $this->mSelectedDepartment = (int)$_GET['DepartmentID'];
    else                                          
       $this->mSelectedDepartment = -1;           
  }                                               
  // calls business tier method to read departments list 
  // and create their links                       
  function init()                                 
  {                                               
    // get the list of departments from the business tier
    $this->mDepartments = $this->mBoCatalog->GetDepartments();
    // create the department links                
    for ($i = 0; $i < count($this->mDepartments); $i++)
       $this->mDepartments[$i]['onclick'] = "index.php?DepartmentID=" . 
                                $this->mDepartments[$i]['department_id'];
  }                                               
} //end class                                     
?>

 
<?php           
// plugin functions inside plugin files must be named: smarty_type_name
function smarty_function_load_departments_list($params, $smarty)
{               
  $departments_list = new DepartmentsList();
  $departments_list->init();
  // assign template variable
  $smarty->assign($params['assign'], $departments_list);
}               
// Manages the departments list
class DepartmentsList
{               
  /* public variables available in departments_list.tpl Smarty template */
  var $mDepartments;                           
  var $mSelectedDepartment;                    
  /* private members */                           
  var $mBoCatalog;                            
  // constructor initializes business tier object 
  // and reads query string parameter             
  function DepartmentsList()                          
  {                                               
    // creating the middle tier object            
    $this->mBoCatalog = new BoCatalog();          
    // if DepartmentID exists in the query string, we're visiting a department
    if (isset($_GET['DepartmentID']))             
       $this->mSelectedDepartment = (int)$_GET['DepartmentID'];
    else                                          
       $this->mSelectedDepartment = -1;           
  }                                               
  // calls business tier method to read departments list 
  // and create their links                       
  function init()                                 
  {                                               
    // get the list of departments from the business tier
    $this->mDepartments = $this->mBoCatalog->GetDepartments();
    // create the department links                
    for ($i = 0; $i < count($this->mDepartments); $i++)
       $this->mDepartments[$i]['onclick'] = "index.php?DepartmentID=" . 
                                $this->mDepartments[$i]['department_id'];
  }                                               
} //end class                                     
?>

July 20th, 2005, 02:40 AM

Anonymous

Registered User

Join Date: Apr 2007

Posts: 22,309

Time spent in forums: < 1 sec
Reputation Power: 25

RE: need PEAR DB help

// index.tpl
// SMARTY template

php Code:

Original - php Code

{* smarty *}                                                 
{config_load file="site.conf"}                               
<!DOCTYPE html                                               
PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"              
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">   
<html>                                                       
  <head>                                                     
    <title>{#sitetitle#}</title>     
    <link href="tshirtshop.css" type="text/css" rel="stylesheet"/>                        
  </head>                                                    
  <body>                                                     
    <table cellspacing="0" cellpadding="0" width="750" border="0">
       <tr>                                                  
         <td width="200" height="100%" valign="top">         
           <table  width="100%" cellspacing="0" cellpadding="0">
              <tr>                                           
                <td valign="top" height="100%">              
                <br/>  
                {include file="departments_list.tpl"}           
                </td>                                        
              </tr>                                          
           </table>                                          
         </td>                                               
         <td>&nbsp;&nbsp;&nbsp;</td>                         
         <td valign="top" width="550"><br />                 
           {include file="header.tpl"}                       
           Place contents here                               
         </td>                                               
       </tr>                                                 
    </table>                                                 
  </body>                                                    
</html>

that's all of the templates and php files that uses PEAR DB. Other files are not relevant

Please show me what I am doing wrong and why my queried-department list of my webaite are not showing up.

- John

July 20th, 2005, 02:46 AM

Anonymous

Registered User

Join Date: Apr 2007

Posts: 22,309

Time spent in forums: < 1 sec
Reputation Power: 25

RE: need PEAR DB help

by the way, u might be wondering where header.tpl is. i do have it

this problem has to be an installation or algorithmic mistake. my syntax are all correct i believe

a lot of the code i got from a book i am reading

- John

July 20th, 2005, 05:53 AM

lig

"Forum Nazi"

Join Date: Apr 2007

Location: Jacksonville, Fl

Posts: 4,775

Time spent in forums: 4 Days 13 h 47 m 18 sec
Reputation Power: 7

RE: need PEAR DB help

This is more for my information -

Quick question - why did you make a wrapper class out of the DB class? All you are adding is another layer of abstraction with no (to me) added advantage.

Oh - I also didn't see any references. Without them you are copying the data not getting a reference.

July 20th, 2005, 11:55 AM

johnny

Join Date: Apr 2007

Location: NJ, USA

Posts: 7

Time spent in forums: < 1 sec
Reputation Power: 0

RE: RE: need PEAR DB help

Quote:

Well, it contains the error-handling code so after writing DBManager Class, I don't need to bother with that detail ever again

I forgot to also show this. (I think this is the reference that you mean. I also have app_botton.php that simply closes the mysql

// app_top.php

php Code:

Original - php Code
<?php // include utility files require_once 'config.inc.php'; require_once 'setup_smarty.php'; require_once 'database.php'; // global DbManager instance $gDbManager = new DbManager(MYSQL_CONNECTION_STRING); ?>

<?php                                                                                  
// include utility files                                                               
require_once 'config.inc.php';    
 
require_once 'setup_smarty.php';  
require_once 'database.php';                                 
// global DbManager instance                                 
$gDbManager = new DbManager(MYSQL_CONNECTION_STRING);                                                                                                                     
?>

July 20th, 2005, 04:32 PM

johnny

Join Date: Apr 2007

Location: NJ, USA

Posts: 7

Time spent in forums: < 1 sec
Reputation Power: 0

RE: need PEAR DB help

what exactly did you mean by reference?

im not sure

#10

July 20th, 2005, 11:25 PM

lig

"Forum Nazi"

Join Date: Apr 2007

Location: Jacksonville, Fl

Posts: 4,775

Time spent in forums: 4 Days 13 h 47 m 18 sec
Reputation Power: 7

RE: need PEAR DB help

http://www.php.net/manual/en/language.references.php

And you might also want to see here - http://www.php.net/manual/en/language.oop.php

I assume you are using php4

#11

July 20th, 2005, 11:58 PM

johnny

Join Date: Apr 2007

Location: NJ, USA

Posts: 7

Time spent in forums: < 1 sec
Reputation Power: 0

RE: need PEAR DB help

Yes, I am using php4

Ok, I have thoroughly read those pages but I don't see why it wouldn;t work without references

I am using $this operator

and it says on the site
"Note: There is no performance loss (since PHP 4 and up use reference counting) returning copies instead of references. On the contrary it is most often better to simply work with copies instead of references, because creating references takes some time where creating copies virtually takes no time (unless none of them is a large array or object and one of them gets changed and the other(s) one(s) subsequently, then it would be wise to use references to change them all concurrently). "

#12

July 21st, 2005, 12:53 AM

johnny

Join Date: Apr 2007

Location: NJ, USA

Posts: 7

Time spent in forums: < 1 sec
Reputation Power: 0

RE: need PEAR DB help

i made a dummy file testPEAR.php that doesn't use my DBManager class and just query a column

All it does is display Object on the screen

php Code:

Original - php Code
<?php include_once('DB.php'); $db = DB::connect("mysql://hthth:kkyukyk@215.158.178.13/departments"); if (DB::isError($db)) { print $db->getMessage(); exit; } else { $allnames = $db->getCol("SELECT name FROM departments;"); print $allnames . '<BR />'; } $db->disconnect(); ?>

 
<?php
    include_once('DB.php');
    $db = DB::connect("mysql://hthth:kkyukyk@215.158.178.13/departments");
    
    if (DB::isError($db)) {
        print $db->getMessage();
        exit;
    } else {
    
        $allnames = $db->getCol("SELECT name FROM departments;");
        print $allnames . '<BR />';
     
    }
 
    $db->disconnect();
?>

ok so what is going on?

#13

July 21st, 2005, 12:57 AM

johnny

Join Date: Apr 2007

Location: NJ, USA

Posts: 7

Time spent in forums: < 1 sec
Reputation Power: 0

RE: need PEAR DB help

why the heck is 'Object' being printed on the screen when i use PEAR's getCols() function?

#14

July 21st, 2005, 01:38 AM

johnny

Join Date: Apr 2007

Location: NJ, USA

Posts: 7

Time spent in forums: < 1 sec
Reputation Power: 0

RE: need PEAR DB help

wow, holy crap it's not recognizing a dam function in PEAR

...

#15

July 21st, 2005, 01:55 AM

johnny

Join Date: Apr 2007

Location: NJ, USA

Posts: 7

Time spent in forums: < 1 sec
Reputation Power: 0

RE: need PEAR DB help

it passed the db::isError test so it is connected but WHY ON EARTH IS NOT RECOGNIZING numCols, numRows, getCols,, getRows etc

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: