There is a code for the conversion counter on the external link. How to remove the element from the $ url array from the array (url), circled in red in the picture to redirect to this url?

<?php mysql_connect("localhost", "root", "") or die(mysql_error()) ; mysql_select_db("dbname") or die(mysql_error()) ; if (empty($_GET['id'])) { header('HTTP/1.1 404 Not found'); die(); } else { $id = mysql_real_escape_string($_GET['id']); mysql_query("update lbsplash set click = click + 1 where id = '$id'"); //$url = выбрать из массива элемент 'product url', где id='$id' header('Location: '.$url); } ?>
enter image description here

    1 answer 1

     $result = mysql_query("select data from lbsplash where id ='$id'"); $row = mysql_fetch_assoc($result); $json_data = $row['data']; $data = json_decode($json_data, true); $url = $data['product'];