text: Q:
  
  Removing backslash from date()
  
  I'm trying to convert SQL datetime to a Y/m/d G:i:s format. 
  It has formated, but there is an extra backslash in front of every frontslash... I've tried str_replace and stripslashes and non of them have worked...
  Data: http://www.zewde.org/instagram/script_new/data.php
  Code: 
  <?php
  define('DB_NAME', 'FollowersCount');
  define('DB_USER', '******');
  define('DB_PASSWORD', '******');
  define('DB_HOST', '*.*.*.*');
  
  $connection = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
  
  if (!$connection) {
    die('Could not connect: ' . mysql_error());
  }
  
  mysql_select_db("FollowersCount", $connection);
  
  $sth = mysql_query("SELECT Date FROM Count ORDER BY Date");
  $sthh = mysql_query("SELECT Count FROM Count ORDER BY Date");
  
  $sthhh = mysql_query("select a.ID, a.Count,coalesce(a.Count -(select b.Count from Count b where b.ID = a.ID - 1), 5) as diff from Count a ORDER BY Date");
  
  $rows = array();
  while(($r = mysql_fetch_array($sth)) && ($rr = mysql_fetch_array($sthh)) && $rrr = mysql_fetch_array($sthhh)) 
  {
      $temp_count = intval($rr['Count']); 
      $temp_date1 = $r['Date'];
  
      $myFormatForView = date("Y/m/d G:i:s", strtotime($temp_date1));
      $final = str_replace("\\", "", $myFormatForView); //Doesn't work, neither does stripslashes...
  
      $temp = array( $final, $temp_count);
      $temp_s = implode(", ", $temp);
      $rows['data'][][] = $temp_s;
  }
  
  $result = array();
  array_push($result,$rows);
  $Jz = json_encode($result, JSON_NUMERIC_CHECK);
  
  echo $Jz;
  
  mysql_close($connection);
  ?>
  
  A:
  
  This is json_encodes fault.
  json_encode() options:
  
  JSON_UNESCAPED_SLASHES
    Don't escape /. Available since PHP 5.4.0.
  
  So
  $Jz = json_encode($result, JSON_NUMERIC_CHECK | JSON_UNESCAPED_SLASHES );
  
  should get rid of those backslashes.
  
  