11-02-2017
HI Rudi -
I've escaped the single quote as well as placed double quotes around it. However, if I'm being completely honest, I'm having trouble understanding how this parameter expansion works. Would it be too much to ask if you explained to me?
Thank you.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I search how i could do to find if a year (for example 2004, 1989, 2058) has 52 or 53 weeks...
Have you a idea for me please??? (1 Reply)
Discussion started by: Castelior
1 Replies
2. Solaris
Is there any way to find "Number of files" that exists on my solaris parition in the starting of 2009 year ?
I know ctime or mtime will not help and unix wouldnt store creation time.
Only hope i can see ( and i am not sure if that will help ) is that my system is up from last 2 years without... (5 Replies)
Discussion started by: rajwinder
5 Replies
3. Shell Programming and Scripting
Hiii i have a file with data as shown below:
a.dat:
RAO 1900 2 7 0 0 0.00 10.8000 76.8000 10.0 0 0.00 0 6.00 0.00 0.00 0 0.00 6.00 0 NULL
LEE 1901 2 15 0 0 0.00 26.0000 100.0000 0.0 0 0.00 0 0.00 0.00 0.00 0 6.00 6.00 0 NULL
RAO 1901 4... (3 Replies)
Discussion started by: reva
3 Replies
4. Shell Programming and Scripting
My PM has told me to learn shell scrting in 2 weeks , how should I start?:confused::confused::confused::confused: (1 Reply)
Discussion started by: manalisharmabe
1 Replies
5. Shell Programming and Scripting
Hi All,
I have source file
x.txt
0001|0003
0031|0031
0045|0049
My desired output should be:
y.txt
0001
0002
0003
0031
0045
0046
0047 (11 Replies)
Discussion started by: kmsekhar
11 Replies
6. Shell Programming and Scripting
Hi anyone can help?
How to calculate total number of weeks from a specify date, for example, 01 Jan 2012.
Thx! (2 Replies)
Discussion started by: rayray2013
2 Replies
7. Shell Programming and Scripting
Hello,
Using bash script, i need to process the following file:
887,86,,2013-11-06,1,10030,5,2,0,200,,
887,86,,2013-11-05,1,10030,5,2,0,199,,
887,138,,2013-11-06,1,10031,6,2,0,1610612736,,
887,164,,2013-11-06,1,10000,0,2,0,36000,,
and to create a new file such as the below
... (2 Replies)
Discussion started by: JonhyDeep
2 Replies
8. Shell Programming and Scripting
Hello,
I am running under ubuntu18.04
My question is about awk.
inputfile
0wo010011oasasds sdjhsdjh=, u12812888
8jsjkahsjajnsanakn akjskjskj=, suhuhuhwx
kskkxmsnnxsnjxsnjxsnjjnjjdi=, 22878ssssss
Below code adds consecutive numbers when string = is found
run_code:
awk -F'=' -v OFS='='... (4 Replies)
Discussion started by: baris35
4 Replies
9. Web Development
Hi Ravinder,
Could you (and anyone else who wants to help out) check this PHP code and confirm it does what I expect it to do, which is to color a badge based on the weeks a member is active in the latest sequence? I did a cut-paste-change from my "days in sequence" PHP prototype script and it... (6 Replies)
Discussion started by: Neo
6 Replies
10. UNIX for Beginners Questions & Answers
Below are my custom period start and end dates based on a calender, these dates are placed in a file, for each period i need to split into three weeks for each period row, example is given below.
Could you please help out to achieve solution through shell script..
File content:
... (2 Replies)
Discussion started by: nani2019
2 Replies
LEARN ABOUT PHP
cubrid_real_escape_string
CUBRID_REAL_ESCAPE_STRING(3) 1 CUBRID_REAL_ESCAPE_STRING(3)
cubrid_real_escape_string - Escape special characters in a string for use in an SQL statement
SYNOPSIS
string cubrid_real_escape_string (string $unescaped_string, [resource $conn_identifier])
DESCRIPTION
This function returns the escaped string version of the given string. It will escape the following characters: '. In general, single quo-
tations are used to enclose character string. Double quotations may be used as well depending on the value of ansi_quotes, which is a
parameter related to SQL statement. If the ansi_quotes value is set to no, character string enclosed by double quotations is handled as
character string, not as an identifier. The default value is yes. If you want to include a single quote as part of a character string,
enter two single quotes in a row.
PARAMETERS
o $unescaped_string
-The string that is to be escaped.
o $conn_identifier
- The CUBRID connection. If the connection identifier is not specified, the last connection opened by cubrid_connect(3) is
assumed.
RETURN VALUES
Escaped string version of the given string, on success.
FALSE on failure.
EXAMPLES
Example #1
cubrid_real_escape_string(3) example
<?php
$conn = cubrid_connect("localhost", 33000, "demodb");
$unescaped_str = ' !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[]^_`abcdefghijklmnopqrstuvwxyz{|}~';
$escaped_str = cubrid_real_escape_string($unescaped_str);
$len = strlen($unescaped_str);
@cubrid_execute($conn, "DROP TABLE cubrid_test");
cubrid_execute($conn, "CREATE TABLE cubrid_test (t char($len))");
cubrid_execute($conn, "INSERT INTO cubrid_test (t) VALUES('$escaped_str')");
$req = cubrid_execute($conn, "SELECT * FROM cubrid_test");
$row = cubrid_fetch_assoc($req);
var_dump($row);
cubrid_close_request($req);
cubrid_disconnect($conn);
?>
The above example will output:
array(1) {
["t"]=>
string(95) " !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[]^_`abcdefghijklmnopqrstuvwxyz{|}~"
}
PHP Documentation Group CUBRID_REAL_ESCAPE_STRING(3)