Hi,
I am trying to do some improvements on feature request [1]. A field (let's call it as 'picture') with mime type "mime/jpeg" is not showing th image, if the query (execute in query window) retrieve the 'picture' field from the table (SELECT `picture` FROM `table_name` WHERE 1) as mentioned in [1].
To display data, $where_clause is generated by the function PMA_getUniqueCondition (in root/libraries/common.lib.php) row wisely. For a long data like blob type, it returns $where_clause as empty string (""). (There is conditions to check the length of the data in that function)
What I'm trying to do is, for that kind of scenarios, make the $where_clause as "`table`.`primary_key_feild_name` = 'primary_key_value_for_corresponding_row'" (tried with hard coding & works for me). To do this I'm going to add a new argument to PMA_getUniqueCondition function with those two parameters (primary field name & relevant value). And call this inside PMA_displayTableBody function (in display_tbl.lib.php) with those values.
If the way I'm going is correct, Is there any way to fetching out primary key field value of each row while inside the PMA_displayTableBody function ? Or is there global parameter which holds table meta data ?
[1] https://sourceforge.net/tracker/index.php?func=detail&aid=3112137&gr...
Regards !
Le 2012-03-23 16:54, Chanaka Dharmarathna a écrit :
Hi,
I am trying to do some improvements on feature request [1]. A field (let's call it as 'picture') with mime type "mime/jpeg" is not showing th image, if the query (execute in query window) retrieve the 'picture' field from the table (SELECT `picture` FROM `table_name` WHERE 1) as mentioned in [1].
To display data, $where_clause is generated by the function PMA_getUniqueCondition (in root/libraries/common.lib.php) row wisely. For a long data like blob type, it returns $where_clause as empty string (""). (There is conditions to check the length of the data in that function)
What I'm trying to do is, for that kind of scenarios, make the $where_clause as "`table`.`primary_key_feild_name` = 'primary_key_value_for_corresponding_row'" (tried with hard coding & works for me). To do this I'm going to add a new argument to PMA_getUniqueCondition function with those two parameters (primary field name & relevant value). And call this inside PMA_displayTableBody function (in display_tbl.lib.php) with those values.
If the way I'm going is correct, Is there any way to fetching out primary key field value of each row while inside the PMA_displayTableBody function ? Or is there global parameter which holds table meta data ?
Look at $fields_meta which is available in this function.
On Sat, Mar 24, 2012 at 8:47 PM, Marc Delisle marc@infomarc.info wrote:
Le 2012-03-23 16:54, Chanaka Dharmarathna a écrit :
Hi,
I am trying to do some improvements on feature request [1]. A field
(let's
call it as 'picture') with mime type "mime/jpeg" is not showing th image, if the query (execute in query window) retrieve the 'picture' field from the table (SELECT `picture` FROM `table_name` WHERE 1) as mentioned in
[1].
To display data, $where_clause is generated by the function PMA_getUniqueCondition (in root/libraries/common.lib.php) row wisely.
For a
long data like blob type, it returns $where_clause as empty string (""). (There is conditions to check the length of the data in that function)
What I'm trying to do is, for that kind of scenarios, make the $where_clause as "`table`.`primary_key_feild_name` = 'primary_key_value_for_corresponding_row'" (tried with hard coding &
works
for me). To do this I'm going to add a new argument to PMA_getUniqueCondition function with those two parameters (primary field name & relevant value). And call this inside PMA_displayTableBody
function
(in display_tbl.lib.php) with those values.
If the way I'm going is correct, Is there any way to fetching out primary key field value of each row
while
inside the PMA_displayTableBody function ? Or is there global parameter which holds table meta data ?
Look at $fields_meta which is available in this function.
-- Marc Delisle http://infomarc.info
This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Hi Marc,
Thanks for your quick reply. I'll look in to that.
Regards !
-
Chanaka Dharmarathna -
Marc Delisle