02-05-2008
thanks, but sadly that didn't work either
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
When I execute following shell script I am getting the following error
syntax error at line 50 : `<<' unmatched
What am I doing wrong :confused:
Script begins here
----------------
MPAN_FILE=$1
exec 3<$MPAN_FILE ... (2 Replies)
Discussion started by: guptan
2 Replies
2. UNIX for Dummies Questions & Answers
#!/usr/bin/csh
#
DAY=`date +%y%m%d`
H=`date +%H`
M=`date +%M`
mailx -s "$H-Myfile" email@email.com</home/mydir/myfile
Thanks! (4 Replies)
Discussion started by: bobo
4 Replies
3. Shell Programming and Scripting
Does anyone see anything wrong with this.
#getInfraFiles()
#{
# cd Infra/$DAY
# rm *
# /usr/bin/ftp -i -n $LINE << cmd
# user "$USER" "$PASSWD"
# cd $INFRAPATH
# binary
# mget *
# bye
#}
besides that its commented out (4 Replies)
Discussion started by: rcunn87
4 Replies
4. UNIX for Dummies Questions & Answers
Hello,
I have a simple script such as
-----------------------------
#! /bin/sh
YEAR=`date -u +%Y`;
MONTH=`date -u +%m`;
DAY=`date -u +%d`;
DATE=$MONTH$DAY$YEAR
LOGFILES=auditTrail-$DATE
LOGMATCH=$LOGFILES\*
ARGUM=''
# find all files and write them to a file
find . -name... (7 Replies)
Discussion started by: arushunter
7 Replies
5. UNIX for Dummies Questions & Answers
I really just mess around in UNIX, for the most part, when I want to get something done. I can usually piece things together by searching for brief how-to's on Google, but the syntax errors in my following .sh file are really confusing me. I've got lots of programming experience in other places, so... (7 Replies)
Discussion started by: demonpants
7 Replies
6. Shell Programming and Scripting
when user select option 2 nothing happen.for testing purpose I put
echo command but is not executing .
basically when user prompt for option 2,I want to get list of database name from user separeted by space (TEST DEVL)
and put into the file seprated by new line
TEST
DEVL
after that stay on... (1 Reply)
Discussion started by: okreporthai
1 Replies
7. UNIX for Dummies Questions & Answers
]#PATH=/usr/bin:/etc:/bin:/boot/grub:/boot/grup/bin:
/boot/solaris/bin:/sbin:/usr/openwin/bin:/usr/5bin://usr/X11/bin:/usr/apache/bin:/usr/apache2/bin:/usr/appserver/bin:... (9 Replies)
Discussion started by: microbot
9 Replies
8. Shell Programming and Scripting
For one of my script, I want one extra parameter needs to be added to one of the Usage option. Below its given
#Check Input parameters are valid
if ; then
function usage() {
echo
echo "*******************************************"
echo " !!! USAGE... (2 Replies)
Discussion started by: raghunsi
2 Replies
9. UNIX for Advanced & Expert Users
I am working on a simple login ID check shell script that should prompt for a user ID then check to see if this user is logged on. Trying to get the hang of this stuff so I am thinking of my own little projects.
#! /bin/sh
echo "please enter a user name"
read user
if user=$user
then... (3 Replies)
Discussion started by: jsk319342
3 Replies
10. Shell Programming and Scripting
Hi ! all I am just trying to check range in my datafile
pls tell me why its resulting wrong
admin@IEEE:~/Desktop$ cat test.txt
0 28.4
5 28.4
10 28.4
15 28.5
20 28.5
25 28.6
30 28.6
35 28.7
40 28.7
45 28.7
50 28.8
55 28.8
60 28.8
65 28.1... (2 Replies)
Discussion started by: Akshay Hegde
2 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)