*************

SQL code: Upload dump Copy Format Clear

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 ;

SQL Server: Preserve result

Result: Copy Clear

PHP code: Copy Format Clear

<?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);

PHP version:

Show: Warnings Notice

Result: Copy Clear

PHPize Online / SQLize Online / SQLtest Online