Eric,
I've got my PHP running fine with PostGreSQL inthe past couple of weeks.
Here is a page that pulls out current members from my club roster and
displays some directory information in a table. I'm kinda proud of the
recursive (ir is it re-iterative?) sections. (Page edited to delete
impertinent identifying data.)
Don't forget to grant the Apache server (user www) select access to your
database or explicitly log in with a valid PostGreSQL user name.
Cheers,
Gary
----------------
<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 3.2//EN\">
<HTML><HEAD><TITLE>CGSSD Member Directory</TITLE></HEAD><BODY
TEXT="#000000" BGCOLOR="#E7E7EF" LINK="#0000EE" VLINK="#551A8B"
ALINK="#FF0000">
<H1 ALIGN=CENTER>Member Directory</H1>
<font size=4>CGSSD membership information is current as of June 1999. This
directory is for the non-commercial use of its members only. Any other use
is <u>prohibited</u>.<p>
<p>Please wait for directory to load.<br>
<?php
flush();
if (!$conn = pg_Connect("","","","","cgssd_members")){
echo "Error! Can't connect to database.";
exit;
}
$query = "select * from memdir4 where status = 'A' order by lower(lname),
lower(fname)";
if (!$result = pg_exec($conn, $query)){
echo "Error while processing query.<br>";
pg_close($conn);
exit;
}
$rows = pg_NumRows($result);
echo "$rows members in directory!\n";
# the non-breaking space is the best way I could find to control column
widths
echo "<p><p><table border=1 cellpadding=3><tr><th
width=200> Name &n
bsp; </th>\n";
echo "<th width=80>Phone</th><th
width=30> Program </th><th
width=100>E-Mail Address</th><th>Web Page</th></tr><p>\n";
for ($j=0; $j < $rows; $j++) {
$member = pg_result($result, $j, 0) . ", " . pg_result($result, $j, 1);
echo "<tr><td>" . $member . "</td>\n";
if (!pg_result($result, $j, 2) or !pg_result($result, $j, 3) or
!pg_result($result, $j, 4)) {
echo "<td> </td>";
}
else {
echo "<td>" . pg_result($result, $j, 2) . "-" . pg_result($result, $j, 3)
."-" . pg_result($result, $j, 4) ."</td>\n";
}
if (!pg_result($result, $j, 5)) {
echo "<td> </td>";
}
else {
echo "<td>" . pg_result($result, $j, 5) . "</td>\n";
}
if (!pg_result($result, $j, 6)) {
echo "<td> </td>";
}
else {
echo "<td><a href=mailto:\"" . pg_result($result, $j, 6) . "\">" .
pg_result($result, $j, 6) ."</a></td>\n";
}
if (!pg_result($result, $j, 7)) {
echo "<td> </td>";
}
else {
echo "<td><a href=http://\"" . pg_result($result, $j, 7) . "\">" .
pg_result($result, $j, 7) ."</a></td>\n";
}
}
echo "</tr></table>";
?>
</body></HTML>
---------------------
ehb@one.net writes:
>I downloaded and compiled the most recent version of PHP and Apache.
>The PHP module functions properly when parsing commands such as
>echo and variable declarations. However when I submit a query through
>pg_exec and try to display the results using pg_Fetch_Array, I get
>"Document
>Contains No Data." I followed the instructions provided by PHP to test
>for
>segmentation fault and have come to the conclusion that when
>PHP attempts
>to post the query to the database, it blows up in segmentation fault.
>
>Does PHP work with Postgresql 6.5.1 at this time?
>
>Please reply to this list as well as my personal email account as soon
>as possible.
>
>Thank you!
>
>Eric Buschelmann
>Systems Analyst
>ehb@one.net
**************************************************************************
* Gary B. Hoffman, Computing Services Manager e-mail: ghoffman@ucsd.edu *
* Graduate School of International Relations and Pacific Studies (IR/PS) *
* University of California, San Diego (UCSD) voice: (858) 534-1989 *
* 9500 Gilman Dr., La Jolla, CA 92093-0519 USA fax: (858) 534-3939 *
**************************************************************************