PHP Audio Array?

6 New Member

Im still new to MySQL and know my way around PHP but not fully.

I'm creating a Audio Database that can be viewed here : http://elixclothing.com/connection.php

Im trying to figure out how to query all of the audio locations and put them in my media player which can be played according to which audio button is pressed.

I have a few ideas, I was wondering if I should move the audiolocation column to a new table so that I select them easier and not stress out my current table. Or follow something along the lines of this http://bytes.com/topic/php/answers/7...y-one-row-time

My current code is below:

Expand|Select|Wrap|Line Numbers

 <html>

<head>

<title>Test</title>

<script src="ac_quicktime.js" language="JavaScript" type="text/javascript"></script>

</head>

<body>

<script type="text/javascript"> 

function toggleVisibility() {

    document.getElementById("toggleMe").style.display = "";

    if(document.getElementById("toggleMe").style.visibility == "hidden" ) {

        document.getElementById("toggleMe").style.visibility = "visible";

    }

    else {

    document.getElementById("toggleMe").style.visibility = "hidden";

    }

}

function toggleDisplay() {

    document.getElementById("toggleMe").style.visibility = "visible";

    if(document.getElementById("toggleMe").style.display == "none" ) {

        document.getElementById("toggleMe").style.display = "";

    }

    else {

        document.getElementById("toggleMe").style.display = "none";

    }

}

</script> 
 
<table border="1" width="75%" cellpadding="2" cellspacing="2"> 

<tr> 

<td align="center">Cue Code</td> 

<td align="center">Cue Title</td> 

<td align="center">Cue Description</td> 

<td align="center">Time</td>

<td align="center"></td>

</tr> 

<br />
 
<?php

mysql_connect("***", "***", "***") or die(mysql_error());

echo "Connected to MySQL<br /><hr />";

mysql_select_db("elixclot_music") or die(mysql_error());

echo "Connected to Database<br /><hr />";

$query = "SELECT * FROM tracks";

$result = mysql_query($query) or die(mysql_error());

while($line = mysql_fetch_array($result)) {
 
    //        Audio Player Begins

echo "<div display='none' id='toggleMe' >

<p>".$line['cue_code']."</p>

<p>".$line['cue_title']."</p>

<OBJECT CLASSID='clsid:02BF25D5-8C17-4B23-BC80-D3488ABDDC6B' WIDTH='290' HEIGHT='20'

CODEBASE='http://www.apple.com/qtactivex/qtplugin.cab'>

<PARAM name='SRC' VALUE=".$line['cue_code'].">

<PARAM name='AUTOPLAY' VALUE='true'>

<PARAM name='CONTROLLER' VALUE='true'>

<EMBED src=".$line[audiolocation]." WIDTH='290' HEIGHT='20'

AUTOPLAY='false' CONTROLLER='true'

PLUGINSPAGE='http://www.apple.com/quicktime/download/'>

</EMBED>

</OBJECT>

 </div>";

   //        Audio Player Ends
 
echo "<td align='center'>".$line['cue_code']."</td>"; 

echo "<td align='center'>".$line['cue_title']."</td>"; 

echo "<td align='center'>".$line['cue_description']."</td>"; 

echo "<td align='center'>".$line['time']."</td>";

echo "<td align='center'><a href='#' onclick='toggleDisplay();'><img src='speaker_dark.gif' border=0></a>";

echo "</tr>"; 

}

?>

</table>

</body>

</html>

Any help would be greatly appreciated.

Jun 4 '10 #1

Subscribe Reply

1834

HaLo2FrEeEk

404

Contributor

I can help a little bit. First, I'm curious as to why you're using a separate div for each track, you don't need to do that. I'm also trying to figure out why you're using quicktime when you should instead use something like a flash-based player.

First off, you have to understand that you're setting multiple divs, all with the same ID. Your javascript is using the hard-coded ID "toggleMe" to show or hide the player div. Since they all have the same ID this causes issues. You should have each track in the database have it's own unique ID which you could append to the div's ID, for example:

track_id = 0
cue_code = OPUS10.013_12
cue_title = She'll Be The One ver. 2
cue_description = underscore
time = 01:48:00

Then your code would use that unique track_id as the div's ID:

<div id="toggleMe_0"...

then your javascript function toggleDisplay() would change to toggleDisplay(divID) and you'd replace all hardcoded instances of "toggleMe" to divID in the actual function, like below. I also made a variable named obj, so that you don't have to type the whole document.getElementById line so many times:

