Re: [PHP-DB] PDO and PostgreSQL - RAISE NOTICE

Samuel ROZE wrote: Hi, Thanks for your reply. In fact, my request returns a result which i get with the fetch method. But, it must returns other informations, which are not in the result... This informations are neturned before the result in console... So, i don't know how I can get that.

Re: [PHP-DB] Need help in triggers

What are you really want to do ? This is an exemple: CREATE FUNCTION myfunction () RETURNS trigger AS $$ BEGIN NEW.update_date = 'now'::date; RETURN NEW; END; $$ LANGUAGE plpgsql; CREATE TRIGGER set_update_date AFTER INSERT ON matable FOR EACH ROW EXECUTE PROCEDURE myfunction();

Re: [PHP-DB] PDO and PostgreSQL - RAISE NOTICE

Thanks a lot ! I'm now understanding why PDO exists.. It is not for replace the actual PostgreSQL/MySQL/SQLite/Firebird/... PHP drivers but for help to developp with many DB with one code. Well... I can developp an extension to PDO PostgreSQL driver, is that correct ? It may help many users like

[PHP-DB] Sorting MYSQL results Paging and column heads

Hi All, I am working on a PHP page to display results from a MySQL db and I am having a problem getting my results to page properly. When the page loads, it looks fine, but hitting next/previous does not change the data? Any thoughts appreciated - Edward Ebrooathealthydirectionsdotcom

[PHP-DB] PDO PgSQL: _pdo_pgsql_notice

Hi ! I'm reading the source of PDO PostgreSQL driver and i see that there's an empty function, _pdo_pgsql_notice, which is very interesting ! I think that it is used when PostgreSQL throw Notices. But, nothing is done... I want to know if somebody know why the content of the function is

Re: [PHP-DB] PDO PgSQL: _pdo_pgsql_notice

To use PostgreSQL's Notices with PDO, i'm modifying the source for trying to store into errmsg (which I can get with PDO::errorInfo) the notice. The _pdo_pgsql_notice function is called everytime that there's an notice. The notice message is in the message var. This what i had tried:

Re: [PHP-DB] Sorting MYSQL results Paging and column heads

Edward Brookhouse wrote: Hi All, I am working on a PHP page to display results from a MySQL db and I am having a problem getting my results to page properly. When the page loads, it looks fine, but hitting next/previous does not change the data? snip db_connect_ecelerity(DBUSER,

Re: [PHP-DB] PDO PgSQL: _pdo_pgsql_notice

Samuel ROZE wrote: To use PostgreSQL's Notices with PDO, i'm modifying the source for trying to store into errmsg (which I can get with PDO::errorInfo) the notice. The _pdo_pgsql_notice function is called everytime that there's an notice. The notice message is in the message var. This what i