Received: from mail.popso.it ([194.243.98.134]) by hub.org (8.9.3/8.9.3) with ESMTP id GAA84751 for ; Thu, 24 Feb 2000 06:56:49 -0500 (EST) (envelope-from giampiero.raschetti@popso.it) Received: (from mail@localhost) by mail.popso.it (8.8.7/8.8.7) id MAA11938; Thu, 24 Feb 2000 12:48:12 +0100 Received: from internal host by mail.popso.it via smap (personal) id xma011914; Thu, 24 Feb 00 12:47:29 +0100 Sender: jimi@popso.it Message-ID: <38B51D61.8656DEF1@popso.it> Date: Thu, 24 Feb 2000 13:00:33 +0100 From: Giampiero Raschetti X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.12-20 i586) X-Accept-Language: en MIME-Version: 1.0 To: James Macken , pgsql-sql@hub.org Subject: Re: [SQL] PostgreSQL and PHP References: <001701bf7eb7$23a82400$ac7d2bcb@jay> Content-Type: multipart/signed; protocol="application/x-pkcs7-signature"; micalg=sha1; boundary="------------ms090B78DD0E041CA8147A97D9" This is a cryptographically signed message in MIME format. --------------ms090B78DD0E041CA8147A97D9 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Did you really read the manual ? From the php postgresSQL manual (pg_fetch_array) Example 1. PostgreSQL fetch array Prev James Macken wrote: > > To those of you who use PHP with PostgreSQL, > > I'm trying to do a simple select inside a ".php3" script. The php3 script > simply says something like (the linux machine is not turned on so I can't > grab it exactly): > > $database = pg_connect("","","","mydb"); > pg_exec($database, "select * from mytable"); > echo "whatever" > ?> > > and all I get is (in the resulting web page): > > whatever > > In other words, it doesn't print out on the web page the query that I just > made. Now have added the "nobody" web user to the list of authorised people > and I have granted permission for nobody to do anything he likes to mydb. > > Other things work however such as the echo command above and the "info" php > command. > > Any ideas? > > James > > ************ -- Best Regards ---------------------------- Ing. Giampiero Raschetti Sistemi Innovativi Banca Popolare di Sondrio ---------------------------- --------------ms090B78DD0E041CA8147A97D9 Content-Type: application/x-pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" Content-Description: S/MIME Cryptographic Signature MIIHuQYJKoZIhvcNAQcCoIIHqjCCB6YCAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHAaCC BdEwggKQMIIB+aADAgECAgMAm8UwDQYJKoZIhvcNAQEEBQAwgbkxCzAJBgNVBAYTAlpBMRUw EwYDVQQIEwxXZXN0ZXJuIENhcGUxFDASBgNVBAcTC0R1cmJhbnZpbGxlMRowGAYDVQQKExFU aGF3dGUgQ29uc3VsdGluZzEpMCcGA1UECxMgVGhhd3RlIFBGIFJTQSBJSyAxOTk4LjkuMTYg MTc6NTUxNjA0BgNVBAMTLVRoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBSU0EgSXNzdWVyIDE5 OTguOS4xNjAeFw05OTAzMDgxNDAzNTZaFw0wMDAzMDcxNDAzNTZaME4xHzAdBgNVBAMTFlRo YXd0ZSBGcmVlbWFpbCBNZW1iZXIxKzApBgkqhkiG9w0BCQEWHGdpYW1waWVyby5yYXNjaGV0 dGlAcG9wc28uaXQwXDANBgkqhkiG9w0BAQEFAANLADBIAkEApIaNCBaZMD9TL8Shxj0vkHxY dtEmNpPEWFun75AdRJ6/Jxp1bhV5HO02UwMUrzwmlFBSKgU02OFRxXtNDxGA8wIDAQABo1Qw UjARBglghkgBhvhCAQEEBAMCBaAwDgYDVR0PAQH/BAQDAgWgMAwGA1UdEwEB/wQCMAAwHwYD VR0jBBgwFoAU/j5gnGuMD7DYM8bKxh5YsHE4teAwDQYJKoZIhvcNAQEEBQADgYEAn6o/B6kK 93HPOUKd3M7qV9TVhT9fq0SKXN79f5bWWgKN3rbFfVSlx0dc4Tc14yT+45xM9t2jelUGBavV f4aEfFqb4uvFIS8v6GS4tjEY3+QvltiDvTvSRyfwDWZF6otsodVKyLv9CVVs0e8e9An2jp1Z Nk+IVwi0k/6ZQoqwSRUwggM5MIICoqADAgECAgEKMA0GCSqGSIb3DQEBBAUAMIHRMQswCQYD VQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRIwEAYDVQQHEwlDYXBlIFRvd24xGjAY BgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgwJgYDVQQLEx9DZXJ0aWZpY2F0aW9uIFNlcnZp Y2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgQ0ExKzAp BgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWlsQHRoYXd0ZS5jb20wHhcNOTgwOTE2MTc1 NTM0WhcNMDAwOTE1MTc1NTM0WjCBuTELMAkGA1UEBhMCWkExFTATBgNVBAgTDFdlc3Rlcm4g Q2FwZTEUMBIGA1UEBxMLRHVyYmFudmlsbGUxGjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5n MSkwJwYDVQQLEyBUaGF3dGUgUEYgUlNBIElLIDE5OTguOS4xNiAxNzo1NTE2MDQGA1UEAxMt VGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIFJTQSBJc3N1ZXIgMTk5OC45LjE2MIGfMA0GCSqG SIb3DQEBAQUAA4GNADCBiQKBgQDEpeXU1NBfCALuByF9JL+ra44e6yAHAhWEa4/QkyQfG53u aLK5LE/pk2cXEBceoflDQSO5MKp2l7vz5/2BwLUxi/amUCZU8pUo6xmkHpcesOK4m8EEmjLQ PAlsT+Q1T/B2vwATA09FCGDz/LTQkAGKEsmcun9S6iqTNTY8POQ1LwIDAQABozcwNTASBgNV HRMBAf8ECDAGAQH/AgEAMB8GA1UdIwQYMBaAFHJJwnM0xlX0C3ZygX539IfnxrIOMA0GCSqG SIb3DQEBBAUAA4GBACzHgh8BQz4Hj+5pXKlkgvjAlq2TK8ubUNdAmoHCuqZ2nTyVQNxVweFV gnmrCimm1QzhVyg+j/m71d8Nk1iqWy2LjzPk3VgVNXZyFSm9QvRakgt3X50n25otThuCBo7S jVa7ld7bDGUF3pWeAt1TF76+/GvDGiJ6FCthvcKfXnpaMYIBsDCCAawCAQEwgcEwgbkxCzAJ BgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxFDASBgNVBAcTC0R1cmJhbnZpbGxl MRowGAYDVQQKExFUaGF3dGUgQ29uc3VsdGluZzEpMCcGA1UECxMgVGhhd3RlIFBGIFJTQSBJ SyAxOTk4LjkuMTYgMTc6NTUxNjA0BgNVBAMTLVRoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBS U0EgSXNzdWVyIDE5OTguOS4xNgIDAJvFMAkGBSsOAwIaBQCggYYwGAYJKoZIhvcNAQkDMQsG CSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMDAwMjI0MTIwMDM1WjAjBgkqhkiG9w0BCQQx FgQU4juvZVs6cuAQg1R1jTVATcjTs9MwJwYJKoZIhvcNAQkPMRowGDAHBgUrDgMCBzANBggq hkiG9w0DAgIBKDANBgkqhkiG9w0BAQEFAARATSfjZA3XQSMnm1rx3hKgAomg84LWrhllaGP5 lRQ2jQ4gnPRXYVq4XW4WQVydUw4XhiRBWL3GtGZX2QaScHN/Fg== --------------ms090B78DD0E041CA8147A97D9--