how to insert string into mysql contains double backslash

[harintfs]

$str="james//bond";
$str= mysqli_real_escape_string($con,$str);
//insert query

after successful insert in database it value shows as "james/bond"

how I can insert exact string? anyone pls help.

[ankit20071991]

try "james"+@"\\Bond"; I think it should work fine.

[computerfox]

Try this?

$str="james\/\/bond";
$succ=$mysqli->query($sql);
 

[Luuk]

That dos not happen here....

mysql> create table actor(name varchar(40));
Query OK, 0 rows affected (0.40 sec)
 
mysql> insert into actor values ("James//Bond");
Query OK, 1 row affected (0.07 sec)
 
mysql> select * from actor;
+-------------+
| name        |
+-------------+
| James//Bond |
+-------------+
1 row in set (0.04 sec)
 
mysql>

[Luuk]

oh wait, I see what I did wrong......

"James Bond" is not an actor..... ;)

[computerfox]

Yeah... you also didn't do it in PHP, which doesn't answer his question. Try running the same querying in PHP and you will get the same result as the OP.

[Luuk]

<?php
        error_reporting(E_ALL);
        $m = new mysqli("localhost","test","test","test");
        $actor = "Roger//Moore";
        $sql = "INSERT INTO actor VALUES ('$actor')";
        $result = $m->query($sql);
 
        $sql = "SELECT * FROM actor";
        if ($result = $m->query($sql)) {
                while ($obj = $result->fetch_object())
                {
                        echo $obj->name."\n";
                }
        }
        $result->close();
?>
 

running this (from the command-line)

luuk@opensuse:~/tmp> php actors.php
James//Bond
Roger//Moore
luuk@opensuse:~/tmp>
 

[Luuk]

and also if I use real_escape_string

<?php
        error_reporting(E_ALL);
        $m = new mysqli("localhost","test","test","test");
        $actor = "Ursula//Andress";
        $actor = $m->real_escape_string($actor);
        $sql = "INSERT INTO actor VALUES ('$actor')";
        $result = $m->query($sql);
 
        $sql = "SELECT * FROM actor";
        if ($result = $m->query($sql)) {
                while ($obj = $result->fetch_object())
                {
                        echo $obj->name."\n";
                }
        }
        $result->close();
?>
 

running this:

luuk@opensuse:~/tmp> php actors.php
James//Bond
Roger//Moore
Ursula//Andress
luuk@opensuse:~/tmp>

[computerfox]

harintfs, were you able to get it to work?

[Luuk]

MUST I remind you, that the subject of this message is NOT the same as what is tried in the example ?

The subject is about 'backslashes' (a.k.a. '\')
The example is showing 'slashes' (a.k.a. '/')

Next code

<?php
        echo "A\\B \n";
        echo "A//B \n";
        echo "A\B \n";
        echo "A/B \n";
?>
 

will print:

A\B
A//B
A\B
A/B
 

[computerfox]

@Luuk, if you look at his code, which I'm sure you did, he just has slashes.
He never mentions "backslashes" in his first post other than the title. Could it be that he misspoke ;-)

Please read the question instead of assuming the question from the title. Since you seem to know exactly what they are asking for, please show me in his first post where he mentions "backslashes" thanks.

[Luuk]

@computerfox: let's wait for harintfs and what he has to say about slashes and backslashes...

I was reading the question, not the title ,when I gave some working code.

But what harintfs describes is the same as what happens to my example

echo "A\\B";

which produces

A\B

so, one should not just read question, but also read title

[computerfox]

Depends how you look at it. Usually if we're lucky to have an example, that's what we should go with, but I agree, let's wait for the OP to clarify what they wanted.

[sugusaraha]

but how about to inserting a location file in variable from "LoadFromFile" in MySQL?

[lewish95]

You need to escape your backslash :

INSERT INTO gender
(sex, date) VALUES (
'male are allowed \\ female are not allowed',
"2012-10-06")