I keep getting an error at line 21, it doesn't like my if statement. Previously I have tried using (( )), but still get errors. The current error is that server_busy is not found. This is the script: added code tags --oombera
I need an IF statement that will compare the contents of the variable CX with the actual string "CP". ie. If the contents of $CX are NOT equal to the actual string "CP" then blah blah blah.
I have tried a number of things including the following.......
if ]; then
if ]; then
if ];... (2 Replies)
hi all. i just have a very small problem. i have a menu of 7 choices. i want an if statement so that if the user chooses anything except inside the 1 to 7 range, i can handle the error for it.
i tried this:
if ]
then
.......
fi
(but it dont work)
...any suggestions?
... (4 Replies)
The problem I am having here is that only the 1st option is executed, no matter if I pick yes or no. What am I doing wrong? How can I get this working right without resorting to a case statement?
echo "This is the max size your lvol can be:"
echo $MAXSIZE
echo
echo Do you want to max out... (2 Replies)
Hi I have a bash script like this
if
then
echo "A"
else
echo "B"
fi
$1 is something like 02350 (there is always a trailing '0')
and I would like to have an if based on the value of the digits after the 0.
Can anybody help?
Thanks,
Sarah (3 Replies)
Could someone help me out with this if statement? It's supposed to get a person's website, but it isn't working when I run it.
website=""
echo "Would you like to enter a website? Enter Yes/No"
read choice
if
then
while
do
echo "Please enter a website:";
read... (4 Replies)
Writing my script and I'm banging my head on the desk right now ...
My biggest problem is the 3rd IF statement where I check if the username exists. Doing the grep command on it's own in the shell gives me a 1 or 0 value. Running the script, it always returns a false value (runs the ELSE... (4 Replies)
Hi,
Here is a big head scratcher for me....
I'm creating a loop with while reading lines from a file called example.txt:
#!/bin/sh
while read line
do
some command > another file ----- output to another file
done < example.txt
I would like that another file to be unique for every... (5 Replies)
echo "Enter the variable: " "
read var1
echo " "
for i in ib eb atm
do
if ; then
mv properties environment.properties
break
else
echo "No changes to $var1 "
fi
done
When i run and enter the eb it's not working.Any suggestions please.. (7 Replies)
Hi All,
I am writing an if statement to check multiple conditions, but when I try to execute the script it is breaking at the point of if statement by showing the issue below.
Code I am using is given below.
if -a ]
then
....
else
...
fi
I am not understanding... (3 Replies)
Discussion started by: ginrkf
3 Replies
LEARN ABOUT PHP
db2_prepare
DB2_PREPARE(3) 1 DB2_PREPARE(3)db2_prepare - Prepares an SQL statement to be executedSYNOPSIS
resource db2_prepare (resource $connection, string $statement, [array $options])
DESCRIPTION db2_prepare(3) creates a prepared SQL statement which can include 0 or more parameter markers ( ? characters) representing parameters for
input, output, or input/output. You can pass parameters to the prepared statement using db2_bind_param(3), or for input values only, as an
array passed to db2_execute(3).
There are three main advantages to using prepared statements in your application:
o Performance: when you prepare a statement, the database server creates an optimized access plan for retrieving data with that
statement. Subsequently issuing the prepared statement with db2_execute(3) enables the statements to reuse that access plan and
avoids the overhead of dynamically creating a new access plan for every statement you issue.
o Security: when you prepare a statement, you can include parameter markers for input values. When you execute a prepared statement
with input values for placeholders, the database server checks each input value to ensure that the type matches the column defini-
tion or parameter definition.
o Advanced functionality: Parameter markers not only enable you to pass input values to prepared SQL statements, they also enable
you to retrieve OUT and INOUT parameters from stored procedures using db2_bind_param(3).
PARAMETERS
o $connection
- A valid database connection resource variable as returned from db2_connect(3) or db2_pconnect(3).
o $statement
- An SQL statement, optionally containing one or more parameter markers..
o $options
- An associative array containing statement options. You can use this parameter to request a scrollable cursor on database servers
that support this functionality. For a description of valid statement options, see db2_set_option(3).
RETURN VALUES
Returns a statement resource if the SQL statement was successfully parsed and prepared by the database server. Returns FALSE if the data-
base server returned an error. You can determine which error was returned by calling db2_stmt_error(3) or db2_stmt_errormsg(3).
EXAMPLES
Example #1
Preparing and executing an SQL statement with parameter markers
The following example prepares an INSERT statement that accepts four parameter markers, then iterates over an array of arrays con-
taining the input values to be passed to db2_execute(3).
<?php
$animals = array(
array(0, 'cat', 'Pook', 3.2),
array(1, 'dog', 'Peaches', 12.3),
array(2, 'horse', 'Smarty', 350.0),
);
$insert = 'INSERT INTO animals (id, breed, name, weight)
VALUES (?, ?, ?, ?)';
$stmt = db2_prepare($conn, $insert);
if ($stmt) {
foreach ($animals as $animal) {
$result = db2_execute($stmt, $animal);
}
}
?>
SEE ALSO db2_bind_param(3), db2_execute(3), db2_stmt_error(3), db2_stmt_errormsg(3).
PHP Documentation Group DB2_PREPARE(3)