计算子字符串出现次数和返回得分

Question

I am working on this project where I have this MySQL database with a table named "speechesLCMcoded" with thousands of lines of parsed text. I have four columns that are "key", "parsed", "weight" and "count".

The text in the column "parsed" looks like this:

{N}table{/N}{V}play{/V}{A}big{/A}

I have another table that is named "concreteness" that has two columns, In the column "word" I have a list of words and in the column "score" I have each word's concreteness score. For example it would look like this

Word    Score 
table   5 
play    3 
big     2

I am working on a php script that will calculate for each line of my table "speechesLCMcoded" the total cumulated score of each word and the total number of scored words.

In my example, the result would look like this:

Key    parsed                            weight    count
1     {N}table{/N}{V}play{/V}{A}big{/A}  10        3

I have written a part of the script but I am stuck because of my limited experience with php. I am confused by the fact that there are two "while" loops in my script

How would you advise me to do?

<?php
//Include functions
        include "functions.php";
        ini_set('max_execution_time', 90000);
        echo 'Time Limit = ' . ini_get('max_execution_time');

//Conecting the database
        if (!$conn) {
         die('Not connected : ' . mysql_error());}

// make LCM the current db
        mysql_select_db('senate');
        $data = mysql_query("SELECT `key`, `tagged` FROM speecheLCMcoded") 
        or die(mysql_error()); 

// puts the "data" info into the $info array 
        while($info = mysql_fetch_array( $data) ){
        $key=$info['key'];
        $tagged=$info['tagged'];

// Print out the contents of the entry 
        Print "<b>Key:</b> ".$info['key'] .  " <br>";  

// Select Word List and their weights
        $dataweights = mysql_query("SELECT `word`, `weight` FROM concreteness") 
        or die(mysql_error()); 

// puts the "data" info into the $infoweights array 
        while($infoweights = mysql_fetch_array( $infoweights) ){
        $word=$info['word'];
        $score=$info['score'];      

// Calulate number of adjectives
        ob_start(); //Start output buffer
        print substr_count($tagged,"{"); 
        $adjectives = ob_get_contents(); //Grab output
        ob_end_clean(); //Discard output buffer

// Calulate number of coded items


//Saving number of coded words
        $sql = "UPDATE speechestest SET adjectives='$adjectives', verbs='$verbs', nouns='$nouns' WHERE `key`='$key';" ;
        $retval = mysql_query( $sql, $conn );
        if(! $retval )
        {die('Could not update data: ' . mysql_error());}
        echo "Updated data successfully
";
}
 ?> 

Answer 1

What you want to do is the following:

o  Query the database to get your sentences

o  For each sentence (while loop) {

  o  Get a list of all the words in your sentence (by breaking up the sentence into words--c.f. explode and preg_match_all)

  o  For each word you found (while loop) {

    o  Query the database to get information about the word.

    o  Do whatever you need to do with the word data.
  }

}

I'm not providing code because that's your job :) Also, try writing out what you want to do in human-readable sentences, and then just replace those sentences with code. It should make it more clear what you're doing and why you're doing it.