PHP/JSON - Remove every occurence of certain character before another character

Question

My JSON is encoding peculiarly, so I need to remove every quote before a right-opening bracket. (e.g. every " before a {) Is it possible to do this in PHP, and if so, how?

"{ I would want to remove every occurrence of the quote before the bracket.

JSON here: http://devticker.pw/json-data.php

Code here:

while($row = mysqli_fetch_array($result))
{
$data[] = '{"c": [{ "v": ' . $row['Timestamp'] . '"},{"v":' . $row['USD'] . '} ]}';
}

$str = json_encode(array("rows"=>$data));

$str = substr($str, 1);

$str = str_replace(""{", "{", $str);

$str = '{"cols":[{"type":"string"},{"type":"number"}],' . $str;

$str = stripslashes($str);

echo $str;

Answer 1

Try

while($row = mysqli_fetch_array($result))
{
    $data[] = array("c" => array(array( "v" => $row['Timestamp']), array("v" => $row['USD'] ))));
}

$rows = array("rows"=>$data));

$cols = array("cols" => array(array("type"=>"string"),array("type"=>"number")),$row);

$str = json_encode($cols);

echo $str;