Please become accustomed and tightly adhere to telling people in here your OS and shell versions with every new thread! Solutions given above rely on being run with a recent bourne shell, like bash or ksh.
Using shell arrays is an apt approach for tasks like given, eliminating "horizontal" and "vertical" problems. Both rdrtx1 and Chubler_XL use it, (set -A being ksh- specific). Make sure your shell provides arrays. If you run your scripts in e.g. sh, none of the proposals will work.
Try (recent bash required)
Last edited by RudiC; 08-06-2019 at 10:17 AM..
Reason: correction of typo (STB <-> STDBY), thanks to wisecracker!
Hi
I have two files in unix. I need to compare two files and print the differed lines in other file
Eg
file1
1111
2222
3333
file2
1111
2222
3333
4444
5555
newfile
4444
5555
Thanks In advance (3 Replies)
I have two files like this:
#FILE 1
ABCD 4322 26485
JMTJ 5311 97248
XMPJ 4321 58978
#FILE 2
ABCD 4321 26485
JMTJ 5311 97248
XMPJ 4321 68978
What to do: Compare the two files and find those lines that doesn't match. And have a new file like this:
#FILE 3
"from file 1"
ABCD 4322 26485... (11 Replies)
I have learned file comparison from my previous post here. Then, it is comparing the whole line. Now, i have a new problem.
I have two files with 3 columns separated with a "|". What i want to do is to compare the second and third column of file 1, and the second and third column of file 2. And... (4 Replies)
Hi there,
I'm sure this question has been asked many times but I can't find any posts with information.
How can I check the differences between say lines 20 - 200 in file1 and lines 420 - 600 in file2?
Thanks in advance for any help!
js (2 Replies)
Hello,
I have two files file 1 and file 2 each having result of a query on certain database tables and need to compare for Col1 in file1 with Col3 in file2, compare Col2 with Col4 and output the value of Col1 from File1 which is a) not present in Col3 of File2 b) value of Col2 is different from... (2 Replies)
Hello,
I have two text files, each with a single column,
file 1:
124152970
123899868
123476854
54258288
123117283
file 2:
124152970
123899868
54258288
123117283
122108330 (5 Replies)
compare two variables and print the difference
i have two variables
X1=rac1,rac2
Y1=rac2,rac3
output=rac1,rac3
Use code tags to wrap code fragments or data samples. (1 Reply)
Discussion started by: jhonnyrip
1 Replies
LEARN ABOUT PHP
pdostatement.bindcolumn
PDOSTATEMENT.BINDCOLUMN(3) 1 PDOSTATEMENT.BINDCOLUMN(3)PDOStatement::bindColumn - Bind a column to a PHP variable
SYNOPSIS
public bool PDOStatement::bindColumn (mixed $column, mixed &$param, [int $type], [int $maxlen], [mixed $driverdata])
DESCRIPTION PDOStatement.bindColumn(3) arranges to have a particular variable bound to a given column in the result-set from a query. Each call to
PDOStatement.fetch(3) or PDOStatement.fetchAll(3) will update all the variables that are bound to columns.
Note
Since information about the columns is not always available to PDO until the statement is executed, portable applications should
call this function afterPDOStatement.execute(3).
However, to be able to bind a LOB column as a stream when using the PgSQL driver, applications should call this method before call-
ing PDOStatement.execute(3), otherwise the large object OID will be returned as an integer.
PARAMETERS
o $column
- Number of the column (1-indexed) or name of the column in the result set. If using the column name, be aware that the name
should match the case of the column, as returned by the driver.
o $param
- Name of the PHP variable to which the column will be bound.
o $type
- Data type of the parameter, specified by the PDO::PARAM_* constants.
o $maxlen
- A hint for pre-allocation.
o $driverdata
- Optional parameter(s) for the driver.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Binding result set output to PHP variables
Binding columns in the result set to PHP variables is an effective way to make the data contained in each row immediately available
to your application. The following example demonstrates how PDO allows you to bind and retrieve columns with a variety of options
and with intelligent defaults.
<?php
function readData($dbh) {
$sql = 'SELECT name, colour, calories FROM fruit';
try {
$stmt = $dbh->prepare($sql);
$stmt->execute();
/* Bind by column number */
$stmt->bindColumn(1, $name);
$stmt->bindColumn(2, $colour);
/* Bind by column name */
$stmt->bindColumn('calories', $cals);
while ($row = $stmt->fetch(PDO::FETCH_BOUND)) {
$data = $name . " " . $colour . " " . $cals . "
";
print $data;
}
}
catch (PDOException $e) {
print $e->getMessage();
}
}
readData($dbh);
?>
The above example will output:
apple red 150
banana yellow 175
kiwi green 75
orange orange 150
mango red 200
strawberry red 25
SEE ALSO PDOStatement.execute(3), PDOStatement.fetch(3), PDOStatement.fetchAll(3), PDOStatement.fetchColumn(3).
PHP Documentation Group PDOSTATEMENT.BINDCOLUMN(3)