Skip to main content
M
MooskirchnerQuintett
Known Participant
March 10, 2009
Question

mp3 and url problem

  • March 10, 2009
  • 4 replies
  • 539 views
Hi everyone!

I have searched here on this forum, but I haven´t found a solutions for my two problems or
I haven˝t searched properly.

My first problem is with mp3 files. I have created a mysql database for my mp3 files
like this: id (int), date (date), content (varchar), file (varchar) and now my problem is
how to set up the page so the file loads on the page and the user
can be listend to it.

My second problem is with url. I have created a image gallery for my banners on the site.
My SQL table is setup like this: id (int), client (varchar), banner (varchar), link (varchar), startingdate (date) and
endingdate (date). I would like to setup is like this: if an user clicks on the banner it will take him to the
clients site.

I thank everyone in advance for any tips I can get to solve my two problems.


This topic has been closed for replies.

4 replies

DwFAQ
DwFAQ
Participating Frequently
March 18, 2009
Heya,

For banners it's pretty much the same concept as previously described; create a recordset then link bindings to the page. So link to banner should look something like the following with bindings where indicated:

<a href="banner_url_binding"><img src="banner_image_binding" alt="banner" /></a>

Hope that helps!
M
MooskirchnerQuintettAuthor
Known Participant
March 17, 2009
DWFAQ.info I need a little more help.

I have worked out with the mp3 files, but I can´t figure out with the banners. I have done the same thing, but when the your clicks on the banner it opens a blank page. How do I set up the linked page that is shows the site of the customer when the user clicks it.

I thank you again in advance.
DwFAQ
DwFAQ
Participating Frequently
March 11, 2009
Heya,

You wrote:
"How should it look like in the Recordset window.
Filter : _________(I wrote ID) = (or should I choose something else)
Url Parameter - _________________(I wrote File)"


It should look like this:

Filter:__________ id
(id lowercase is the primary key auto increment integer for your item you create a DB table field for as described in your original post.)

=

URL Parameter:_________ id (or whatever name you want)


Then place dynamic info into page by dragging table field from Binding Window onto page as described in earlier post. Then when you visit your_page.php?id=3 you will see table info placed from binding tab where id = 3. 4 for 4, 5 for 5, etc. If you put something else like File in URL parameter filter then visiting your_page.php?File=3 will show info from table placed in page from binding tab where primary key id = 3 etc.

That should be more than enough information to get you on your way!


M
MooskirchnerQuintettAuthor
Known Participant
March 12, 2009
quote:
Originally posted by: DWFAQ.info
Heya,

You wrote:
"How should it look like in the Recordset window.
Filter : _________(I wrote ID) = (or should I choose something else)
Url Parameter - _________________(I wrote File)"


It should look like this:

Filter:__________ id
(id lowercase is the primary key auto increment integer for your item you create a DB table field for as described in your original post.)

=

URL Parameter:_________ id (or whatever name you want)


Then place dynamic info into page by dragging table field from Binding Window onto page as described in earlier post. Then when you visit your_page.php?id=3 you will see table info placed from binding tab where id = 3. 4 for 4, 5 for 5, etc. If you put something else like File in URL parameter filter then visiting your_page.php?File=3 will show info from table placed in page from binding tab where primary key id = 3 etc.

That should be more than enough information to get you on your way!




Thank you DWFAQ.info for the HELP! it´s working now.
DwFAQ
DwFAQ
Participating Frequently
March 10, 2009
Heya,

Pretty much same solution for both. Create a recordset for table then filter id from URL parameter so when user visits page.php?id=2 they have content from DB table with id 2 displayed on page. Place content from filtered recordset onto page by dragging from bindings tab.

Basically it's all about creating recordsets and placing the bindings onto the page.

Hope that helps!
M
MooskirchnerQuintettAuthor
Known Participant
March 10, 2009
quote:
Originally posted by: DWFAQ.info
Heya,

Pretty much same solution for both. Create a recordset for table then filter id from URL parameter so when user visits page.php?id=2 they have content from DB table with id 2 displayed on page. Place content from filtered recordset onto page by dragging from bindings tab.

Basically it's all about creating recordsets and placing the bindings onto the page.

Hope that helps!


I tried, but I couldn´t get it right. I am totally new to this kind of developing and could you please guide me to get this right.
How should it look like ni the Recordset window.
Filter : _________(I wrote ID) = (or should I choose something else)
Url Parameter - _________________(I wrote File)

How do I then connect the folder audio where my audio files are placed.

Thank for your help if you decide to help me.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices