Thread: anyone can help?
Hi: I just graduated from univ. and got my first job. then I was just asked to do something I really don't know how to do it. anyone can help? my boos wanted me to build an interface to put ou the web page to serve our customers. it's simple, the database is already there, there's products' detail,manufacturers' detail and price plus products' picture. my boss just want me to create a window (maybe java? or can I write a VB program?), use three combo-boxes to let customers chose from product model, manufactures and price range. then clike a button and the picture and the detail will show in a textarea. but I don't know how to write the SQL, anyone can help? p.s: for example, when customers first choose product, the price and manufactures list box will show only math records. vice versa.
There are many ways to go about this- here are a couple: Our company uses Postgresql,JDBC and Tomcat to accomplish this sort of task. It's an industrial-strength approach that scales up and maintains well, but involves a lot of learning for a simple application. I'd recommend it if it seems like the boss will want to expand the web offering. For a quicker approach, PHP might be a pretty good solution for a simple application. I've not used PHP much, but it appears to be more suited to rapid development and I think you'll find good support for it in the Postgresql community. We only chose not to use it because we didn't think it would scale up well. (But I'm sure that making this assertion will elicit many opinions to the contrary.) What platform does it need to run on? -Nick -------------------------------------------------------------------------- Nick Fankhauser nickf@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ > -----Original Message----- > From: pgsql-sql-owner@postgresql.org > [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Melisa > Sent: Friday, December 07, 2001 1:05 AM > To: pgsql-sql@postgresql.org > Subject: [SQL] anyone can help? > > > Hi: > I just graduated from univ. and got my first job. then I was just > asked to do something I really don't know how to do it. anyone can > help? > > my boos wanted me to build an interface to put ou the web page to > serve our customers. it's simple, the database is already there, > there's products' detail,manufacturers' detail and price plus > products' picture. my boss just want me to create a window (maybe > java? or can I write a VB program?), use three combo-boxes to let > customers chose from product model, manufactures and price range. then > clike a button and the picture and the detail will show in a textarea. > but I don't know how to write the SQL, anyone can help? > > p.s: for example, when customers first choose product, the price and > manufactures list box will show only math records. vice versa. > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >
On Thu, Dec 06, 2001 at 10:05:03PM -0800, Melisa wrote: > asked to do something I really don't know how to do it. anyone can > help? We can give you pointers. > my boos wanted me to build an interface to put ou the web page to > serve our customers. it's simple, the database is already there, > there's products' detail,manufacturers' detail and price plus > products' picture. my boss just want me to create a window (maybe > java? or can I write a VB program?), use three combo-boxes to let Java, VB, PHP, Tcl, Python, Perl, etc. depends mostly on the web server you are running. I'd stay away from Java since your need is very simple and doesn't justify the added complexity that Java brings (from what you've told us). > customers chose from product model, manufactures and price range. then > clike a button and the picture and the detail will show in a textarea. > but I don't know how to write the SQL, anyone can help? > > p.s: for example, when customers first choose product, the price and > manufactures list box will show only math records. vice versa. This is pretty simple to do. But everything, from the client language to the SQL (to some extent) will depend on your server environment. What web server? what database server? What languages do you have available? There are several tutorials to do this kind of thing. Stay away from the MySQL-type tutorials (usually written by idiots) and you should be safe. -Roberto -- +----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Developer WHeRe is ThaT DArN ShIfT keY?
If I read this correctly it sounds as if you are asking about which web development toolset you should use. Unfortunately for you there is almost an unlimited set of tools that are compatible with PostgreSQL. Chances are good that whatever language you are currently most comfortable with has a web technology or two that will happily read data from PostgreSQL. That being said, if this is your first foray into web development I would suggest PHP. I personally do most of my work in Zope nowadays, but it is hard to beat PHP for simple web applications. It's easy to use, it runs everywhere, it has a very supportive user community, and oustanding documentation. Jason lin_melisa@hotmail.com (Melisa) writes: > Hi: > I just graduated from univ. and got my first job. then I was just > asked to do something I really don't know how to do it. anyone can > help? > > my boos wanted me to build an interface to put ou the web page to > serve our customers. it's simple, the database is already there, > there's products' detail,manufacturers' detail and price plus > products' picture. my boss just want me to create a window (maybe > java? or can I write a VB program?), use three combo-boxes to let > customers chose from product model, manufactures and price range. then > clike a button and the picture and the detail will show in a textarea. > but I don't know how to write the SQL, anyone can help? > > p.s: for example, when customers first choose product, the price and > manufactures list box will show only math records. vice versa. > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)