Expand|Select|Wrap|Line Numbers

 function toggleDisplay(divID) {

  var obj = document.getElementById(divID);

  obj.style.visibility = "visible";

  if(obj.style.display == "none" ) {

    obj.style.display = "";

    } else {

    obj.style.display = "none";

    }

  }

You are also forgetting to print an opening tag for a table row, you're only printing the closing tag which is making all of your information print on 1 row. The fix is easy:

Expand|Select|Wrap|Line Numbers

 //        Audio Player Ends
 
echo "<tr>";

echo "<td align='center'>".$line['cue_code']."</td>";

...

Just insert the echo "<tr>"; line before you start printing your table data tags.

One more thing, you should add "return: false;" (without the quotes) directly after your toggleDisplay() call in the onclick attribute, this will stop the link from actually navigating in the browser (yes, a # is still technically navigation.)

And again, you should look into a flash-based player, you can usually feed data to it through a javascript call and you'll only have to print one, plus Flash is more universal. Since I want you to do that instead of using Quicktime, I'm only going to point out a slight error in your audio player printing code in passing, because I don't think you should use it:

Expand|Select|Wrap|Line Numbers

 <PARAM name='SRC' VALUE=".$line['cue_code'].">

[...]

<EMBED src=".$line[audiolocation]." WIDTH='290' HEIGHT='20'...

For starters, the Object param src and the embed src should be the same thing, you're setting 2 different values. Secondly, you forgot the single quotes in the embed src:

$line[audiolocation]

Should be:

$line['audiolocation']

Anyway, I hope this gives you something to work with, let me know if yu have any more questions and I'll do my best to help!

Jun 4 '10 #2

xkrazykidx

New Member

@HaLo2FrEeEk
I really cant thank you enough! You have finally given me an intelligent response that relates to what I am trying to do. Ive spent so many times on other forums trying to get some help.

I have made the additions you recommended, also I do have a "ID" column in my table.

Expand|Select|Wrap|Line Numbers

 <html>

<head>

<title>Test</title>

<script src="ac_quicktime.js" language="JavaScript" type="text/javascript"></script>

</head>

<body>

<script type="text/javascript"> 

function toggleDisplay(divID) {

  var obj = document.getElementById(divID);

  obj.style.visibility = "visible";

  if(obj.style.display == "none" ) {

    obj.style.display = "";

    } else {

    obj.style.display = "none";

    }

  }

</script> 
 
<table border="1" width="75%" cellpadding="2" cellspacing="2"> 

<tr> 

<td align="center">Cue Code</td> 

<td align="center">Cue Title</td> 

<td align="center">Cue Description</td> 

<td align="center">Time</td>

<td align="center"></td>

</tr> 

<br />
 
<?php

mysql_connect("localhost", "elixclot_haywars", "mister") or die(mysql_error());

echo "Connected to MySQL<br /><hr />";

mysql_select_db("elixclot_music") or die(mysql_error());

echo "Connected to Database<br /><hr />";

$query = "SELECT * FROM tracks";

$result = mysql_query($query) or die(mysql_error());

while($line = mysql_fetch_array($result)) {
 
    //        Audio Player Begins

echo "<div display='none' id='toggleMe_1' >

<p>".$line['cue_code']."</p>

<p>".$line['cue_title']."</p>

<OBJECT CLASSID='clsid:02BF25D5-8C17-4B23-BC80-D3488ABDDC6B' WIDTH='290' HEIGHT='20'

CODEBASE='http://www.apple.com/qtactivex/qtplugin.cab'>

<PARAM name='SRC' VALUE=".$line['cue_code'].">

<PARAM name='AUTOPLAY' VALUE='true'>

<PARAM name='CONTROLLER' VALUE='true'>

<EMBED src=".$line['audiolocation']." WIDTH='290' HEIGHT='20'

AUTOPLAY='false' CONTROLLER='true'

PLUGINSPAGE='http://www.apple.com/quicktime/download/'>

</EMBED>

</OBJECT>

 </div>";

   //        Audio Player Ends
 
echo "<tr>";

echo "<td align='center'>".$line['cue_code']."</td>"; 

echo "<td align='center'>".$line['cue_title']."</td>"; 

echo "<td align='center'>".$line['cue_description']."</td>"; 

echo "<td align='center'>".$line['time']."</td>";

echo "<td align='center'><a href='#' onclick='toggleDisplay(divID);'><img src='speaker_dark.gif' border=0></a>";

echo "</tr>"; 

}

?>

</table>

</body>

</html>

But I want to switch to a flash player like you suggested. I did a quick Google search and found this http://www.flamplayer.com/, is this a good player to use? I was going for simplicity. Also an example for what I was going for was this site http://opus1.o1engine.com/

again THANK YOU! THANK YOU!

Jun 4 '10 #3

HaLo2FrEeEk

404

Contributor

That player would work, you'd just build a dynamic playlist in the format that the player reads.

And are you trying to build something exactly like that example site? Sorting by genre, artist, album, title, etc? That's quite a bit of work for somethig that's already been done to death.

Jun 5 '10 #4

xkrazykidx

New Member

Great ill start working on putting it together.

Unfortunately yes, im working with a start-up audio production company and this is how they want to organize their audio clips. They wanted their site to mimic Opus's site almost to the T.

Jun 5 '10 #5

HaLo2FrEeEk

404

Contributor

Looks like you've got quite a bit of work ahead of you then. You'll want to start by clearly defining, in your database, individual details about every track. Don't wait til later, do it now while there are only a few tracks to add the data to and not hundreds.

Jun 5 '10 #6

xkrazykidx

New Member

@HaLo2FrEeEk
Thanks for all your help! You have been great! I wish I would have came here first! Luckily I have told the other team members to work on a CSV with all the information about each track and I also gave them outlines :)

