PDA

View Full Version : Database Query... Novice Alert...No Idea Where to Turn...


lax828
12-18-2006, 08:57 PM
Hello,

I'm creating a website for a student organization at my university. Basically, I have an Excel file with a list of contacts that the members of our organization need to be able to search on our website.

The only field that I need our members to be able to search is "contact location." So for example, a member might want to know if our organization has any contacts in Spain, so the member would type "spain" into the "contact location search" field" and would get results.

I really don't known where to turn... I need the easiest thing that would be manageable for a novice. It doesn't need to be an intense search function; just something to make the website functional (so it obviously needs to be uploadable to a server; the server has PHP capability...no idea if that has any relevance). I've been searching around all day and have come across potentials like PHP, SQL, XML, etc. but have no idea which way to turn... I have Office and Adobe Studio programs at my disposal.

Thank you all-powerful and all-knowing web gods! I owe you my deepest gratitude!

Mikey :confused:

davidj
12-18-2006, 09:57 PM
your going to need PHP and there is no better way to learn than to follow our tutorials

www.dreamweaverclub.com/vtm/ (http://www.dreamweaverclub.com/vtm/)

once you have covered those basics we will be able to look at your requirements more closely

its no good me posting a script coz you wont know how to use it

welcome to the forum lax

keratos
12-21-2006, 12:43 PM
It is possible to achive this relatively straight forward using an ASPX server app and appropriate control (e.g. form). It can be done using ASP although a little more involved.

If the above doesn't make sense then I agree with David, you need to learn the basics of ASPX and how to create data connections. The Macromedia help has a tutorial on the basics. Takes about a day to fully grasp so that you are up and running, creating your own. The link David gave is a good pointer although personally I find PHP quite clunky, but that's my view and a matter of personal choice.

davidj
12-21-2006, 02:22 PM
in my opinion your better off with PHP

when you come to host your application it will be allot cheaper also we will be able to help with problems regarding PHP

i reckon there is more of an uptake of php

to be fair though i do think .net commands a higher salary

keratos
12-22-2006, 12:21 PM
I work within the S/W division here at a large Baesystems site. We do not have any PHP engineers. All ours are .NET capable (that accounts for circa 50%), Oracle/SQL (30%), and VBA/Access (20%). No PHP! So here at least, you wouldn't get a penny in Salary!

But I have to conceed that PHP popularity is evident - perhaps the open source nature (free) is a contributory factor.

In business we need to be dealing with vendors who have a proven track record, offer a single "shop door" and backed up with sound technical customer focused support. PHP does not offer this.

domedia
12-22-2006, 04:41 PM
keratos, I hope you stick around, we need people with knowledge in ASP!

lux
12-22-2006, 06:24 PM
lax828

if you list the column headings in your excel file i'll put together the code with an explaination of how to complete it, using php/mysql

keratos
12-23-2006, 01:49 PM
One simple way is to create an ODBC connection (via control panel using MS odbc data source admin tool). The connection should use the xls driver and point to your workbook/sheet file.

Next, using DW GUI create a blank .NET ASP page. Add search form and controls (see DW Help - type "building a database search page").

Next add a data grid control and link it to the ODBC driver using the "Applications->Bindings" tab.

This is straight forwards, minimises the need to update code/script and can be readily and speedily modified using the GUI at a later date should you wish to change/enhance your search app.