How can I output the most frequently occurring word in a field of a table using PHP?

To output the most frequently occurring word in a field of a table using PHP, you can retrieve the data from the table, tokenize the text into individual words, count the occurrences of each word using an associative array, and then find the word with the highest frequency. Here is a PHP code snippet that demonstrates this: 

// Connect to your database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Retrieve data from the table
$sql = "SELECT field FROM your_table";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    $wordFrequency = array();

    // Tokenize and count word occurrences
    while($row = $result->fetch_assoc()) {
        $words = explode(" ", $row['field']);
        foreach($words as $word) {
            $word = strtolower($word);
            if(array_key_exists($word, $wordFrequency)) {
                $wordFrequency[$word]++;
            } else {
                $wordFrequency[$word] = 1;
            }
        }
    }

    // Find the word with the highest frequency
    $mostFrequentWord = array_search(max($wordFrequency), $wordFrequency);
    echo "The most frequently occurring word is: " . $mostFrequentWord;
} else {
    echo "No results found";
}

$conn->close();

Keywords

PHP MySQL SQL COUNT GROUP BY

Related Questions