09-16-2019
Hi RudiC,
Can you please explain the above code what you replied. How does the above code fetch Return code from file and assign SUCCESS FAIL WARNING based on it ?
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have a utility that opens a telnet session and allows me to execute commands through a script. The utility allows me to output to a text file whatever is outputted to screen.
This utility runs from a DOS prompt in Windows 95/98, NT or 2000. How can I mail text file this to a certain user.
I... (2 Replies)
Discussion started by: petrosi
2 Replies
2. UNIX for Advanced & Expert Users
I have one file say CM.txt which contains values like below.Its just a flat file
1000,A,X
1001,B,Y
1002,B,Z
...
..
total around 4 million lines of entries will be in that file.
Now i need to write another file CM1.txt which should have
1000,1
1001,2
1002,3
....
...
..
Here i... (6 Replies)
Discussion started by: sivasu.india
6 Replies
3. Shell Programming and Scripting
I have a list of mail ids in text file and want a ksh script that reads this text file and sends a mail to all mail ids with same subject line and content.
I am using UX-HP machine and KSH.
Thanks for help in advance! (5 Replies)
Discussion started by: Sriranga
5 Replies
4. UNIX for Advanced & Expert Users
Hi All,
Requirement is to select the data from database and send the output in mail. But the output should in HTML tabular format in mail body.
For example my select command is :
select ename,esal,edegn,dept from emp where deptno in (10,15);
In the mail body the output should :
Employee... (3 Replies)
Discussion started by: alex_us
3 Replies
5. UNIX for Advanced & Expert Users
only wc -l greater than 0 then send email to owner, otherwise do nothing.
ie.
result=powermt display dev=all|awk '{print $7}'|grep -i dead|wc -l
if
then
echo $result
else
:
fi
mailx -s "there is dead path (s)" "mymail@mydomain.com"
-----------
it is not working... (2 Replies)
Discussion started by: orafup
2 Replies
6. Shell Programming and Scripting
I am generating a output:
Name Count_1 Count_2
abc 12 12
def 15 14
ghi 16 16
jkl 18 18
mno 7 5
I am sending the output in html email, I want to add the code:
<font color="red"> NAME COLUMN record </font>
for the Name... (8 Replies)
Discussion started by: karumudi7
8 Replies
7. Shell Programming and Scripting
Hi All,
I want to change the name as SEQ_13
ie., <Property Name="Name">SEQ_13</Property>
when the Stage Type is PxSequentialFile
ie., <Property Name="StageType">PxSequentialFile</Property> :wall:
Input.XML
<Main>
<Record Identifier="V0S13" Type="CustomStage" Readonly="0">... (3 Replies)
Discussion started by: kmsekhar
3 Replies
8. Shell Programming and Scripting
Hello Gurus,
I have a question.
I have a file which has 2 columns and is tab separated and looks like below:
FIELD1 FIELD2
Manual m456@hotmail.com
Execution din098@gmail.com
Artistic m456@hotmail.com
Graphic din098@gmail.com
FIELD2 values will have always either of the 2 above... (8 Replies)
Discussion started by: Max499
8 Replies
9. UNIX for Advanced & Expert Users
Hi All,
I have records in a file with name,SSO,openitems,manageremail with | delimited file.Now i want to group the records by SSO and openitems and send email to their manageremail.
kiran|1111|draft|aaa@gmail.com
guna|2222|reject|bbb@gmail.com
kiran|1111|submitter|aaa@gmail.com... (2 Replies)
Discussion started by: kiranparsha
2 Replies
10. UNIX for Beginners Questions & Answers
Hi All,
I am having a job and I need to send email when the job is running. On any other case (success,fail) I don't needed to send email. I check with BMC they told they dont have that in the version I am using.
So I created a dependent job and grepped for the status and sent email. My... (1 Reply)
Discussion started by: arunkumar_mca
1 Replies
LEARN ABOUT PHP
mysqli_stmt_fetch
MYSQLI_STMT_FETCH(3) 1 MYSQLI_STMT_FETCH(3)
mysqli_stmt::fetch - Fetch results from a prepared statement into the bound variables
Object oriented style
SYNOPSIS
bool mysqli_stmt::fetch (void )
DESCRIPTION
Procedural style
bool mysqli_stmt_fetch (mysqli_stmt $stmt)
Fetch the result from a prepared statement into the variables bound by mysqli_stmt_bind_result(3).
Note
Note that all columns must be bound by the application before calling mysqli_stmt_fetch(3).
Note
Data are transferred unbuffered without calling mysqli_stmt_store_result(3) which can decrease performance (but reduces memory
cost).
PARAMETERS
o $
stmt -Procedural style only: A statement identifier returned by mysqli_stmt_init(3).
RETURN VALUES
Return Values
+------+---------------------------------------------------+
|Value | |
| | |
| | Description |
| | |
+------+---------------------------------------------------+
| | |
|TRUE | |
| | |
| | Success. Data has been fetched |
| | |
| | |
|FALSE | |
| | |
| | Error occurred |
| | |
| | |
|NULL | |
| | |
| | No more rows/data exists or data truncation |
| | occurred |
| | |
+------+---------------------------------------------------+
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();
}
$query = "SELECT Name, CountryCode FROM City ORDER by ID DESC LIMIT 150,5";
if ($stmt = $mysqli->prepare($query)) {
/* execute statement */
$stmt->execute();
/* bind result variables */
$stmt->bind_result($name, $code);
/* fetch values */
while ($stmt->fetch()) {
printf ("%s (%s)
", $name, $code);
}
/* 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();
}
$query = "SELECT Name, CountryCode FROM City ORDER by ID DESC LIMIT 150,5";
if ($stmt = mysqli_prepare($link, $query)) {
/* execute statement */
mysqli_stmt_execute($stmt);
/* bind result variables */
mysqli_stmt_bind_result($stmt, $name, $code);
/* fetch values */
while (mysqli_stmt_fetch($stmt)) {
printf ("%s (%s)
", $name, $code);
}
/* close statement */
mysqli_stmt_close($stmt);
}
/* close connection */
mysqli_close($link);
?>
The above examples will output:
Rockford (USA)
Tallahassee (USA)
Salinas (USA)
Santa Clarita (USA)
Springfield (USA)
SEE ALSO
mysqli_prepare(3), mysqli_stmt_errno(3), mysqli_stmt_error(3), mysqli_stmt_bind_result(3).
PHP Documentation Group MYSQLI_STMT_FETCH(3)