zend framework 2 with db oracle

Question

I use xamppv3.2.2 use PHP Version 5.6.14 use windows 8.1 use zend framework 2

I try to connect to Oracle DB(in other remote machine)

I can try set environment variables.

but i obtain always same error message:

Zend\Db\Adapter\Exception\RuntimeException

File: C:\xampp\htdocs\zendframework\zend-db\src\Adapter\Driver\Oci8\Oci8.php:149

"The Oci8 extension is required for this adapter but the extension is not loaded"

Please Help me

Thanks

Answer 1

You should try to use PDO extension. Or use mysqli extension. Learn more about it at Php PDO extension.

Test Code:

$param = $_POST;
$db_username = "youusername";
$db_password = "yourpassword";
$db = "oci:dbname=yoursid";
$conn = new PDO($db,$db_username,$db_password);
$name = $param['module'];
$file = $param['file'];
$stmt = $conn->exec("INSERT INTO AL_MODULE (AL_MODULENAME, AL_MODULEFILE) VALUES ('$name', '$file')");