Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

cubrid_ping(3) [php man page]

CUBRID_PING(3)								 1							    CUBRID_PING(3)

cubrid_ping - Ping a server connection or reconnect if there is no connection

SYNOPSIS
bool cubrid_ping ([resource $conn_identifier]) DESCRIPTION
Checks whether or not the connection to the server is working. PARAMETERS
o $conn_identifier - The CUBRID connection identifier. If the connection identifier is not specified, the last connection opened by cubrid_connect(3) is assumed. RETURN VALUES
Returns TRUE if the connection to the server CUBRID server is working, otherwise FALSE. EXAMPLES
Example #1 cubrid_ping(3) example <?php set_time_limit(0); $conn = cubrid_connect('localhost', 33000, 'demodb'); /* Assuming this query will take a long time */ $sql = "select * from athlete"; $result = cubrid_query($sql); if (!$result) { echo 'Query #1 failed, exiting.'; exit; } /* Make sure the connection is still alive, if not, try to reconnect */ if (!cubrid_ping($conn)) { echo 'Lost connection, exiting after query #1'; exit; } cubrid_free_result($result); /* So the connection is still alive, let's run another query */ $sql2 = "select * from code"; $result2 = cubrid_query($sql2); ?> PHP Documentation Group CUBRID_PING(3)

Check Out this Related Man Page

CUBRID_ERRNO(3) 							 1							   CUBRID_ERRNO(3)

cubrid_errno - Return the numerical value of the error message from previous CUBRID operation

SYNOPSIS
int cubrid_errno ([resource $conn_identifier]) DESCRIPTION
Returns the error number from the last CUBRID function. The cubrid_errno(3) function is used to get the error code of the error that occurred during the API execution. Usually, it gets the error code when API returns false as its return value. PARAMETERS
o $conn_identifier - The CUBRID connection identifier. If the connection identifier is not specified, the last connection opened by cubrid_connect(3) is assumed. RETURN VALUES
Returns the error number from the last CUBRID function, or 0 (zero) if no error occurred. EXAMPLES
Example #1 cubrid_errno(3) example <?php $con = cubrid_connect('localhost', 33000, 'demodb', 'dba', ''); $req = cubrid_execute($con, "select id, name from person"); if ($req) { while (list ($id, $name) = cubrid_fetch($req)) echo $id, $name; } else { echo "Error Code: ", cubrid_errno($con); echo "Error Message: ", cubrid_error($con); } ?> The above example will output: Error Code: -493 Error Message: Syntax: Unknown class "person". select id, [name] from person SEE ALSO
cubrid_error(3), cubrid_error_code(3), cubrid_error_msg(3). PHP Documentation Group CUBRID_ERRNO(3)
Man Page

14 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Signal Processing

Hello, Can any body give example of using Unix Signals. What I want to do is I am running a sql query in a shell script I want, if sql query exceed the defined no. of seconds limit, then I would like to kill the process. I know this can be done thru Unix Signal Handling but I do not know... (8 Replies)
Discussion started by: sanjay92
8 Replies

2. Shell Programming and Scripting

Help With Shell Scripts

if I run the below mentioned code, i am getting error. I dunno why. plz help me out this code runs a sql query and sends the result by email #!/bin/ksh # # Purpose: - Report Workflows that have Persistence turned ON echo "Workflow Persistence Report Started: `date '+%Y%m%d_%H%M%S'`" >>... (6 Replies)
Discussion started by: ragha81
6 Replies

3. Shell Programming and Scripting

any possible to run sql result and output to file

Hi, I search all post...and no soluation about..if i would like to run a sql statement and output the result to txt file. for example, i usually run "sql" to logon the database and run select statement. Then I need to copy the output into the result.txt. Can I run the script to do this... (7 Replies)
Discussion started by: happyv
7 Replies

4. Shell Programming and Scripting

How to store the data retrived by a select query into variables?

