protected function getSingleResult($sql)
 {
     $statement = oci_parse($this->connection, $sql);
     oci_execute($statement);
     if ($result = oci_fetch_assoc($statement)) {
         oci_free_statement($statement);
         return $result;
     } else {
         oci_free_statement($statement);
         return NULL;
     }
 }

 function dispCart()
 {
     $cartLen = count($_SESSION['cart']);
     if ($cartLen < 1) {
         echo 'You have no items in your cart.<br><a href="main.php">Keep shopping</a><br>';
         die;
     }
     //for loop to iterate through cart items
     for ($i = 0; $i < $cartLen; $i++) {
         if ($cartLen > 0) {
             $newconn = conndb();
             //sql
             $s = oci_parse($newconn, "select * from PRODUCT where PRODUCTID=:pid_prefix");
             $plook = $_SESSION['cart'][$i]['productid'];
             oci_bind_by_name($s, ':pid_prefix', $plook);
             oci_execute($s);
             //fetch a single row depending on product id
             $res = oci_fetch_assoc($s);
             echo "Product name: ", $res['PRODUCTNAME'], " Price: ", $res['PRODUCTPRICE'];
             echo '<a href="cart.php?del=' . $i . '"> Remove item</a><br>';
         }
     }
     if ($cartLen > 0) {
         echo '<a href="checkout.php">Proceed to checkout</a><br>';
     }
 }

function afficher_produit($is_fruit)
{
    if ($is_fruit) {
        $requete = "SELECT * FROM Produits WHERE `fruit`=1";
    } else {
        $requete = "SELECT * FROM Produits WHERE `fruit`=0";
    }
    $idcom = connex("Myparam");
    $stmt = oci_parse($idcom, $requete);
    $result = oci_execute($result, OCI_DEFAULT);
    if (!$result) {
        echo "Lecture impossible";
    } else {
        echo "<table cellspacing='0' cellpadding='5'>";
        echo "<tr>";
        echo "<th>Produit</th><th>Description</th><th>Stock</th><th>Prix</th><th>Quantité</th><th></th>";
        echo "</tr>";
        while ($ligne = oci_fetch_assoc($result)) {
            echo "<tr id='" . $ligne[0] . "'>";
            echo "<td>" . $ligne[1] . "</td>";
            echo "<td>" . $ligne[2] . "</td>";
            echo "<td>" . $ligne[3] . "</td>";
            echo "<td>" . $ligne[4] . "</td>";
            echo "<td><select name='qte_v[]'>";
            for ($i = 1; $i <= $ligne[3]; $i++) {
                echo "<option>" . $i . "</option>";
            }
            echo "</select></td>";
            echo '<td><button onclick="addProduit($(this));" class=bouton_produit>Ajouter au panier</button></td>';
            echo "</tr>";
        }
        echo "</table>";
    }
}

