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

Hi Ratin, check out this FAQ : https://sqlite.org/faq.html#q7 SQlite has a read-only table that holds the creation query for each table. By doing a text analysis of this query, you can find out which field is declared as primary key. Regards, Bert On 11/10/16 02:12, Ratin wrote: Sorry

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

You may be correct. Admittedly, I am stabbing in the dark here. I work on MySQL, not SQLite. Just good at key word searches. :) This link seems to be promising. http://www.sqlite.org/c3ref/table_column_metadata.html Sorry I can't help more. Best, Karl DeSaulniers Design Drumm

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

Hi Karl, Isnt it the same ? I am doing the check if ($result['pk'] == 1), and you are doing if ($result['pk'] !== null). I wanted to make sure I dont get false positives, what if $result['pk'] is set to zero, in your case it will be a match but thats probably not what we want, cuz the pk field

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

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 your end. while ($result = $query->fetchArray()) { if ($result['pk'] !== null) { $primary_key=$result['pk']; } } Best,

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

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

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

Hi Ratin, working with sqlite, are you ? In that case, take a look at the default table : SELECT sql from sqlite_master where type= "table" and name = "" This query returns the creation query of the table concerned. By parsing it textually, you can find out the field name that was declared

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

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

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

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 > On Aug 18, 2016, at 6:51 PM, Ratin wrote: >

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

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

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

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 > On Aug 18, 2016, at 1:27 PM, Ratin

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

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