How to play my audio file in jplayer audio player?

Question

I am trying to set up a Jplayer audio player. I have almost completed it but I want to know how to play my selected audio file from using $GET method and retrieving from database?

Here is link to audio player page which is suppose to play a file known as Kalimba.mp3 which the file is stored in the directory AudioFiles/Kalimba.mp3.

Audio Play page

Below is link to jplayer instructions (commented line where error is)

http://www.jplayer.org/latest/quick-start-guide/

Below is the code I currently have, I commented line number where error is:


    
    Preview Audio
    
       
    
      




prepare($audioquery)) {
        // Handle errors with prepare operation here
}


// Bind parameter for statement
$audiostmt->bind_param("s", $getaudio);

// Execute the statement
$audiostmt->execute();

            if ($audiostmt->errno) 
            {
                // Handle query error here
            }

$audiostmt->bind_result($dbAudioFile); 

$audiostmt->fetch(); 

$audiostmt->close(); 

?>

  
  
    
      
        
          play
          pause
          stop
          mute
          unmute
          max volume
        
        
          
            
          
        
        
          
        
        
          
          
          
            repeat
            repeat off

user1830984 · Accepted Answer

This code below should do the trick:

$getaudio = 'AudioFiles/' . $_GET['filename'];

$audioquery = "SELECT AudioFile FROM Audio WHERE (AudioFile = ?)";

        if (!$audiostmt = $mysqli->prepare($audioquery)) {
        // Handle errors with prepare operation here
}


// Bind parameter for statement
$audiostmt->bind_param("s", $getaudio);

// Execute the statement
$audiostmt->execute();

            if ($audiostmt->errno) 
            {
                // Handle query error here
            }

$audiostmt->bind_result($dbAudioFile); 

$audiostmt->fetch(); 

$audiostmt->close(); 

$info = pathinfo($dbAudioFile);

How to play my audio file in jplayer audio player?

Answers (1)

Related Questions