Just curious why the values can only be accessed by column names and not an
array subscript, like :
$i=0;
$result = $db->query('select * from DecoderUser');
while ($entries = $result->fetchArray())
{
$value=$entries[i];
$i = $i + 1;
}
On Mon, Aug 1, 2016 at 12:25 PM, Ratin <ratin3@xxxxxxxxx> wrote:
> Thanks Aziz, that works. Somehow i thought the ' needed to be included
> just like you quote all strings on an interactive DB shell or even when you
> get the value directly by column name.
>
> On Mon, Aug 1, 2016 at 11:47 AM, Aziz Saleh <azizsaleh@xxxxxxxxx> wrote:
>
>> But if i print $entries['decoderUserGUID'] I get the correct value
>>
>> This means the key value is decoderUserGUID NOT 'decoderUserGUID', try
>> creating $strIndex without the quotes, just the key value.
>>
>> On Mon, Aug 1, 2016 at 2:31 PM, Ratin <ratin3@xxxxxxxxx> wrote:
>>
>>> Hi I am new to this list, not sure how active this list is but i have a
>>> question regarding php-sqlite integration. I am using a string variable
>>> where I put the column name and trying to use that varible to get its
>>> value, in a loop. So here is what I have (simplified version):
>>>
>>>
>>> $strIndex='\'' . $columns[$i] . '\''; //strIndex has the value :
>>> 'decoderUserGUID' (including quotes)
>>> $result = $db->query('select * from DecoderUser');
>>> while ($entries = $result->fetchArray())
>>> {
>>> $value=$entries[$strIndex];
>>> }
>>>
>>>
>>>
>>> So if I print $value, I get nothing. But if i print
>>> $entries['decoderUserGUID'] I get the correct value. If I print
>>> $strIndex,
>>> I get 'decoderUserGUID' (including the quotes). How can I solve this
>>> mistery.. whats hapenning here , Anybody have any idea?
>>>
>>>
>>> Thanks
>>>
>>> Ratin
>>>
>>
>>
>
