I have a very simple question. We have an IBM UniVerse server and I want to connect to it through PHP in the same manner that I use to connect to MySQL. I do not know any other information (server version, age, etc). All I know is that it runs on a *NIX OS.
Can somebody point to me to a starting point? Are there drivers I can use (libraries for PHP?)? Do I need to find out more information (it will be tough but i can try).
Thank you for all the support.
AC
You may try this to connect to a UniVerse server, but I'm not sure what you mean same manner that you use to connect to MySql, since UniVerse is a lot different from MySql.
If you want to use SQL command like SELECT/INSERT/UPDATE, I think ODBC is what you looking for.
<?php
$UOSession = new COM("UniObjects.unioaifctrl");
$UOSession->HostName = "localhost";
$UOSession->AccountPath = "ACC.NAME";
$UOSession->DatabaseType = 1;
$UOSession->UserName = "username";
$UOSession->Password = "password";
$UOSession->Connect;
if ($UOSession->IsActive) {
// process
}
$UOSession->Disconnect;
$UOSession = null;
?>
The easiest way to do this would be to use the ODBC driver.
You can use PDO with ODBC drivers, or you can use the ODBC classes directly. I recommend PDO, as having that extra layer of abstraction is good in case you need to switch to a different database in the future.
As said by Brad, if you want SQL access you can use ODBC to connect. Note that UniVerse is not a SQL database so when accessing it via ODBC you might have to do some setup work on the server. You might want to read some of the manuals.
Alternatively, Rocket Software have now released a RESTful Web Services product (free to download as part of the U2 DBTools package) that allows you to access the database in the manner instead.