[OSGeo-Discuss] Db connect

[Ravi]

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/