function addTransport()
{
    global $con1;
    global $id;
    global $departmentId;
    global $transportTypeId;
    global $transportSubtypeId;
    global $model;
    global $gid;
    $query = "SELECT sq_request_all.nextval FROM DUAL";
    $statement = oci_parse($con1, $query);
    if (oci_execute($statement, OCI_DEFAULT)) {
        $res = oci_fetch_assoc($statement);
        $id = $res["NEXTVAL"];
    } else {
        $err = oci_error();
        die("Не удалось получить индентификатор : " . $err[message]);
        echo false;
    }
    $query2 = "INSERT INTO TRANSPORT_ITEMS(ITEM_ID, ITEM_TITLE, ITEM_GID, DEP_ID, ITEM_TYPE_ID, ITEM_SUBTYPE_ID)\n               VALUES({$id}, '{$model}', '{$gid}', {$departmentId}, {$transportTypeId}, {$transportSubtypeId})";
    $statement2 = oci_parse($con1, $query2);
    if (oci_execute($statement2, OCI_COMMIT_ON_SUCCESS)) {
        $query3 = "SELECT * FROM TRANSPORT_ITEMS WHERE ITEM_ID = {$id}";
        $statement3 = oci_parse($con1, $query3);
        if (oci_execute($statement3, OCI_DEFAULT)) {
            $transport = oci_fetch_assoc($statement3);
            echo json_encode($transport);
        }
    } else {
        $err = oci_error();
        die("Не удалось добавить транспорт: " . $err[message]);
        echo "fail";
    }
}

 public function Query($query_string, $params = null)
 {
     ++self::$query_count;
     $this->qid = $this->prepareSQL($query_string, $params);
     $result = oci_execute($this->qid);
     $this->row = 0;
     $this->selected_rows = null;
     $err = oci_error($this->qid);
     $this->error = $err['message'];
     $this->errno = $err['code'];
     if (oci_statement_type($this->qid) == 'SELECT') {
         $this->records = array();
         $this->selected_rows = 0;
         $this->current_row = 0;
         while ($row = @oci_fetch_assoc($this->qid)) {
             $this->records[] = $row;
             ++$this->selected_rows;
         }
     }
     if (!$result) {
         throw new Exception('Invalid query: ' . $query_string . ': ' . $this->error, $this->errno);
     }
     //if
     return $result;
 }

 function getUserForID($userId)
 {
     $user = new User();
     ini_set('display_errors', 'On');
     $db = "w4111c.cs.columbia.edu:1521/adb";
     $conn = oci_connect("kpg2108", "test123", $db);
     $stmt = oci_parse($conn, "select * from users where user_Id='" . $userId . "'");
     $rows = oci_execute($stmt);
     oci_close($conn);
     while ($row = oci_fetch_assoc($stmt)) {
         echo $row['LOGIN_ID'];
         $user->setUserId($row['USER_ID']);
         $user->setPassword($row['PASSWORD']);
         $user->setFirstName($row['FNAME']);
         $user->setLastName($row['LNAME']);
         $user->setLoginId($row['LOGIN_ID']);
         $user->setEmailId($row['EMAIL_ID']);
         $user->setAddress($row['ADDRESS']);
         $user->setPhoneNumber($row['PHONE_NO']);
         $user->setSecurityAnswer($row['ANSWER']);
         $user->setSecurityQuestion($row['QUESTION']);
         $user->setMiles($row['MILES']);
     }
     return $user;
 }

 public function fetchAssoc()
 {
     set_error_handler(static::getErrorHandler());
     $row = oci_fetch_assoc($this->resource);
     restore_error_handler();
     return $row;
 }

 public function get_next($res)
 {
     $data = oci_fetch_assoc($res);
     if (array_key_exists("VALUE", $data)) {
         $data["value"] = $data["VALUE"];
     }
     return $data;
 }

 protected function fetchDateFormat()
 {
     $sql = "select value from v\$nls_parameters where parameter = 'NLS_DATE_FORMAT'";
     $query = oci_parse($this->conn->getResource(), $sql);
     oci_execute($query);
     $row = oci_fetch_assoc($query);
     oci_free_statement($query);
     return $row['VALUE'];
 }

function cari_tgl_pengangkatan($nid)
{
    $sql = "SELECT  HIRE_DATE\n\t\t\tFROM " . $USERPAYROLL . ".EMP_DETAIL \n\t\t\tWHERE NID = '{$nid}'\n\t\t\t";
    $stmt = oci_parse($conn, $sql) or die("Query gagal");
    oci_execute($stmt);
    $row = oci_fetch_assoc($stmt);
    $tgl = $row['HIRE_DATE'];
    return $tgl;
}

 private function fetch_next()
 {
     if ($row = oci_fetch_assoc($this->stmt)) {
         $row = array_change_key_case($row, CASE_LOWER);
         unset($row['oracle_rownum']);
         array_walk($row, array('oci_native_moodle_database', 'onespace2empty'));
     }
     return $row;
 }

 public function findOne($tSql, $sClassRow)
 {
     $pRs = $this->query($this->bind($tSql));
     if (empty($pRs)) {
         return null;
     }
     $tRow = oci_fetch_assoc($pRs);
     $oRow = new $sClassRow($tRow);
     return $oRow;
 }

 function count()
 {
     $stmt = clone $this;
     $stmt->sql = "SELECT COUNT(*) AS THEROWC FROM ({$this->sql})";
     $stmt->hasChanged = true;
     $queryId = $stmt->execute();
     $row = oci_fetch_assoc($queryId);
     $stmt->free();
     return $row['THEROWC'];
 }

 public function get_next($res)
 {
     $data = oci_fetch_assoc($res);
     if ($data) {
         foreach ($data as $k => $v) {
             $data[strtolower($k)] = $v;
         }
     }
     return $data;
 }

