hi all
i saved myfile.php to the Desktop.
how can i run mysite.php file by programatically.
popen(/usr/bin/mozilla /root/Desktop/myfile.php","r")
it is not working.
can you please show me the way
thank you (1 Reply)
from CLI pressing Tab and character like a shows result of the commands starting with a,
can i use this in a script too and post the results to a file?
thanks (1 Reply)
Hello guys,
Does anyone can help me?
I've just made my simple index.php without any code, but after insert session code to check if any user is authenticated, my index.php doesn't work anymore.
Any fresh eyes could help me to see what and where the code is wrong?
<?
if... (6 Replies)
I want to press "apple + T" to open a new terminal tab. This terminal tab must be in the same directory as the current one. Anyone knows how to do that?
Thanks a lot! (1 Reply)
hi,
In a cron tab, can the command to be executed contain parametrs for the script too?
E.g:
******* ./script.sh file fil2 > /dev/null
Is the above valid one?
Thanks
You have 37 posts - you should know how and when to use code tags. You got a PM with instructions. (1 Reply)
Hi I am running the following script in cron tab:
#!/usr/local/bin/php
<?php
$handle=fopen('xmlfile.xml',"w");
$xmlfile= file_get_contents('http://diur-plus.2me.co.il/xml.aspx');
fwrite($handle,$xmlfile);
fclose($handle);
/*
* To change this template, choose Tools |... (1 Reply)
Hi everyone,
I have a data.xml file which only contains thousands of data (tag) blocks. A part of the file looks exactly like this;
<data>
Line
Line
Line
</data>
<data>
Line
Line
Line
</data>
the rest of the file is simply a repetition of this part. Here each data block contains a... (8 Replies)
Hi folks,
Everyone knows about crontab, what i am looking for a script where i will define hour,minute and day and it will generate crontab complete time entry, i have seen many website generating crontab entry and my question is that is there any shell script that can do same work.
20 09... (4 Replies)
Hi All ,
i am trying to create an alias to open a new gnome-terminal and run some commands in each tab & to have a specific name for each tab
i am using csh ,
tried this command
gnome-terminal --tab -t "s1" --tab -t "s2" --tab -t "s3" --tab -t "s4"
it opened 4 tabs but the title didn't... (0 Replies)
Discussion started by: Assem
0 Replies
LEARN ABOUT PHP
mysql_real_escape_string
MYSQL_REAL_ESCAPE_STRING(3) 1 MYSQL_REAL_ESCAPE_STRING(3)mysql_real_escape_string - Escapes special characters in a string for use in an SQL statementSYNOPSIS
Warning
This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should
be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:
omysqli_real_escape_string(3)
o PDO::quote
string mysql_real_escape_string (string $unescaped_string, [resource $link_identifier = NULL])
DESCRIPTION
Escapes special characters in the $unescaped_string, taking into account the current character set of the connection so that it is safe to
place it in a mysql_query(3). If binary data is to be inserted, this function must be used.
mysql_real_escape_string(3) calls MySQL's library function mysql_real_escape_string, which prepends backslashes to the following charac-
ters: x00,
,
, , ', " and x1a.
This function must always (with few exceptions) be used to make data safe before sending a query to MySQL.
Caution
Security: the default character set
The character set must be set either at the server level, or with the API function mysql_set_charset(3) for it to affect
mysql_real_escape_string(3). See the concepts section on character sets for more information.
o $unescaped_string
- The string that is to be escaped.
o $
link_identifier -The MySQL connection. If the link identifier is not specified, the last link opened by mysql_connect(3) is
assumed. If no such link is found, it will try to create one as if mysql_connect(3) was called with no arguments. If no connection
is found or established, an E_WARNING level error is generated.
Returns the escaped string, or FALSE on error.
Example #1
Simple mysql_real_escape_string(3) example
<?php
// Connect
$link = mysql_connect('mysql_host', 'mysql_user', 'mysql_password')
OR die(mysql_error());
// Query
$query = sprintf("SELECT * FROM users WHERE user='%s' AND password='%s'",
mysql_real_escape_string($user),
mysql_real_escape_string($password));
?>
Example #2
An example SQL Injection Attack
<?php
// We didn't check $_POST['password'], it could be anything the user wanted! For example:
$_POST['username'] = 'aidan';
$_POST['password'] = "' OR ''='";
// Query database to check if there are any matching users
$query = "SELECT * FROM users WHERE user='{$_POST['username']}' AND password='{$_POST['password']}'";
mysql_query($query);
// This means the query sent to MySQL would be:
echo $query;
?>
The query sent to MySQL:
SELECT * FROM users WHERE user='aidan' AND password='' OR ''=''
This would allow anyone to log in without a valid password.
Note
A MySQL connection is required before using mysql_real_escape_string(3) otherwise an error of level E_WARNING is generated, and
FALSE is returned. If $link_identifier isn't defined, the last MySQL connection is used.
Note
If magic_quotes_gpc is enabled, first apply stripslashes(3) to the data. Using this function on data which has already been escaped
will escape the data twice.
Note
If this function is not used to escape data, the query is vulnerable to SQL Injection Attacks.
Note
mysql_real_escape_string(3) does not escape % and _. These are wildcards in MySQL if combined with LIKE, GRANT, or REVOKE.
mysql_set_charset(3), mysql_client_encoding(3), addslashes(3), stripslashes(3), The magic_quotes_gpc directive, The magic_quotes_runtime
directive.
PHP Documentation Group MYSQL_REAL_ESCAPE_STRING(3)