Fetch the next row and return it as an object

- « cubrid_fetch_lengths

- cubrid_fetch_row »

- PHP Manual
- CUBRID MySQL Compatibility Functions
- Fetch the next row and return it as an object

# cubrid_fetch_object

(PECL CUBRID >= 8.3.0)

cubrid_fetch_object — Fetch the next row and return it as an object

### Description

cubrid_fetch_object(
resource `$result`,
string `$class_name` = ?,
array `$params` = ?,
int `$type` = ?
): object

This function returns an object with the column names of the result set as properties. The values of these properties are extracted from the current row of the result.

### Parameters

`result`

  `result` comes from a call to cubrid_execute()

`class_name`

  The name of the class to instantiate. If not specified, a stdClass (stdClass is PHP's generic empty class that's used when casting other types to objects) object is returned.

`params`

  An optional array of parameters to pass to the constructor for `class_name` objects.

`type`

  Type can only be CUBRID_LOB, this parameter will be used only when you need to operate the lob object.

### Return Values

An object, when process is successful.

`false`, when there are no more rows; NULL, when process is unsuccessful.

### Examples

Example #1 cubrid_fetch_object() example

    <?php$conn = cubrid_connect("localhost", 33000, "demodb");$res = cubrid_execute($conn, "SELECT * FROM code");var_dump(cubrid_fetch_object($res));// if you want to operate LOB object, you can use cubrid_fetch_object($res, CUBRID_LOB)class demodb_code {    public $s_name = null;    public $f_name = null;    public function toString() {        var_dump($this);    }}var_dump(cubrid_fetch_object($res, "demodb_code"));// if you want to operate LOB object, you can use cubrid_fetch_object($res, "demodb_code", CUBRID_LOB)class demodb_code_construct extends demodb_code {    public function __construct($s, $f) {        $this->s_name = $s;         $this->f_name = $f;     }   }var_dump(cubrid_fetch_object($res, 'demodb_code_construct', array('s_name', 'f_name')));// if you want to operate LOB object, you can use cubrid_fetch_object($res, 'demodb_code_construct', array('s_name', 'f_name'), CUBRID_LOB)var_dump(cubrid_fetch_object($res));cubrid_close_request($res);cubrid_disconnect($conn);?>

The above example will output:

    object(stdClass)#1 (2) {
      ["s_name"]=>
      string(1) "X"
      ["f_name"]=>
      string(5) "Mixed"
    }
    object(demodb_code)#1 (2) {
      ["s_name"]=>
      string(1) "W"
      ["f_name"]=>
      string(5) "Woman"
    }
    object(demodb_code_construct)#1 (2) {
      ["s_name"]=>
      string(6) "s_name"
      ["f_name"]=>
      string(6) "f_name"
    }
    object(stdClass)#1 (2) {
      ["s_name"]=>
      string(1) "B"
      ["f_name"]=>
      string(6) "Bronze"
    }

### See Also

- cubrid_execute() - Execute a prepared SQL statement
- cubrid_fetch() - Fetch the next row from a result set
- cubrid_fetch_array() - Fetch a result row as an associative array, a numeric array, or both
- cubrid_fetch_assoc() - Return the associative array that corresponds to the fetched row
- cubrid_fetch_row() - Return a numerical array with the values of the current row