php_mysql_devapi extension provides access to the MySQL Document Store via the X DevAPI. The X DevAPI is a common API provided by multiple MySQL Connectors providing easy access to relational tables as well as collections of documents, which are represented in JSON, from a API with CRUD-style operations.
The X DevAPI uses the X Protocol, the new generation client-server protocol of the MySQL 8.0 server.
To install this extension, you need to have mysql 8 on your system.
After installing mysql 8 follow these steps to install php_mysql_xdevapi.
- Go to this link https://pecl.php.net/package/mysql_xdevapi to download the .dll for the php_mysql_xdevapi .
- After downloading the extension paste in your php installation directory subfolder ext C:\wamp64\bin\php\php7.2.4\ext.
- Now you have to add this extension in the php.ini file near the dynamic extensions. extension=php_mysql_xdevapi.dll
- One important caveat is that in wamp default mysql 8 installation , XDevApi plugin is disable, you have to enable it by commenting the part which is disabling mysql_xdevapi.
;Disabling X Plugin
Now you successfully have install the php_mysql_xdevapi on wamp, to see it working,
$session = mysql_xdevapi\getSession('mysqlx://<user>:<password>@host:33060?connect-timeout=5000&ssl-mode=disabled');