Qfyilyi

I am trying to get a value from php file ,php file retrieve data from ORACLE DATABASE, to a script js this is the php file :

<?php

include("../../config.php");



if(isset($_POST['songId'])) {

    $songId = $_POST['songId'];



    $query = oci_parse($con, "SELECT s.song_path, s.song_id, s.TITLE, r.Artist_Name, a.artworkpath FROM songs s, artists r, albums a WHERE s.artist_id = r.artist_id AND a.album_id = s.album_id  AND song_id='$songId'");

    oci_execute($query);

    $resultArray = oci_fetch_array($query);



    echo json_encode($resultArray,JSON_FORCE_OBJECT);

}

?>

it works and successfully retrieve data from the tables.

The script that uses data:

<?php

$songQuery = oci_parse($con, "SELECT song_id from songs order by dbms_random.value");

oci_execute($songQuery);

$resultArray = array();



while(($row = oci_fetch_array($songQuery, OCI_BOTH)) != false) {

    array_push($resultArray, $row['SONG_ID']);

}



$jsonArray = json_encode($resultArray, JSON_FORCE_OBJECT);

?>



<script>



$(document).ready(function() {

    currentPlaylist = <?php echo $jsonArray; ?>;

    audioElement = new Audio();

    setTrack(currentPlaylist[0], currentPlaylist, false);

});





function setTrack(trackId, newPlaylist, play) {



    $.post("includes/handlers/ajax/getSongJson.php", { songId: trackId }, function(data) {



        var track = JSON.parse(data);

        $(".trackName span").text(track.TITLE);

        $(".artistName span").text(track.ARTIST_NAME);

        $(".albumLink img").attr("src", track.ARTWORKPATH);



        audioElement.setTrack(track.SONG_PATH);

        audioElement.audio.play();

    });



    if(play == true) {

        audioElement.audio.play();

    }

}



function playSong() {

    if(audioElement.audio.currentTime == 0) {

        $.post("includes/handlers/ajax/updatePlays.php", { songId: audioElement.audio.currentlyPlaying.SONG_ID});

    }



    $(".controlButton.play").hide();

    $(".controlButton.pause").show();

    audioElement.audio.play();}





function pauseSong() {

    $(".controlButton.play").show();

    $(".controlButton.pause").hide();

    audioElement.audio.pause();

}



</script>

All the functions work well except

(songId: audioElement.audio.currentlyPlaying.SONG_ID) 

It don't recognize SONG_ID which is a column from database retrieved in the php file (ajax/getSongJson.php)

PS: the (ajax/updatePlays.php) file is a php file that is for Updating DATA (PLAYS) when the user use playSong function when the current time = 0 so it increment the PLAY colomn in the database by 1

The update php file

<?php

include("../../config.php");



if(isset($_POST['songId'])) {

    $songId = $_POST['songId'];



    $query = OCI_parse($con, "UPDATE songs SET plays = plays + 1 WHERE song_id='$songId'");

      oci_execute($query);

}

?>

This is the script file when I created a Audio Class, used in the script:

var currentPlaylist = ;

var audioElement;





function Audio() {



    this.currentlyPlaying;

    this.audio = document.createElement('audio');



    this.setTrack = function(track) {

        this.currentlyPlaying = track;

        this.audio.src = track.SONG_PATH;

    }



    this.play = function() {

        this.play();

    }



    this.pause = function() {

        this.pause();

    }



}

The error says :

Uncaught TypeError: Cannot read property 'SONG_ID' of undefined

at playSong ((index):140)

at HTMLButtonElement.onclick