I'm having a problem with a php script when connecting to a postgresql
database. The problem is this: When Apache runs the php script, the
output is missing everything after my first call to pg_connect(). i.e., I
can "echo", "print" whatever I like, but everything is cut off after that
call--it doesn't show up in the output when run by Apache However.
if I pass the script through php manually, I get the expected output.
For instance, here's the code:
<html>
<head>
<title>PHP Test</title>
</head>
<body>
<?php
import_request_variables('p', 'p_');
$conn_string = "dbname=PilotProjects user=web-user password=secret";
print "<p>";
echo "Point 1";
echo "</p>";
print "fubar";
$database = pg_connect ($conn_string)
or die ("No connection to the database. Error: " . pg_last_error());
echo "Point1.5\n";
echo "<p>";
echo pg_dbname($database);
echo "</p>";
echo get_resource_type($database);
echo "Point 2\n";
$result=pg_query ($database, "SELECT \"ProjectName\" FROM
\"ProjectsTable\"");
$resultprintme = pg_fetch_row($result,0)
or die ("Help! no query result. Error: " .pg_last_error() . "\n");
echo $resultprintme[0] . "\n";
/* foreach ($resultprintme as $ProjectName) {
print ("$ProjectName\n");
}*/
pg_close ($database);
?>
</body>
</html>
When Apache runs the script through php, here's the output:
<html>
<head>
<title>PHP Test</title>
</head>
<body>
<p></p>fubar
However, when I run the code through php from the command line, the output
is this:
dbrunber@galadriel:~/htdocs/tests/php$ php ./selectStudy1.php
Content-type: text/html
X-Powered-By: PHP/4.3.0
<html>
<head>
<title>PHP Test</title>
</head>
<body>
<p>Point 1</p>fubarPoint1.5
<p>PilotProjects</p>pgsql linkPoint 2
Brown County
</body>
</html>
Which is what I expected.
Can anyone help me with this? Is this a problem with Apache? With php? With
something
else?
Any help will be greatly appreciated!
dwb
===
My configuration:
Slackware Linux w / 2.4.18 kernel
Apache:
root@galadriel:/etc/apache# httpd -V
Server version: Apache/1.3.26 (Unix)
Server built: Jun 19 2002 05:51:45
Server's Module Magic Number: 19990320:13
Server compiled with....
-D EAPI
-D HAVE_MMAP
-D HAVE_SHMGET
-D USE_SHMGET_SCOREBOARD
-D USE_MMAP_FILES
-D HAVE_FCNTL_SERIALIZED_ACCEPT
-D HAVE_SYSVSEM_SERIALIZED_ACCEPT
-D SINGLE_LISTEN_UNSERIALIZED_ACCEPT
-D HTTPD_ROOT="/usr"
-D SUEXEC_BIN="/usr/sbin/suexec"
-D DEFAULT_PIDLOG="/var/run/httpd.pid"
-D DEFAULT_SCOREBOARD="/var/run/httpd.scoreboard"
-D DEFAULT_LOCKFILE="/var/run/httpd.lock"
-D DEFAULT_ERRORLOG="/var/log/apache/error_log"
-D TYPES_CONFIG_FILE="/etc/apache/mime.types"
-D SERVER_CONFIG_FILE="/etc/apache/httpd.conf"
-D ACCESS_CONFIG_FILE="/etc/apache/access.conf"
-D RESOURCE_CONFIG_FILE="/etc/apache/srm.conf"
php:
root@galadriel:/etc/apache# php -v
PHP 4.3.0 (cgi), Copyright (c) 1997-2002 The PHP Group
Zend Engine v1.3.0, Copyright (c) 1998-2002 Zend Technologies
--------------------------------------------------------
David W. Brunberg
Engineering Supervisor - Field Process
The F.B. Leopold Company, Inc.
227 South Division Street
Zelienople PA 16063
(724) 452-6300
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