Hi Friends, Can u please help mw with the following query . I need to run a database sql statement to select particular fields from a table.I need to store the retrieved filed values into variables so that i can print it in a specific format. But the particular select query retrieves more... (12 Replies)
Discussion started by: jisha
12 Replies

5. Programming

problem with sql command in pro*c

In a pro*C program, I use query follow: INSERT INTO radacct_wk SELECT (select psid from cscterminfo where cscterminfo.TELNO = username), nasipaddress, acctstarttime, acctstoptime, acctsessiontime, acctinputoctets, acctoutputoctets, acctterminatecause, framedipaddress FROM radacct@DBSV_B;... (7 Replies)
Discussion started by: quynhtrang
7 Replies

6. Shell Programming and Scripting

need help in reading a output of a sql query in unix script

i'm used a sql query in a unix script to get the information from table. but unable to extract the output which i need. Any help with logic will be greatly appreciated. my sql query provide output some thing like this - col1 col2 count ---- ---- ------ A B 10 c D 6 e... (8 Replies)
Discussion started by: pharos467
8 Replies

7. Shell Programming and Scripting

how to add ; at the end of last line

hi, i have file which is having large sql query eg : i am executing this sql file but now i want to add ; after query on same line i.e. i should look like any idea how to achieve it ? (6 Replies)
Discussion started by: crackthehit007
6 Replies

8. UNIX for Dummies Questions & Answers

ORA-12154: TNS:could not resolve service name

Hi everyone, when i run ; sqlplus -s username/password@TTTEST @umt.sql i take "ORA-12154: TNS:could not resolve service name" i want to run "umt.sql" query and also see result. thanx for your helping. (6 Replies)
Discussion started by: temhem
6 Replies

9. Solaris

Access to ILOM (V440 server)

I have ALOM working on our V440 server but is there a way to get ILOM working on this server? (8 Replies)
Discussion started by: New2Sol
8 Replies

10. UNIX for Advanced & Expert Users

Script which will run every 10minutes and Send SMS to mobile

Hello Genuis guys, I am running Aix5 and Oracle 9 on it. I have sql query which only count a particular rows. I need to prepare a script which will run that sql query every 10 minutes and if the ouput count is greate than 20. It will send SMS to mobile numbers. Need your kind help to... (8 Replies)
Discussion started by: thepurple
8 Replies

11. Shell Programming and Scripting

Parallel SQL sessions in shell script

i have 3 sqls , sql 1 and sql 2 shuld run in parallel , but sql 3 should run after completion f sql1 nd sql2, my code is as below, please suggest the changes sqlplus username1/password1@DB1 @sql >> log1 & sqlplus username2/password2@DB2 @sql2 >> log1 & how can i execute the... (7 Replies)
Discussion started by: only4satish
7 Replies

12. Shell Programming and Scripting

Shell script to run sql query having a long listing of parameters

Hi, I have a query regarding execution of a sql query having long listing of parameters ..I need to execute this query inside a shell script. The scenario is like.... Suppose I have a file abc.txt that has the card numbers..it could be in thousands.. then I need to fire a query like ... (12 Replies)
Discussion started by: vsachan
12 Replies

13. Shell Programming and Scripting

How to get sql command with output in files?

I tried executing set of queries from shell script but not able to capture the input query in the log file,but the input query is not displayed along with output. Only the outputs are being captured in the log file. Is there a way to capture the input query along with the corresponding input?? (8 Replies)
Discussion started by: pallvi_mahajan
8 Replies

14. Shell Programming and Scripting

Sql query output count

Hi Team, below sql rerturn 20 records, the result set i am going to assign to one variable and it showing count is 1. and i don't use count() in sql query... based on count, i need to fail the script. No_of_step=`echo ${g_count} | wc -l` function gf_count() { g_count=`sqlplus -s... (8 Replies)
Discussion started by: bmk123
8 Replies