| Re: How to construct an associative and numeric indexable array [message #178274 is a reply to message #178272] |
Sat, 26 May 2012 03:09   |
Leonardo Azpurua
Messages: 46
Registered: December 2010
Karma:
|
Member |
|
|
"Jerry Stuckle" <jstucklex(at)attglobal(dot)net> escribió en el mensaje
news:jpp6u3$l9u$1(at)dont-email(dot)me...
> On 5/25/2012 7:19 PM, Leonardo Azpurua wrote:
>> Hi,
>>
>> The docs for MS's SQLSRV PHP interface sayes:
>>
>> "Based on the value of the $fetchType parameter, the returned array can
>> be a
>> numerically indexed array, an associative array, or both."
>>
>> It might be helpful to have such an array in some other places.
>>
>> How is it done?
>>
>
> RTFM:
>
> http://us.php.net/manual/en/function.mssql-fetch-array.php
Hi,
As far as I have RdTFM, an array can be indexed either by key values
$a1 = array("L1" => "a", "L2" => "b");
or by an integer
$a2 = array("a", "b");
You can write $a1["L1"], or $a2[0].
Of course, there is no point in writing $a2["L1"], but being able to write
$a1[0] might certainly come handy at times.
My mention of the SQLSRV/PHP Driver (not to be confused with the "old" mssql
library) was because it provides the function sqlsrv_fetch_array, that
returns a row from a data source as an array whose elements may be accessed
both by their column name or by their ordinal position (minus one) in the
column list of the query that generated the statement resource.
So, given a statement ($stmt) based on the query SELECT C1, C2 FROM T, and
$row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_BOTH);
both $row["C1"] and $row[0] are acceptable and equivalent.
My question is *not* how to fetch rows from a result set, but how can I
build an array that allows both ways of indexing.
I know that if I RTFM, think a lot and devote a few hours (or even days) to
the problem, I might come with some sort of solution.
But it doesn't hurt to ask, just in case somebody has an answer.
Better if it is an answer to the actual question, but everything helps.
Thanks!
--
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]