function AchatProduit()
{
    $conn = oci_connect("SYSTEM", "azerty", "//localhost/XE");
    $select_stmt2 = "SELECT * FROM ALEXIS.AUTEUR";
    $stid = oci_parse($conn, $select_stmt2);
    $result = oci_execute($stid);
    while ($ligne2 = oci_fetch_assoc($stid)) {
        echo '<li><a href="#">' . $ligne2['PRENOM_AUTEUR'] . " " . $ligne2["NOM_AUTEUR"] . "</a></li>";
    }
    oci_free_statement($stid);
}

 public function fetch_row()
 {
     if ($this->flags['fetch_all_rows']) {
         return false;
     }
     if ($this->num_fields) {
         $this->flags['fetch_row']++;
         return oci_fetch_assoc($this->resource);
     }
     return false;
 }

 function loadTables()
 {
     if ($this->isExisting) {
         $config = $this->connection->getConfig();
         $schema = strtoupper($config['user']);
         $result = $this->connection->execute("SELECT TABLE_NAME FROM ALL_TABLES WHERE OWNER = '{$schema}'");
         while ($row = oci_fetch_assoc($result)) {
             $this->tables[strtolower($row['TABLE_NAME'])] = 1;
         }
         oci_free_statement($result);
         $this->isTablesLoaded = true;
     }
 }

 /**
  * @throws SQLException
  * @return void
  */
 protected function initTables()
 {
     include_once 'creole/drivers/oracle/metadata/OCI8TableInfo.php';
     $sql = "SELECT table_name\n            FROM all_tables\n            WHERE owner = '{$this->schema}'";
     $statement = @oci_parse($this->conn->getResource(), $sql);
     $success = @oci_execute($statement, OCI_DEFAULT);
     if (!$success) {
         throw new SQLException("Could not get tables", $this->conn->getResource()->nativeError($statement));
     }
     while ($statement && ($row = oci_fetch_assoc($statement))) {
         $row = array_change_key_case($row, CASE_LOWER);
         $this->tables[strtoupper($row['table_name'])] = new OCI8TableInfo($this, $row['table_name']);
     }
 }

function getIVal($col, $from, $where, $debug = false)
{
    global $mysqli;
    if ($debug === true) {
        echo "<pre>SELECT {$col} FROM {$from} WHERE {$where}</pre>";
    }
    //$result = oci_parse("SELECT $col FROM $from WHERE $where");
    $result = oci_parse($GLOBALS['conn'], "SELECT {$col} FROM {$from} WHERE {$where}");
    oci_execute($result);
    if ($result == null) {
        return null;
    }
    $row = oci_fetch_assoc($result);
    return $row[0];
}

 public function execute()
 {
     if (!oci_execute($this->_cursor)) {
         require_once 'Zend/Db/Cursor/Exception.php';
         throw new Zend_Db_Cursor_Exception('Couldn\'t execute the cursor.');
     }
     // Cursor is ready to go
     while ($data = oci_fetch_assoc($this->_cursor)) {
         require_once 'Zend/Db/Cursor/Row.php';
         $row = new Zend_Db_Cursor_Row();
         foreach ($data as $key => $value) {
             $row->{$key} = $value;
         }
         $this->pushRow($row);
     }
 }