Re: MYSQL_ASSOC & DB_FETCHMODE & more

From: Date: Wed, 07 Feb 2001 09:05:51 +0000
Subject: Re: MYSQL_ASSOC & DB_FETCHMODE & more
References: 1  Groups: php.pear 
Request: Send a blank email to php-pear+get-1282@lists.php.net to get a copy of this message
> Robert Kelly wrote: > > Howdy! > > I'd like to say we're thinking of using PEAR here at Insight.com and > leveraging it. Hopefully will be giving our code back to the > community as well. > > Where is MYSQL_ASSOC defined? I cannot find this definition > anywhere... it's not in php.ini or the DB.php and DB/*. at least, it > doesn't show up on a grep. > > Method getAssoc calls the fetchRow function with the > DB_FETCHMODE_[PARAM]. It passes mysql_fetch_array the MYSQL_ASSOC > value. > > if ($fetchmode & DB_FETCHMODE_ASSOC) { > $row = mysql_fetch_array($result); //<- I am seeking this > #$row = mysql_fetch_array($result, MYSQL_ASSOC); //<-not this > } else { > $row = mysql_fetch_row($result); > } > > So, question one is where is the MYSQL_ASSOC (its defaulting to 1) > set. Question 2, if I am wanting an associative array (like the line > above), shoudl I be setting DB_FETCHMODE_ to something different? DB_FETCHMODE_ASSOC is a constant. A lot of DB methods have a "fetchmode" parameter where you can use either DB_FETCHMODE_ASSOC or DB_FETCHMODE_ORDERED. For example: $sth = $dbh->query("SELECT foo, bar FROM table"); $row = $sth->fetchRow(DB_FETCHMODE_ASSOC); The $row you get here will be indexed by column name. If you remove the fetchmode parameter or change it to DB_FETCHMODE_ORDERED, $row will have numerical indexes. MYSQL_ASSOC is defined in PHP itself. - Stig

« previous php.pear (#1282) next »