07-13-2016
Hi ravinder,
Thanks but it didn't work.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I have this problem of separating 10 consecutive lines from a file, say starting from 21 to 30... I have used a filter like this..
head -n 30 myfile | tail -n 10
Is there a simpler way than this? (2 Replies)
Discussion started by: Vishnu
2 Replies
2. Shell Programming and Scripting
Hi Folks
Probably an easy one here but how do I get a sequence to get used as mentioned. For example in the following I want to automatically create files that have a 2 digit number at the end of their names:
m@pyhead:~$ for x in $(seq 00 10); do touch file_$x; done
m@pyhead:~$ ls file*... (2 Replies)
Discussion started by: amadain
2 Replies
3. Shell Programming and Scripting
We have very large transaction logs that have transactions which start with a line that starts with 'Begin :' and ends with a line that starts with 'End :'. For most transactions there is valid data between those two lines.
I am trying to get rid of lines that look like this:
Begin :... (11 Replies)
Discussion started by: deneuve01
11 Replies
4. Shell Programming and Scripting
Hello all! I've looked all over the internet and this site and have come up a loss with an easy way to make a bash script to do what I want to do. I have a file with a naming convention as follows:
2012-01-18 string of words here 123.jpg
2012-01-18 string of words here 1234.jpg
2012-01-18... (2 Replies)
Discussion started by: Buzzman25
2 Replies
5. Shell Programming and Scripting
Hi ,
I do have a fixedwidth flatfile that has data for 10 different datasets each identified by the first two digits in the flatfile.
01 in the first two digit position refers to Set A
02 in the first two digit position refers to Set B and so on
I want to genrate 10 different files from my... (6 Replies)
Discussion started by: okkadu
6 Replies
6. Shell Programming and Scripting
Hi,
Using AWK script I want to pick those rows that has AT LEAST TWO columns EACH has a count >=3.
i.e. two conditions: at least two columns, each of which has a count at least 3.
There must be a simple way to do this job, but could not figure it out by myself.
Input file (thousand of... (3 Replies)
Discussion started by: yifangt
3 Replies
7. Shell Programming and Scripting
I have a file
# cat asasas
AAAAAA
11
22
33
44
BBBBB
NILNILNIL
AAAAAA
22
33
44
55
66
77
88
BBBBB
NILNILNIL (2 Replies)
Discussion started by: anil510
2 Replies
8. Shell Programming and Scripting
Hi Unix Mates,
I have requirement where in which I have to replace second to last -1 occurence of space with a word and last occurence of a space with a word and a space,input would be a file.
Desired result:
Second consecutive to last-1 occurence of space replace with: HRU
LAST... (5 Replies)
Discussion started by: Kingcobra
5 Replies
9. UNIX for Dummies Questions & Answers
Hi Folks,
I have a text file with lots of rows with duplicates in the first column, i want to filter out records based on filter columns in a different filter text file.
bash scripting is what i need.
Data.txt
Name OrderID Quantity
Sam 123 300
Jay 342 498
Kev 78 2500
Sam 420 50
Vic 10... (3 Replies)
Discussion started by: tech_frk
3 Replies
10. UNIX for Beginners Questions & Answers
Hi All ,
I am having an input file as stated below
5728 U_TOP_LOGIC/U_CM0P/core/u_cortexm0plus/u_top/u_sys/u_core/r03_q_reg_20_/Q 011
611 U_TOP_LOGIC/U_CM0P/core/u_cortexm0plus/u_top/u_sys/u_core/r04_q_reg_20_/Q 011
3486... (4 Replies)
Discussion started by: kshitij
4 Replies
LEARN ABOUT PHP
mysqli_real_escape_string
MYSQLI_REAL_ESCAPE_STRING(3) 1 MYSQLI_REAL_ESCAPE_STRING(3)
mysqli::real_escape_string - Escapes special characters in a string for use in an SQL statement, taking into account the current charset of the
connection
Object oriented style
SYNOPSIS
string mysqli::escape_string (string $escapestr)
DESCRIPTION
string mysqli::real_escape_string (string $escapestr)
Procedural style
string mysqli_real_escape_string (mysqli $link, string $escapestr)
This function is used to create a legal SQL string that you can use in an SQL statement. The given string is encoded to an escaped SQL
string, taking into account the current character set of the connection.
Caution
Security: the default character set
The character set must be set either at the server level, or with the API function mysqli_set_charset(3) for it to affect
mysqli_real_escape_string(3). See the concepts section on character sets for more information.
PARAMETERS
o $
link -Procedural style only: A link identifier returned by mysqli_connect(3) or mysqli_init(3)
o $escapestr
- The string to be escaped. Characters encoded are NUL (ASCII 0),
,
, , ', ", and Control-Z.
RETURN VALUES
Returns an escaped string.
EXAMPLES
Example #1
mysqli::real_escape_string example
Object oriented style
<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s
", mysqli_connect_error());
exit();
}
$mysqli->query("CREATE TEMPORARY TABLE myCity LIKE City");
$city = "'s Hertogenbosch";
/* this query will fail, cause we didn't escape $city */
if (!$mysqli->query("INSERT into myCity (Name) VALUES ('$city')")) {
printf("Error: %s
", $mysqli->sqlstate);
}
$city = $mysqli->real_escape_string($city);
/* this query with escaped $city will work */
if ($mysqli->query("INSERT into myCity (Name) VALUES ('$city')")) {
printf("%d Row inserted.
", $mysqli->affected_rows);
}
$mysqli->close();
?>
Procedural style
<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "world");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s
", mysqli_connect_error());
exit();
}
mysqli_query($link, "CREATE TEMPORARY TABLE myCity LIKE City");
$city = "'s Hertogenbosch";
/* this query will fail, cause we didn't escape $city */
if (!mysqli_query($link, "INSERT into myCity (Name) VALUES ('$city')")) {
printf("Error: %s
", mysqli_sqlstate($link));
}
$city = mysqli_real_escape_string($link, $city);
/* this query with escaped $city will work */
if (mysqli_query($link, "INSERT into myCity (Name) VALUES ('$city')")) {
printf("%d Row inserted.
", mysqli_affected_rows($link));
}
mysqli_close($link);
?>
The above examples will output:
Error: 42000
1 Row inserted.
NOTES
Note
For those accustomed to using mysql_real_escape_string(3), note that the arguments of mysqli_real_escape_string(3) differ from what
mysql_real_escape_string(3) expects. The $link identifier comes first in mysqli_real_escape_string(3), whereas the string to be
escaped comes first in mysql_real_escape_string(3).
SEE ALSO
mysqli_set_charset(3), mysqli_character_set_name(3).
PHP Documentation Group MYSQLI_REAL_ESCAPE_STRING(3)