03-07-2014
Hi anbu23,
I am putting your statement in a function.
It doesnot work if i put your statement in a function because i am using $5 after awk statement. It tries to find the argument present in 5th positional parameter of the function.
Please suggest another way to substitue $5.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I need to have an if statement in a script to run if there are certain processes running. Easiest way I can see to do this is to run a ps and grep the results based on what I am looking for:
$ ps -ef | grep wtrs
---
webtrend 5046 1 0 May 12 ? 0:28 /webtrends/versions/6.1/wtrs_ui... (6 Replies)
Discussion started by: LordJezo
6 Replies
2. Shell Programming and Scripting
Does awk have a syntax for a range of numbers or is this the best way?
if ($1 >= 0 && $1 <= 9 ) (7 Replies)
Discussion started by: Arsenalman
7 Replies
3. Shell Programming and Scripting
Hi Gurus,
I've using HPUX B.11.23 U ia64 with shell = sh.
I've been having some problem get the highest number of this script.
Actually I wanted to get the highest number from this listing (TEST123 data and based on this highest number, there will be email being sent out.
For example,... (6 Replies)
Discussion started by: superHonda123
6 Replies
4. Shell Programming and Scripting
I've got a script with one massive case statement consisting of about 130 entries. Each entry essentially passes variables into a compiled executable. Is it possible to extract the code in a specific statement? Each case entry is unique :(
My goal is to dynamically create a flat file to... (4 Replies)
Discussion started by: ironhalo
4 Replies
5. Shell Programming and Scripting
Hi!
I have a file that contains non-regular strings like:
SCSGTI:N="$4,0,1,4,34622991111-->RemoteSPC: 1111", NWID=1;
SCSGTI:N="$4,0,1,4,34622991211-->RemoteSPC: 1211", NWID=1;
SCSGTI:N="$4,0,1,4,*-->RemoteSPC: 2112,Sec:RemoteSPC: 2212", NWID=1;
SCSGTI:N="$4,10,1,4,34622999213-->RemoteSPC:... (4 Replies)
Discussion started by: Flavius
4 Replies
6. Shell Programming and Scripting
I am trying to extract the numbers from the strings.
Lakers win 80% of the games
24 numbered Kobe scores 90% from free throw line
Chances of Lakers winning championship is 100%
I have data like this. and am looking to extract the %
80%
90%
100% (6 Replies)
Discussion started by: grajp002
6 Replies
7. Shell Programming and Scripting
Hi my code is as follow:
stringA=`cat /s01/oracle/11.2/network/admin/listener.ora | grep "PORT"`
stringB=`cat $ORACLE_HOME/network/admin/listener.ora | grep "PORT"`
stringC="PORT"
echo ${stringA}
echo ${stringB}
echo ${stringC}
position=`expr index "$stringB" "stringC"`
echo... (2 Replies)
Discussion started by: jediwannabe
2 Replies
8. Shell Programming and Scripting
Is it possible to test against a varible within a ranges in a if statement.
ex.
if ];then
echo "not in range"
else
echo "number within range"
fi (8 Replies)
Discussion started by: leemalloy
8 Replies
9. Shell Programming and Scripting
Hi
I am on Sun os. I have data in the below format and I need to grab the number out from the string.
O/p needed:
---------- Post updated at 12:39 PM ---------- Previous update was at 12:32 PM ----------
I tried this but I am getting . at the front (14 Replies)
Discussion started by: dsravanam
14 Replies
10. Shell Programming and Scripting
I have a lot of file with a lot of lines following the same pattern
the lines go like this:
alpha_9/output- -413.74928476 2.6116
and I want it to be:
9 -413.74928476 2.6116
thanks for the help (5 Replies)
Discussion started by: galboski
5 Replies
LEARN ABOUT PHP
mysqli_stmt_affected_rows
MYSQLI_STMT_AFFECTED_ROWS(3) 1 MYSQLI_STMT_AFFECTED_ROWS(3)
mysqli_stmt::$affected_rows - Returns the total number of rows changed, deleted, or inserted by the last executed statement
Object oriented style
SYNOPSIS
int$mysqli_stmt->affected_rows ()
DESCRIPTION
Procedural style
int mysqli_stmt_affected_rows (mysqli_stmt $stmt)
Returns the number of rows affected by INSERT, UPDATE, or DELETE query.
This function only works with queries which update a table. In order to get the number of rows from a SELECT query, use
mysqli_stmt_num_rows(3) instead.
PARAMETERS
o $
stmt -Procedural style only: A statement identifier returned by mysqli_stmt_init(3).
RETURN VALUES
An integer greater than zero indicates the number of rows affected or retrieved. Zero indicates that no records where updated for an
UPDATE/DELETE statement, no rows matched the WHERE clause in the query or that no query has yet been executed. -1 indicates that the query
has returned an error. NULL indicates an invalid argument was supplied to the function.
Note
If the number of affected rows is greater than maximal PHP int value, the number of affected rows will be returned as a string
value.
EXAMPLES
Example #1
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();
}
/* create temp table */
$mysqli->query("CREATE TEMPORARY TABLE myCountry LIKE Country");
$query = "INSERT INTO myCountry SELECT * FROM Country WHERE Code LIKE ?";
/* prepare statement */
if ($stmt = $mysqli->prepare($query)) {
/* Bind variable for placeholder */
$code = 'A%';
$stmt->bind_param("s", $code);
/* execute statement */
$stmt->execute();
printf("rows inserted: %d
", $stmt->affected_rows);
/* close statement */
$stmt->close();
}
/* close connection */
$mysqli->close();
?>
Example #2
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();
}
/* create temp table */
mysqli_query($link, "CREATE TEMPORARY TABLE myCountry LIKE Country");
$query = "INSERT INTO myCountry SELECT * FROM Country WHERE Code LIKE ?";
/* prepare statement */
if ($stmt = mysqli_prepare($link, $query)) {
/* Bind variable for placeholder */
$code = 'A%';
mysqli_stmt_bind_param($stmt, "s", $code);
/* execute statement */
mysqli_stmt_execute($stmt);
printf("rows inserted: %d
", mysqli_stmt_affected_rows($stmt));
/* close statement */
mysqli_stmt_close($stmt);
}
/* close connection */
mysqli_close($link);
?>
The above examples will output:
rows inserted: 17
SEE ALSO
mysqli_stmt_num_rows(3), mysqli_prepare(3).
PHP Documentation Group MYSQLI_STMT_AFFECTED_ROWS(3)