hexadecimal number format

9 views
Skip to first unread message

leven...@gmail.com

unread,
Dec 20, 2017, 7:43:58 AM12/20/17
to phpliteadmin
Is there any way in phpliteadmin to view integer numbers in hexadecimal format?

Thanks,
Levente

Christopher Kramer

unread,
Dec 21, 2017, 5:51:25 AM12/21/17
to phpliteadmin
Hi,
I guess it should work like this:
Add the php-function dechex() to the $custom_functions Array in your configuration like this:
$custom_functions = array(
    'md5', 'sha1', 'time', 'strtotime', 'dechex',
    // add the names of your custom functions to this array
    /* 'leet_text', */
);

Then you should be able to use it in SELECTs like this:
 SELECT dechex(intcolumn) AS hex FROM tableName

Greetings,
Christopher
Reply all
Reply to author
Forward
0 new messages