Exemplo n.º 1
0
function showAllTranscriptions()
{
    $query = "select * from recordings where transcribed is null";
    $result = mysql_query($query) or die(mysql_error());
    if (mysql_num_rows($result) == 0) {
        echo "<div class='transcription_block'>There are no calls to transcribe right now</div>";
    }
    for ($index = 0; $index < mysql_num_rows($result); $index++) {
        $row = mysql_fetch_array($result);
        showTranscription($row);
    }
}
Exemplo n.º 2
0
<?php

require_once "connect.php";
require_once "pages.php";
$query = "select * from recordings where transcribed!='1'";
$result = mysql_query($query) or die(mysql_error());
printHeader();
for ($index = 0; $index < mysql_num_rows($result); $index++) {
    $row = mysql_fetch_array($result);
    showTranscription($row);
}
printFooter();
function showTranscription($row)
{
    $url = $row['url'];
    $id = $row['recording_id'];
    $transcriptionName = "transcription" . $id;
    echo "<div class='transcription_block'>\n<div class='recording'>\n<EMBED height='50' SRC='{$url}' VOLUME='50' loop='false' controls='console' AUTOSTART='FALSE' width='90%'>\n</div>\n<div class='transcription'>\n<textarea id='{$transcriptionName}' cols='80' rows='5'>Enter your transcription here</textarea>\n</div>\n<div class='button'>\n<button name='transcribe'>Save Transcription</button>\n</div>\n</div>\n\n";
}