Hi,
I'm developing a system which requires me to run a ksh script from within a cgi script. What sort of syntax will I need to do this, I'm sure it's simple but can't find out how anywhere!
Thanks. (2 Replies)
Hi guys,
i know how to run a single query using mysql embedded in a shell script as follows:
`mysql -umyuser -pmypass --host myhost database<<SQL
${query};
quit
SQL`
However, how would i be able to run several queries within the same connection?
The reason for this is i am creating... (3 Replies)
Hi
I am new to this Scripting process and would like to know How can i write a ksh script that will call other ksh scripts and write the output to a file and/or email.
For example
-------
Script ABC
-------
a.ksh
b.ksh
c.ksh
I need to call all three scripts execute them and... (2 Replies)
hi i have a script called test.sh. the content is ls >> crontest.txt.
if i run manually it's giving output.but if i scheduled in crontab it's not giving output.
crontab entry:
02 * * * * /sms5/SMSHOME/eds_sh/test.sh >> /sms5/SMSHOME/eds_sh/testfile/logfile 2>&1
I am using ksh.is there... (2 Replies)
Hi,
I have a script where I make a sqlplus connection. In the script I have multiple sql queries within that sqlplus connection. I want the result of the queries to be stored in shell variables declared earlier. I dont want to use procedures. Is there anyway else.
Thanks in advance..
Cheers (6 Replies)
i ran the below in ksh...
nohup <script> &
it is runnign in background.
now how do i see if the above command is success...
i also need to bring the command to foreground and view the run details.
pls advise how to do that... (1 Reply)
Hi programmers, say I have 4 files : file1.py,file2.py,file3.py,file4.py
How do I, on a korn shell, create one file, run_all, that is one file that sequentially calls file1-file4, but only so if they complete w/o errors?
Something like:
#!/usr/bin/ksh
file1.py
/*......????*/
... (7 Replies)
how to store the count of queries in variables inside a filein shell script
my output :
filename
-------
variable1=result from 1st query
variable2=result from 2nd query
.
.
.
. (3 Replies)
How can i run sql queries from UNIX shell script and retrieve data into text docs of UNIX? :confused: (1 Reply)
Discussion started by: 24ajay
1 Replies
LEARN ABOUT PHP
mysqli_use_result
MYSQLI_USE_RESULT(3) 1 MYSQLI_USE_RESULT(3)mysqli::use_result - Initiate a result set retrieval
Object oriented style
SYNOPSIS
mysqli_result mysqli::use_result (void )
DESCRIPTION
Procedural style
mysqli_result mysqli_use_result (mysqli $link)
Used to initiate the retrieval of a result set from the last query executed using the mysqli_real_query(3) function on the database con-
nection.
Either this or the mysqli_store_result(3) function must be called before the results of a query can be retrieved, and one or the other
must be called to prevent the next query on that database connection from failing.
Note
The mysqli_use_result(3) function does not transfer the entire result set from the database and hence cannot be used functions such
as mysqli_data_seek(3) to move to a particular row within the set. To use this functionality, the result set must be stored using
mysqli_store_result(3). One should not use mysqli_use_result(3) if a lot of processing on the client side is performed, since this
will tie up the server and prevent other threads from updating any tables from which the data is being fetched.
RETURN VALUES
Returns an unbuffered result object or FALSE if an error occurred.
EXAMPLES
Example #1
mysqli::use_result example
Object oriented style
<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s
", mysqli_connect_error());
exit();
}
$query = "SELECT CURRENT_USER();";
$query .= "SELECT Name FROM City ORDER BY ID LIMIT 20, 5";
/* execute multi query */
if ($mysqli->multi_query($query)) {
do {
/* store first result set */
if ($result = $mysqli->use_result()) {
while ($row = $result->fetch_row()) {
printf("%s
", $row[0]);
}
$result->close();
}
/* print divider */
if ($mysqli->more_results()) {
printf("-----------------
");
}
} while ($mysqli->next_result());
}
/* close connection */
$mysqli->close();
?>
Procedural style
<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "world");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s
", mysqli_connect_error());
exit();
}
$query = "SELECT CURRENT_USER();";
$query .= "SELECT Name FROM City ORDER BY ID LIMIT 20, 5";
/* execute multi query */
if (mysqli_multi_query($link, $query)) {
do {
/* store first result set */
if ($result = mysqli_use_result($link)) {
while ($row = mysqli_fetch_row($result)) {
printf("%s
", $row[0]);
}
mysqli_free_result($result);
}
/* print divider */
if (mysqli_more_results($link)) {
printf("-----------------
");
}
} while (mysqli_next_result($link));
}
/* close connection */
mysqli_close($link);
?>
The above examples will output:
my_user@localhost
-----------------
Amersfoort
Maastricht
Dordrecht
Leiden
Haarlemmermeer
SEE ALSO mysqli_real_query(3), mysqli_store_result(3).
PHP Documentation Group MYSQLI_USE_RESULT(3)