PHP: Cut The File Content By Lines ~ Dumb Coder

Problem Description
Assumed, you have very long text in one file. But, you only need some part of its contents. For example; i have a whole database dump in one file, but i only need to import specific database. So, i looked the whole contents and found the line range which would import the target database.

Solution Scope
There was some requirement to be fulfilled:

The file should only contain text.
You have to know where lines should cut.

Algorithm
The solution required user to submit a file and line range, before the process to cut the content. Step by step solution described below:

Input: file, line start, and line end.
Read the file line by line using while loop.
If the line matched with line start, store the text to temporary variable.
If the line matched with line end, break or stop the loop.

Code

<?php
    if ($_SERVER['REQUEST_METHOD'] == 'POST') {
        $tmp = 'tmp/';
        $targetFile = $tmp . basename($_FILES['upFile']['name']);
        $uploadOk = 1;

        if (move_uploaded_file($_FILES['upFile']['tmp_name'], $targetFile)) {
            $handle = fopen($targetFile, 'r');
            $row = 1;
            $tmpF = "";

            if ($handle) {
                if (!empty($_POST['finish_row'])) {
                    while (($line = fgets($handle)) !== false) {
                        if ($row == $_POST['finish_row']) {
                            break;
                        }

                        if ($row >= $_POST['start_row']) {
                            $tmpF .= $line;
                        }
                        ++$row;
                    }
                } else {
                    while (($line = fgets($handle)) !== false) {
                        if ($row >= $_POST['start_row']) {
                            $tmpF .= $line;
                        }
                        ++$row;
                    }
                }

                fclose($handle);
                header("Content-Type: text/plain");
                header("Content-Disposition: attachment; filename=result.txt");
                // Disable caching
                header("Cache-Control: no-cache, no-store, must-revalidate"); // HTTP 1.1
                header("Pragma: no-cache"); // HTTP 1.0
                header("Expires: 0"); // Proxies
                echo $tmpF;
            } else {
                header('Location: http://localhost/file-cutter.php/?error=Can%20not%20read%20file');
            }
        } else {
            header('Location: http://localhost/file-cutter.php/?error=Can%20not%20upload%20file');
        }
    } else {
        if (isset($_GET['error'])) {
            $err = "<label>".$_GET['error']."</label><br>";
        } else {
            $err = "";
        }
        echo "
<!DOCTYPE html>
<html>
<head>
    <title>Selection File Row</title>
</head>
<body>
    $err
    <form action='file-cutter.php' method='POST' accept-charset='utf-8' enctype='multipart/form-data'>
        <input type='file' name='upFile'>
        <input type='number' name='start_row'>
        <input type='number' name='finish_row' placeholder='empty for end of file' value=''>
        <input type='submit' name='OK'>
    </form>
</body>
</html>
";

You can try the online demo.

Dumb Coder

Just dumb man try talk about code.

Thursday, July 7, 2016

PHP: Cut The File Content By Lines

0 comments :

Post a Comment

Followers