Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
create table userAgent (
id int auto_increment primary key,
target varchar(20) not null,
agent varchar(2000)
);
INSERT INTO userAgent (id, target, agent) VALUES (1, 'MOB', 'Mozilla/5.0 (Linux; Android 11; SAMSUNG SM-G970F) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/15.0 Chrome/90.0.4430.210 Mobile Safari/537.36');
INSERT INTO userAgent (id, target, agent) VALUES (2, 'WEB', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/95.0.4638.54 Safari/537.36');
select * from userAgent ;
<?php
$answer ='{"status":"success","location":"https://www.benaughty.com/site/loginlink/?key=2e80ea3a1aca61567e0a88b82a1b2253&dci=132178530037c7cc5091bcf39f77156caf9323dd&tds_host=bend-me-over.com&tds_path=%2FtdsApi&tds_split=a&tds_campaign=b5780kru&tds_id=b5780kru_tds_site_group_a_1618326374100&tds_oid=bn&tds_cid=775e85349ca1a2ec26267bf2d5a2c87178a0bfc3&data2=bbbbb5555&utm_campaign=a2a3cd26&tdsId=b5780kru_tds_site_group_a_1618326374100&utm_source=mrmrmr&s1=mrss&utm_term=mrs1&utm_content=mrDist&apiKey=a9zdnijuuwydz4715qpjbh5phsl2xsl3qctvfpo9dpzrfexflum2x1a4iui0bhph&email=sergey.krugl3444rff0gg55%40gmail.com&sexual_orientation=hetero&gender=male&dob=1995-07-22&affiliateIp=-&ip=37.143.130.84&ua=MOB&p_tds_cid=&tds_reason=direct&tds_ac_id=s3656kru"}';
$obj = json_decode($answer);
$status = $obj->{'status'};
$code = $obj->{'code'};
$message = $json['message'];
$location = $json['location'];
$result = array(
'status' => $status,
'code' => $code,
'message' => $message,
'location' => $location
);
echo json_encode($result);