How to properly save an image URL in Mysql database?

Question

How to properly save an image URL in Mysql database?

Asked 9 years, 4 months ago

Viewed 2,437 times

6

I am testing the targeting of images with the URL. However, during the tests, the URL was returned with changes as can be seen below:

URL inserted in the database:

http://www.meusite.com.br/pastaimagem/logos/imageLogo.jpg

URL returned by database:

http:\/\/www.meusite.com.br\/pastaimagem\/logos\/imageLogo.jpg

I noticed this problem while testing the query by browser.

Version of PHP:

PHP: 5.4.37

Query used to insert URL:

UPDATE  `meusite_sitebd`.`jump` SET  `urlimagem` =  'http://www.meusite.com.br/pastaimagem/logos/imageLogo.jpg' WHERE `register`.`idRegistro` =1;

PHP code used to perform the request:

<?php

include 'conexao.php';

//Converte para UTF8 os resultados da query
mysql_set_charset('UTF8');

// Retorna registro por id

$id = $_GET['idRegistro'];

$sql = "SELECT * FROM registros WHERE idRegistro = '$id'";

$resultado = mysql_query($sql) or die ("Erro: ".mysql_error());

// Crinha variável linha do tipo array
$linha = array();

  while($r = mysql_fetch_assoc($resultado))
    { 
        $linha [] = $r;
    }


 echo json_encode($linha);


mysql_close(); 

?>

As you can see it’s a very simple code.

No. I’m saving only her URL. I’ve actually edited the question. It’s gotten a little confusing, but now it’s more readable. The image is in a directory on the server itself.

– Tiago Amaral

2015/02/23 at 20:35
Okay, how are you saving the URL?

– stderr

2015/02/23 at 20:36
On the Phpmyadmin screen itself, I edit the record and copy and paste the URL. But on the PHP screen the URL is normal. Only appears with the counterbars when I receive them by request.

– Tiago Amaral

2015/02/23 at 20:37
Is Magic Quotes enabled? What version of php? Could you put the code of Insert

– rray

2015/02/23 at 20:39
I edited the question and added the code used to update the record and insert the PHP URL and version. I will check the Magic Quotes...

– Tiago Amaral

2015/02/23 at 20:47
You don’t happen to have a code addslashes putting these bars?

– bfavaretto

2015/02/23 at 20:52
No. This is the first time I’ve encountered this problem. :/

– Tiago Amaral

2015/02/23 at 20:56
I’ll add the code I’m using to the query...

– Tiago Amaral

2015/02/23 at 20:57

Show 3 more comments

2 answers

5

By default json_encode puts bars to escape some characters, to avoid this behavior, pass JSON_UNESCAPED_SLASHES in the second argument of the function thus the escape bars will not be added.

echo json_encode($url,  JSON_UNESCAPED_SLASHES);

Example - ideone

Based on: How to remove backslash on json_encode() Function?

Perfect! It worked!

– Tiago Amaral

2015/02/23 at 22:32

Browser other questions tagged php mysql json url request

You are not signed in. Login or sign up in order to post.

by opeta • **385** points · Answer 1 · 2015-02-23T21:53:29+00:00

@Tiago Amaral saw that you set your database to "UTF8" charset in php but your database was created with this same charset? in php your charset tbm is "UTF8"? If that’s where the problem might be, check it out. put this in php to set the charset of the same.

header("Content-Type: text/html; charset=UTF-8", true);

in the connection file with the bank put this to see if it solves.

mysql_query("SET NAMES 'utf8'");
mysql_query('SET character_set_connection=utf8');
mysql_query('SET character_set_client=utf8');
mysql_query('SET character_set_results=utf8');