<?PHP

$servername = "192.168.2.75";
$username = "kodi";
$password = "kodi";
$dbname = "torrents";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}


#INITIAL SCRAPE OF PAGE
$initial_results = array();
$url="https://1337x.unblocked.vc/user/QxR/";
#$url="https://1337x.unblocked.vc/QxR-torrents/2/";
$data=file_get_contents($url);
$data = strip_tags($data,"<a>");
$d = preg_split("/<\/a>/",$data);
foreach ( $d as $k=>$u ){
    if( strpos($u, "<a href=") !== FALSE ){
        $u = preg_replace("/.*<a\s+href=\"/sm","",$u);
        $u = preg_replace("/\".*/","",$u);
        if( strpos($u, '/torrent/') !== FALSE) {
        array_push($initial_results, $u);
        }
    }
}

#LOOP TO GRAB INFO FROM PAGES
$reversed = array_reverse($initial_results);
foreach ($reversed as $result){
$title_split = explode("/", $result);
$title = "'".$title_split[3]."'";
$encoder=substr($title, 0, -5);
$encoder="'".end(explode('-',$encoder))."'";
 print "TITLE: " . $title . "<br>";
$url="https://1337x.unblocked.vc".$result;
 print "URL: <a href='" . $url . "'>" . $url . "</a><br>";
$data=file_get_contents($url);
$data = strip_tags($data,"<a>");
$d = preg_split("/<\/a>/",$data);
foreach ( $d as $k=>$u ){
    if( strpos($u, "href=\"magnet") !== FALSE ){
        $u = preg_replace("/.*href=\"/sm","",$u);
        $u = preg_replace("/\".*/","",$u);
        if( strpos($u, "magnet") !== FALSE ){
        print "MAGNET: <a href='" . $u . "'>MAGNET</a><br>";
        $start = "btih:";
        $end = "&dn";
        $hash = "'".getBetween($u,$start,$end)."'";
        print "HASH: " . $hash . "<br>";
	print "ENCODER: " . $encoder . "<br>";
$check_select = mysqli_query("SELECT * FROM `qxr` WHERE title = '$title'");
$numrows=mysqli_num_rows($check_select);

if($numrows == 0){

        $sql = "INSERT INTO qxr (title,hash,encoder) VALUES ($title, $hash, $encoder)";
        $conn->query($sql);
}
else
{print "Record exists";}
        break;
        }
    }
}

}

function getBetween($content,$start,$end){
    $r = explode($start, $content);
    if (isset($r[1])){
        $r = explode($end, $r[1]);
        return $r[0];
    }
    return '';
}

$conn->close();

?>

hello