Re: Any method to get primary key matching a given value ?

And then I do a query where the value (argument) matches for a primary key name. The table name is also an input to make things easier. On Mon, Oct 10, 2016 at 5:12 PM, Ratin <ratin3@gmail.com> wrote: > Sorry about my late reply but this was my function - a bit of a hack but > works properly on my version of php-sqlite3: > > > function get_primary_key_name($table) > { > $primary_key=''; > $db = new MyDB(); > if(!$db) > { > echo $db->lastErrorMsg(); > } > else > { > $qstr = "PRAGMA table_info(" . $table . ");" ; > $query = $db->query($qstr); > while ($result = $query->fetchArray()) > { > if ($result['pk'] == 1) > { > $primary_key=$result['name']; > } > } > } > $db->close(); > return $primary_key; > } > > > On Sat, Aug 20, 2016 at 3:35 AM, Karl DeSaulniers <karl@designdrumm.com> > wrote: > >> This may also shed some light for you. >> The accepted answer and possibly the one below it if you are on .NET >> >> >> http://stackoverflow.com/questions/763516/information-schema >> -columns-on-sqlite >> >> HTH, >> >> Best, >> >> Karl DeSaulniers >> Design Drumm >> http://designdrumm.com >> >> >> >> >> > On Aug 20, 2016, at 5:30 AM, Karl DeSaulniers <karl@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 a primary key or not. >> > >> > Best, >> > >> > Karl DeSaulniers >> > Design Drumm >> > http://designdrumm.com >> > <http://designdrumm.com/> >> > >> > >> > >> > >> >> On Aug 18, 2016, at 6:51 PM, Ratin <ratin3@gmail.com> wrote: >> >> >> >> Hi Karl, Thanks a lot for your response, I think INFORMATION_SCHEMA >> is not available for sqlite database. I had to built up the whole query >> with php using PRAGMA table_info(tablename), looking at the pk entry, when >> its 1, get the column name, and then update the sql statement based on >> that. A bit 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 < >> karl@designdrumm.com <⌠>> >Q³G7Èž{œÁÑmailto:karl@designdrumm.com>> wrote: >> >> Hi Ratin, >> >> Going to take a stab at this one. >> >> Have you looked into INFORMATION_SCHEMA.COLUMNS for your query? >> >> Might be where you want to look for what you are trying. >> >> Sorry can't help more. >> >> >> >> Best, >> >> >> >> Karl DeSaulniers >> >> Design Drumm >> >> http://designdrumm.com >> >> <http://designdrumm.com/> >> >> >> >> >> >> >> >> >> >>> On Aug 18, 2016, at 1:27 PM, Ratin <ratin3@gmail.com <mailto: >> ratin3@gmail.com>> wrote: >> >>> >> >>> I'm writing the generic get that works on different tables having >> different >> >>> primary keys but the argument of get is always the primary key , i.e. >> get >> >>> request is - >> >>> >> >>> get (column name, value) >> >>> >> >>> the value is always the primary key value. >> >>> >> >>> It looks like it would be a pretty standard method but I cant find a >> method >> >>> like that. Anybody have any clue? >> >>> >> >>> Thanks >> >>> >> >>> Ratin >> >> >> >> >> >> -- >> >> PHP Database Mailing List (http://www.php.net/ >> >> <http://www.php.net/>) >> >> To unsubscribe, visit: >> >> http://www.php.net/unsub.php < >> http://www.php.net/unsub.php> >> >> >> >> >> > >> >> >> -- >> PHP Database Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php >> >> >