[OSGeo-Discuss] Db connect

[Daniel Morissette]

Guys,

This is the OSGeo-Discuss list, with over 1000 members interested in 
general OSGeo-related discussions and announcements. My fear is that if 
we answer support questions here the noise level will increase and we 
will lose several subscribers who are here for "general OSGeo-related 
discussions and announcements" but can't bear the noise level.

I believe support questions such as this one should be posted to the 
list of the software package/project to which they relate, in this case: 
Postgis or OSGeo4W.

Thanks for your understanding

Daniel


Ravi wrote:
> Hi,
> this is the output
> Pl educate me.. what does it indicate, among many others
> 
> 1.The connection works ??
> 
> Ravi
> 
> Element 0:
>  0103000020847F0000010000007501000085EB5DC924CD2141F81548992FAE3C4135542EE00CCD214174280385D9AD3C4173DD0BD6E1CC2141486F267C77AD3C41D14CB04E2FCD2141909A9B9D74AD3C413F2FB808B9CD21416BB7E9B372AD3C4164126AF2BACD2141EC9A70B530AD3C41D05983FA3DCE2141D9F68E1933AD3C41B84A98FF3ECE2141EBAA037EEEAC3C4135960BAA10CD2141D81704FAE7AC3C41539BA09019CD2141851E430BC7AC3C41AAAA5F4434CD2141AD4FD47BC3AC3C41C8E1B36846CE21411ECD8908BFAC3C41F01245D942CE2141383B80E19FAC3C418B266BA659CD2141F3045A8A9AAC3C416B231751ADCD214127E1463C5CAC3C412E4DED5201CF2141CC20699366AB3C416F802E97C3D02141BF4F437871AB3C41DC8955B9F8D02141AD08A69E49AB3C4147D5631395CF21412C44E57A1EAB3C415ED7E64064D12141CA30938355AA3C414B4FA5519CD121414F8276D8F5A93C410403BC37A2D1214145E73C7771A93C4128368E39FBD1214162ECD15D7AA93C41E2FF67E2F5D12141542937C65EA93C41CEA76FCE0ED22141646B31154CA93C410CB0580AC4D12141DAFEE46641A93C415F42F99769D22141201B8BD693A83C418F2027DB87D22141E279C2FB59A83C4184A78AD7CBD32141514659937AA73C414D8B
> FC0254D421411701FCADEEA63C410641645F8FD42141D53DBB19ACA63C41D76BEAA27AD5214131F7C51812A63C41342A87BA13D6214145B6DE8D74A53C416B36F21882D62141ED8EE08303A53C41F1A4CD42B5D621414F6EE9DBD0A43C41732343F679D621416B4AF24BB1A43C412E5ACA89FFD52141043E15B187A43C41C87E6B4997D521414462E15863A43C41B19F4D4040D5214187BC8A644CA43C41019B3A821AD52141A1919D7229A43C4150FD5C6313D52141044CB86709A43C41D1BC0C3FFCD4214119A4B07BF0A33C41F04001DDD6D42141B768F53DE2A33C4153FB1BD2B6D421414B013E76E0A33C41061859A88FD4214157AC99B7A5A33C41516F996FFCD42141BF343E5D5BA33C4115D455CA20D5214126795C343BA33C4112CB75F539D52141B766553D1FA33C412D8BC7884DD5214120B453E9E5A23C4160F3178D44D32141059958E1D1A23C416F2BFEDC39D32141F9E6E87B3BA23C41B3460CCA03D22141BED78CEF32A23C411B184324EDD12141D9B6B22924A23C4104821BEF73D12141FA3A9D19D5A13C4104821BEF73D121413ED8E3D155A13C4108FF3915E9D021418A5728806A9F3C41C9076F8A40D02141EB20EDE55D9F3C4118CBBDC4CDCF2141A15A89125A9F3C41A1E10C9122CF2141FB29E0CF549F3C413C06AE50BAC
> E2141683807DB539F3C415D88AC4AB0CD214150A188B0499F3C41011C1CA283CD2141A0AA8FDF469F3C417237036E86CD21411C9D3FA06C9F3C4145D2FFC513CD21417FD87DA2659F3C41816D436BEFCC2141AB831E6F879D3C419C2D95FE02CD21415AE67747249C3C4140C03F1C46CD2141A4B7FBE9689B3C41B387554F07CC214166696FA3059B3C418FA3836858CC214120A1CBD5A79B3C4103C84A0942CC214117862B57F39B3C41CB3EC70D34CC214186429B1AB09C3C4177EC11AA2BCC214116DAFCEF349D3C4191AC633D3FCC214100D6D3D28F9D3C4191AC633D3FCC21419991B5FBAF9D3C4150FF5FEE95CC2141F8649C207C9E3C41C423278F7FCC21410DBD96D6629F3C418F027FA0F9CB214152E8E6D3659F3C4130D24245E8CB21417EDDC6481B9F3C41442A3B59CFCB21418B88228AE09E3C41CAFFE8F9B1CB214113694F0DC09E3C41BEBBAD1968CB2141356CA3626C9E3C41576AF41660CB214137EB021A3E9E3C41ABE214BD52CB21412B1BA80EC99D3C41F8C5D7E679CB214103D2D747769D3C4132D001B48BCB21414A875D564D9D3C4189DFC067A6CB2141E5B4030B179D3C41134C0D16B1CB21418A0EA649D49C3C415782336DB6CB2141AA929AE7AE9C3C417FB3C4DDB2CB21414D6DDD6E9A9C3C411D7809A0A4CB21417C
> 33CC5B629C3C41ED99DB5C86CB2141EC984292079C3C41D09446767DCB2141FCDA3CE1F49B3C41642D8FAE7BCB214113B294ACAD9B3C418C5E201F78CB214191DAA57A6E9B3C415A9F553AD2C92141A11CA0C95B9B3C41773B8FA3C1C921411F4B34A2489C3C419404C10BBCC92141C4DDDEBF8B9C3C41E856766FC4C921413D1B80440C9E3C419828DFBEB5C92141100FEF1F9E9F3C4170F74D4EB9C921415147560800A03C4183D0E6AACEC92141D9FDA04A6AA13C41EF379E72D0C92141A539F3EEFEA13C41F1B6FD29A2C9214132EEFC9F0CA33C4146475D26EBC9214149DD93C11BA33C41B17E964140C921410A6E8A24EBA33C419C757F387EC82141B5A68873D3A43C41E5A964FE26C8214108B888B84AA53C4198C6A1D4FFC721412E82F9C7CBA53C41B5AF2995E4C72141ABBD1DA027A63C411458149598C7214154FD88CC27A73C417FBDE41886C721410434876069A73C4133DC083373C721415396686BACA73C41A1C21FB246C721416A1EDF2B40A83C41AC3DFD465FC621417CA8967D30A93C4139A808640DC621410C4320478BA93C41F2DA43FFDFC521419A518AE5BAA93C41CC281246B5C5214176B79782E6A93C4113DE97548CC52141A695C5C504AA3C41E1CFEB64C1C421410C805E6791AA3C4198EAE7A93DC42141BE357BDCE
> EAA3C417054FF5B33C4214130BFA7B5F2AA3C41B231C68A61C42141A9A24B310EAB3C412325751A3FC321414653E67FD4AB3C4198FA18CD64C221418AC55CAF54AC3C414AC303E810C221411498B53984AC3C41361E52D3B1C12141E2D33A89CBAC3C4179D435F741C12141300B506E1FAD3C412BBFB50DD0C0214151E11FF47DAD3C416F5304367EC021419AB5FF870EAE3C4161B69B2A75C0214124C4F0041DAE3C417D894433E7BF2141767B966D00AF3C41E0113A9458BF21418FDC70F8CDAF3C41A3EA9E9F56BF21413A618064D1AF3C418EC8640537BF2141DF1C66B208B03C4104F60B7B07BF2141F2C117C767B03C415B51A1B3F6BE214142020D81A2B03C41550D694BE8BE214126DD6A4AC5B03C4125D1FD8CCFBE214156A7BE9501B13C415B51A1B3F6BE214144B555222AB13C41FEE34BD139BF2141DE79172031B13C41356DCFCC47BF2141E950E01454B13C41CCD019CC52BF21415F4637527DB13C41FBDA6BFC52BF214190EC6A077EB13C418ABF843050BF21411CC8A36694B13C41A788B6984ABF21416131D02BACB13C41A991966D31BF2141337F1525C1B13C413A7F8F7615BF2141DA1AA017EBB13C41C65AC8D52BBF2141C61F57CF2CB23C41C148082C5EBF214161DB38F84CB23C41169BBD8F66BF2141B3240E876EB23C41
> 6BED72F36EBF21414CE0EFAF8EB23C4159F6B61951BF214122D201D0A1B23C417C114AC553BF21412AB90E0DAEB23C41DC085ABF71BF2141015C236CC2B23C41BD36488290BF21418D375CCBD8B23C414709A10CC0BF2141A5EECD8905B33C4108657D92FDBF214188259C210BB33C41902EF64746C02141950545EB14B33C41FC371D6A7BC021412FC1261435B33C4181F8B54ADDC021415558419C6BB33C412894403D07C12141B481BFF496B33C4197A6473423C1214131746FB5BCB33C41AF5DB9F24FC12141492BE173E9B33C4102A78E8171C121418C8B2D641AB43C41C50B4BDC95C121415DD0928848B43C41C1F98A32C8C121411E2C6F0E86B43C41F8820E2ED6C12141B5DE7062BFB43C41C6654BDEE6C121411F7DB029F8B43C413CF9FE2FDCC121418C70871C25B53C419B9D1B60C2C12141E8A2040993B53C416BBFED1CA4C12141328808C416B63C41C34D0C8890C121414E9A5D1E79B63C41C8142BB17CC121416A61BE58BCB63C415D14E4632EC12141E241AE6F14B73C41A3D3A75CA5C02141FAA288FAE1B73C418A1C369E78C02141C6D52D7542B83C41574EAF6B59C021411290F40777B83C419137D61C2DC021417336C1B2C1B83C413DE520B924C0214197C4FB6511B93C415DB732F605C02141E90DD1F432B93C415DB732F
> 605C021412E77FDB94AB93C41201CEF502AC021413B57A68354B93C419237D61C2DC021415AD3208DD6B93C4181ADE18F4CC021413C09C11952BA3C41475A5CDD41C02141C8972B57B8BA3C41D877D943FBBF2141ABBFA98266BB3C41A657A17CCABF2141897C4554B7BB3C41BE3F285777BF21411EF23FC34BBC3C41951D303812C021412213CB0D57BC3C41E177CBD667C021410F09B7245BBC3C4176DF2A13AFC021416E741D9361BC3C418B235A6AFFC02141CC7951B469BC3C41D8588D9E94C121410B088EB38ABC3C41386320C9E8C121412DB562397FBC3C4167E869DE12C221415E6B2AA96ABC3C416B1E474220C221410D390C0E4CBC3C414F423ED23FC22141771156B53DBC3C41A626DCDD0BC42141C63E154710BC3C41606A361DA0C42141D4AC197F00BC3C41A036C42291C52141737108FAEABB3C41D560BAFC59C621416F3B2B96DDBB3C41FA436CE65BC62141535F2226FDBB3C41440AD0B95FC62141ADFDFA8836BC3C418FD0338D63C62141BC705ECA72BC3C41D896976067C621414AFBDB00A5BC3C41F87C5EE3DFC6214125182A17A3BC3C41CD01D3E04DC72141FE99897B9ABC3C412D0C660BA2C721415A04CFEA9BBC3C414ABC4F2A0DC82141F2C673F5B0BC3C411970F81167C82141E6F35D6FC7BC3C415B03941AD4C821
> 41DBBB369BE4BC3C41747DA0D531C9214119AF84E8FEBC3C41D387330086C92141D654DBDC15BD3C41BBE107F4B2C9214167ABC51F10BD3C4117B6BDBAF9C92141472F6FF4DCBC3C41A7459AFA77CA214130BAC142CBBC3C41219147E3A5CA21414D6AAB6136BD3C419BDCF4CBD3CA21414F6F0A6B82BD3C41D468E75A1FCB21412C91B78ACCBD3C41BFF898B259CB21415A7B12EEEFBD3C41542D22B776CC214154AA46D8DBBD3C41C9A7038A90CC21416382BB6711BE3C41F5F66F3BADCC2141E00346B44CBE3C4143F3B072BECC2141AAE6228692BE3C41B6D2A393D1CC214162251EBCDABE3C414139761B51CE214132A0D4A6B0BE3C4185D271E0EFCE21415E20D9AD34BF3C419106EC423BD021419DC4FC27F7BE3C4164FE9908F1D021413422CA15E0BE3C4147A08A9522D22141AF867041E5BE3C417A2F92BDE4D221417664EE09DFBE3C41EC4777DB7BD32141732E11A6D1BE3C41A0BA0505FCD32141DB6B6C9BBCBE3C4125A84A1952D42141688C797AA9BE3C41817C00E098D421412ECF08919CBE3C414EFFC48AF7D421414B26F33285BE3C41FE367D2958D521418F3B987073BE3C4160B0DFB43DD62141309B759D64BE3C4113887F2CB7D62141C28C4E9265BE3C415E22C4AE45D72141D05F64184FBE3C41A2242F1844D821414BDC8
> F5B3EBE3C4194209B3799D82141BA85A51844BE3C41848118A5E7D8214116F0EA8745BE3C415C3C6A0663D92141E00346B44CBE3C41EA305894DAD921419A73BF4456BE3C413330AE6462DA2141D295417C5CBE3C4119C3745513DB2141F6DD04B457BE3C41B72AC624C7DB21411926C8EB52BE3C4152124D9E35DC2141DC1CCC1050BE3C41804695F390DC214198D8D0924FBE3C4179AEBBDA00DD2141963DE2E048BE3C41842434B5B3DD2141EE714AEC3CBE3C414FDBF13584DE21416C8964E132BE3C414BA514D276DE2141D92D1B95ECBD3C4102DFB0FE72DE21411F16E0A6CDBC3C419806675781DE2141E1B821026EBC3C415211CF9991DE21413B1E086823BC3C41906E8D3EF1DE2141297A26CC25BC3C41D20129475EDF21413B1E086823BC3C413F1D23FE6BE02141DD18D4461BBC3C4198C45CE5B2E02141BA97680770BB3C4115864D52F8E02141691D07D020BB3C410D0B70BDDFE12141C5A9E4A9B0BA3C41E1A10BC5F3E121414E6F32C81FBA3C41452C42D9F3E121410542FD351FBA3C4177B5D5FFE0E12141A4DBABD40EBA3C4173F9AC8972E121411F70475AFDB93C410AB983D93BE121410790B125EEB93C413152811A45E121413B9AF1B8C0B93C41A6CC62ED5EE121411F5478F19AB93C419492F1A8A6E12141A8D4371535B9
> 3C419567DE45E8E121411045D8A8D0B83C413F0BAA0414E321419F25CD3DFEB73C41C9C9BA2E7EE32141877FA1312BB83C41C6F3041FFEE321415B0D519AF6B73C4130F44B6C4CE4214118AD04AAC5B73C411ADD8C2436E52141DD70592D03B73C4176B142EB7CE52141A24978ECB0B63C41D6BBD515D1E5214121FC8093ADB63C416863CCB04DE621418E6C1B6245B63C419F9560F35EE62141D04C3A5123B63C416F1069836FE6214133C6BDA002B63C4194433B85C8E62141D270827B41B53C411F63ED436EE721411448B7B22AB53C41F101D89C61E72141188D28EB93B43C41CA0A196877E72141CD23E4C64DB43C412CE7DF612AE82141F7CCBEF851B43C413256517920E921413671E27214B43C413CD7823AE4E92141D85044EFCFB33C418A0E981F38EA21417927C696A4B33C41AF61EFFE77EA2141EF29D83C8EB33C41CA97218C8CEA21413283164F31B33C4169AC69F0A0EA2141F625561AD5B23C411A4A470FA8EA21410F944CF3B5B23C414BA7D40998EA21411DBE07EC4CB23C41A635F37484EA214114788B7AA6B13C41F50EDF6C86EA2141B0FFC68B48B13C41B061EFFE77EA2141885A20D7C0B03C4192DE8EC9EAEA2141C82C9083B4B03C4192DE8EC9EAEA21419B93777E5EAF3C41A91AF2F5E7EA2141B6764165C0AD3C41CD7
> 638BDE6E92141949CACA2C4AD3C4180853CFA97E72141980769BAE3AD3C41043DCC8AAAE62141D0D759471FAD3C41E4E4E8CCB1E52141DE9A40937FAC3C4101B1BDC62FE52141CEEE4E3403AC3C4123E84ED8CCE4214156B49E8D93AB3C41B74BD0C75BE421413B6A7B9818AB3C4108C26785E4E32141E1A3F6C491AA3C41366EC06BE5E22141E3EA00EBC5AA3C41778AC9E750E2214141AE89EFE5AA3C41A16A6638DCE12141233792CDFEAA3C41264BD8A023E12141DB758D0347AB3C414724CC778DE021415A92060289AB3C412A74E25822E021419E562065B7AB3C41994917679DDF2141AEC983A6F3AB3C412D02FE5E1ADF21412F81EB563CAC3C411523E055C3DE2141CC145C7765AC3C4145D448BC62DE2141AE9D64557EAC3C41FF0AD04FE8DD21417B4CAE338CAC3C4193C3B64765DD2141130F533EA1AC3C414358A6AFC2DC2141E4F37980BCAC3C4167CC883833DC21412282B67FDDAC3C41FB4B7D332CDB2141B913DD2F31AD3C41611A09C885DA21416B810C5065AD3C41EA305894DAD92141647FC2DF8FAD3C411773F199E8D821413D6B929BCCAD3C41F853381AECD72141BC870B9A0EAE3C41D818498362D72141BA84012E3EAE3C4121C75FDF45D72141F315A985FDAD3C412B335D0519D72141C47F2F13DEAD3C412B679D350E
> D72141A272102DAAAD3C410684EB4B0CD72141C6EB51BF66AD3C419BD33E1F90D521419D97DA8764AD3C41B0C99AE9CFD42141701F142F6AAD3C41B89F13190ED52141AEE6CF973FAE3C41633D1621A4D42141FE08B56475AE3C41640509BEB1D421413FAE42ABE8AE3C416B9DE2D641D421411ACB90C1E6AE3C415223D61BE4D32141615B1731DDAE3C415720C1826DD32141C9987226C8AE3C4133D8FD4A72D32141C8C491773DAE3C419166EE6826D22141C629A3C536AE3C41DB6A0A662AD22141DCA1E293B6AC3C41137775C498D221418D3FC0B2BDAC3C419B6462BBD1D2214146587B66DDAB3C410A63B890FBD221416E7C4C6380AB3C41F93A3E29C1D32141E50F00B575AB3C4197FF82EBB2D32141823B65D8E2AA3C410BF6729B34D3214122D838D9E2AA3C417B5E11C6AFD22141FE9E328CE3AA3C412B1E1C0C75D221412FB8E1A2ECAA3C41E8BDCF1B44D2214171182E931DAB3C4111B461ACC0D12141B6815A5835AB3C41A8BCFA3359D12141835FCB6C45AB3C41665CAE4328D1214118B4B88547AB3C4188B78391EFD0214163651C8872AB3C4176A9319EACD02141582DF5B38FAB3C41DEE68C9397D02141E0E6A6D4ADAB3C41DDE68C9397D0214171A7016FEDAB3C412A1702D2ABD02141CB2E89746CAC3C4131B499E0BCD021413
> 2C186CDE1AC3C41FD6447CBC0D02141B8DDA8F84EAD3C416B1A9D54B4CF2141638BF39446AD3C41032336DC4CCF2141805425FD40AD3C41DF05D938FECE21413997B1EC41AD3C41F8AB0445D1CE214137FCC23A3BAD3C41476F537F5ECE21416E8356C03AAD3C415BDFA12724CE2141561B7CBA37AE3C419D9E5C8106CE21418DA20F4037AE3C41875A2D2AB6CD21413138CAD035AE3C41DF2425DE64CD214168BF5D5635AE3C4185EB5DC924CD2141F81548992FAE3C41
> 
> 
> --- On Thu, 4/3/10, Dave Patton <davep at confluence.org> wrote:
> 
>> From: Dave Patton <davep at confluence.org>
>> Subject: Re: [OSGeo-Discuss] Db connect
>> To: "OSGeo Discussions" <discuss at 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 at 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 at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/discuss


-- 
Daniel Morissette
http://www.mapgears.com/