Re: [PHP] Unexpected values in an associative array


On Jul 31, 2007, at 12:06 PM, Instruct ICC wrote:

array(6) {
["task_id"]=>
int(22)
[0]=>
string(2) "22"
["container_id"]=>
int(3784)
[1]=>
string(4) "3784"
["name"]=>
string(12) "108-6972.XTG"
[2]=>
string(24) "3130382D363937322E585447"
}

What is $coersions or $inQuery['coersions']? Maybe a var_dump or a print_r on that for the list?

For the above record, $coersions is an associative array of the form

array('task_id'=> 'integer', 'container_id'=> 'integer', 'name'=>'hex_decode');

I found that I was doing a lot of coersions with results of SQL queries to turn them into real integers, floats or decode from base64/ hex before I could use them so rolling all that ugly stuff into the query makes it so users of the function don't have to do coersions any more. There may be a better way to perform coersions from string types returned by PDO queries and their real types but I'm a PDO noob so don't know if one.

What is $value and what is this supposed to do:
case 'integer':
$value += 0;
break;

case 'float':
$value += 0.0;

If $value is a string, you should quote your 0 and 0.0. What add 0 or 0.0 to an int or float respectively?

The point of these is to convert the strings to ints, floats, decode them etc...

What's the extra "[]" about in $rows[$groupKey][] = $fields;
Maybe that's where your duplicates are coming from although I don't see duplicates in your output.

Another thing I found the need for was to group rows in a select result by specific keys. For example say a query gets all ads in a publication, and you want to physically group them by page. That's what that group function does.

Ken
.