What is the PHP equivalent of MySQL's UNHEX()?

Question

For instance, the following query and PHP function should provide the same value.

SELECT UNHEX(c1) AS unhexed_c1 FROM table;

$unhexed_c1=PHPs_UNHEX_Equivalent($c1);

This is similar question http://stackoverflow.com/questions/7488538/convert-hex-to-ascii-characters — Michał Powaga, Sep 28 '13 at 20:21

score 14 · Accepted Answer · answered Sep 28 '13 at 20:24

14

There's a built-in function called hex2bin if you're running PHP >= 5.4.

answered Sep 28 '13 at 20:24

Joel Hinz

score 11 · Answer 2 · answered Sep 28 '13 at 20:22

11

It can be done with pack:

$unhexed = pack('H*', $hexstring);

answered Sep 28 '13 at 20:22

dev-null-dweller

1

Why pack instead of hex2bin (assuming you are running PHP 5.4 or greater)? – user1032531 Dec 25 '14 at 14:54
2

In the time of writing this answer, most hosting companies that I have used were stuck with php 5.3.x. Even now many popular frameworks / cms / blog platforms targets php 5.3 or even 5.2, so my answer was not assuming that. – dev-null-dweller Dec 26 '14 at 09:23

score 5 · Answer 3 · edited May 23 '17 at 10:32

5

  function unhex($hex) {
    for($i=0;$i<strlen($hex);$i+=2)
       $str .= chr(hexdec(substr($hex,$i,2)));

    return $str;
  }

edited May 23 '17 at 10:32

Community

answered Sep 28 '13 at 20:21

dajavax

score 2 · Answer 4 · answered Sep 28 '13 at 20:24

2

I think you look for hex2bin

answered Sep 28 '13 at 20:24

4 Answers4