connect_errno) {$em = $mysqli->connect_error;} if($em==="") { $browser=$_SERVER['HTTP_USER_AGENT'] ; $db_table="cockology_stats"; $sql = 'INSERT INTO `'.$db_table.'`(`connection_speed`, `html5video`, `devicetype`, `ostype`, `userid`, `thebrowser`, `datecreated`)'.' VALUES (?, ?, ?, ?, ?, ?, UTC_TIMESTAMP())'; if($query = $mysqli->prepare($sql)) { $query->bind_param( 'dsssis', $cspeed, $html5, $devicetype, $ostype, $userid, $browser) ; $query->execute(); $cockid = $mysqli->insert_id; } else { $em = $mysqli->errno . ' ' . $mysqli->error; } } if ($mysqli->connect_errno) {$em = $mysqli->connect_error;} else{$_SESSION['connectionspeed']=$cspeed;} $arr = array ('connectionspeed'=> $cspeed, 'cset'=>"set", 'error_message' => $em); echo json_encode($arr); exit(); } $arr = array ('connectionspeed'=> $_SESSION['connectionspeed'], 'cset'=>"not set", 'error_message' => ""); echo json_encode($arr); exit(); ?>