Version: 0.1

Type: Class

Category: Databases

License: GNU General Public License

Description: Inspired by Perl DBI's built in support to read MySQL options from the standard ~/.my.cnf, I thought I would be nice to have the same support in PHP. That's what this class does. It reads options from any specified group in ~/.my.cnf and returns an associative array. Read the top of the file for more info.



FILENAME:   mycnfOptions.class.php
AUTHOR:     Benjamin D. Jones (
COPYRIGHT:  Copyright (C) 2001 Benjamin D. Jones
PURPOSE:    Read group options from ~/.my.cnf and return the values for use in a script
VERSION:    0.1 (22.Mar.2001)

This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or (at
your option) any later version.

This program is distributed in the hope that it will be useful, but
WITHOUT ANY WARRANTY; without even the implied warranty of
General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.  


Why is this an object? Are you a moron?

No. Two reasons why I took an object oriented approach.

1.) to eliminate namespace conflicts (you never know)

2.) because I find that code is easier to manage this way.

You're welcome to retool it as a single function if you like.


$mycnf = new mycnfOptions([$group], [$home]);
$array_of_options = $mycnf -> readMycnf();


This class reads MySQL options from the standard ~/.my.cnf file that
other MySQL programs read. You specify the group to be read when
instantiating the object. The group name can be anything you want, as
long as that section actually exists in ~/.my.cnf, then those options
will be read, and placed in an associative array.

Read more about the my.cnf file in the MySQL manual.

This is guaranteed not to work with the Win32 version of PHP and
MySQL. I don't use Windows so I don't develop for Windows.

A quick example . . . 
      $mycnf = new mycnfOptions('phpscripts', '/home/username/'); 
      $dbInfo = $mycnf -> readMycnf();

If ~/.my.cnf contained the following group entries . . . 
   # ~/.my.cnf

   host = localhost
   user = username
   password = secret
   database = myDB

   # end ~/.my.cnf

   . . . then $dbInfo would have the indexes 'host', 'user',
   'password', and 'database' with the corresponding values.

  The first constructor argument is optional and defaults to
  'php'. You can use any group name you want as long as you acutally
  have entries for it in your ~/.my.cnf

  The second constuctor argument is optional, if omitted, the
  enviromental variable $HOME is used. This probably won't be set
  unless you are running your script from the command line or have set
  it previously with putenv().

  By using this class, you can eliminate the need for various config
  files, etc. for your different scripts. You can keep all you MySQL
  options in the file in which they were meant to be kept.


class mycnfOptions

  var $groupName;
  var $mycnfFile;
  var $options;

  function mycnfOptions($groupName = 'client', $homeDir = '')

    $this -> groupName = $groupName;
    $this -> mycnfFile  = $this -> findMycnf ($homeDir);
    $this -> options = array();


  function findMycnf($homeDir = '')
    // PURPOSE: set up the location of the ~/.my.cnf file

    // if $homeDir is empty (it's optional), use the enviroment

    if ( empty($homeDir) ) {

      $homeDir = getenv('HOME');


    // strip the trailing '/' if there is one

    $homedir = preg_replace('@/$@', '', $homeDir);

    return "$homeDir/.my.cnf";


  function readMycnf()
    // PURPOSE: Read the ~/.my.cnf file 
    //          Return the options for the appropriate group
    //          as an associative array
    if ( $this -> fh = fopen($this -> mycnfFile, 'r') ) {
      // find the correct group

      $this -> findFilePosition();

      // extract the options for the appropriate group

      $this -> getOptions();

      fclose($this -> fh);


    return $this -> options;

  function getOptions()
    // PURPOSE: extract the options from the file for this group
    while ( $line = fgets($this -> fh, 100) ) {
      $line = trim($line);

      if ( preg_match('/^([a-z_A-Z]*) *= *(.*)$/', $line, $match) ) {

        // an option is listed so create a new key/value set 
        // in the options array

        $this -> options[$match[1]] = $match[2];
      } else if ( preg_match('/^\[/', $line) ) {

        // the next group has started so exit the loop




    return true;


  function findFilePosition()
    // PURPOSE: Find the desired group section in the file
    while ( $line = fgets($this -> fh, 100) ) {
      if ( preg_match('/^\[' . $this -> groupName . '\]$/', $line) ) {
        // found the correct position

        return true;



    return false;