cubrid_pconnect

(PECL CUBRID >= 8.3.1)

cubrid_pconnectOpen a persistent connection to a CUBRID server

Description

cubrid_pconnect(
    string $host,
    int $port,
    string $dbname,
    string $userid = ?,
    string $passwd = ?
): resource

Establishes a persistent connection to a CUBRID server.

cubrid_pconnect() acts very much like cubrid_connect() with two major differences.

First, when connecting, the function would first try to find a (persistent) link that's already open with the same host, port, dbname and userid. If one is found, an identifier for it will be returned instead of opening a new connection.

Second, the connection to the SQL server will not be closed when the execution of the script ends. Instead, the link will remain open for future use (cubrid_close() or cubrid_disconnect() will not close links established by cubrid_pconnect()).

This type of link is therefore called 'persistent'.

Parameters

host

Host name or IP address of CUBRID CAS server.

port

Port number of CUBRID CAS server (BROKER_PORT configured in $CUBRID/conf/cubrid_broker.conf).

dbname

Name of database.

userid

User name for the database.

passwd

User password.

Return Values

Connection identifier, when process is successful, or false on failure.

Examples

Example #1 cubrid_connect() example

<?php
printf
("%-30s %s\n""CUBRID PHP Version:"cubrid_version());

printf("\n");

$conn cubrid_pconnect("localhost"33000"demodb""dba");

if (!
$conn) {
    die(
'Connect Error ('cubrid_error_code() .')' cubrid_error_msg());
}

$db_params cubrid_get_db_parameter($conn);

while (list(
$param_name$param_value) = each($db_params)) {
    
printf("%-30s %s\n"$param_name$param_value);
}

printf("\n");

$server_info cubrid_get_server_info($conn);
$client_info cubrid_get_client_info();

printf("%-30s %s\n""Server Info:"$server_info);
printf("%-30s %s\n""Client Info:"$client_info);

printf("\n");

$charset cubrid_get_charset($conn);

printf("%-30s %s\n""CUBRID Charset:"$charset);

cubrid_disconnect($conn);
?>

The above example will output:

CUBRID PHP Version:            9.1.0.0001

PARAM_ISOLATION_LEVEL          3
LOCK_TIMEOUT                   -1
MAX_STRING_LENGTH              1073741823
PARAM_AUTO_COMMIT              1

Server Info:                   9.1.0.0212
Client Info:                   9.1.0

CUBRID Charset:                iso8859-1

See Also

Here you can write a comment


Please enter at least 10 characters.
Loading... Please wait.
* Pflichtangabe
There are no comments available yet.

PHP cURL Tutorial: Using cURL to Make HTTP Requests

cURL is a powerful PHP extension that allows you to communicate with different servers using various protocols, including HTTP, HTTPS, FTP, and more. ...

TheMax

Autor : TheMax
Category: PHP-Tutorials

Midjourney Tutorial - Instructions for beginners

There is an informative video about Midjourney, the tool for creating digital images using artificial intelligence, entitled "Midjourney tutorial in German - instructions for beginners" ...

Mike94

Autor : Mike94
Category: KI Tutorials

Basics of views in MySQL

Views in a MySQL database offer the option of creating a virtual table based on the result of an SQL query. This virtual table can be queried like a normal table without changing the underlying data. ...

admin

Autor : admin
Category: mySQL-Tutorials

Publish a tutorial

Share your knowledge with other developers worldwide

Share your knowledge with other developers worldwide

You are a professional in your field and want to share your knowledge, then sign up now and share it with our PHP community

learn more

Publish a tutorial