<?php
set_time_limit(0);
$con=mysqli_connect("localhost","rub3x_testbed","GF~Zm}eM(lpp","rub3x_testbed");
if (mysqli_connect_errno()) {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$new = True;
$handle = @fopen("movielist.txt", "r");
if ($handle) {
    $total = array();
    $i = 0;
    $x = 0;
    while (($buffer = fgets($handle, 4096)) !== false)
    {
        if($x == 0)
        {
            $total[$i][0] = $buffer;
            $mseries = $buffer;
            $x++;
            $new = True;
        } elseif($x == 3) {
            $x = 0;
            $total[$i][3] = $buffer;
            $i++;
            $new = False;
        } else {
            $total[$i][$x] = $buffer;
            $x++;
            $new = False;
        }
        //loop broke you need a true/false to make below work

        if($new == False)
        {
            $mdate = substr(strrchr($buffer, " ("), 1);
            $mdate = str_replace('(', '', $mdate);
            $mdate = str_replace(')', '', $mdate);
            $mname = substr($buffer, 0,strrpos($buffer, ' ('));
            $mname = str_replace(' ', '%20', $mname);
            //$url = "http://www.omdbapi.com/?t=$mname&y=$udate";
            //$json = file_get_contents($url);
            //$obj = json_decode($json);
            //$mimage = $obj->Poster;
            //echo $i . "<br />";
            //usleep(75000);
            //$mrating = $obj->imdbRating;
            //$mgenre = $obj->Genre;
            //$mactors = $obj->Actors;
            //$dbname = $obj->Title;
            //mysqli_query($con,"INSERT INTO `rub3x_testbed`.`movies` (`series`, `movie`, `date`, `image`, `rating`, `genre`, `actors`) VALUES ('$mseries', '$dbname', '$mdate', '$mimage', '$mrating', '$mgenre', '$mactors');");
            echo '"' . $mname . '"<br />';
        } else {
            echo 'Series: "' . $mseries . '"<br />';
        }
    }

    if (!feof($handle))
    {
        echo "Error: unexpected fgets() fail\n";
    }
    fclose($handle);

}


mysqli_close($con);


?>