Menu
Community /Pin to ProfileBookmark
@NogDogMay 05.2008 — #It does not sound like anything abnormal, and therefore should be do-able with any of the popular web languages and DBMS's. Unless the target platform dictates what language/DBMS you can use, you choice might depend on what languages you are used to. If you've worked with C, Perl, or other similar "C-like" syntax languages, you'll probably pick up PHP pretty quickly. That along with its widespread availability would make it a good choice then. If you're more of a Java person, perhaps you should look into JSP; and if a M$ coder then the .NET platform on a Windows server might be your path of least resistance.
If you go the PHP route, it has native support for many DBMS's, with MySQL being probably the most used. If you define your table in MySQL using the MyISAM engine, you can use the[url=http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html]full text search functions[/url] , which might be beneficial for your #2 search requirement.
What technology for simple db webpage
I’m a programmer with 2 decades of software writing skills.
I have virtually no experience of web development but wan’t to move into
this area. I have a simple requirement and am not sure what technology to use.
I’ve put this message in the php forum as I think that might be the route to go but I’m open to other suggestions.
Here is a simple spec of what I want:
I have a simple database with one table with a list of parts.
The fields are something like:
PartNo
Description1
Description2
Make
Model
(It’s currently in MS access but could be transferred)
I want to end up with a webpage from which I can do a couple of
simple searches:
(1) Allow selecting Make and then Model in dropdwon boxes
which will trigger listing all parts for that Make and/or Model
(2) Allow typing in one or two text words
which will trigger searching all 5 fields for the words and
displaying a list of relevant parts
I’ve designed an interface in Access but it’s obviously not running on a web server and doesn’t have a web interface.
Any suggestions as to a simple technology for doing this.
MySQL & php?
Or is there a higher level application where I could just design the tables
more visually and the webpage look would be created for me?
Any ideas would be appreciated
Thanks in advance
Suhada
Sign in
to post a comment1 Comments(s) ↴
0
@NogDogMay 05.2008 — #It does not sound like anything abnormal, and therefore should be do-able with any of the popular web languages and DBMS's. Unless the target platform dictates what language/DBMS you can use, you choice might depend on what languages you are used to. If you've worked with C, Perl, or other similar "C-like" syntax languages, you'll probably pick up PHP pretty quickly. That along with its widespread availability would make it a good choice then. If you're more of a Java person, perhaps you should look into JSP; and if a M$ coder then the .NET platform on a Windows server might be your path of least resistance.If you go the PHP route, it has native support for many DBMS's, with MySQL being probably the most used. If you define your table in MySQL using the MyISAM engine, you can use the