![\"\"](\"https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2020\/10\/mp3_tutorial.png\")
<\/a>\n<\/p>\n
In this example we will be using MySQL database and here is how our log table looks like. If you enable security in your project then the “username” field will contain the username of the current user. “current_time” column stores the position of audio file where play or pause was pressed.<\/p>\n
\r\nCREATE TABLE `audio_log` (\r\n `id` int(11) NOT NULL,\r\n `current_time` double DEFAULT NULL,\r\n `date` datetime DEFAULT current_timestamp(),\r\n `username` varchar(50) DEFAULT NULL,\r\n `action` varchar(50) DEFAULT NULL,\r\n `file` varchar(50) DEFAULT NULL\r\n);\r\nALTER TABLE `audio_log`\r\n ADD PRIMARY KEY (`id`);\r\nALTER TABLE `audio_log`\r\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;\r\n<\/pre>\nField with audio content needs to have ‘View as’ type Audio. The following code goes to Javascript OnLoad event of the page where Audio is played, i.e. to List or to View page.<\/p>\n
\r\n$('audio').on(\"play pause\",function(event) {\r\n\tsend_data(event);\r\n});\r\n\r\nfunction send_data(audio_event) {\r\n \/\/ parsing audio attributes to get the audio file name\r\n\tvar fileinfo = parse_file_props(audio_event.currentTarget.src);\r\n\t\/\/ building array with data to send to the server\r\n var data = {\r\n\t\taction:audio_event.type,\r\n\t\tfile:fileinfo.file,\r\n\t\tcurrent_time:audio_event.currentTarget.currentTime\r\n\t}\r\n \/\/ sending data to the server \r\n\t$.get(\"\",{a:\"log\",data:data});\r\n\r\n}\r\n\r\nfunction parse_file_props(src) {\r\n\treturn src.split(\"?\").pop().split(\"&\").reduce(\r\n function(p,e){\r\n var a = e.split('=');\r\n p[ decodeURIComponent(a[0])] = decodeURIComponent(a[1]);\r\n return p;\r\n },\r\n {}\r\n );\r\n}\r\n<\/pre>\nAnd the following code goes to the BeforeProcess event of the page with audio files. <\/p>\n
PHP:<\/b><\/p>\n
\r\nif( postvalue(\"a\") === \"log\" ){\r\n\t$data = postvalue(\"data\");\r\n\t$data[\"username\"] = Security::getUserName();\r\n\tDB::Insert(\"audio_log\",$data);\r\n\texit();\r\n}\r\n<\/pre>\nC#:<\/b><\/p>\n
\r\nif( MVCFunctions.postvalue(\"a\") == \"log\" ){\r\n\tdynamic data = MVCFunctions.my_json_decode(MVCFunctions.postvalue(\"data\"));\r\n\tdata.InitAndSetArrayItem(Security.getUserName(),\"username\");\r\n\tDB.Insert(\"audio_log\",data);\r\n\tMVCFunctions.Exit();\r\n}\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"If you have a website with a large number of audio files you might be interested in collecting stats like who listened to what and for how long and where they paused and started again etc. Turns out that collecting data like this and saving in the log table is easier than you would think.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,1,8],"tags":[],"_links":{"self":[{"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/posts\/2338"}],"collection":[{"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/comments?post=2338"}],"version-history":[{"count":5,"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/posts\/2338\/revisions"}],"predecessor-version":[{"id":2344,"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/posts\/2338\/revisions\/2344"}],"wp:attachment":[{"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/media?parent=2338"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/categories?post=2338"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/tags?post=2338"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}