[PHP-DB] php 5.2.9 and Postgres 8.3.7
Hello, I tried all day yesterday to setup a brand new machine with a fresh Linux install; with apache 2.2.10 (from source) php 5.2.9 (from source) and PostgresQL 8.3.7 (from the very neat one-click installer provided by Enterprisedb) ; everything compiles and installs fine but when trying to run the first query to my database I consistently get a message about pg_escape_string function missing. I am connecting through ADODB which filters any query via '.pg_escape_string($this-_connectionID,$s).'; I had no problem using the same build with php 5.2.8 and Postgres 8.3.4, so I ended up using the mod_php5.so module for apache build with these versions, but would like to get to the bottom of it. Any idea or comment ? Didier -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Postgres query failing, not enough info for debugging...
On 16 June 2009 15:57, Carol Walter advised: Hello, I'm using PHP 5 and PostgreSQL 8.3.6. I have a query that is failing and I don't know how to troubleshoot the problem. The error message that it is giving is quite vague. The error message is as follows: Warning: pg_query_params() [function.pg-query-params]: Query failed: ERROR: syntax error at end of input at character 156 in /home/walterc/ ssl/PHP/km_input_test2c.php on line 631 ERROR: syntax error at end of input at character 156 The query that is failing looks like this... $pg_pres_ins6 = pg_query_params(INSERT INTO \brdgMediaCallsEvents \ (\mediumId\, \eventId\, rank) VALUES ((currval('\tblMedia_mediumId_seq\'), (currval('\tblCallsEvents_eventId_seq\'), $1), array($ev_rank)); echo pg_last_error($pg_connection); You have 2 more opening parentheses than close parentheses in that SQL -- in both cases, the parenthesis immediately preceding currval should be omitted. Also, to ameliorate your quote hell, you might consider using a heredoc (http://php.net/manual/language.types.string.php#language.types.string.s yntax.heredoc) for this: $pg_pres_ins6 = pg_query_params(SQL INSERT INTO brdgMediaCallsEvents (mediumId, eventId, rank) VALUES (currval('tblMedia_mediumId_seq'), currval('tblCallsEvents_eventId_seq'), $1) SQL , array($ev_rank)); Cheers! Mike -- Mike Ford, Electronic Information Developer, C507, Leeds Metropolitan University, Civic Quarter Campus, Woodhouse Lane, LEEDS, LS1 3HE, United Kingdom Email: m.f...@leedsmet.ac.uk Tel: +44 113 812 4730 To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] php 5.2.9 and Postgres 8.3.7
Do you have postgres module for PHP installed? This will probably be the cause. Didier Gasser-Morlay napsal(a): Hello, I tried all day yesterday to setup a brand new machine with a fresh Linux install; with apache 2.2.10 (from source) php 5.2.9 (from source) and PostgresQL 8.3.7 (from the very neat one-click installer provided by Enterprisedb) ; everything compiles and installs fine but when trying to run the first query to my database I consistently get a message about pg_escape_string function missing. I am connecting through ADODB which filters any query via '.pg_escape_string($this-_connectionID,$s).'; I had no problem using the same build with php 5.2.8 and Postgres 8.3.4, so I ended up using the mod_php5.so module for apache build with these versions, but would like to get to the bottom of it. Any idea or comment ? Didier -- S pozdravem Daniel Tlach Freelance webdeveloper Email: m...@danaketh.com ICQ: 160914875 MSN: danak...@hotmail.com Jabber: danak...@jabbim.cz -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] What is SAPI?
Dear Sir/Madam, SilkWise.com is a popular question answer website. Some of our users asked the above question, and we think you are the domain expert who can provide a great answer to it. Can you help to answer the question or improve the current answer at the following link? http://www.silkwise.com/content/viewthread_thread,7748 Everyone has unique expertise. SilkWise is the place to share your wisdom, build your networks, and market yourself! SilkWise Team To stop future messages from me, visit http://silkwise.com/content/viewthread_thread,6667 contact PO BOX 36092 Milpitas,CA -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] php 5.2.9 and Postgres 8.3.7
Lester, Sorry, I should have said: Yes: Postgres is up running happily on the machine yes : Postgres is listed in phpinfo; with the correct version; php was connecting fine to the dababase, this message only happens on the 1st query which is when the function pg_escape_string is called. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] php 5.2.9 and Postgres 8.3.7
Lester, Sorry, I should have said: Yes: Postgres is up running happily on the machine yes : Postgres is listed in phpinfo; with the correct version; php was connecting fine to the dababase, this message only happens on the 1st query which is when the function pg_escape_string is called. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Using a PostgreSQL refcursor.
Good morning. Is there a way to use a returned refcursor from PostgreSQL using PDO? I have scoured the web and have yet to find a good result. Here's a few things I've tried. This example simply does not work. - $database = Database::load(); // Returns a singleton object with PDO connected to the database. $sql = select my_function();; $p = $database-query($sql); $p-execute(); $result = $p-fetchAll(); $p-closeCursor(); - This example is closer but PDO complains that the cursor is already open. - $database = Database::load(); // Returns a singleton object with PDO connected to the database. $sql = BEGIN; select my_function('my_refcursor'); FETCH ALL from 'my_refcursor';; $p = $database-query($sql); $p-execute(); $result = $p-fetchAll(); $p-closeCursor(); - Matthew Hartman Programmer/Analyst Information Management, ICP Kingston General Hospital (613) 549- x4294 .now. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php