Actually the query is,
In the variable $file, report name is coming.
but i want to check the string in that file but my query is not working in the script.
query:
Last edited by radoulov; 10-13-2011 at 07:13 AM..
Reason: Code tags!
Hi,
I'd like to grep a variable that I saved in the program.
Like
grep '0\$variable1' file1
Does someone know what's wrong with this command?
Thanks a lot! (2 Replies)
Hi, I can't get this script to work (returns 0, should return 3):
$ cat A.lst | \
while read LINE
do
echo "$LINE"
grep -c "$LINE" B.tmp
done> > > > >
Socket
0
$
but in contrast this one works fine (returns 3 as expected):
$ LINE=Socket
$ grep -c $LINE B.tmp
3
$ (5 Replies)
Hi all,
I am trying to do a simple thing in my mind. However I am fairly new to bash. What I need to do is create a folder for each partition on each CD, and each partition has a unique name (with spaces in it, do not ask why, it is already done :confused: ) . All CD's will show up... (2 Replies)
can i grep a variable
say i have a variable var=`hostname` and I want to make an if statement like
if grep "esp-ueh" $var;then......
how can i do this
I dont want to store this variable in a file and the grep it because my script will be used at the same time on multiple stations and then that... (9 Replies)
how can I use grep with a variable to find a value?
cat data.out
Hello World
grep "Hello World" data.out
Hello World ## Value found
I want to do something like this but can't seem to get it to work any
suggestions would be appreciated.
var="Hello World"
grep $var data.out (3 Replies)
I have a pattern like:
column "5" is missing
PS: the no is in double quotes.
The number usally changes, so we use a loop to grep.
grep 'column "$number" is missing' filename.txt
But it is not working....
How to solve this? (2 Replies)
Hello,
I usually search extensively and have to date found what I've needed. However, this one's got me stumped. I need to create a variable as follow. The issue however is that upon execution, it freezes. $var1 isn't always present in usage.log and this is fine but I'd like it to continue with... (6 Replies)
I've got a file that I'm trying to grep through that looks like this:
alpha1
alpha2
alpha3
beta1
beta2
gamma5
gamma6
gamma7
gamma8
gamma9
and I want the output to only contain the line with the highest value for each, so the output I want is:
alpha3
beta2
gamma9
I also need... (11 Replies)
Hi,
I am trying to grep one variable over the other variable
Example:
i=abc
j=ab
grep $j $i
I am getting this error:
The error is due to $i being variable and not file. I know I could do it by putting the value of abc in a file
and then greping it. (1 Reply)
hi
i have a file which contains some messages counters.
below is the snippet on the file.
17-05-29::22:36:21|message|231
17-05-29::22:36:31|message|222
17-05-29::22:36:41|message|213
17-05-30::22:36:51|message|221
17-05-30::22:37:01|message|227
17-05-30::22:37:11|message|207... (5 Replies)
Discussion started by: scriptor
5 Replies
LEARN ABOUT PHP
pg_query
PG_QUERY(3)PG_QUERY(3)pg_query - Execute a querySYNOPSIS
resource pg_query ([resource $connection], string $query)
DESCRIPTION pg_query(3) executes the $query on the specified database $connection. pg_query_params(3) should be preferred in most cases.
If an error occurs, and FALSE is returned, details of the error can be retrieved using the pg_last_error(3) function if the connection is
valid.
Note
Although $connection can be omitted, it is not recommended, since it can be the cause of hard to find bugs in scripts.
Note
This function used to be called pg_exec(3). pg_exec(3) is still available for compatibility reasons, but users are encouraged to
use the newer name.
PARAMETERS
o $connection
- PostgreSQL database connection resource. When $connection is not present, the default connection is used. The default connection
is the last connection made by pg_connect(3) or pg_pconnect(3).
o $query
- The SQL statement or statements to be executed. When multiple statements are passed to the function, they are automatically exe-
cuted as one transaction, unless there are explicit BEGIN/COMMIT commands included in the query string. However, using multiple
transactions in one function call is not recommended.
Warning
String interpolation of user-supplied data is extremely dangerous and is likely to lead to SQL injection vulnerabilities. In
most cases pg_query_params(3) should be preferred, passing user-supplied values as parameters rather than substituting them
into the query string.
Any user-supplied data substituted directly into a query string should be properly escaped.
RETURN VALUES
A query result resource on success or FALSE on failure.
EXAMPLES
Example #1
pg_query(3) example
<?php
$conn = pg_pconnect("dbname=publisher");
if (!$conn) {
echo "An error occurred.
";
exit;
}
$result = pg_query($conn, "SELECT author, email FROM authors");
if (!$result) {
echo "An error occurred.
";
exit;
}
while ($row = pg_fetch_row($result)) {
echo "Author: $row[0] E-mail: $row[1]";
echo "<br />
";
}
?>
Example #2
Using pg_query(3) with multiple statements
<?php
$conn = pg_pconnect("dbname=publisher");
// these statements will be executed as one transaction
$query = "UPDATE authors SET author=UPPER(author) WHERE id=1;";
$query .= "UPDATE authors SET author=LOWER(author) WHERE id=2;";
$query .= "UPDATE authors SET author=NULL WHERE id=3;";
pg_query($conn, $query);
?>
SEE ALSO pg_connect(3), pg_pconnect(3), pg_fetch_array(3), pg_fetch_object(3), pg_num_rows(3), pg_affected_rows(3).
PHP Documentation Group PG_QUERY(3)