Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 6A3654759BD for ; Fri, 30 Aug 2002 02:26:09 -0400 (EDT) Received: from mail.surguttel.ru (unknown [217.106.46.1]) by postgresql.org (Postfix) with ESMTP id C2E6A47597C for ; Fri, 30 Aug 2002 02:26:07 -0400 (EDT) Received: from dr_sad (oper.surguttel.ru [217.106.46.7] (may be forged)) by mail.surguttel.ru (8.12.2/8.12.2/SuSE Linux 0.6) with ESMTP id g7UJPDCH018809; Fri, 30 Aug 2002 12:25:13 -0700 Date: Fri, 30 Aug 2002 12:26:04 +0600 From: "dr_sad(surguttel)" X-Mailer: The Bat! (v1.53d) Reply-To: "dr_sad(surguttel)" X-Priority: 3 (Normal) Message-ID: <43953037134.20020830122604@surguttel.ru> To: Jean-Luc Lachance Cc: pgsql-php@postgresql.org Subject: Re: Where can I get error messages? In-Reply-To: <3D6E4129.FA61A0AA@nsd.ca> References: <150770979970.20020828095147@surguttel.ru> <3D6CEA4B.76516A2E@nsd.ca> <193857726615.20020829095734@surguttel.ru> <3D6E4129.FA61A0AA@nsd.ca> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavis-milter (http://amavis.org/) X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/110 X-Sequence-Number: 1455 Sorry, but this sample doesn't work... :\ if I change phptype "pgsql" in DSN (pgsql://$userid:$password@$dbhost/$database) on "mysql", then get error message:"DB Error: connect failed", but else if phptype=pqsql (as write in sample) nothing happyness and result html code is: PostgreSQL PHP Test -- Best wishes, Andrey Thursday, August 29, 2002, 9:43:37 PM, you wrote: JLL> Here is a sample: JLL> JLL> JLL> PostgreSQL PHP Test JLL> JLL>
JLL> require_once( 'DB.php'); JLL> $userid=...; JLL> $password=...; JLL> $dbhost=...; JLL> $databse=...; JLL> $db = DB::connect( "pgsql://$userid:$password@$dbhost/$database"); JLL> if( DB::iserror( $db)) JLL> { JLL> die( "DB:connect " . $db->getMessage()); JLL> } JLL> $sql = "select * from whatever"; JLL> $q = $db->query($sql); JLL> if( DB::iserror( $q)) JLL> { JLL> die( "Query " . $q->getMessage()); JLL> } JLL> while( $row = $q->fetchRow( )) JLL> { JLL> ?> JLL> JLL> JLL> JLL> JLL> } JLL> ?> JLL>
JLL> JLL> JLL> Make sure that you include /usr/share/pear in the include_path in JLL> php.ini and restart httpd. JLL> JLL JLL> "dr_sad(surguttel)" wrote: >> >> Hi, Jean-Luc. >> Can't find any documents about "DB::connect" at www.php.net :( >> Give me please any links to that. >> And why "pg_connect" does not work properly? >> Script ex.: >> ---- cut --------- >> >> >> > printf("Hello, world!
"); >> $s="host=dbserv port=5432 dbname=ll user=postgres password=gecnzr"; >> if (($db=pg_pconnect ($s))===false) {printf("FALSE! No connection!
");} >> printf("This is the end of script
"); >> ?> >> >> >> --- cut ----------- >> No errors messages... "Hello, world!
" - is the last line in >> generated html text :\ >> >> with respect, Andrey >> >> Wednesday, August 28, 2002, 9:20:43 PM, you wrote: >> JLL> Why don't you use the DB::connect instead? >> >> JLL> "dr_sad(surguttel)" wrote: >> >> >> >> I've installed Postgres 7.2.2 on Linux SuSE 8.0 Pro. >> >> >From other server (SuSE 8.0 Pro + Apache 2.0.39 + PHP 4.2.2) I'm trying >> >> to get access to Postgres database, using PHP-script: >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> I've no errors messages both in PHP log and Postgres console, but HTML >> >> page was been generated this script are stoped on tag. Where >> >> can I get error messages? That is possible troubles? >> >> >> >> Thank You >> >> >> >> -- >> >> With respect, Andrey Sergeev >> >> >> >> ---------------------------(end of broadcast)--------------------------- >> >> TIP 2: you can get off all lists at once with the unregister command >> >> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >> >> JLL> ---------------------------(end of broadcast)--------------------------- >> JLL> TIP 4: Don't 'kill -9' the postmaster