KARAOKE SCENE MAGAZINE ONLINE! - My karaoke list on a www database...Help! Public Forums Karaoke Discussions Karaoke Scene's Karaoke Forums Home | Contact Us | Site Map  

Karaoke Forums

Karaoke Scene Karaoke Forums

Karaoke Scene

   
  * Login
  * Register

  * FAQ
  * Search

Custom Search

Social Networks


premium-member

Offsite Links


It is currently Wed Jan 15, 2025 11:44 pm

All times are UTC - 8 hours





Post new topic Reply to topic  [ 24 posts ]  Go to page 1, 2  Next
Author Message
PostPosted: Sat Apr 09, 2011 2:17 pm 
Offline
Super Plus Poster
Super Plus Poster
User avatar

Joined: Fri Jan 13, 2006 4:03 pm
Posts: 1921
Images: 1
Location: N. Central Iowa
Been Liked: 53 times
Ok, the other nite while hosting a show, a thought came to me.

I want a database of my karaoke and DJ songs online that people can search from their web enable phones.

Something simple to make it fast.
Something cheap.

I setup 2 sub domains.....
http://KJ.sskaraoke.com
&
http://DJ.sskaraoke.com

to hold the 2 lists.


I though first just to put a text file, but scrolling through the songs on a phone would take to long.

The I though have a simple HTML file with markers to go alphabetical to A,B, & C thru Z and return to top, but that would take too long to redo if I updated songs list.

So in a perfect world, just a search box on the index page, and then after you typed in "Kid Rock", it would show all songs (files) with kid rock in them whether it was in artist or song title with a database/excel file that is actually searched.

Looking on the WEB it can be done, but most things I find are WAY TO EXPENSIVE, or I cant get the JAVA script working to do it.

HELP!!!!!!

Tony ya out there?


Top
 Profile Personal album Singer's Showcase Profile 
 
PostPosted: Sat Apr 09, 2011 2:50 pm 
Offline
webmaster
webmaster
User avatar

Joined: Sun Jul 01, 2001 4:00 am
Posts: 2807
Images: 36
Location: Anaheim, Orange County, CA
Been Liked: 122 times
hmmm...

It can be done. I can create a db - to function as you need - If you already have an excel spreadsheet I could develop a structure from that - then create a method to search and display results.

You have a site is it on a Linux server? Do you have php capabilities and MySQL db?

How soon and what's your budget?

Currently, bustin' a hump working on here... LOL

_________________
Phill Cross
Webmaster, Host Provider & Part-Time “Technical” Problem Solver

KJ / MC
Image

services provided by:
CROSS WEB TECH


Top
 Profile Personal album Singer's Showcase Profile 
 
PostPosted: Sat Apr 09, 2011 3:14 pm 
Offline
Super Poster
Super Poster
User avatar

Joined: Thu Aug 05, 2010 1:40 pm
Posts: 1052
Images: 1
Been Liked: 204 times
I have found that the easiest is to post a pdf file of my song list on my site. Users can view it in a browser or save the file for use on any smartphone that can read pdf's.

Pdf's have inherent text search-ability and you can add an index tab to make moving through alphabetical sections easier.

_________________
Never the same show twice!


Top
 Profile Personal album Singer's Showcase Profile 
 
PostPosted: Sat Apr 09, 2011 4:05 pm 
Offline
Super Poster
Super Poster
User avatar

Joined: Sun Nov 14, 2010 7:10 pm
Posts: 933
Location: Twin Lake, MI
Been Liked: 59 times
You can post them on my website. www.whattosing.com.

It is still under construction, but functional. No charge btw.

_________________
I'm not a cheerleader, but I paid for my pom poms with my own money!


Top
 Profile Singer's Showcase Profile 
 
PostPosted: Sat Apr 09, 2011 5:46 pm 
Offline
Super Poster
Super Poster
User avatar

Joined: Tue Jun 08, 2004 11:15 am
Posts: 907
Location: San Jose CA
Been Liked: 33 times
Try google docs (spreadsheet)

PDF's are nice too.

_________________
Living my life as Robert Cortese, 162 E. Jackson St, San Jose CA.

It's like the difference between high and low budget toilet paper, it really doesn't matter in the end. -exweedfarmer

Which is smarter? Just sticking to making/selling karaoke, while people all over the world create software FOR FREE that helps you sell it, or trying to compete with them and keeping it a closed loop while you blow your money into an industry (software) that you(the karaoke manu) knows nothing about?
-me


Top
 Profile Singer's Showcase Profile 
 
PostPosted: Sat Apr 09, 2011 7:55 pm 
Offline
Extreme Plus Poster
Extreme Plus Poster
User avatar

Joined: Tue Apr 04, 2006 9:24 pm
Posts: 5576
Location: Cocoa Beach
Been Liked: 122 times
I have something which I just whipped up. I will be ready to show it before long -- I did the first incantation for one of our members and would like to show him before I show others. But basically, it allows you to search-as-you-type through a song database, give singers a way to make requests via smartphone, search on the web, etc. etc.

I should post something here in a few days.

_________________
[color=#ffff55]Mickey J.[/color]
Alas for those who never sing, but die with all their music in them.
-- Oliver Wendell Holmes, Sr.


Top
 Profile Singer's Showcase Profile 
 
PostPosted: Sat Apr 09, 2011 8:49 pm 
Offline
Extreme Poster
Extreme Poster
User avatar

Joined: Sun Jul 30, 2006 7:24 pm
Posts: 4466
Been Liked: 1052 times
I also have a pdf file on my website. Works out great.

_________________
Electro-Voice Evolve 50... Taking Sound To The Next Level.


Top
 Profile Singer's Showcase Profile 
 
PostPosted: Sun Apr 10, 2011 7:00 am 
Offline
Super Plus Poster
Super Plus Poster
User avatar

Joined: Fri Jan 13, 2006 4:03 pm
Posts: 1921
Images: 1
Location: N. Central Iowa
Been Liked: 53 times
mckyj57 wrote:
I have something which I just whipped up. I will be ready to show it before long -- I did the first incantation for one of our members and would like to show him before I show others. But basically, it allows you to search-as-you-type through a song database, give singers a way to make requests via smartphone, search on the web, etc. etc.

I should post something here in a few days.


That's what I am looking for.


For all others that posted.....
I already tested PDF, but some ppls phones couldn't handle it

Phil.....NO PHP or SQL on my web host (tripod). I should change but it is cheap. And I have a VERY TINNY budget.

Also tried GOOGLE docs with a Gadget, but then ya still have to scroll. This was cool, but no search function.


Troy....cool site, might give it a try, but would like it to fit on mobile phone, and be linked directly thru my www site. SO that is a possibility.


Top
 Profile Personal album Singer's Showcase Profile 
 
PostPosted: Sun Apr 10, 2011 8:39 am 
Offline
Extreme Plus Poster
Extreme Plus Poster
User avatar

Joined: Tue Apr 04, 2006 9:24 pm
Posts: 5576
Location: Cocoa Beach
Been Liked: 122 times
twansenne wrote:
mckyj57 wrote:
I have something which I just whipped up. I will be ready to show it before long -- I did the first incantation for one of our members and would like to show him before I show others. But basically, it allows you to search-as-you-type through a song database, give singers a way to make requests via smartphone, search on the web, etc. etc.

I should post something here in a few days.


That's what I am looking for.


For all others that posted.....
I already tested PDF, but some ppls phones couldn't handle it

Phil.....NO PHP or SQL on my web host (tripod). I should change but it is cheap. And I have a VERY TINNY budget.

Also tried GOOGLE docs with a Gadget, but then ya still have to scroll. This was cool, but no search function.


Troy....cool site, might give it a try, but would like it to fit on mobile phone, and be linked directly thru my www site. SO that is a possibility.

Bear in mind that mobile phone != smart phone. I have no intention of supporting WML and WSCRIPT, only HTML and JScript. It will work on ioS/iPhone, Android, and Windows Mobile, and anything else like that. Not on first-generation "smart" phones that only accept text/vnd.wap.wml.

Mine will be a hosted application. If traffic remains low, it will probably be "send me something via paypal if you have a mind to". If I start getting dozens of users, then I'll probably charge $60.00 per year. That will give you a virtual web site as well as a songbook.

Eventually I plan on delivering printed Songbooks from the same database, and possibly some limited mail show-announcement functionality for users who sign up with you.

_________________
[color=#ffff55]Mickey J.[/color]
Alas for those who never sing, but die with all their music in them.
-- Oliver Wendell Holmes, Sr.


Top
 Profile Singer's Showcase Profile 
 
PostPosted: Mon Apr 11, 2011 5:06 am 
Offline
Extreme Poster
Extreme Poster
User avatar

Joined: Mon Dec 20, 2004 10:09 am
Posts: 3341
Location: Tampa Bay, FL
Been Liked: 445 times
FastTracks will publish a website database automatically. What is your songbook software?

_________________
C Mc
KJ, FL


Top
 Profile Singer's Showcase Profile 
 
PostPosted: Mon Apr 11, 2011 7:24 am 
Offline
Extreme Plus Poster
Extreme Plus Poster
User avatar

Joined: Tue Apr 04, 2006 9:24 pm
Posts: 5576
Location: Cocoa Beach
Been Liked: 122 times
TopherM wrote:
FastTracks will publish a website database automatically. What is your songbook software?

Creating the database (read: spreadsheet) never seems to be the problem. It's what you do with it once you get it.

_________________
[color=#ffff55]Mickey J.[/color]
Alas for those who never sing, but die with all their music in them.
-- Oliver Wendell Holmes, Sr.


Top
 Profile Singer's Showcase Profile 
 
PostPosted: Mon Apr 11, 2011 12:51 pm 
Offline
Extreme Plus Poster
Extreme Plus Poster
User avatar

Joined: Tue Apr 04, 2006 9:24 pm
Posts: 5576
Location: Cocoa Beach
Been Liked: 122 times
OK, here's my book using my facility:

http://www.inkaraoke.com/k/m/mickey

Derived from a three-column table:

title artist diskid

You can add a fourth column called book_number if you wish. This is only used when the singer sends a request. (Allows you to plug in a CAVS or Hoster ID.)

_________________
[color=#ffff55]Mickey J.[/color]
Alas for those who never sing, but die with all their music in them.
-- Oliver Wendell Holmes, Sr.


Top
 Profile Singer's Showcase Profile 
 
PostPosted: Mon Apr 11, 2011 1:10 pm 
Offline
Super Extreme Poster
Super Extreme Poster
User avatar

Joined: Mon Dec 10, 2001 3:57 pm
Posts: 22978
Songs: 35
Images: 3
Location: Tacoma, WA
Been Liked: 2126 times
This rocks Mickey! Beatifully written! And free to boot (for now anyway!!! :D )

_________________
LIKE Lonman on Facebook - Lonman Productions Karaoke & my main site via my profile!
Image


Top
 Profile Personal album Singer's Showcase Profile 
 
PostPosted: Mon Apr 11, 2011 2:16 pm 
Offline
Super Plus Poster
Super Plus Poster
User avatar

Joined: Fri Jan 13, 2006 4:03 pm
Posts: 1921
Images: 1
Location: N. Central Iowa
Been Liked: 53 times
TopherM wrote:
FastTracks will publish a website database automatically. What is your songbook software?


No song book software, just grab file names and dump them into a spread sheet (with some formatting of the spreadsheet)


Top
 Profile Personal album Singer's Showcase Profile 
 
PostPosted: Mon Apr 11, 2011 2:18 pm 
Offline
Super Plus Poster
Super Plus Poster
User avatar

Joined: Fri Jan 13, 2006 4:03 pm
Posts: 1921
Images: 1
Location: N. Central Iowa
Been Liked: 53 times
mckyj57 wrote:
OK, here's my book using my facility:

http://www.inkaraoke.com/k/m/mickey

Derived from a three-column table:

title artist diskid

You can add a fourth column called book_number if you wish. This is only used when the singer sends a request. (Allows you to plug in a CAVS or Hoster ID.)


OK, gonna give it a try when I get some free time. Perhaps this weekend.

I assume if I have ppl go to http://dj.sskaraoke.com I can just redirect them to you site?


Top
 Profile Personal album Singer's Showcase Profile 
 
PostPosted: Mon Apr 11, 2011 2:27 pm 
Offline
Super Extreme Poster
Super Extreme Poster
User avatar

Joined: Mon Dec 10, 2001 3:57 pm
Posts: 22978
Songs: 35
Images: 3
Location: Tacoma, WA
Been Liked: 2126 times
twansenne wrote:
mckyj57 wrote:
OK, here's my book using my facility:

http://www.inkaraoke.com/k/m/mickey

Derived from a three-column table:

title artist diskid

You can add a fourth column called book_number if you wish. This is only used when the singer sends a request. (Allows you to plug in a CAVS or Hoster ID.)


OK, gonna give it a try when I get some free time. Perhaps this weekend.

I assume if I have ppl go to http://dj.sskaraoke.com I can just redirect them to you site?

Nothing comes up on your current site except a 'test' line. Is it supposed to at least have a list?

_________________
LIKE Lonman on Facebook - Lonman Productions Karaoke & my main site via my profile!
Image


Top
 Profile Personal album Singer's Showcase Profile 
 
PostPosted: Mon Apr 11, 2011 3:04 pm 
Offline
Super Plus Poster
Super Plus Poster
User avatar

Joined: Fri Jan 13, 2006 4:03 pm
Posts: 1921
Images: 1
Location: N. Central Iowa
Been Liked: 53 times
No list yet LON just doing some testing.....

http://dj.sskaraoke.com/test.html
This is a Google docs spread sheet with a Google Table Gadget on the website. I like the idea of this, but no search functions on the Gadget.


Top
 Profile Personal album Singer's Showcase Profile 
 
PostPosted: Mon Apr 11, 2011 4:30 pm 
Offline
Extreme Plus Poster
Extreme Plus Poster
User avatar

Joined: Tue Apr 04, 2006 9:24 pm
Posts: 5576
Location: Cocoa Beach
Been Liked: 122 times
I'll be working next week on providing a few things:

1. Upload of new song database
2. Management to take old database off line and put new one on line.
3. Better smart phone template.
4. A default account setting so I can give out some blank accounts and let people upload their song database, change their page template, and tinker with their settings.

_________________
[color=#ffff55]Mickey J.[/color]
Alas for those who never sing, but die with all their music in them.
-- Oliver Wendell Holmes, Sr.


Top
 Profile Singer's Showcase Profile 
 
PostPosted: Mon Apr 11, 2011 5:19 pm 
Offline
Super Plus Poster
Super Plus Poster
User avatar

Joined: Fri Jan 13, 2006 4:03 pm
Posts: 1921
Images: 1
Location: N. Central Iowa
Been Liked: 53 times
twansenne wrote:
No list yet LON just doing some testing.....

http://dj.sskaraoke.com/test.html
This is a Google docs spread sheet with a Google Table Gadget on the website. I like the idea of this, but no search functions on the Gadget.

Liking #4

Will it be possible to have 2 list?
One for DJ songs, one for Karaoke Songs.

I'd even donate to the cause for that!


Top
 Profile Personal album Singer's Showcase Profile 
 
PostPosted: Mon Apr 11, 2011 5:35 pm 
Offline
Extreme Plus Poster
Extreme Plus Poster
User avatar

Joined: Tue Apr 04, 2006 9:24 pm
Posts: 5576
Location: Cocoa Beach
Been Liked: 122 times
twansenne wrote:
twansenne wrote:
No list yet LON just doing some testing.....

http://dj.sskaraoke.com/test.html
This is a Google docs spread sheet with a Google Table Gadget on the website. I like the idea of this, but no search functions on the Gadget.

Liking #4

Will it be possible to have 2 list?
One for DJ songs, one for Karaoke Songs.

I'd even donate to the cause for that!

You would just use two accounts, I guess....

_________________
[color=#ffff55]Mickey J.[/color]
Alas for those who never sing, but die with all their music in them.
-- Oliver Wendell Holmes, Sr.


Top
 Profile Singer's Showcase Profile 
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 24 posts ]  Go to page 1, 2  Next

All times are UTC - 8 hours


Who is online

Users browsing this forum: No registered users and 284 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Powered by phpBB® Forum Software © phpBB Group

Privacy Policy | Anti-Spam Policy | Acceptable Use Policy Copyright © Karaoke Scene Magazine
design & hosting by Cross Web Tech