$segment_count = count($echonest_data->segments); $bar_duration_sum = 0; foreach ($echonest_data->bars as $bars_data) { $bar_duration_sum = $bar_duration_sum + $bars_data->duration; } $bar_avg_second = $bar_duration_sum / $bar_count; echo "second: {$second} \n"; echo "bar_count: {$bar_count} \n"; echo "beat_count: {$beat_count} \n"; echo "tatum_count: {$tatum_count} \n"; echo "section_count: {$section_count} \n"; echo "segment_count: {$segment_count} \n"; echo "bar_avg_second: {$bar_avg_second} \n"; $music_feature_id = $music_feature_god->findBySongId($song_obj->getId()); if ($music_feature_id) { $music_feature_obj = new LMMusicFeature($music_feature_id); $music_feature_obj->second = $second; $music_feature_obj->bar_count = $bar_count; $music_feature_obj->beat_count = $beat_count; $music_feature_obj->tatum_count = $tatum_count; $music_feature_obj->section_count = $section_count; $music_feature_obj->segment_count = $segment_count; $music_feature_obj->bar_avg_second = $bar_avg_second; if ($music_feature_obj->save()) { echo "update music feature success \n"; } else { echo "update music feature fail \n"; } } else { $parameter_array = array(); $parameter_array['song_id'] = $song_obj->getId();
* PHP version 5 * * @category PHP * @package /p-schedule/ * @author Fukuball Lin <*****@*****.**> * @license No Licence * @version Release: <1.0> * @link http://sarasti.cs.nccu.edu.tw */ require_once dirname(dirname(__FILE__)) . "/p-config/application-setter.php"; $db_obj = LMDBAccess::getInstance(); $select_sql = "SELECT " . "id " . "FROM music_feature " . "WHERE is_deleted = '0' " . "ORDER BY id"; $query_result = $db_obj->selectCommand($select_sql); // get unprocess data foreach ($query_result as $query_result_data) { $music_feature_obj = new LMMusicFeature($query_result_data['id']); $song_id = $music_feature_obj->song_id; $select_sql2 = "SELECT " . "macw.id code_word_id," . "maw.song_id," . "COUNT(maw.code_word_id) word_count " . "FROM muisc_audio_code_word macw " . "LEFT JOIN music_audio_word maw " . "ON (macw.id=maw.code_word_id AND maw.song_id=" . $song_id . ") " . "WHERE macw.code_book_id=1 " . "GROUP BY macw.id " . "ORDER BY macw.id"; $query_result2 = $db_obj->selectCommand($select_sql2); $histogram_array = array(); foreach ($query_result2 as $query_result_data2) { array_push($histogram_array, $query_result_data2['word_count']); } $histogram_array_string = implode(',', $histogram_array); $music_feature_obj->pitch_audio_word_histogram = $histogram_array_string; if ($music_feature_obj->save()) { echo "update music feature " . $music_feature_obj->getId() . " success \n"; } else { echo "update music feature " . $music_feature_obj->getId() . " fail \n"; } unset($music_feature_obj);