Choose an artist:
\n");
printf("");
printf("");
if(isset($_POST["artist"])) {
printf("Choose a title:
\n");
$sql_retrieve_names = sprintf("SELECT name FROM stimulus where artist = '%s'",$_POST["artist"]);
mysql_select_db($database_subject,$subject);
$retrieve_names = mysql_query($sql_retrieve_names,$subject) or die(mysql_error());
printf("
");
}
printf("\n");
printf("OR
Enter a stim ID:
");
$sql_retrieve_stim_ids = sprintf("select stimulus_id from stimulus");
mysql_select_db($database_subject,$subject);
$retrieve_stim_ids = mysql_query($sql_retrieve_stim_ids,$subject) or die(mysql_error());
printf("");
}
if((isset($_POST["artist"]) && isset($_POST["name"])) || isset($_POST["id"])) {
if(isset($_POST["id"])) {
$sql_retrieve_location = sprintf("select * from stimulus where stimulus_id = %d",$_POST["id"]);
$retrieve_location = mysql_query($sql_retrieve_location) or die(mysql_error());
$row_retrieve_location = mysql_fetch_assoc($retrieve_location);
$artist = $row_retrieve_location['artist'];
$name = $row_retrieve_location["name"];
$stim_id = $_POST["id"];
}
else {
$sql_retrieve_id = sprintf("SELECT stimulus_id from stimulus where artist = '%s' and name = '%s'",$_POST["artist"],$_POST["name"]);
mysql_select_db($database_subject,$subject);
$retrieve_id = mysql_query($sql_retrieve_id) or die(mysql_error());
$row_retrieve_id = mysql_fetch_assoc($retrieve_id);
$artist = $_POST["artist"];
$name = $_POST["name"];
$stim_id = $row_retrieve_id["stimulus_id"];
}
printf("\nPlaying: \"%s\" by %s\n",stripslashes($name),stripslashes($artist));
//present_stimuli(NULL,$stim_id);
$stimInfo = get_stim_file_info_from_ID($stim_id);
$audioPlayerOptions['urls'][] = $stimInfo['url'];
$audioPlayerOptions['loadWhenDone'] = $questionnaire_hostname . $_SERVER['PHP_SELF'];
$audioPlayerOptions['playLengths'][] = 0;
$audioPlayerOptions['pauses'][] = 0;
switch($stimInfo['format']) {
case 'mp3':
play_audio_stimuli_flash($audioPlayerOptions);
break;
case 'wav':
play_audio_stimuli_applet($audioPlayerOptions);
break;
}
} //if posted artist and posted name
?>