Hi,
when I execute some simple commands on my solaris system, I am getting the following warning message:
Could anybody tell me what could be the reason
Ex:- If I give the command,
which ls
Warning: cannot determine current directory
... (15 Replies)
I want to perform a task on all the files in the current directory but I'd like to loop through them one at a time. How do I tell it to give me the first filename? (2 Replies)
Hi All
I was wondering what is the most efficient way to find files in the current directory(that may contain 100,000's files), that meets a certain specified file type and of a certain age.
I have experimented with the find command in unix but it also searches all sub directories. I have... (2 Replies)
Hi all,
I have a simple script follow:
-------------
#!/bin/bash
echo -n " Enter the date of today: "
read dateoftoday
-------------
Now I want to compare the variant $dateoftoday with date of the system (now) in order to prevent user inputs the past date to $dateoftoday. I want to make... (3 Replies)
I wanna make a backup tarball. I wanna write a script that makes tarball of the current directory.
There are lots of files so I cant type all files, I wanna make the tarball by excluding few files.
Like there 1000 files in a directory I wanna create a tarball containing 98 files of that... (1 Reply)
HPUX does not recognise \h,\w,\u to display the hostname,working directory and username respectively.
So how do i set the PS1 variable to display my current working Directory as my prompt?
I also tried PS1=$PWD,
But it keeps showing the same directory path as prompt which PWD was holding at... (3 Replies)
Hello,
I want to use the string with the current directory in my awk command.
I tried: 'pwd=system("pwd")'
but it doesn't work. can please help somebody? (2 Replies)
Hi all,
I need a script to delete a large set of files from a directory under / based on an input file and want to redirect errors into separate file.
I have already prepared a list of files in the input file.
Kndly help me.
Thanks,
Prash (36 Replies)
Hi, I'm very new to Unix, but have been given a command to type in which is :
mail -s <email subject goes here> <my email address> <success.txt
this command is quite a basic one and sends an email containing the contents of the file "success.txt" to whatever email I put in with the subject of... (2 Replies)
Hi.
My example:
I have a filesystem /log. Everyday, log files are copied to /log. I'd like to set owner and permission for files and directories in /log like that
chown -R log_adm /log/*
chmod -R 544 /log/*It's OK, but just at that time. When a new log file or new directory is created in /log,... (8 Replies)
Discussion started by: bobochacha29
8 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)