Good PEAR::MDB2 documentation

Hi all,

I'm looking for a good documentation about the PEAR module MDB2.
I need :
- a complete list of the functions ;
- detailed description of each function ;
- a lot of examples.

I don't care of the format (HTML, PDF, CHM) ;D
Richard Coffree-commerce Product ManagerAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

Richard QuadlingConnect With a Mentor Senior Software DeveloperCommented:
From what I know of PEAR, the best way to get the documentation is to build your own using the PEARDocumentor. As part of the PEAR standard, the source code must contain specifically structured comments to allow an external application to build the documentation.

MDB2 is no different in that regard. Take a look at the source to see some of the comments. It is very clearly commented.
Richard QuadlingSenior Software DeveloperCommented:

Is the official dox. Is there more you need?
Richard Coffree-commerce Product ManagerAuthor Commented:
I found it when I downloaded the package, but it is just an introduction.
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Richard QuadlingSenior Software DeveloperCommented:
Hmm. Ok. What more info do you need?

For example contains 2 good examples on the Query. also looks useful.
Richard Coffree-commerce Product ManagerAuthor Commented:
For example, I think that the doc it is a little bit light when it describes the use of queryAll and default options.

E.g. ,  I used the following request with native Mysql lib :

$select  = "SELECT rplcats.WCATA,  cat_name, category_description , WTYPC, WLIMA, cat_ID ";
      $select .= "FROM rplcata, rplcats, wp_categories ";
      $select .= "WHERE rplcata.WCATA = rplcats.WCATA ";
      $select .= "AND rplcata.WCATA = wp_categories.category_nicename ";
      $select .= "AND rplcats.WLANG = 'FRA' ";
      $select .= "ORDER BY WPRIO";

When I read to use queryAll with the mode $mdb2->setFetchMode(MDB2_FETCHMODE_ASSOC);  I realize that the indexes are in lowercase instead of what it is exactly written in the query.
So far i use, e.g., $ligne['WCATA'] but now it is $ligne['wcata'].

I do not find why, I have to do so !!!
Richard QuadlingSenior Software DeveloperCommented:
From what I can see there are some settings related to setting/alterning the case of the columns.

$this->db->options['portability'] & MDB2_PORTABILITY_FIX_CASE


$this->db->options['field_case'] == CASE_LOWER

You can set the field_case option to the DB to CASE_LOWER or CASE_UPPER

See MDB2.php Line 1057 (// $Id: MDB2.php,v 1.216 2006/06/11 14:17:42 lsmith Exp $)

Richard Coffree-commerce Product ManagerAuthor Commented:
I created the doc using PHPDocumentor.

Thanks a lot.
Richard QuadlingSenior Software DeveloperCommented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.