Read only first ten words from a text file using php

Question

<?php
    include 'db_connection.php';

    if (isset($_POST['submit'])) {

    $file = fopen("quiz3.txt","r") or die("Unable to open file!");

    $line = fgets($file);

    $sql = "INSERT INTO quiz3 (FromFile) VALUES ('".$line."')";

    $result = mysqli_query($conn,$sql);

    if (!$result) {

        echo mysqli_error($conn);
    }
    else
    {
        echo "Your File Has Been Read & Stored In Database Successfully<br>Line Stored = ";
        echo $line;
    }

    fclose($file);
    }
?>

I want to store only first ten words from the line. How Can i do that? currently it is saving the first line.

http://stackoverflow.com/questions/5956610/how-to-select-first-10-words-of-a-sentence — Farkie, Sep 21 '16 at 09:13

score 2 · Accepted Answer · answered Sep 21 '16 at 09:17

2

function get_words($sentence, $count = 10) {
  preg_match("/(?:\w+(?:\W+|$)){0,$count}/", $sentence, $matches);
  return $matches[0];
}

$file = fopen("quiz3.txt","r") or die("Unable to open file!");

$line = fgets($file);

$convertedLine = get_words($line );

$sql = "INSERT INTO quiz3 (FromFile) VALUES ('".$convertedLine ."')";

$result = mysqli_query($conn,$sql);

answered Sep 21 '16 at 09:17

virepo

320
5
22

can you please explain the working of the function in 2 to 3 three lines – Sadda Hussain Sep 21 '16 at 09:27
It would be a little hard to explain Regex in 2 - 3 lines. I would advise learning regex at some stage though – virepo Sep 21 '16 at 09:32

score 0 · Answer 2 · answered Sep 21 '16 at 09:33

Not sure if your data contains comma, or other symbols. This might be quick solution, and it also works with CJK words.

    <?php
    function cut_words($source, $number_take){
        $result = "";
        $wc = 0;
        $source = str_replace("  ", " ", $source); // Simple sanity
        $string = explode(" ", $source);
        while ($wc < $number_take){
            if(isset($string[$wc])){ // Prevent index out of bound.
                $result .= $string[$wc];
                if($wc < $number_take) {
                    $result .= " ";
                }
            $wc++;
            } else {
                break;
            }
        }
        $result = trim($result);
        return $result;
    }

    $line = cut_words($line, 10); 

    ?>

It is. Especially compare with regular expressions. ;) – HZS Sep 22 '16 at 13:00 — HZS, Sep 22 '16 at 13:00

Read only first ten words from a text file using php

2 Answers2