Re: [PHP-DB] weird string literal related problem

2016-08-01 Thread Ratin
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, Rati

Re: [PHP-DB] weird string literal related problem

2016-08-01 Thread Ratin
$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 <rat...@gmail.com> wrote: > >> Hi I am new to t

[PHP-DB] weird string literal related problem

2016-08-01 Thread Ratin
ID'] 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

Re: [PHP-DB] weird string literal related problem

2016-08-01 Thread Ratin
nvm, I got my answer -- foreach ( $entries as $column => $value ) will give the column names .. which simplifies my task a lot. On Mon, Aug 1, 2016 at 12:52 PM, Ratin <rat...@gmail.com> wrote: > Just curious why the values can only be accessed by column names and not > an array

Re: [PHP-DB] Any method to get primary key matching a given value ?

2016-08-18 Thread Ratin
of work, wouldve been much simpler if a method was provided, but oh well .. Thanks again Ratin On Thu, Aug 18, 2016 at 2:53 PM, Karl DeSaulniers <k...@designdrumm.com> wrote: > Hi Ratin, > Going to take a stab at this one. > Have you looked into INFORMATION_SCHEMA.COLUMNS

[PHP-DB] Any method to get primary key matching a given value ?

2016-08-18 Thread Ratin
find a method like that. Anybody have any clue? Thanks Ratin

Re: [PHP-DB] Any method to get primary key matching a given value ?

2016-10-10 Thread Ratin
is not set to 1.. Regards, Ratin On Mon, Oct 10, 2016 at 5:38 PM, Karl DeSaulniers <k...@designdrumm.com> wrote: > Hi Ratin, > I "think" you can just do this and not have to store the table name. > However, I have no way of testing this. You will have to test on you

[PHP-DB] Incorporating latest version of sqlite.c and making a sqlite3.so for php

2016-10-10 Thread Ratin
the DB in r/w mode). Are there any official documentation on how to build the so for php ? Thanks all Ratin

Re: [PHP-DB] Any method to get primary key matching a given value ?

2016-10-10 Thread Ratin
t; > > > > > On Aug 20, 2016, at 5:30 AM, Karl DeSaulniers <k...@designdrumm.com> > wrote: > > > > Hey Ratin, > > Have you looked into the table column named 'pk' inside table_info? > > That is where a column is indicated to be