Re: [GENERAL] PHP and Postgresql 6.5.1
От | ghoffman@ucsd.edu (Gary Hoffman) |
---|---|
Тема | Re: [GENERAL] PHP and Postgresql 6.5.1 |
Дата | |
Msg-id | fc.00249f0e003839d63b9aca0080564995.3839df@irpsbbs.ucsd.edu обсуждение исходный текст |
Список | pgsql-general |
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 * **************************************************************************
В списке pgsql-general по дате отправления: