IFX_PCONNECT(3) 1 IFX_PCONNECT(3)ifx_pconnect - Open persistent Informix connectionSYNOPSIS
resource ifx_pconnect ([string $database], [string $userid], [string $password])
DESCRIPTION ifx_pconnect(3) acts very much like ifx_connect(3) 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, username and
password. 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 (ifx_close(3) will not close links established by ifx_pconnect(3)).
This type of links is therefore called 'persistent'.
PARAMETERS
All of the arguments are optional, and if they're missing, defaults are taken from values supplied in php.ini (ifx.default_host for the
host (Informix libraries will use INFORMIXSERVER environment value if not defined), ifx.default_user for user, ifx.default_password for the
password (none if not defined).
o $database
- The database name, as a string.
o $userid
- The username, as a string.
o $password
- The password, as a string.
RETURN VALUES
Returns: valid Informix persistent link identifier on success, or FALSE on errors.
SEE ALSO ifx_connect(3).
PHP Documentation Group IFX_PCONNECT(3)
Check Out this Related Man Page
IBASE_PCONNECT(3) 1 IBASE_PCONNECT(3)ibase_pconnect - Open a persistent connection to an InterBase databaseSYNOPSIS
resource ibase_pconnect ([string $database], [string $username], [string $password], [string $charset], [int $buffers], [int
$dialect], [string $role], [int $sync])
DESCRIPTION
Opens a persistent connection to an InterBase database.
ibase_pconnect(3) acts very much like ibase_connect(3) with two major differences.
First, when connecting, the function will first try to find a (persistent) link that's already opened with the same parameters. If one is
found, an identifier for it will be returned instead of opening a new connection.
Second, the connection to the InterBase server will not be closed when the execution of the script ends. Instead, the link will remain
open for future use (ibase_close(3) will not close links established by ibase_pconnect(3)). This type of link is therefore called 'persis-
tent'.
PARAMETERS
o $database
- The $database argument has to be a valid path to database file on the server it resides on. If the server is not local, it must
be prefixed with either 'hostname:' (TCP/IP), '//hostname/' (NetBEUI) or 'hostname@' (IPX/SPX), depending on the connection proto-
col used.
o $username
- The user name. Can be set with the ibase.default_user php.ini directive.
o $password
- The password for $username. Can be set with the ibase.default_password php.ini directive.
o $charset
-$charset is the default character set for a database.
o $buffers
-$buffers is the number of database buffers to allocate for the server-side cache. If 0 or omitted, server chooses its own
default.
o $dialect
-$dialect selects the default SQL dialect for any statement executed within a connection, and it defaults to the highest one sup-
ported by client libraries. Functional only with InterBase 6 and up.
o $role
- Functional only with InterBase 5 and up.
o $sync
-
RETURN VALUES
Returns an InterBase link identifier on success, or FALSE on error.
SEE ALSO ibase_close(3), ibase_connect(3).
PHP Documentation Group IBASE_PCONNECT(3)
Currently running Informix 7.23 UC11 on HP UX 10.20. Want to upgrade O/S to HP UX 11i. ANyone done this before? will informix 7.23 run on 11i? Thanks. (4 Replies)
Hey..
I'm writing a code to download some stuff from Informix database and put it on Xls. It works fine, but I have a problem fitting in a new requirement.
I have currently a file which has information like below.
f_name|Ronnie|Johnson|23.00|
f_sal|Ronnie|Jhonson|4000.00|... (4 Replies)
I have following.
.
.
.
$userid = 2
.
$query = "select username from users where userid = ".$userid.";";
.
$username = $line;
$data="Some Data Here";
.
$query = "insert into logger (username, data) valuse ($username, $data);";
.
I would like to not have 2 database calls. (3 Replies)
Hi
I would like to take input from user like username/password@connectstring
I should be able to cut the username and password and connect string
for example if someone enters like
sam/sammy@ora1
my program should take sam as username sammy as password and ora1 as connectstring and... (3 Replies)
Hi All,
My script gets aborted as it is connecting as a remote database through a DB link on every 3rd sunday.As the remote DB is down for more than 6 hours.
Can TNSPING DBNAME inside my script ensure the database is up???
Then how can i check the database is up or down ?
... (2 Replies)
Hi All,
Could anyone please help me with the command or script for checking the password expiry for a particular userid on AIX.
Regards,
Sanjay...:) (5 Replies)
Hi Everyone,
I want to know which database (Oracle,SQL,Informix...) are installed on Unix Machine.
I have very limited experience on Unix Environment, :confused: So I have no idea of getting this information. But in windows we can get Service names using WMI. Is there any similar way of Doing... (5 Replies)
Hi all,
I have problem to set up a persistent oracle connection in child thread.
We have a massive batch process dealing with large data. Application was written and impossible to be rewritten. I am trying to extract the most time consuming data fetching and put it into a dedicated child... (3 Replies)
Hi All,
I need to execute a SQL via shell script and i am connecting to Oracle DB by this way $USERNAME1/$PASSWORD1@$STRING1 and i need to get username, password and string from someother file stored in the Unix Directory. $Username, $Password and $String is stored in File A in Path A and i want... (3 Replies)
Hi Experts,
I am writing a shell script (for displaying disk space details) which is logging to 15 different servers using following command.
ssh userid@servername
It is prompting me for password for all 15 servers when I manually run it.
However , soon I would like to schedule this script... (4 Replies)
Hi guys,
Anybody is running Informix Dynamic Server on Open Server 6?
Can you share your kernel parameters for SHM, SEM, etc.?
I have a situation where oninit stops starting when the BUFFERS Informix parameter is increased. Already went through the machine release notes for Informix but... (6 Replies)
Hello,
One of my colleagues is working on a p730 without HMC, only one LPAR has all resources.
The server is showing some issues with Informix (10.00 & 11.50), the same config (OS & IFX) works perfectly on Power6 so I would like to ask him to change the processor compatibility mode to power6 on... (3 Replies)
Hi,
I need help in creating script for "User password reset in database" by logging into database from linux server and resetting the user password.
Could you please provide the script for this task?
Steps are given below.
1. Login into database from server
sqlplus... (5 Replies)