my jukebox can't play music

Discussion in 'PHP' started by chitara, Nov 23, 2006.

0
  1. #1
    Hi there!

    I have created a playlist with multiple checkbox for a jukebox.

    now I want to play this or these song in a player that I customized that will hld the value of those selected track.
    my files are as follows>>>

    my first file>> playlist.php

    ***[
    <form name=fp action="player.php" method="POST" enctype="audio/mpegurl">

    <table width=100% align=left>
    <?

    $query="select * from musiclibrary where music_no='$id' order by music_no desc";
    $result=mysql_query($query);
    $count=mysql_num_rows($result);


    if( empty( $count ) )
    {
    echo "<BR>&nbsp;&nbsp;Song is not available<BR>&nbsp;&nbsp;in this category.";

    }
    else
    {
    while($rows=mysql_fetch_array($result)){

    ?> <tr>
    <td width=25% align=center>
    <input type=checkbox name="track[]" value="<? echo $rows['music_no']; ?>">
    </td>
    <td width=75% align=left>
    <? echo $rows['music_name']; var_dump($rows['music_no']);?>
    </td>
    </tr>

    <?

    }

    }


    ?>

    </table>
    </div>
    <div id="Layer6" style="position:absolute; width:55; height:23; z-index:5; left: 208px; top: 249px">
    <input type="hidden" name="track[]" value="<? echo $rows['music_no']; ?>">
    <input type=image name=play src="../images/button_playlist.gif" width="55" height="23" border=0>

    </div>
    </form>

    ]***


    My second file >> player.php
    ***]
    <?

    include "../admin/include/db.php";

    $file=$_GET['track'];


    $result = mysql_query( "SELECT music_no, music_name, file_name FROM musiclibrary where music_no='$file'" );
    //$count = mysql_num_rows( $result );
    if ($result){
    while($row = mysql_fetch_array($result, MYSQL_NUM))
    {
    $result_array[] = $mdir."/".$row[3]."\n";

    }

    mysql_free_result( $result );
    }else{
    echo'error';
    }
    ?>


    <html>
    <head>
    <title>Player</title>
    </head>
    <body bgcolor="#FFFFFF">



    <title>player</title>
    <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
    <script language="JavaScript">
    <!--
    function MM_reloadPage(init) { //reloads the window if Nav4 resized
    if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
    document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
    else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
    }
    MM_reloadPage(true);
    // -->
    <!--</script>
    </head>

    <div id="Layer1" style="position:absolute; width:300; height:300; z-index:2; left: -2px; top: -2px; background-color: #000000; layer-background-color: #000000; border: 1px none #000000">


    <OBJECT ID="MediaPlayer" WIDTH=300 HEIGHT=300
    classid="clsid:22D6f312-B0F6-11D0-94AB-0080C74C7E95"
    STANDBY="Loading Media Player components"
    TYPE="application/x-oleobject"
    codebase="http://activex.microsoft.com">

    <PARAM NAME = "autostart" VALUE = "True" >
    <PARAM NAME = "filename" VALUE = "<?print $result_array [i am confuse abuot this value];?>" >

    </OBJECT>


    </div>

    </body>
    </html>
    <script>

    ]***

    my table format is like .....

    CREATE TABLE `musiclibrary` (
    `music_no` int(11) NOT NULL auto_increment,
    `music_name` varchar(100) default NULL,
    `file_name` varchar(100) default NULL,
    `music_day` decimal(10,0) default NULL,
    `cat_id` decimal(10,0) default NULL,
    PRIMARY KEY (`music_no`),
    UNIQUE KEY `music_no` (`music_no`),
    KEY `cat_id` (`cat_id`)
    );

    please tel me how'll I do that!!

    Regards
     
    chitara, Nov 23, 2006 IP
  2. chitara

    chitara Peon

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    is there anyone how can suggest me?????
     
    chitara, Nov 24, 2006 IP
  3. maiahost

    maiahost Guest

    Messages:
    664
    Likes Received:
    35
    Best Answers:
    0
    Trophy Points:
    0
    #3
    OK Assuming you have the ID of the song : 
    
<?
$query1="select * from musiclibrary where music_no='$id' ";
$result1=mysql_query($query);
$row1=mysql_fetch_assoc($result);
?>

<PARAM NAME = "filename" VALUE = "<?php echo $row1["file_name"]; ?>" >
    PHP:
     
    maiahost, Nov 25, 2006 IP