IBASE_EXECUTE(3) 1 IBASE_EXECUTE(3)ibase_execute - Execute a previously prepared querySYNOPSIS
resource ibase_execute (resource $query, [mixed $bind_arg], [mixed $...])
DESCRIPTION
Execute a query prepared by ibase_prepare(3).
This is a lot more effective than using ibase_query(3) if you are repeating a same kind of query several times with only some parameters
changing.
PARAMETERS
o $query
- An InterBase query prepared by ibase_prepare(3).
o $bind_arg
-
o $...
-
RETURN VALUES
If the query raises an error, returns FALSE. If it is successful and there is a (possibly empty) result set (such as with a SELECT query),
returns a result identifier. If the query was successful and there were no results, returns TRUE.
Note
This function returns the number of rows affected by the query (if > 0 and applicable to the statement type). A query that suc-
ceeded, but did not affect any rows (e.g. an UPDATE of a non-existent record) will return TRUE.
EXAMPLES
Example #1
ibase_execute(3) example
<?php
$dbh = ibase_connect($host, $username, $password);
$updates = array(
1 => 'Eric',
5 => 'Filip',
7 => 'Larry'
);
$query = ibase_prepare($dbh, "UPDATE FOO SET BAR = ? WHERE BAZ = ?");
foreach ($updates as $baz => $bar) {
ibase_execute($query, $bar, $baz);
}
?>
SEE ALSO ibase_query(3).
PHP Documentation Group IBASE_EXECUTE(3)
Check Out this Related Man Page
CUBRID_UNBUFFERED_QUERY(3) 1 CUBRID_UNBUFFERED_QUERY(3)cubrid_unbuffered_query - Perform a query without fetching the results into memorySYNOPSIS
resource cubrid_unbuffered_query (string $query, [resource $conn_identifier])
DESCRIPTION
This function performs a query without waiting for that all query results have been complete. It will return when the results are being
generated.
PARAMETERS
o $query
-A SQL query.
o $conn_identifier
-The CUBRID connection. If the connection identifier is not specified, the last connection opened by cubrid_connect(3) is assumed.
RETURN VALUES
For SELECT, SHOW, DESCRIBE or EXPLAIN statements returns a request identifier resource on success.
For other type of SQL statements, UPDATE, DELETE, DROP, etc, returns TRUE on success.
FALSE on failure.
NOTES
Note
The benefits of cubrid_unbuffered_query(3) come at a cost: you cannot use cubrid_num_rows(3) and cubrid_data_seek(3) on a result
set returned from cubrid_unbuffered_query(3).
EXAMPLES
Example #1
cubrid_unbuffered_query(3) example
<?php
$link = cubrid_connect("localhost", 30000, "demodb", "dba", "");
if (!$link)
{
die('Could not connect.');
}
$query = "select * from code";
$result = cubrid_unbuffered_query($query, $link);
while ($row = cubrid_fetch($result))
{
var_dump($row);
}
cubrid_close_request($result);
cubrid_disconnect($link);
?>
PHP Documentation Group CUBRID_UNBUFFERED_QUERY(3)
Hi
I am writng a script to spool some account nos information to .txt file but wants that information for each and every account no to be written in a different .txt file with account no as part of the file name of its associated file.
Thanks (32 Replies)
Hi All,
I have seen many examples of spooling query output in csv file.
But I want to spool the query results in proper excel file.
Can you guys help me on this? (4 Replies)
Hi
I am new in unix. oracle and unix are installed in my sytem.i need the script
which could connect to the oracle using username ,password and schema and can run the select * from tab query.
Thanks
vijay (8 Replies)
hi
i want to make script. where i want to query from the user yes or no
exp: do you want to proceed :
y for yes
n for NO.
how this is possible in unix (3 Replies)
Hi
Please can someone help me with a query. Will the following query bring back 'Jolly Brewers'. My understanding is that it will bring back either 'Jolly' or 'Brewers' but not 'Jolly Brewers'....because of the pipe
egrep '(Jolly)|(Brewers)' Public_Houses
Please can someone confirm?
... (6 Replies)
Can someone please give me a big help?
I'm trying to read the file below, which have the format:
query,XX,XX,6559,0.132,0.210,0.108,0.03%
query,XX,XX,6559,0.132,0.210,0.108,0.03%
query,XX,XX,6559,0.132,0.210,0.108,0.03%
Need to get the 4th value: 6559 and sum all and put it into a var:
... (2 Replies)
Hi ,
I am facing error in perl
when I assign a below query in a varibale $query because of new line charchters
$query=
SELECT XYZ
, ABC
, c2
, c3
, c4
FROM t1
how can i get rid of new line charchters with out changing the... (2 Replies)
Discussion started by: gvk25
2 Replies
8. Post Here to Contact Site Administrators and Moderators
Hi,
I have a query regarding searching the threads initiated by me.
Once i browse out from the page where i have started the query. i m not able to see the replies to my post later.
Is ther any tab where i can refer the threads started by me and the replies to it...at a later point.
... (3 Replies)
Dear community,
I have to do something too hard for me :rolleyes:. I hope you can help me.
This is an output coming from Oracle query, stored in a file called query.out, there are many rows, but I read them, one by one, using while/read/done. Assuming each row is contained into $line variable... (8 Replies)
I'm typing "id <user's id>" and its returning a different UID that what is defined in our administration system. Where does id / getent query and where is it configured to query? I'm guessing it queries the local /etc/passwd file first, and then if it doesn't find anything it would query LDAP... (2 Replies)
I'm looking for a way to neaten up the out put of an ldapquery. I might get one, none, or several returns for each query; and each query consists of multiple lines. And while each return will contain the same types of info, it might be in a different order, like:
uniq: 1
ip: 192.168.2.3... (3 Replies)
hey , i am using this code to store value of a sql query and and then use
it in other query but after some time , but it is not working. please help
#!/bin/bash
val_1=$( sqlplus -s rte/rted2@rel76d2 << EOF
setting heading off
select max(stat_id) from cvt_stats;
exit
EOF
)
nohup... (5 Replies)
I'm using a .txt file filled with domain names for dig to use, the problem is that when i look at the results I get the query time for each individual query, I want to know how long it took in total for all queries to run, how can I achieve this? any help would be greatly appreciated, thank you.... (3 Replies)
HI,
I am having scenario like to print multipule rows from output of database query
sample query i mentioned below
code=`db2 -x select code,values from dummy`
in the query output i am getting around 110 records with 2 columns.
sample output pasted below
code,value... (3 Replies)
Hello Friends,
I am using check_mysql_query plugin in nagios to query database and get output. query is working fine but output which i am getting contain query. I want to remove query from output and give custom message which will be simple and understandable.
Can you help me here with any... (5 Replies)