php - Json数据库链接

Question

这个问题已经有答案了:

json_encode() escaping forward slashes (4 个回答)

PHP, why do you escape my quotes? [duplicate] (6 个回答)

已关闭 7 年前。

大家好，我在处理 PHP 和 JSON 时遇到问题

这是我的 php 代码

<?php

    mysql_connect("127.0.0.1","root","");
    mysql_select_db("spadramatico_db");

    $query = mysql_query("SELECT * FROM feed_table ORDER BY id");
    $records = array();

    while($obj = mysql_fetch_object($query)) {
        $records [] = $obj;
    }
    print (json_encode($records));

?>

这是输出结果:

[{"id":"1","title":"Teste Title","image":"http:\/\/catalinaseaspa.com\/wp-content\/uploads\/2015\/03\/island-girl.jpg","desc":"Desc test","price":"1"}]

我的问题在于链接，输出如下:

http:\/\/catalinaseaspa.com\/wp-content\/uploads\/2015\/03\/island-girl.jpg

但它是这样的:

http://catalinaseaspa.com/wp-content/uploads/2015/03/island-girl.jpg

我该如何解决这个问题？谢谢:D

Answer 1

试试这个代码。将 JSON_UNESCAPED_SLASHES 添加到函数中。

<?php
    mysql_connect("127.0.0.1","root","");
    mysql_select_db("spadramatico_db");

    $query = mysql_query("SELECT * FROM feed_table ORDER BY id");
    $records = array();

    while($obj = mysql_fetch_object($query)) {
        $records [] = $obj;
    }
    print (json_encode($records,JSON_UNESCAPED_SLASHES));

?>