June 24, 200818 yr I am a newbie dreamweaver user, limited knowledge but enough to create a good html site. I need to know the best approach to take with a new site I am designing. Essentially the site will only contain about 5 pages but will have a search field where people can search information I currently have in a large spreadsheet. I want them to also be able to navigate there way around this information as well with some kind of explorer. Basically I just need to do this the easiest way possible, I am a windows admin with no linux\database knowledge etc. What is the quickest and easiest way to get the information in my very large spreadsheet onto my website please? Any direction would be much appreciated?
June 24, 200818 yr Welcome to WDF! You'll need to get your data into a database first, then have a script to perfrom queries on the database (the search), and then outpout the results to a web page. What sort of information is it? How much is there (how many records)? How do you envisage that people would search, ie by keyword or a set of parameters?
June 25, 200818 yr Author Welcome to WDF! You'll need to get your data into a database first, then have a script to perfrom queries on the database (the search), and then outpout the results to a web page. What sort of information is it? How much is there (how many records)? How do you envisage that people would search, ie by keyword or a set of parameters? Thanks for the response. It is essentially a spreadsheet listing different training courses in the UK, with locations, prices, days etc. Around 2000 rows. People will be able to search by either keyword or by narrowing down courses by choosing the parameters. I have setup an apache\mysql\php server and use Dreamweaver CS3, do you have any advice as to where I can quickley bring my knowledge up to speed to create something?
June 25, 200818 yr If you want a quick fix database/search utility have a look at http://www.ezscripting.com/ - it's a set of perl scripts that allow you to write, read and search a text file database, and it's got loads of configurable options like searching by any field, dates etc. It's saved my neck more than once and they really work well. You could do it in php/mysql but you'd need a small custom script written to query the database and show the results.
June 26, 200818 yr Author If you want a quick fix database/search utility have a look at http://www.ezscripting.com/ - it's a set of perl scripts that allow you to write, read and search a text file database, and it's got loads of configurable options like searching by any field, dates etc. It's saved my neck more than once and they really work well. You could do it in php/mysql but you'd need a small custom script written to query the database and show the results. thanks for the reply I will take a look.
Create an account or sign in to comment