Thanks again!

Jun 6 '10 #7

HaLo2FrEeEk

404

Contributor

if you need it I've got a php script that can take a CSV file and translate it into an SQL query to mass import into a database, unless your database admin panel already lets you import a CSV.

Also, don't forget to mark a best answer : )

Jun 6 '10 #8

captainB

New Member

I was reading this thread out of interest, and I must say that I'm impressed with the effort shown by HaLo2FrEeEk to answer the question.

You elevate the quality of this forum!

Thanks!

Jun 6 '10 #9

xkrazykidx

New Member

@HaLo2FrEeEk
Hmm I tried out FlamPlayer its great but unfortunately does not accomplish the task I was looking for. It automatically adds tracks to a database but does not include all the extra fields which im guessing I would have to input manually.

Also If i would like to add a track to the page, example where a user clicks on the listen button. I wouldnt be able to link that one track as FLAM is more about making playlists.

Also my Database allows importing of CSV's but thanks!
This project is becoming daunting and it seems like im never going to be able to complete it.

HaLo2FrEeEk I was wondering if you have the time to explain a little more about the "ID" idea. That seems like its more fitting to what I would like to accomplish.

Thanks again for all your help.

Jun 6 '10 #10

HaLo2FrEeEk

404

Contributor

A few more things I'd like to touch on. It still looks like you're printing the player code for each individual track, when I click the little play icon for a song, it actually hides that track's player instead of making it visible.

You're also still forgetting to print your table row tag at the beginning of each track:

Expand|Select|Wrap|Line Numbers

 //        Audio Player Ends
 
echo "<tr>";

echo "<td align='center'>".$line['cue_code']."</td>";

...

You need to do that.

Other than that, looking good.

Jun 7 '10 #11

xkrazykidx

New Member

@HaLo2FrEeEk
Thanks Ill add the code when I get home, I think to better explain my issue is that I would like to display only 1 media player and when I click the play button it plays that table specific song. Im trying to finish this before friday...which is seeming impossible.

HaLo2FrEeEk you have been a great help so far thanks.

I am having a hard time passing the audiolocation to the audio player and making the player hidden so that when I click listen it displays the hidden player. Also if I click the next track to listen it should (Not hide the player) but just load up that track and play.

Edit: Made an advancement and changed my Code, hopefully this works. Im just having an issue with line 77.

Expand|Select|Wrap|Line Numbers

 <html>

<head>

<title>Test</title>

<script src="ac_quicktime.js" language="JavaScript" type="text/javascript"></script>

</head>

<body>
 
<script type="text/javascript"> 

function toggleDisplay(divID) {

  var obj = document.getElementById(divID);

  obj.style.visibility = "visible";

  if(obj.style.display == "none" ) {

    obj.style.display = "";

    } else {

    obj.style.display = "none";

    }

  }

</script> 
 
<?php

  mysql_connect("***", "***", "***") or die(mysql_error());

  echo "Connected to MySQL<br /><hr />";

 mysql_select_db("elixclot_music") or die(mysql_error());

  echo "Connected to Database<br /><hr />";

  $query = "SELECT * FROM tracks";
 
  $result = mysql_query($query) or die(mysql_error());

$line = mysql_fetch_array($result);

?>
 
<?php
 
$cue_id = $_GET['cue'];
 
if($cue_id == $line['cue_code'])

    {    

    $audioURL = $line['audiolocation'];

    return $audioURL;

    }
 
?>
 
     //        Audio Player Begins

echo "<div display='none' id='toggleMe' >

<OBJECT CLASSID='clsid:02BF25D5-8C17-4B23-BC80-D3488ABDDC6B' WIDTH='290' HEIGHT='20'

CODEBASE='http://www.apple.com/qtactivex/qtplugin.cab'>

<PARAM name='SRC' VALUE=".$line['cue_code'].">

<PARAM name='AUTOPLAY' VALUE='true'>

<PARAM name='CONTROLLER' VALUE='true'>

<EMBED src="<?php $audioURL; ?>" WIDTH='290' HEIGHT='20'

AUTOPLAY='false' CONTROLLER='true'

PLUGINSPAGE='http://www.apple.com/quicktime/download/'>

</EMBED>

</OBJECT>

</div>";

    //        Audio Player Ends
 
<table border="1" width="75%" cellpadding="2" cellspacing="2"> 

<tr> 

<td align="center">Cue Code</td> 

<td align="center">Cue Title</td> 

<td align="center">Cue Description</td> 

<td align="center">Time</td>

<td align="center"></td>

</tr> 

<br />
 
<?php
 
while($line) 

    {

echo "<td align='center'>".$line['cue_code']."</td>"; 

echo "<td align='center'>".$line['cue_title']."</td>"; 

echo "<td align='center'>".$line['cue_description']."</td>"; 

echo "<td align='center'>".$line['time']."</td>";

echo "<td align='center'><a href="<?php echo '?cue='.$line['cue_code']; ?>" onclick='toggleDisplay();'><img src='speaker_dark.gif' border=0></a>";

  echo "</tr>"; 

  }

 ?>

  </table>

   </body>

   </html>

Jun 7 '10 #12

Similar topics

2244

Handling 16-bit .WAV audio files

by: nigel | last post by:

I'm trying to handle 16-bit .WAV format audio files. I've started with the code below (from pythonapocrypha.com). I can successfully read in the 16-bit code, using Numeric.fromstring, as they...

Python

2579

Audio type

by: Shelly | last post by:

I had a problem with uploading images in that some files did not have a type of "image/something" from the $_FILES which I used for my verification. Someone (THANK YOU) suggested using...

PHP

1773

Audio Mixer

by: daniel123456 | last post by:

Hi, I'm searching for an audio mixer class that can change the balance o the lines too. I already found the AudioMixerHelper (e.g http://forums.hostrocket.com/archive/index.php/t-16820.html...

C# / C Sharp

2079

Playing Audio from a Filestream using MCI

by: Gidi Morris via .NET 247 | last post by:

Hi, Is there a way to play audio using MCI (I preffer MCI, but if you know of any others I'll be greatful) from a Filestream? I mean, I have a filestream to an audio file, can I play the audio?...

Visual Basic .NET

7830

sound capture (record audio input) in VB.NET????

by: positivebalance41m | last post by:

I have been searching how to do sound capture (record audio input) in VB.NET for days now. I find some references to "winmm.dll" calls, but they give VB5 or VB6 examples which won't code convert...

Visual Basic .NET

1981

Circular Audio Files

by: Quentin | last post by:

Hi, I want to save an audio stream into a circular file so that I only keep say the last hour's audio. Can anybody help? Cheers, Quentin

C# / C Sharp

2344

Java Audio Help Plz

by: mmc | last post by:

3 methods needs doing; wave1: This static method takes an AudioInputStream and gradually lowers and then raises the volume so that the new AudioInputStream appears to be constantly alerting in...

Java

11761

C++ reading database from the file into the array

by: ianenis.tiryaki | last post by:

well i got this assignment which i dont even have a clue what i am supposed to do. it is about reading me data from the file and load them into a parallel array here is the question: Step (1) ...

C / C++

2169

Audio responses to text found in textbox: VB 6.0

by: Dököll | last post by:

Greetings, Good buddies! I am for the first time, since I started learning VB, going to build an application I wanted to build for my first son, a language and activities program that will allow...

Visual Basic 4 / 5 / 6

7857

Soap Client : No deserializer defined for array type

by: ehsanch | last post by:

Hi i am writing a SOAP client, when using php 5 soap , it send this code and i get error : <?xml version="1.0" encoding="UTF-8"?> <SOAP-ENV:Envelope...

PHP

7037

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

7080

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

6735

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

6895

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

5326

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

2992

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

2977

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

558

php

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

176

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General