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

You can use hex2bin() function since it is the PHP equivalent of MySQL's UNHEX().

The syntax is as follows −

$anyVariableName = hex2bin("yourHexadecimalValue");

To understand the above syntax, let us implement the above syntax in PHP. The PHP code is as follows −

$myFirstValue = hex2bin("7777772E4D7953514C4578616D706C652E636F6D");
var_dump($myFirstValue);
$mySecondValue=hex2bin("416476616E6365644A617661576974684672616D65776F726B");
echo('<br>');
var_dump($mySecondValue);

The snapshot of PHP code is as follows −

Here is the snapshot of The output −

Here is the MySQL UNHEX() −

Case 1 − The query is as follows −

mysql> SELECT UNHEX("7777772E4D7953514C4578616D706C652E636F6D");

The following is The output −

+---------------------------------------------------+
| UNHEX("7777772E4D7953514C4578616D706C652E636F6D") |
+---------------------------------------------------+
| www.MySQLExample.com                              |
+---------------------------------------------------+
1 row in set (0.00 sec)

Case 2 − The query is as follows −

mysql> SELECT UNHEX("416476616E6365644A617661576974684672616D65776F726B");

Here is the output −

+-------------------------------------------------------------+
| UNHEX("416476616E6365644A617661576974684672616D65776F726B") |
+-------------------------------------------------------------+
| AdvancedJavaWithFramework |
+-------------------------------------------------------------+
1 row in set (0.00 sec)

Samual Sam

Updated on: 2019-07-30T22:30:25+05:30

642 Views

Kickstart Your Career

Get certified by completing the course

Get Started