Re: Postgres and Web access - Mailing list pgsql-novice
From | Alan Nilsson |
---|---|
Subject | Re: Postgres and Web access |
Date | |
Msg-id | 04fb01c04b3a$f59f0640$5e22ca11@apple.com Whole thread Raw |
In response to | Postgres and Web access (Greg Thomas <gregt@WestgateSoftware.com>) |
List | pgsql-novice |
You can use the PHP scripting language that embeds directly into you web pages. It is very easy to use & quite powerful. I am new to all of this and I was just blown away how easy it was to create a dynamically loaded database driven page. Check it out at www.php.net The online manual provides step by step instuctions to the installation and integration with Apache. Also check out www.phpbuilder.com for additional tutorial info have fun! Alan Nilsson anilsson@apple.com How hard can it be? ----- Original Message ----- From: "Greg Thomas" <gregt@WestgateSoftware.com> To: <pgsql-novice@postgresql.org> Sent: Thursday, November 09, 2000 2:47 PM Subject: [NOVICE] Postgres and Web access > OK. I'm a bit overwhelmed over I think. > > I'm going to start out by saying I dont know Linux very well at all. > > Basicly, what I'd like to do is access the database from a web page. The > person hosting the database right now doesn't give me the control I need to > manipulate that database, and takes a while to do that changes himself, so > I've decided to host it all myself. (the database and web). > > I got Redhat 7.0 installed the other day. In the installation, it had the > options for postges, etc. I selected all the options to get that installed. > I also installed apache web server. At this point, I'm not absolutly > positive I have the JDBC stuff for postgres installed, even though I did > select the file in RH installation. How can I test this? > > This is where I'm a bit lost. I got the postmaster running and can create, > modify, etc the database fine. What do I need to do to connect the database > to the web server? I didn't see much on apache in the documents for > PostreSQL, so if theres a better recomended web server, I'd be happy to use > that. As I said, I'm just lost at this point. The thing that'd probably > help me the most would be just a list and order of things to install from > scratch. I kinda have an idea of what needs to be done, but no idea what > order to do it in, or what products to use. > > (i.e. 1- Install Linux, 2- Install apache web server, etc...) > > Thank you very much for your time and patients. > > Here is a sample of the jsp code I'm using for page that works from the > original server (made everything generic to save space...) to maybe give you > a better idea. > > <html> > <head> > <title>Test</title> > <%@ page import="java.util.*,java.sql.*" %> > </head> > <body> > > <% > Connection c = > DriverManager.getConnection("jdbc:postgresql://127.0.0.1/database_name","use > r","password"); > Statement s = c.createStatement(); > ResultSet resultset_name = s.executeQuery("select * from table;"); > %> > > Web Content > > <table> > <% > while(rs.next()){ > %> > > <tr><td> > > <%=resultset_name.getString("dababase_field")%> > > </td><tr> > > <% > } > s.close(); > rs.close(); > %> > > </table> > </BODY> > </HTML>
pgsql-novice by date: