Log in

View Full Version : Database Driven Website On Flash Drive (32mb)



dailytool
08-19-2008, 03:56 PM
I have a database of 18,000 Baby Names in Comma Delimited format. Here is an example of my database:

[Name],[Category],[Gender],[Meaning],[Origin]
"Ginger","Floral","F","Pure","Latin"
"Hazel","Floral","F","Hazelnut","Old English"
"Heath","Floral","M","A heath or a moor","Old English"
"Heather","Floral","F","Flower","Old English"
"Holly","Floral","F","To prick","Old English"

I want to build a mobile website on a 32mb flash drive keychain that shows the baby names and be searchable by category, gender, origin, etc. It needs to work on both a PC or a Mac just like the internet. Additionally, I would like to have a 'My Favorites' where the user can save a list of favorite names to the flash drive.

I thought this would be easy since i've built many websites, but i've been trying to figure out a way to do this forever!

It has to be on a small flashdrive so installing a mobile server seems rediculous. I noticed that this script:

http://www.dynamicdrive.com/dynamicindex17/featuredcontentslider.htm

will call info from a .txt doc. Can this be utilized in my application?

Please help. Any information or ideas are so highly appreciated!

David

dailytool
08-20-2008, 02:03 AM
I have a database of 18,000 Baby Names

Any Ideas Anyone????

Master_script_maker
08-20-2008, 05:23 PM
you would need php so i suggest you look at this (http://www.firepages.com.au/php_usb.htm). next you might want to add all of your names to a mysql database; you could do this using a php script or if you have no life ;), manually. After that you would need a php script to do mysql functions and display all of your names in a sortable searchable table. Since there are a lot of names and a whole server you might need a bigger flash drive. Also, i think this (http://www.dynamicdrive.com/forums/showthread.php?t=35116) script would be very useful to you.

dailytool
08-21-2008, 05:50 AM
Thanks so much for replying...

If you look at the last section at the bottom of this page (http://www.firepages.com.au/php_usb.htm#start.bat), you will see that unfortunately, this isn't plug and play. The server and mysql both have to be turned on before i could run the database through php. Which causes problems because just anyone would not be able to figure it out.

This all started when I had a worthless programmer write a program in Delphi. He said it would work on any PC which it doesn't. He said Delphi was standalone which it doesn't seem to be. Additionally, he did a terrible job. lol I would go that route if it could be done properly. It just wouldn't work on a Mac (which isn't the end of the world).

Ideally, php and mysql are the way to go. I just can't figure out how to do it where it's user friendly...

Any ideas?

Thanks again!

Master_script_maker
08-21-2008, 03:33 PM
I found what seams to be an easier program here. (http://portablewebap.com/)