06-27-2013
Hi Thomas,
Yes..You can use n number of parameters,jus need to add only in the printf statements in terms of %s and $n.
regards,
kumar
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
I am pasting my code below
if # e means file exists
then
echo OFR_Configlist exists >> OFR_Backup_Configfiles.log
else
echo OFR_Configlist Not exists >> OFR_Backup_Configfiles.log
exit
fi
How can i show the echo message in console also at the same time?
I dont want to write... (3 Replies)
Discussion started by: subin_bala
3 Replies
2. UNIX for Dummies Questions & Answers
Hi,
Good morning. Would you please explain to me what does it mean by the following command.
echo "$$ $# $@" >> /opt/ftp_generic_send.log
I know that something is being directed to log file, but not sure what exactly mean by those $$ and $# and $@ means.
Thank you for your help.... (3 Replies)
Discussion started by: howdy
3 Replies
3. Shell Programming and Scripting
Can anybody tell me what does following command do?
# echo gsoc1 | ./configure_cmd.sh
Regards,
akash mahakode (1 Reply)
Discussion started by: akash_mahakode
1 Replies
4. Linux
Hi all,
I am executing a Oracle SQL statement in a shell script and spooling the output of the query into a File with spool command.
I want to ensure that only output of the query appears in file excluding the SQL statement but even set echo off command is not working.
Please help (7 Replies)
Discussion started by: sumi_mn
7 Replies
5. Shell Programming and Scripting
Hi Friends,
I am trying a very simple thing to print through bash shell scripting using echo but failing. My script is-
A=Abha
B=Biha
C=2011
D=5
echo " The name is $A_$B$C0$D"
It should print-
"The name is Abha_Biha201105"
but it's printing something else. Is my script wrong?... (2 Replies)
Discussion started by: NARESH1302
2 Replies
6. Shell Programming and Scripting
Hi All
I want to use the echo command to had some lines to a file but the lines i want to have contain " and ;
here is my command
system("echo user_pref("accessibility.typeaheadfind.flashBar", 0); > $profile");
but i think there are too many " and so it barfs
n e ideas
thanks
A (5 Replies)
Discussion started by: ab52
5 Replies
7. UNIX for Dummies Questions & Answers
Hi All
I have the big statement which needs to be appended to the file MANUALLY without opening the file.
So, i tried with echo command
echo " failure ( 4446): for host xx.xx.xx.xxx trying to GET /index.html, wl-proxy reports: exception occurred for backend host 'xx.xx.xxx.xx/12210/12210':... (11 Replies)
Discussion started by: Kalaiela
11 Replies
8. Shell Programming and Scripting
Hello
i am trying to do some calculation from output command
for example
ls -l
if
then
echo "error"
else
echo "$"
fi
its something like this
which get strings from output command and try to sum total lines of this string if exceed certain number it display error
if not it... (3 Replies)
Discussion started by: mogabr
3 Replies
9. Shell Programming and Scripting
Hi All,
I am using the below script which has awk command, but it is not returing the expected result. can some pls help me to correct the command.
The below script sample.ksh should give the result if the value of last 4 digits in the variable NM matches with the variable value DAT. The... (7 Replies)
Discussion started by: G.K.K
7 Replies
10. Shell Programming and Scripting
Hello,
I have written a command n shell script :
srvctl relocate service -d t1 -s s1 -i i1 -t t1 -f
If the above command executes successfully without error I need to echo
"Service relocated successfully
and If it errors out I need to trap the errors in a file and also need to make... (1 Reply)
Discussion started by: Vishal_dba
1 Replies
LEARN ABOUT PHP
mysqli_prepare
MYSQLI_PREPARE(3) 1 MYSQLI_PREPARE(3)
mysqli::prepare - Prepare an SQL statement for execution
Object oriented style
SYNOPSIS
mysqli_stmt mysqli::prepare (string $query)
DESCRIPTION
Procedural style
mysqli_stmt mysqli_prepare (mysqli $link, string $query)
Prepares the SQL query, and returns a statement handle to be used for further operations on the statement. The query must consist of a
single SQL statement.
The parameter markers must be bound to application variables using mysqli_stmt_bind_param(3) and/or mysqli_stmt_bind_result(3) before exe-
cuting the statement or fetching rows.
PARAMETERS
o $
link -Procedural style only: A link identifier returned by mysqli_connect(3) or mysqli_init(3)
o $query
- The query, as a string.
Note
You should not add a terminating semicolon or g to the statement.
This parameter can include one or more parameter markers in the SQL statement by embedding question mark ( ?) characters at the
appropriate positions.
Note
The markers are legal only in certain places in SQL statements. For example, they are allowed in the VALUES() list of an
INSERT statement (to specify column values for a row), or in a comparison with a column in a WHERE clause to specify a com-
parison value.
However, they are not allowed for identifiers (such as table or column names), in the select list that names the columns to
be returned by a SELECT statement, or to specify both operands of a binary operator such as the = equal sign. The latter
restriction is necessary because it would be impossible to determine the parameter type. It's not allowed to compare marker
with NULL by ? IS NULL too. In general, parameters are legal only in Data Manipulation Language (DML) statements, and not in
Data Definition Language (DDL) statements.
RETURN VALUES
mysqli_prepare(3) returns a statement object or FALSE if an error occurred.
EXAMPLES
Example #1
mysqli::prepare 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();
}
$city = "Amersfoort";
/* create a prepared statement */
if ($stmt = $mysqli->prepare("SELECT District FROM City WHERE Name=?")) {
/* bind parameters for markers */
$stmt->bind_param("s", $city);
/* execute query */
$stmt->execute();
/* bind result variables */
$stmt->bind_result($district);
/* fetch value */
$stmt->fetch();
printf("%s is in district %s
", $city, $district);
/* close statement */
$stmt->close();
}
/* 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();
}
$city = "Amersfoort";
/* create a prepared statement */
if ($stmt = mysqli_prepare($link, "SELECT District FROM City WHERE Name=?")) {
/* bind parameters for markers */
mysqli_stmt_bind_param($stmt, "s", $city);
/* execute query */
mysqli_stmt_execute($stmt);
/* bind result variables */
mysqli_stmt_bind_result($stmt, $district);
/* fetch value */
mysqli_stmt_fetch($stmt);
printf("%s is in district %s
", $city, $district);
/* close statement */
mysqli_stmt_close($stmt);
}
/* close connection */
mysqli_close($link);
?>
The above examples will output:
Amersfoort is in district Utrecht
SEE ALSO
mysqli_stmt_execute(3), mysqli_stmt_fetch(3), mysqli_stmt_bind_param(3), mysqli_stmt_bind_result(3), mysqli_stmt_close(3).
PHP Documentation Group MYSQLI_PREPARE(3)