cubrid_is_instance

Description

The cubrid_is_instance() function is used to check whether an instance referred to by an OID exists in the database.

Syntax

int cubrid_is_instance (resource $conn_identifier, string $oid)

• conn_identifier : Connection identifier
• oid : OID of an instance, for which you want to check whether it exists

Return Value

• An instance exists : 1
• An instance does not exist : 0
• An error occurs : -1

Example

<?php

$conn = cubrid_connect("localhost", 33000, "demodb");

$sql = <<EOD

SELECT host_year, medal, game_date

FROM game

WHERE athlete_code IN

    (SELECT code FROM athlete WHERE name='Thorpe Ian');

EOD;

$req = cubrid_execute($conn, $sql, CUBRID_INCLUDE_OID);

$oid = cubrid_current_oid($req);

$res = cubrid_is_instance ($conn, $oid);

if ($res == 1) {

    echo "Instance pointed by $oid exists.\n";

} else if ($res == 0){

    echo "Instance pointed by $oid doesn't exist.\n";

} else {

    echo "error\n";

}

cubrid_disconnect($conn);

?>

The above example will output:

Instance pointed by @0|0|0 doesn't exist.

See Also

• cubrid_drop
• cubrid_get_class_name