Hi all,
I have a logfile which has lines as following:
DOMAIN\username,Deposit,DOMAIN\ServiceAccountName,25/03/2010,00:10,\\SERVER,,,,/Ts=4BAA9BD6,,,10.00,10.03
It's a log of a pcounter print charge system.
I need to only have the first part (domain\username) and the second last... (4 Replies)
Hi Everyone,
1.txt
test here (888_f)a/fff (eeee) test2 (q)--(qq)
the output is
test here a/fff test2 --
means remove the characters in between (), and () itself. Please advice.
Thanks (3 Replies)
Hi everyone,
suppose that I have the following line:
#test your knowledge
can I use AWK to print the word "test" only? without the #?
what should I change to this:
awk '{print $1}'
thanks in advance guys (2 Replies)
I have the following code for removing duplicate records based on fields in inputfile file & moves the duplicate records in duplicates file(1st Awk) & in 2nd awk i fetch the non duplicate entries in inputfile to tmp file and use move to update the original file.
Requirement:
Can both the awk... (4 Replies)
Hi All,
I have searched many threads for possible close solution. But I was unable to get simlar scenario.
I would like to print all duplicate based on 3rd column except the first occurance. Also would like to print if it is single entry(non-duplicate).
i/P file
12 NIL ABD LON
11 NIL ABC... (6 Replies)
I would like to remove lines with certain pattern but only Estimate: and Realised: in USD and Date: shall be output. The order of the currency are mixed.
Output
I failed on awk with sub, gensub and was not able to remove the multiple entry on the * Date: (2 Replies)
Hi Everybody:
I need your help, please...
I have this file *.txt
0000 | 16010201 22000000 67892000 00000000 00000000 00000100 72246681 28E08236
| ~~~~"~~~g~ ~~~~~~~~~~~~~r$f~(~~6 |
0020 | 10476173 90010100 10000000 00000001 05000226 17163011 12442212 48140484
|... (2 Replies)
Discussion started by: solaris21
2 Replies
LEARN ABOUT PHP
pdostatement.bindvalue
PDOSTATEMENT.BINDVALUE(3) 1 PDOSTATEMENT.BINDVALUE(3)PDOStatement::bindValue - Binds a value to a parameter
SYNOPSIS
public bool PDOStatement::bindValue (mixed $parameter, mixed $value, [int $data_type = PDO::PARAM_STR])
DESCRIPTION
Binds a value to a corresponding named or question mark placeholder in the SQL statement that was used to prepare the statement.
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 $value
- The value to bind to the parameter.
o $data_type
- Explicit data type for the parameter using the PDO::PARAM_* constants.
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->bindValue(':calories', $calories, PDO::PARAM_INT);
$sth->bindValue(':colour', $colour, PDO::PARAM_STR);
$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->bindValue(1, $calories, PDO::PARAM_INT);
$sth->bindValue(2, $colour, PDO::PARAM_STR);
$sth->execute();
?>
SEE ALSO PDO.prepare(3), PDOStatement.execute(3), PDOStatement.bindParam(3).
PHP Documentation Group PDOSTATEMENT.BINDVALUE(3)