Wsrtjtyk

I want to parse all of the returned values from a MySQL database into a JSON file. So I wrote my php side like this:

foreach ($Posts->Show() as $Key => $Post) {

    $Data ['POST'][$Post['Post_Id']]["Id"]=$Post['Post_Id'];

    $Data ['POST'][$Post['Post_Id']]["Url"] = "https://eastcloud.ir/Blog?=" . $Post['Post_Url'];

    $Data ['POST'][$Post['Post_Id']]["Name"] = $Post['Post_Name'];

    $Data ['POST'][$Post['Post_Id']]["Date"] = $Post['Post_Date'];

    $Data ['POST'][$Post['Post_Id']]["Author"] = $Post['Post_Author'];

    $Data ['POST'][$Post['Post_Id']]["Image"] = "https://eastcloud.ir/" . $Post['Post_Image'];

    $Data ['POST'][$Post['Post_Id']]["Tags"] = "https://eastcloud.ir/" . $Post['Post_Image'];

    $ID++;

}

The given json is something like this:

POST

17

{

    Id  "17"

    Url "https://eastcloud.ir/Blog?=Simplist-Documentations"

    Name    "Simplist Documentations"

    Date    "23 May, 2018"

    Author  "Milad"

    Image   "https://eastcloud.ir/Content/Shared/Posts/SimplistV2.png"

    Tags    "https://eastcloud.ir/Content/Shared/Posts/SimplistV2.png"

}

The loop will continue getting value and parsing them into JSON (The JSON file is available here) but if I want to use the given JSON here on Json2Sharp it tells invalid JSON file given.
What is the solution? How can I create a JSON from my database values with PHP?

Did you tried to use json_encode() method?

foreach ($Posts->Show() as $Key => $Post) {

    $Data['POST'] = [

        $Post['Post_Id'] = [

            "Id" => $Post['Post_Id'],

            "Url" => "https://eastcloud.ir/Blog?=" . $Post['Post_Url'],

            "Name" => $Post['Post_Name'],

            "Date" => $Post['Post_Date'],

            "Author" => $Post['Post_Author'],

            "Image" => "https://eastcloud.ir/" . $Post['Post_Image'],

            "Tags" => "https://eastcloud.ir/" . $Post['Post_Image'],

        ],

    ];

    $ID++;

}



// here is your json from db fetching loop

$json = json_encode($Data);

upd 1.0

Please check this JSON, which I generated based on your

{

    "POST" : [

        {

        "Id": "17",

        "Url": "https://eastcloud.ir/Blog?=Simplist-Documentations",

        "Name": "Simplist Documentations",

        "Date": "23 May, 2018",

        "Author": "Milad",

        "Image": "https://eastcloud.ir/Content/Shared/Posts/SimplistV2.png",

        "Tags": "https://eastcloud.ir/Content/Shared/Posts/SimplistV2.png"

        },

        {

        "Id": "18",

        "Url": "https://eastcloud.ir/Blog?=angular-2-vs-react",

        "Name": "انگیولار ۲ در مقابل ری‌اکت",

        "Date": "23 May, 2018",

        "Author": "Milad",

        "Image": "https://eastcloud.ir/Content/Shared/Posts/432644.png",

        "Tags": "https://eastcloud.ir/Content/Shared/Posts/432644.png"

        }

    ]

}

Reponse from json2csharp

public class POST

{

    public string Id { get; set; }

    public string Url { get; set; }

    public string Name { get; set; }

    public string Date { get; set; }

    public string Author { get; set; }

    public string Image { get; set; }

    public string Tags { get; set; }

}



public class RootObject

{

    public List<POST> POST { get; set; }

}

Use the json_encode for creating json. It is not the best way to create it
manually.

To understand what is wrong with your output, the correct JSON format of your data should look like this:

{

    "Id":"17",

    "Url":"https://eastcloud.ir/Blog?=Simplist-Documentations",

    "Name":"Simplist Documentations",

    "Date":"23 May, 2018",

    "Author":"Milad",

    "Image":"https://eastcloud.ir/Content/Shared/Posts/SimplistV2.png",

    "Tags":"https://eastcloud.ir/Content/Shared/Posts/SimplistV2.png"

}

Take a closer look at the quotation marks and the double dots and comma after each not the last line.

You can use json_encode() data from database