Re: [OSGeo-Discuss] Db connect
B43C413256517920E921413671E27214B43C413CD7823AE4E92141D85044EFCFB33C418A0E981F38EA21417927C696A4B33C41AF61EFFE77EA2141EF29D83C8EB33C41CA97218C8CEA21413283164F31B33C4169AC69F0A0EA2141F625561AD5B23C411A4A470FA8EA21410F944CF3B5B23C414BA7D40998EA21411DBE07EC4CB23C41A635F37484EA214114788B7AA6B13C41F50EDF6C86EA2141B0FFC68B48B13C41B061EFFE77EA2141885A20D7C0B03C4192DE8EC9EAEA2141C82C9083B4B03C4192DE8EC9EAEA21419B93777E5EAF3C41A91AF2F5E7EA2141B6764165C0AD3C41CD7
638BDE6E92141949CACA2C4AD3C4180853CFA97E72141980769BAE3AD3C41043DCC8AAAE62141D0D759471FAD3C41E4E4E8CCB1E52141DE9A40937FAC3C4101B1BDC62FE52141CEEE4E3403AC3C4123E84ED8CCE4214156B49E8D93AB3C41B74BD0C75BE421413B6A7B9818AB3C4108C26785E4E32141E1A3F6C491AA3C41366EC06BE5E22141E3EA00EBC5AA3C41778AC9E750E2214141AE89EFE5AA3C41A16A6638DCE12141233792CDFEAA3C41264BD8A023E12141DB758D0347AB3C414724CC778DE021415A92060289AB3C412A74E25822E021419E562065B7AB3C41994917679DDF2141AEC983A6F3AB3C412D02FE5E1ADF21412F81EB563CAC3C411523E055C3DE2141CC145C7765AC3C4145D448BC62DE2141AE9D64557EAC3C41FF0AD04FE8DD21417B4CAE338CAC3C4193C3B64765DD2141130F533EA1AC3C414358A6AFC2DC2141E4F37980BCAC3C4167CC883833DC21412282B67FDDAC3C41FB4B7D332CDB2141B913DD2F31AD3C41611A09C885DA21416B810C5065AD3C41EA305894DAD92141647FC2DF8FAD3C411773F199E8D821413D6B929BCCAD3C41F853381AECD72141BC870B9A0EAE3C41D818498362D72141BA84012E3EAE3C4121C75FDF45D72141F315A985FDAD3C412B335D0519D72141C47F2F13DEAD3C412B679D350E
D72141A272102DAAAD3C410684EB4B0CD72141C6EB51BF66AD3C419BD33E1F90D521419D97DA8764AD3C41B0C99AE9CFD42141701F142F6AAD3C41B89F13190ED52141AEE6CF973FAE3C41633D1621A4D42141FE08B56475AE3C41640509BEB1D421413FAE42ABE8AE3C416B9DE2D641D421411ACB90C1E6AE3C415223D61BE4D32141615B1731DDAE3C415720C1826DD32141C9987226C8AE3C4133D8FD4A72D32141C8C491773DAE3C419166EE6826D22141C629A3C536AE3C41DB6A0A662AD22141DCA1E293B6AC3C41137775C498D221418D3FC0B2BDAC3C419B6462BBD1D2214146587B66DDAB3C410A63B890FBD221416E7C4C6380AB3C41F93A3E29C1D32141E50F00B575AB3C4197FF82EBB2D32141823B65D8E2AA3C410BF6729B34D3214122D838D9E2AA3C417B5E11C6AFD22141FE9E328CE3AA3C412B1E1C0C75D221412FB8E1A2ECAA3C41E8BDCF1B44D2214171182E931DAB3C4111B461ACC0D12141B6815A5835AB3C41A8BCFA3359D12141835FCB6C45AB3C41665CAE4328D1214118B4B88547AB3C4188B78391EFD0214163651C8872AB3C4176A9319EACD02141582DF5B38FAB3C41DEE68C9397D02141E0E6A6D4ADAB3C41DDE68C9397D0214171A7016FEDAB3C412A1702D2ABD02141CB2E89746CAC3C4131B499E0BCD021413
2C186CDE1AC3C41FD6447CBC0D02141B8DDA8F84EAD3C416B1A9D54B4CF2141638BF39446AD3C41032336DC4CCF2141805425FD40AD3C41DF05D938FECE21413997B1EC41AD3C41F8AB0445D1CE214137FCC23A3BAD3C41476F537F5ECE21416E8356C03AAD3C415BDFA12724CE2141561B7CBA37AE3C419D9E5C8106CE21418DA20F4037AE3C41875A2D2AB6CD21413138CAD035AE3C41DF2425DE64CD214168BF5D5635AE3C4185EB5DC924CD2141F81548992FAE3C41
--- On Thu, 4/3/10, Dave Patton da...@confluence.org wrote:
From: Dave Patton da...@confluence.org
Subject: Re: [OSGeo-Discuss] Db connect
To: OSGeo Discussions discuss@lists.osgeo.org
Date: Thursday, 4 March, 2010, 6:43 AM
On 2010/03/02 7:01 PM, Ravi wrote:
Hi, am using OSGeo4W bundle and the apache and php
there in. Apache
installed OK showing as aservice and in the browser
http:\\localhost issues the OSGeo4w welcome screen and
phpthere on
with the following wish to connect to PGSQL 8.4 and
postGIS there in with the following. But it doesnt work.
Where am I going wrong ?
$db_handle = pg_connect(”host = localhost port =
5432 dbname =
postgis user = postgres password = GrassJump”);
$query = “SELECT *
FROM rjybound”; $result = pgexec($dbhandle,
$query);
Try something like this. (Not fully tested)
?
error_reporting(E_ALL);
$db_handle = pg_connect(host = localhost port = 5432
dbname = postgis user = postgres password = GrassJump);
if( $db_handle === FALSE ) {
echo 'Failed to connect';
} else {
$query = 'SELECT * FROM rjybound';
$result = pg_query($db_handle, $query);
if( $result === FALSE ) {
$error = pg_last_error($db_handle);
if( $error === FALSE ) {
echo 'Unable to determine last
error';
} else {
echo 'Last Error = ' . $error;
}
} else {
while ( $row = pg_fetch_row($result) ) {
echo Element 0: $row[0];
echo br /\n;
}
}
}
?
-- Dave Patton
CIS Canadian Information Systems
Victoria, B.C.
Degree Confluence Project:
Canadian Coordinator
Technical Coordinator
http://www.confluence.org/
Personal website:
Maps, GPS, etc.
http://members.shaw.ca/davepatton/
___
Discuss mailing list
Discuss@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/discuss
The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
http://in.yahoo.com/
___
Discuss mailing list
Discuss@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/discuss
--
Daniel Morissette
http://www.mapgears.com/
___
Discuss mailing list
Discuss@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/discuss
RE: [OSGeo-Discuss] Db connect
Hi Kumaran, ?php phpinfo(); (needs another ? before ;) ?php phpinfo()?; it is displaying what it should. Ravi Kumar --- On Wed, 3/3/10, Kumaran Narayanaswamy kumaran.narayanasw...@kcubeconsulting.com wrote: From: Kumaran Narayanaswamy kumaran.narayanasw...@kcubeconsulting.com Subject: RE: [OSGeo-Discuss] Db connect To: 'OSGeo Discussions' discuss@lists.osgeo.org Date: Wednesday, 3 March, 2010, 1:10 PM Dear Mr.Ravi Kumar, Are your PHP pages getting processed?.Just create a simple page with the below code and run to see if you get the PHP Environment information details. If you dont get the information then your PHP is not configured well. ?php phpinfo(); ? Regards Kumaran -Original Message- From: discuss-boun...@lists.osgeo.org [mailto:discuss-boun...@lists.osgeo.org] On Behalf Of Ravi Sent: Wednesday, March 03, 2010 12:16 PM To: OSGeo Discussions Cc: postgis Subject: Re: [OSGeo-Discuss] Db connect Hi, am trying to learn rendering maps using browser(shapefiles) no error is given from the browser, but it just displays $db_handle = pg_connect(”host = localhost port = 5432 dbname = postgis user = postgres password = GrassJump”); $query = “SELECT * FROM rjybound”; $result = pgexec($dbhandle, $query); Ravi Kumar --- On Wed, 3/3/10, Tyler Mitchell (OSGeo) tmitch...@osgeo.org wrote: From: Tyler Mitchell (OSGeo) tmitch...@osgeo.org Subject: Re: [OSGeo-Discuss] Db connect To: OSGeo Discussions discuss@lists.osgeo.org Date: Wednesday, 3 March, 2010, 8:56 AM Hi Ravi, what kind of error are you getting? Tyler Ravi wrote: Hi, am using OSGeo4W bundle and the apache and php there in. Apache installed OK showing as aservice and in the browser http:\\localhost issues the OSGeo4w welcome screen and phpthere on with the following wish to connect to PGSQL 8.4 and postGIS there in with the following. But it doesnt work. Where am I going wrong ? $db_handle = pg_connect(”host = localhost port = 5432 dbname = postgis user = postgres password = GrassJump”); $query = “SELECT * FROM rjybound”; $result = pgexec($dbhandle, $query); Ravi Kumar Your Mail works best with the New Yahoo Optimized IE8. Get it NOW! http://downloads.yahoo.com/in/internetexplorer/ ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/ ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/ ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss
Re: [OSGeo-Discuss] Db connect
Hi, even when $dbhandle is changed to $db_handle gives error Parse error: syntax error, unexpected '=' in C:\OSGeo4W\apache\htdocs\lu.php on line 2 Is using Vista Home is an issue Ravi Kumar --- On Wed, 3/3/10, Robert Hollingsworth r...@prodigy.net wrote: From: Robert Hollingsworth r...@prodigy.net Subject: Re: [OSGeo-Discuss] Db connect To: OSGeo Discussions discuss@lists.osgeo.org Date: Wednesday, 3 March, 2010, 12:51 PM is the missing '_' in $dbhandle below significant? REH Hi, am trying to learn rendering maps using browser(shapefiles) no error is given from the browser, but it just displays $db_handle = pg_connect(”host = localhost port = 5432 dbname = postgis user = postgres password = GrassJump”); $query = “SELECT * FROM rjybound”; $result = pgexec($dbhandle, $query); -Inline Attachment Follows- ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss Your Mail works best with the New Yahoo Optimized IE8. Get it NOW! http://downloads.yahoo.com/in/internetexplorer/ ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss
Re: [OSGeo-Discuss] Db connect
Hi, In this line: $query = “SELECT * FROM rjybound”; Add a ';' to it like this. $query = “SELECT * FROM rjybound*;*”; Guess it should work. Ricky On Wed, Mar 3, 2010 at 12:31 PM, Ravi ravivundava...@yahoo.com wrote: Hi, even when $dbhandle is changed to $db_handle gives error Parse error: syntax error, unexpected '=' in C:\OSGeo4W\apache\htdocs\lu.php on line 2 Is using Vista Home is an issue Ravi Kumar --- On Wed, 3/3/10, Robert Hollingsworth r...@prodigy.net wrote: From: Robert Hollingsworth r...@prodigy.net Subject: Re: [OSGeo-Discuss] Db connect To: OSGeo Discussions discuss@lists.osgeo.org Date: Wednesday, 3 March, 2010, 12:51 PM is the missing '_' in $dbhandle below significant? REH Hi, am trying to learn rendering maps using browser(shapefiles) no error is given from the browser, but it just displays $db_handle = pg_connect(”host = localhost port = 5432 dbname = postgis user = postgres password = GrassJump”); $query = “SELECT * FROM rjybound”; $result = pgexec($dbhandle, $query); -Inline Attachment Follows- ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss Your Mail works best with the New Yahoo Optimized IE8. Get it NOW! http://downloads.yahoo.com/in/internetexplorer/ ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss
Re: [OSGeo-Discuss] Db connect
On 2010/03/02 7:01 PM, Ravi wrote:
Hi, am using OSGeo4W bundle and the apache and php there in. Apache
installed OK showing as aservice and in the browser http:\\localhost
issues the OSGeo4w welcome screen and phpthere on
with the following wish to connect to PGSQL 8.4 and postGIS there in
with the following. But it doesnt work. Where am I going wrong ?
$db_handle = pg_connect(”host = localhost port = 5432 dbname =
postgis user = postgres password = GrassJump”); $query = “SELECT *
FROM rjybound”; $result = pgexec($dbhandle, $query);
Try something like this. (Not fully tested)
?
error_reporting(E_ALL);
$db_handle = pg_connect(host = localhost port = 5432 dbname = postgis
user = postgres password = GrassJump);
if( $db_handle === FALSE ) {
echo 'Failed to connect';
} else {
$query = 'SELECT * FROM rjybound';
$result = pg_query($db_handle, $query);
if( $result === FALSE ) {
$error = pg_last_error($db_handle);
if( $error === FALSE ) {
echo 'Unable to determine last error';
} else {
echo 'Last Error = ' . $error;
}
} else {
while ( $row = pg_fetch_row($result) ) {
echo Element 0: $row[0];
echo br /\n;
}
}
}
?
--
Dave Patton
CIS Canadian Information Systems
Victoria, B.C.
Degree Confluence Project:
Canadian Coordinator
Technical Coordinator
http://www.confluence.org/
Personal website:
Maps, GPS, etc.
http://members.shaw.ca/davepatton/
___
Discuss mailing list
Discuss@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/discuss
Re: [OSGeo-Discuss] Db connect
On 2010/03/02 7:01 PM, Ravi wrote:
Hi, am using OSGeo4W bundle and the apache and php there in. Apache
installed OK showing as aservice and in the browser http:\\localhost
issues the OSGeo4w welcome screen and phpthere on
with the following wish to connect to PGSQL 8.4 and postGIS there in
with the following. But it doesnt work. Where am I going wrong ?
$db_handle = pg_connect(”host = localhost port = 5432 dbname =
postgis user = postgres password = GrassJump”); $query = “SELECT *
FROM rjybound”; $result = pgexec($dbhandle, $query);
Try something like this. (Not fully tested)
?
error_reporting(E_ALL);
$db_handle = pg_connect(host = localhost port = 5432 dbname = postgis
user = postgres password = GrassJump);
if( $db_handle === FALSE ) {
echo 'Failed to connect';
} else {
$query = 'SELECT * FROM rjybound';
$result = pg_query($db_handle, $query);
if( $result === FALSE ) {
$error = pg_last_error($db_handle);
if( $error === FALSE ) {
echo 'Unable to determine last error';
} else {
echo 'Last Error = ' . $error;
}
} else {
while ( $row = pg_fetch_row($result) ) {
echo Element 0: $row[0];
echo br /\n;
}
}
}
?
--
Dave Patton
CIS Canadian Information Systems
Victoria, B.C.
Degree Confluence Project:
Canadian Coordinator
Technical Coordinator
http://www.confluence.org/
Personal website:
Maps, GPS, etc.
http://members.shaw.ca/davepatton/
___
Discuss mailing list
Discuss@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/discuss
Re: [OSGeo-Discuss] Db connect
638BDE6E92141949CACA2C4AD3C4180853CFA97E72141980769BAE3AD3C41043DCC8AAAE62141D0D759471FAD3C41E4E4E8CCB1E52141DE9A40937FAC3C4101B1BDC62FE52141CEEE4E3403AC3C4123E84ED8CCE4214156B49E8D93AB3C41B74BD0C75BE421413B6A7B9818AB3C4108C26785E4E32141E1A3F6C491AA3C41366EC06BE5E22141E3EA00EBC5AA3C41778AC9E750E2214141AE89EFE5AA3C41A16A6638DCE12141233792CDFEAA3C41264BD8A023E12141DB758D0347AB3C414724CC778DE021415A92060289AB3C412A74E25822E021419E562065B7AB3C41994917679DDF2141AEC983A6F3AB3C412D02FE5E1ADF21412F81EB563CAC3C411523E055C3DE2141CC145C7765AC3C4145D448BC62DE2141AE9D64557EAC3C41FF0AD04FE8DD21417B4CAE338CAC3C4193C3B64765DD2141130F533EA1AC3C414358A6AFC2DC2141E4F37980BCAC3C4167CC883833DC21412282B67FDDAC3C41FB4B7D332CDB2141B913DD2F31AD3C41611A09C885DA21416B810C5065AD3C41EA305894DAD92141647FC2DF8FAD3C411773F199E8D821413D6B929BCCAD3C41F853381AECD72141BC870B9A0EAE3C41D818498362D72141BA84012E3EAE3C4121C75FDF45D72141F315A985FDAD3C412B335D0519D72141C47F2F13DEAD3C412B679D350E
D72141A272102DAAAD3C410684EB4B0CD72141C6EB51BF66AD3C419BD33E1F90D521419D97DA8764AD3C41B0C99AE9CFD42141701F142F6AAD3C41B89F13190ED52141AEE6CF973FAE3C41633D1621A4D42141FE08B56475AE3C41640509BEB1D421413FAE42ABE8AE3C416B9DE2D641D421411ACB90C1E6AE3C415223D61BE4D32141615B1731DDAE3C415720C1826DD32141C9987226C8AE3C4133D8FD4A72D32141C8C491773DAE3C419166EE6826D22141C629A3C536AE3C41DB6A0A662AD22141DCA1E293B6AC3C41137775C498D221418D3FC0B2BDAC3C419B6462BBD1D2214146587B66DDAB3C410A63B890FBD221416E7C4C6380AB3C41F93A3E29C1D32141E50F00B575AB3C4197FF82EBB2D32141823B65D8E2AA3C410BF6729B34D3214122D838D9E2AA3C417B5E11C6AFD22141FE9E328CE3AA3C412B1E1C0C75D221412FB8E1A2ECAA3C41E8BDCF1B44D2214171182E931DAB3C4111B461ACC0D12141B6815A5835AB3C41A8BCFA3359D12141835FCB6C45AB3C41665CAE4328D1214118B4B88547AB3C4188B78391EFD0214163651C8872AB3C4176A9319EACD02141582DF5B38FAB3C41DEE68C9397D02141E0E6A6D4ADAB3C41DDE68C9397D0214171A7016FEDAB3C412A1702D2ABD02141CB2E89746CAC3C4131B499E0BCD021413
2C186CDE1AC3C41FD6447CBC0D02141B8DDA8F84EAD3C416B1A9D54B4CF2141638BF39446AD3C41032336DC4CCF2141805425FD40AD3C41DF05D938FECE21413997B1EC41AD3C41F8AB0445D1CE214137FCC23A3BAD3C41476F537F5ECE21416E8356C03AAD3C415BDFA12724CE2141561B7CBA37AE3C419D9E5C8106CE21418DA20F4037AE3C41875A2D2AB6CD21413138CAD035AE3C41DF2425DE64CD214168BF5D5635AE3C4185EB5DC924CD2141F81548992FAE3C41
--- On Thu, 4/3/10, Dave Patton da...@confluence.org wrote:
From: Dave Patton da...@confluence.org
Subject: Re: [OSGeo-Discuss] Db connect
To: OSGeo Discussions discuss@lists.osgeo.org
Date: Thursday, 4 March, 2010, 6:43 AM
On 2010/03/02 7:01 PM, Ravi wrote:
Hi, am using OSGeo4W bundle and the apache and php
there in. Apache
installed OK showing as aservice and in the browser
http:\\localhost issues the OSGeo4w welcome screen and
phpthere on
with the following wish to connect to PGSQL 8.4 and
postGIS there in with the following. But it doesnt work.
Where am I going wrong ?
$db_handle = pg_connect(”host = localhost port =
5432 dbname =
postgis user = postgres password = GrassJump”);
$query = “SELECT *
FROM rjybound”; $result = pgexec($dbhandle,
$query);
Try something like this. (Not fully tested)
?
error_reporting(E_ALL);
$db_handle = pg_connect(host = localhost port = 5432
dbname = postgis user = postgres password = GrassJump);
if( $db_handle === FALSE ) {
echo 'Failed to connect';
} else {
$query = 'SELECT * FROM rjybound';
$result = pg_query($db_handle, $query);
if( $result === FALSE ) {
$error = pg_last_error($db_handle);
if( $error === FALSE ) {
echo 'Unable to determine last
error';
} else {
echo 'Last Error = ' . $error;
}
} else {
while ( $row = pg_fetch_row($result) ) {
echo Element 0: $row[0];
echo br /\n;
}
}
}
?
-- Dave Patton
CIS Canadian Information Systems
Victoria, B.C.
Degree Confluence Project:
Canadian Coordinator
Technical Coordinator
http://www.confluence.org/
Personal website:
Maps, GPS, etc.
http://members.shaw.ca/davepatton/
___
Discuss mailing list
Discuss@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/discuss
The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
http://in.yahoo.com/
___
Discuss mailing list
Discuss@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/discuss
[OSGeo-Discuss] Db connect
Hi, am using OSGeo4W bundle and the apache and php there in. Apache installed OK showing as aservice and in the browser http:\\localhost issues the OSGeo4w welcome screen and phpthere on with the following wish to connect to PGSQL 8.4 and postGIS there in with the following. But it doesnt work. Where am I going wrong ? $db_handle = pg_connect(”host = localhost port = 5432 dbname = postgis user = postgres password = GrassJump”); $query = “SELECT * FROM rjybound”; $result = pgexec($dbhandle, $query); Ravi Kumar Your Mail works best with the New Yahoo Optimized IE8. Get it NOW! http://downloads.yahoo.com/in/internetexplorer/ ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss
Re: [OSGeo-Discuss] Db connect
Hi Ravi, what kind of error are you getting? Tyler Ravi wrote: Hi, am using OSGeo4W bundle and the apache and php there in. Apache installed OK showing as aservice and in the browser http:\\localhost issues the OSGeo4w welcome screen and phpthere on with the following wish to connect to PGSQL 8.4 and postGIS there in with the following. But it doesnt work. Where am I going wrong ? $db_handle = pg_connect(”host = localhost port = 5432 dbname = postgis user = postgres password = GrassJump”); $query = “SELECT * FROM rjybound”; $result = pgexec($dbhandle, $query); Ravi Kumar Your Mail works best with the New Yahoo Optimized IE8. Get it NOW! http://downloads.yahoo.com/in/internetexplorer/ ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss
Re: [OSGeo-Discuss] Db connect
Hi, am trying to learn rendering maps using browser(shapefiles) no error is given from the browser, but it just displays $db_handle = pg_connect(”host = localhost port = 5432 dbname = postgis user = postgres password = GrassJump”); $query = “SELECT * FROM rjybound”; $result = pgexec($dbhandle, $query); Ravi Kumar --- On Wed, 3/3/10, Tyler Mitchell (OSGeo) tmitch...@osgeo.org wrote: From: Tyler Mitchell (OSGeo) tmitch...@osgeo.org Subject: Re: [OSGeo-Discuss] Db connect To: OSGeo Discussions discuss@lists.osgeo.org Date: Wednesday, 3 March, 2010, 8:56 AM Hi Ravi, what kind of error are you getting? Tyler Ravi wrote: Hi, am using OSGeo4W bundle and the apache and php there in. Apache installed OK showing as aservice and in the browser http:\\localhost issues the OSGeo4w welcome screen and phpthere on with the following wish to connect to PGSQL 8.4 and postGIS there in with the following. But it doesnt work. Where am I going wrong ? $db_handle = pg_connect(”host = localhost port = 5432 dbname = postgis user = postgres password = GrassJump”); $query = “SELECT * FROM rjybound”; $result = pgexec($dbhandle, $query); Ravi Kumar Your Mail works best with the New Yahoo Optimized IE8. Get it NOW! http://downloads.yahoo.com/in/internetexplorer/ ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/ ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss
RE: [OSGeo-Discuss] Db connect
Dear Mr.Ravi Kumar, Are your PHP pages getting processed?.Just create a simple page with the below code and run to see if you get the PHP Environment information details. If you dont get the information then your PHP is not configured well. ?php phpinfo(); ? Regards Kumaran -Original Message- From: discuss-boun...@lists.osgeo.org [mailto:discuss-boun...@lists.osgeo.org] On Behalf Of Ravi Sent: Wednesday, March 03, 2010 12:16 PM To: OSGeo Discussions Cc: postgis Subject: Re: [OSGeo-Discuss] Db connect Hi, am trying to learn rendering maps using browser(shapefiles) no error is given from the browser, but it just displays $db_handle = pg_connect(”host = localhost port = 5432 dbname = postgis user = postgres password = GrassJump”); $query = “SELECT * FROM rjybound”; $result = pgexec($dbhandle, $query); Ravi Kumar --- On Wed, 3/3/10, Tyler Mitchell (OSGeo) tmitch...@osgeo.org wrote: From: Tyler Mitchell (OSGeo) tmitch...@osgeo.org Subject: Re: [OSGeo-Discuss] Db connect To: OSGeo Discussions discuss@lists.osgeo.org Date: Wednesday, 3 March, 2010, 8:56 AM Hi Ravi, what kind of error are you getting? Tyler Ravi wrote: Hi, am using OSGeo4W bundle and the apache and php there in. Apache installed OK showing as aservice and in the browser http:\\localhost issues the OSGeo4w welcome screen and phpthere on with the following wish to connect to PGSQL 8.4 and postGIS there in with the following. But it doesnt work. Where am I going wrong ? $db_handle = pg_connect(”host = localhost port = 5432 dbname = postgis user = postgres password = GrassJump”); $query = “SELECT * FROM rjybound”; $result = pgexec($dbhandle, $query); Ravi Kumar Your Mail works best with the New Yahoo Optimized IE8. Get it NOW! http://downloads.yahoo.com/in/internetexplorer/ ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/ ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss
