| From: | "paul butler" <paul(at)entropia(dot)co(dot)uk> |
|---|---|
| To: | "Jill Jensen" <jill(dot)jensen(at)aisn(dot)net> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Database connection |
| Date: | 2003-01-29 10:09:02 |
| Message-ID: | 036da2111101d13PCOW058M@blueyonder.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Send reply to: <color><param>0000,0000,8000</param><<jill(dot)jensen(at)aisn(dot)net>
</color>From: <color><param>0000,0000,8000</param>"Jill Jensen" <<jill(dot)jensen(at)aisn(dot)net>
</color>To: <color><param>0000,0000,8000</param><<pgsql-novice(at)postgresql(dot)org>
<bold></color>Subject: <color><param>0000,0000,8000</param>[NOVICE] Database connection
</bold></color>Date sent: <color><param>0000,0000,8000</param>Sun, 26 Jan 2003 19:03:08 -0600
There's a php pg list somewhere for these questions, I've outlined
what I think is wrong below</color>
<color><param>7F00,0000,0000</param>> Hello:
>
> I cannot connect to my database::
>
> the code is this:
>
>
> <<html>
> <<body>
> <<?php
>
>
>
> $host = "localhost";
> $user = "srproject";
> $pass = "56364563";
> $db = "srproject";
>
> //open a connection to the database server
</color>Theres a space in $local host here, so $local host will evaluate to
something useless like "" or Null >>
<color><param>7F00,0000,0000</param>> $connection = pg_connect ("host=$local host dbname=$srproject
> user=$srproject password=$56364563");
</color>why are you redelaclaring the connection parameters here ?(and thanks to the above line $host will not evaluate usefully)>>
<color><param>7F00,0000,0000</param>> $connection = pg_connect ("host=$host dbname=$dbuser=$user
> password=$pass");
>
> if (!$connection)
> {
> die("Could not open connection to database server");
> }
>
> $query = "INSERT INTO student(firstname, lastname) VALUES ('jill',
> 'jensen')";
>
>
> if (!$result) {
> printf ("ERROR");
> $errormessage = pg_errormessage($db);
> echo $errormessage;
> exit;
> }
> printf ("These values were inserted into the database - %s %s",
> $firstname, $lastname); pg_close(); ?> <</body> <</html>
>
> -------------------------------------
>
> the error I get is this:
>
> Warning: pg_connect() unable to connect to PostgreSQL server: unknown
> host name: host in /home/srproject/webpage/action.php on line 13
>
> Warning: pg_connect() unable to connect to PostgreSQL server: could
> not connect to server: Connection refused Is the server running on
> host localhost and accepting TCP/IP connections on port 5432? in
> /home/srproject/webpage/action.php on line 15 Could not open
> connection to database server
>
> I have been assure that port 5432 is open for connections on the
> localhost, and that tcp/ip connections are accepted. Best regards,
>
> Jill Jensen, MCP
> Operations Manager
>
>
> jill(dot)jensen(at)aisn(dot)net
>
> AIS Network
> Internet Services Worldwide
>
> Office: 847. 202. 1400 x 27
> Fax: 847-202-4460
> Cell: 847. 530. 7845
>
>
>
> ---------------------------(end of
> broadcast)--------------------------- TIP 4: Don't 'kill -9' the
> postmaster
</color>HTH
Paul Butler
<nofill>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/enriched | 2.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | paul butler | 2003-01-29 10:15:39 | Re: Silly Question about varchar(n) |
| Previous Message | paul butler | 2003-01-29 10:03:31 | Re: Developing a forms based web application |