I wrote a PHP function to query a database and return the complete result set but it's not working (I get no results). I'm new to PHP, am I using the function properly?
<?php
$sql = array(
'user' => 'user',
'password' => 'pass',
'server' => '10.10.10.10',
'db' => 'XE'
);
$conn = oci_connect($sql['user'], $sql['password'], $sql['server'].'/'.$sql['db']);
if (!$conn) {
$e = oci_error();
trigger_error( htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR );
}
function db_query( $conn, $bindings, $query )
{
$stmt = oci_parse( $conn, trim($query) );
foreach ($bindings as $key => $value) {
if ( strpos( $query, $key) ) {
oci_bind_by_name( $stmt, $key, $value );
}
}
oci_execute( $stmt );
oci_fetch_all( $stmt, $data );
oci_free_statement( $stmt );
return $data;
}
$bindings = array();
$query = 'SELECT COUNT(*) FROM Orders';
echo db_query();
?>