PHP Function Oci_Field_Type

Article about php function oci_field_type

The oci_field_type() PHP function is used to find out the data type of a field in a row returned by a select query. This is useful for applications that want to make sure that the data sent to Oracle matches the data types expected in PHP variables.

The function returns a string that identifies the data type of the field in the current row (fetched by oci_fetch()). It can be either the column number (1-based) or the column name, in uppercase. The return value is FALSE if there is an error. This function is a replacement for ocicolumnname(), which can still be used in PHP versions before 5.0.0 but is deprecated and not recommended.

SQL statements that change database data are only visible within the session of the user who is executing the statement until it is committed to the database, which makes it available to other sessions. The oci_commit() and oci_rollback() functions control database transactions.

The oci_debug() PHP function sends meta data to the Oracle database when statements are executed. This information is displayed in many Oracle tools and can be helpful in debugging problems. The function also escapes text that resembles HTML tags so it can be included in Web pages without causing an error. This is useful for sites that include images, such as blogs.

Andreas Behr - CTO of DesertCoderz
You are a developer and looking for Shopware projects?
Apply Now!

oci_field_type example


        return array_map(fn ($fieldIndex) => oci_field_name($this->resultID, $fieldIndex), range(1, $this->getFieldCount()));
    }

    /** * Generates an array of objects representing field meta-data. */
    public function getFieldData(): array
    {
        return array_map(fn ($fieldIndex) => (object) [
            'name'       => oci_field_name($this->resultID, $fieldIndex),
            'type'       => oci_field_type($this->resultID, $fieldIndex),
            'max_length' => oci_field_size($this->resultID, $fieldIndex),
        ], range(1, $this->getFieldCount()));
    }

    /** * Frees the current result. * * @return void */
    public function freeResult()
    {
        
Home | Imprint | This part of the site doesn't use cookies.