02-16-2011
I don't know enough about php to know why it worked with unquoted "dagger" but I think it's good policy to quote all strings in any programming language. It might be worth investigating the string matching functions, too. Not only will it emphasize the fact that you are using strings but it gives you the option to ignore case if you like.
Andrew
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
When ever i run this if statement with the -n OR -z switches it always returns says positive and does "HAVE STUFF". BUT the file does not contain the word optimus in any form.
$echo this is mojo > test.file
$if ; then
>echo HAVE STUFF
>else^Jecho NO STUFF
>fi
HAVE STUFF
$if ; then... (1 Reply)
Discussion started by: Optimus_P
1 Replies
2. Shell Programming and Scripting
Wow I'm so zoned out I don't even know if I posted this question up already (I couldn't find it in my book marks or in "yesterday's" post).
My question is, I'm writing a korn script that does something like the following, but I don't yet completely understand the syntax. I need to check that... (16 Replies)
Discussion started by: yongho
16 Replies
3. Shell Programming and Scripting
Hi All,
Can some one tell me how to get run the following:
data1="hello"
data2="world"
if
then
{
echo "good afternnon"
}
else
{
echo " good morning"
}
fi
The above code gives me an error ad below :
./if.h: line 3: ' (7 Replies)
Discussion started by: jisha
7 Replies
4. UNIX for Dummies Questions & Answers
Hi friends,
I have a script that sets the env variable path based on different conditions.
Now the new path variable setting should not done in the same terminal or same shell.
Only a new terminal or new shell should have the new path env variable set.
I am able to do this only as follows:
>cd... (1 Reply)
Discussion started by: sowmya005
1 Replies
5. Shell Programming and Scripting
Hi, I hope the title does not scare people to look into this thread but it describes roughly what I'm trying to do. I need a solution in PHP.
I'm a programming beginner, so it might be that the approach to solve this, might be easier to solve with an other approach of someone else, so if you... (0 Replies)
Discussion started by: lowmaster
0 Replies
6. Shell Programming and Scripting
Hello Everybody,
thanks in advance for spending some time in my problem.
My problem is this:
I want to call a java-Programm out of my shell skript, check if die return code is right, and split the output to the normal output and into a file.
The following code doesn't work right, because in... (2 Replies)
Discussion started by: danifunny
2 Replies
7. Shell Programming and Scripting
Hi
What is the syntax for if statement using && and || operator?
if && ] ||
here its giving me an error to this if statement
any suggestion?? (2 Replies)
Discussion started by: Avi
2 Replies
8. Shell Programming and Scripting
Hi, I'm using the && operator in if statement:
if ; then
exp $UID/$PWD@$ORACLE_SID FILE=./DUMP/$TODAY$CONCAT_STR$USERNAME.dmp STATISTICS=NONE LOG=./LOG/$TODAY$CONCAT_STR$USERNAME.log
elif ; then
expdp $UID/$PWD@$ORACLE_SID DIRECTORY=./DUMP/ DUMPFILE=$TODAY$CONCAT_STR$USERNAME.dmp... (8 Replies)
Discussion started by: priya001
8 Replies
9. Shell Programming and Scripting
how do you write an if statement for something like
if ((expr 1 >= expr 2 && expr 3 >= expr 4) && expr 5 <= expr 6)
if ((TRUE && TRUE) && TRUE) then
condition...
i've done it this way but it doesn't seem to work.
if (] && "$ex_day" -le "$curr_day" ); then
condition... (3 Replies)
Discussion started by: angilulu
3 Replies
10. Shell Programming and Scripting
Hi All,
Do you have any sample script,
- auto get file from SFTP remote server and delete file in remove server after downloaded.
- only download specify filename
- auto upload file from local to SFTP remote server and delete local folder file after uploaded
- only upload specify filename
... (3 Replies)
Discussion started by: weesiong
3 Replies
LEARN ABOUT PHP
pdostatement.bindparam
PDOSTATEMENT.BINDPARAM(3) 1 PDOSTATEMENT.BINDPARAM(3)
PDOStatement::bindParam - Binds a parameter to the specified variable name
SYNOPSIS
public bool PDOStatement::bindParam (mixed $parameter, mixed &$variable, [int $data_type = PDO::PARAM_STR], [int $length], [mixed
$driver_options])
DESCRIPTION
Binds a PHP variable to a corresponding named or question mark placeholder in the SQL statement that was used to prepare the statement.
Unlike PDOStatement.bindValue(3), the variable is bound as a reference and will only be evaluated at the time that PDOStatement.execute(3)
is called.
Most parameters are input parameters, that is, parameters that are used in a read-only fashion to build up the query. Some drivers support
the invocation of stored procedures that return data as output parameters, and some also as input/output parameters that both send in data
and are updated to receive it.
PARAMETERS
o $parameter
- Parameter identifier. For a prepared statement using named placeholders, this will be a parameter name of the form $:name. For a
prepared statement using question mark placeholders, this will be the 1-indexed position of the parameter.
o $variable
- Name of the PHP variable to bind to the SQL statement parameter.
o $data_type
- Explicit data type for the parameter using the PDO::PARAM_* constants. To return an INOUT parameter from a stored procedure, use
the bitwise OR operator to set the PDO::PARAM_INPUT_OUTPUT bits for the $data_type parameter.
o $length
- Length of the data type. To indicate that a parameter is an OUT parameter from a stored procedure, you must explicitly set the
length.
o $driver_options
-
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Execute a prepared statement with named placeholders
<?php
/* Execute a prepared statement by binding PHP variables */
$calories = 150;
$colour = 'red';
$sth = $dbh->prepare('SELECT name, colour, calories
FROM fruit
WHERE calories < :calories AND colour = :colour');
$sth->bindParam(':calories', $calories, PDO::PARAM_INT);
$sth->bindParam(':colour', $colour, PDO::PARAM_STR, 12);
$sth->execute();
?>
Example #2
Execute a prepared statement with question mark placeholders
<?php
/* Execute a prepared statement by binding PHP variables */
$calories = 150;
$colour = 'red';
$sth = $dbh->prepare('SELECT name, colour, calories
FROM fruit
WHERE calories < ? AND colour = ?');
$sth->bindParam(1, $calories, PDO::PARAM_INT);
$sth->bindParam(2, $colour, PDO::PARAM_STR, 12);
$sth->execute();
?>
Example #3
Call a stored procedure with an INOUT parameter
<?php
/* Call a stored procedure with an INOUT parameter */
$colour = 'red';
$sth = $dbh->prepare('CALL puree_fruit(?)');
$sth->bindParam(1, $colour, PDO::PARAM_STR|PDO::PARAM_INPUT_OUTPUT, 12);
$sth->execute();
print("After pureeing fruit, the colour is: $colour");
?>
SEE ALSO
PDO.prepare(3), PDOStatement.execute(3), PDOStatement.bindValue(3).
PHP Documentation Group PDOSTATEMENT.BINDPARAM(3)