Online PHP editor | refs for 3uQl4

<?php header('Content-Type: text/html; charset=UTF-8'); date_default_timezone_set('America/Los_Angeles'); echo memory_get_usage() . "\n"; $con = mysqli_connect("localhost", "***", "***", '***'); $result = mysqli_query($con,"SELECT * FROM **_streams"); while($row = mysqli_fetch_array($result)) { $json_array = json_decode(file_get_contents('https://api.twitch.tv/kraken/streams/'.strtolower($row['channel'])), true); if ($json_array['stream'] != NULL) { // turn them into variables to prevent outside SQL injection $displayname = mysqli_real_escape_string($con,$json_array['stream']['channel']['display_name']); $title = mysqli_real_escape_string($con,$json_array['stream']['channel']['status']); $game = mysqli_real_escape_string($con,$json_array['stream']['channel']['game']); $viewers = mysqli_real_escape_string($con,$json_array['stream']['viewers']); $preview = mysqli_real_escape_string($con,$json_array['stream']['preview']['medium']); $followers = mysqli_real_escape_string($con,$json_array['stream']['channel']['followers']); $date = date('m/d/Y h:i:s a', time()); mysqli_query($con,"SET NAMES utf8mb4"); mysqli_query($con,"UPDATE mybb_streams SET `online` = '1', `title` = '$title', `viewers` = '$viewers', `game` = '$game', `preview` = '$preview', `followers` = '$followers', `lastactive` = '$date' WHERE `channel` = '".strtolower($row['channel'])."'") or die("A MySQL error has occurred.<br />Your Query: UPDATE `streams` SET `online` = `1`, `title` = `$title`, `viewers` = `$viewers`, `game` = `$game`, `preview` = `$preview` WHERE channel = '".strtolower($row['channel'])."'<br /> Error: (" . mysqli_errno($con) . ") " . mysqli_error($con)); } else { mysqli_query($con,"UPDATE mybb_streams SET `online` = '0', `viewers` = '0' WHERE `channel` = '".strtolower($row['channel'])."'") or die("A MySQL error has occurred.<br />Your Query: UPDATE streams SET `online` = '0', `viewers` = '0' WHERE `channel` = '".strtolower($row['channel'])."'<br /> Error: (" . mysqli_errno($con) . ") " . mysqli_error($con)); } } echo memory_get_usage() . "\n"; ?>