06-09-2010
Quote:
Originally Posted by
ripat
This pattern /^\S+\@test.com$/i will match anybody@testscom. Shouldn't the dot be escaped?
Hello ripat,
Indeed it should be escaped.
but that kind of input is unlikely of course.
Regards,
Gaurav.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi...
question is this:
How do I mount an LVD hotswap scsi drive in bay #2 on a netra using the mount command? volmgt doesn't seem to mount it and/or I don't know how to view the drives data if it's formatted which it may not be. This drive is not new out of the box so I'm not sure.
... (4 Replies)
Discussion started by: soulshaker
4 Replies
2. UNIX for Dummies Questions & Answers
Hi,
I need a clarification.
Is there any difference between AIX box and Sun Solaris box?
The bzip command with -c option works in AIX box and the same does not work in Sun Solaris box.
Can anyone please explain if there is an implementation difference in both these boxes for the shell... (1 Reply)
Discussion started by: nisha4680
1 Replies
3. UNIX for Dummies Questions & Answers
scp file="myfile.txt" todir="user@somehost:(M:drive:/somepath/)"/
Not sure I need it to go to a specific drive on the windows box (1 Reply)
Discussion started by: xgringo
1 Replies
4. Shell Programming and Scripting
Hi;
If I do something like this.
dftotalsize=0;export dftotalsize;df -k | grep \/db001 | awk '{print $4}' | while read theinput \
; do export $theinput; dftotalsize=`expr $dftotalsize + $theinput`; export dftotalsize; echo $dftotalsize; done ; echo `expr $dftotalsize \/ 1024 \/ 1024 "GB"
Is... (4 Replies)
Discussion started by: myjess
4 Replies
5. Shell Programming and Scripting
I have two variables that are set by a number i.e.
recs_on_db=12
yesterdays_recs_on_db=10
i need to get the difference between the two and be able to set this in a variable
I have tried expr but does not work:
db_difference=`expr $recs_on_db - $yesterdays_recs_on_db`
i get:
expr:... (2 Replies)
Discussion started by: Pablo_beezo
2 Replies
6. UNIX for Dummies Questions & Answers
Hi,
I have a directory 'data' which is a symbolic link to /var/opt/store/rawdata/appname on a remote box. I am not able to SFTP some files from my local box to this dir. in the remote box. Also I am not able to copy or move the files in the robot id home dir. in remote box to this data dir... (2 Replies)
Discussion started by: vharsha
2 Replies
7. UNIX for Dummies Questions & Answers
Hi Guys,
Just wanted to seek your assistance on an issue encountered with one of our client DNS server query. we have 2 sets of DNS servers.. internal and external. For Internal to reach the external DNS server (DMZ) it has to go through 2 FWs.
Current settings:
- FW rules for Internal... (3 Replies)
Discussion started by: Hotshot8259
3 Replies
8. Solaris
Hi
What are all the command outputs we have to note and keep it for safe before rebooting or shutting down a solaris box (5 Replies)
Discussion started by: newtoaixos
5 Replies
9. Shell Programming and Scripting
Hi,
I have a script that should login to a different box then the box that i am in and run the commands.
I have the script sample below that logins to a unix box and get the files .Looks like ls-lrt command is not running or its wrongly used.
#!/bin/bash
# Ask the user for build month... (5 Replies)
Discussion started by: learninguser235
5 Replies
10. UNIX for Dummies Questions & Answers
Hi,
I have a text file where i define all the inputs to my shell script:
IP=1.2.3.4
PC=1234
In the shell script, i am trying to read the input variables from the above mentioned text file:
#!/bin/bash
#usage
IP=expr cat /tmp/input.txt | grep IP| cut -d "=" -f2
PC=expr cat... (4 Replies)
Discussion started by: akarnya
4 Replies
LEARN ABOUT PHP
pg_escape_string
PG_ESCAPE_STRING(3) PG_ESCAPE_STRING(3)
pg_escape_string - Escape a string for query
SYNOPSIS
string pg_escape_string ([resource $connection], string $data)
DESCRIPTION
pg_escape_string(3) escapes a string for querying the database. It returns an escaped string in the PostgreSQL format without quotes.
pg_escape_literal(3) is more preferred way to escape SQL parameters for PostgreSQL. addslashes(3) must not be used with PostgreSQL. If the
type of the column is bytea, pg_escape_bytea(3) must be used instead. pg_escape_identifier(3) must be used to escape identifiers (e.g. ta-
ble names, field names)
Note
This function requires PostgreSQL 7.2 or later.
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 $data
- A string containing text to be escaped.
RETURN VALUES
A string containing the escaped data.
CHANGELOG
+--------+-------------------+
|Version | |
| | |
| | Description |
| | |
+--------+-------------------+
| 5.2.0 | |
| | |
| | $connection added |
| | |
+--------+-------------------+
EXAMPLES
Example #1
pg_escape_string(3) example
<?php
// Connect to the database
$dbconn = pg_connect('dbname=foo');
// Read in a text file (containing apostrophes and backslashes)
$data = file_get_contents('letter.txt');
// Escape the text data
$escaped = pg_escape_string($data);
// Insert it into the database
pg_query("INSERT INTO correspondence (name, data) VALUES ('My letter', '{$escaped}')");
?>
SEE ALSO
pg_escape_bytea(3).
PHP Documentation Group PG_ESCAPE_STRING(3)