<?php

            $host = 'localhost';
            $user = 'fulltime_admin';
            $pass = 'jordan23';
            $database = 'fulltime_db';

            $db = mysql_connect($host, $user, $pass);
            mysql_query($database, $db);


            //////////////////////////////// EDIT ////////////////////////////////////

            $redirect_num = 500;   // Select how many rows to insert each time before refresh.
                                    // More rows = faster insertion. However cannot be too high otherwise it will timeout.

            $filename = "ps4_emails.csv"; // The file we are going to get the data from...

            $table = "`ps4_emails`";


            ////////////////////////////// END EDIT //////////////////////////////////

            $file = file($filename);
            $lines = count($file);

            // Have we just redirected?
            $nextline = $_GET['nextline'];
            if (!isset($nextline)){
            $nextline = 0;
            }

            $query = "INSERT INTO ".$table." (email) VALUES ('".$final_line[0]."')";

            for ($line=$nextline; $line<=$lines; $line++){

            $final_line = explode(",", $file[$line]);

            if ($line!=$lines){
            mysql_query($query,$db);

            }

            if ($line % $redirect_num){

                // something needs to go here
            }
            else {
            $nextline = $line+1;
            exit ('<meta http-equiv="refresh" content="0;url=texttomysqlemails.php?nextline='.$nextline.'" />');
            }

            echo  ( $line==$lines ) ? "Done" : "";

            }
            ?>