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
>>
>
>
