TPB backup to mysql (PHP)

<?php
// This solution isn't elegant but works fine.

// CONFIGURATION ---------------------------------------------------
// set memory limit
ini_set('memory_limit', '-1');
// raw TPB file
$tpb_file = "complete";

// mySQL config ------------------------------
$mysql_host = "HOST";
$mysql_user = "USER";
$mysql_password = "PASSWORD";
$mysql_database = "DATABASE";
// CREATE THE TABLE BEFORE START THAT SCRIPT!
$mysql_table = "tpb"; //dafault

/* create the new table
$query = "CREATE TABLE `my_onlinemanga`.`tpb` (
`ID` DOUBLE NOT NULL ,
`name` TEXT NOT NULL ,
`size` DOUBLE NOT NULL ,
`seeders` INT NOT NULL ,
`leechers` INT NOT NULL ,
`magnet` TEXT NOT NULL
)";
*/

// ------------------------------------------
// ----------------------------------------------------------------

// Connecting, selecting database
$link = mysql_connect($mysql_host, $mysql_user, $mysql_password)
    or die('Could not connect: ' . mysql_error());
echo 'Connected successfully to MySQL';
mysql_select_db($mysql_database) or die('Could not select database');

// Performing SQL query
$query = "SELECT * FROM $mysql_table";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());

// read file into array
$file_array = file($tpb_file, FILE_IGNORE_NEW_LINES | FILE_SKIP_EMPTY_LINES);

$file_row_num = count($file_array);

// start with code manipulation--------
for($i=0; $i < $file_row_num; $i++){
  $original = $file_array[$i];
  // string lengh -1
  $len = strlen($original);
  $tpbid = substr($original, 0, 7); // TPD ID for database

  $original = substr($original, 8, $len);  // eliminate ID
  $reverse = strrev($original); //reverse the string for check '|'
  $pos = strpos($reverse, '|'); // last '|' [reversed]
  $magnetlink = substr($reverse, 0, $pos); // magnet link [reversed]
  $magnetlink = strrev($magnetlink); // MAGNET LINK for database

  $len = strlen($reverse);
  $reverse = substr($reverse, $pos + 1, $len);
  $pos = strpos($reverse, '|'); // last '|' [reversed]
  $leechers = substr($reverse, 0, $pos); // leechers [reversed]
  $leechers = strrev($leechers); // LEECHERS for database

  $len = strlen($reverse);
  $reverse = substr($reverse, $pos + 1, $len);
  $pos = strpos($reverse, '|'); // last '|' [reversed]
  $seeders = substr($reverse, 0, $pos); // seeders [reversed]
  $seeders = strrev($seeders); // SEEDERS for database

  $len = strlen($reverse);
  $reverse = substr($reverse, $pos + 1, $len);
  $pos = strpos($reverse, '|'); // last '|' [reversed]
  $size = substr($reverse, 0, $pos); // size [reversed]
  $size = strrev($size); // SIZE for database

  $len = strlen($reverse);
  $name = substr($reverse, $pos + 1, $len); //name [reversed]
  $name = strrev($name); // NAME for database

  // test
  // echo ("ID: $tpbid\nName: $name\nSize: $size\nSeed: $seeders\nLeech: $leechers\nMagnet link: $magnet_header$magnetlink\n\n");

  // insert to sql
  $query = "INSERT INTO tpb VALUES ('$tpbid','$name','$size','$seeders','$leechers','$magnetlink')";
  $result = mysql_query($query) or die('Query failed: ' . mysql_error());
}

// Closing connection
mysql_close($link);
?>