PHP & Postgres - query not writing to database.

Hello,

I have a PHP program that contains a number of postgres queries. At
the end of the program, it needs to write data to a database. You can
see the code that I'm using below. I have "die" clauses on all the
queries and I have the program echoing the queries that it runs to the
screen. The "die" clause does not execute. The queries are echoed to
the screen, but nothing is being written to the database. There don't
appear to be any errors in the postgres log or the php log. Is there
a function that I can use that will tell me exactly what is going on
here? If there is, can you give me the syntax?

Thanks in advance for your time.

Carol

P.S. This PHP 5 and PostgreSQL 8.3.6 on Solaris 10.

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ +++++++++++
+++++++++++++++
I've written a query that needs to insert data into two base tables
and a bridge table. The code looks like...

/* Echo data for database to the screen */
echo"

Contact Locator: $cont_loc

Contact Type Rank: $cont_rank

Contact Info Type: $contact_type

New name string: $f_name_new

New name string: $m_name_new

New name string: $l_name_new

New ivl web string: $ivl_web_peop

New cns_web string: $cns_web_peop

New contact rank string: $cont_rank

New contact locator string: $cont_loc

New contact item string: $contact_info1

New contact type string: $contact_type

Re: PHP & Postgres - query not writing to database.

--------------070905040706010809090401
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

I'd suggest you to copy the echoed queries and run them directly in
terminal (if you have access). Also if you have remote access to the
database and can use tools like pgAdmin or Navicat, that could help you
with testing. Or send me the table structure and I'll try them myself ;)

Carol Walter napsal(a):
> Hello,
>
> I have a PHP program that contains a number of postgres queries. At
> the end of the program, it needs to write data to a database. You can
> see the code that I'm using below. I have "die" clauses on all the
> queries and I have the program echoing the queries that it runs to the
> screen. The "die" clause does not execute. The queries are echoed to
> the screen, but nothing is being written to the database. There don't
> appear to be any errors in the postgres log or the php log. Is there
> a function that I can use that will tell me exactly what is going on
> here? If there is, can you give me the syntax?
>
> Thanks in advance for your time.
>
> Carol
>
> P.S. This PHP 5 and PostgreSQL 8.3.6 on Solaris 10.
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++
>
> I've written a query that needs to insert data into two base tables
> and a bridge table. The code looks like...
>
> /* Echo data for database to the screen */
> echo"

Contact Locator: $cont_loc

Contact Type Rank: $cont_rank

Contact Info Type: $contact_type

New name string: $f_name_new

New name string: $m_name_new

New name string: $l_name_new

New ivl web string: $ivl_web_peop

New cns_web string: $cns_web_peop

New contact rank string: $cont_rank

New contact locator string: $cont_loc

New contact item string: $contact_info1

New contact type string: $contact_type

Re: PHP & Postgres - query not writing to database.

--Apple-Mail-5--374287055
Content-Type: text/plain;
charset=US-ASCII;
format=flowed;
delsp=yes
Content-Transfer-Encoding: 7bit

I have copied the queries into psql and wrapped them in a BEGIN and
COMMIT. Even from psql the queries appear to work but don't store the
information. There don't appear to be errors in the log either.

Thanks for your help,

Carol

km_tezt=# begin;
BEGIN
km_tezt=# INSERT INTO "tblPeople"("fName","mName","lName", ivlweb,
cnsweb) VALU
ES ('Frank', 'D',' Oz', 't', 't');
INSERT 0 1
km_tezt=# INSERT INTO
"tblContactInformation"("contactItem","contactType") VALU
ES ('foz@indiana.edu','0010');
INSERT 0 1
km_tezt=# INSERT INTO
"brdgPeopleContactInformation" ("peopleId","contactInform
ationId",rank, type) VALUES
(currval('"tblPeople_peopleId_seq"'),currval('"tblC
ontactInformation_contactInformationId_seq"'), '1', '100');
INSERT 0 1
km_tezt=# commit;
COMMIT
km_tezt=# select * from "tblPeople" where "lName" like 'O%';
peopleId | fName | mName | lName | ivlweb | cnsweb
----------+---------+-------+--------+--------+--------
404 | Ilka | | Ott | t | t
410 | Elinor | | Ostrom | t | t
374 | Gregory | | O'Hare | t | t
33 | Terry | J. | Ord | t | t
(4 rows)

On May 10, 2009, at 4:41 AM, danaketh wrote:

> I'd suggest you to copy the echoed queries and run them directly in
> terminal (if you have access). Also if you have remote access to the
> database and can use tools like pgAdmin or Navicat, that could help
> you with testing. Or send me the table structure and I'll try them
> myself ;)
>
> Carol Walter napsal(a):
>>
>> Hello,
>>
>> I have a PHP program that contains a number of postgres queries.
>> At the end of the program, it needs to write data to a database.
>> You can see the code that I'm using below. I have "die" clauses on
>> all the queries and I have the program echoing the queries that it
>> runs to the screen. The "die" clause does not execute. The
>> queries are echoed to the screen, but nothing is being written to
>> the database. There don't appear to be any errors in the postgres
>> log or the php log. Is there a function that I can use that will
>> tell me exactly what is going on here? If there is, can you give
>> me the syntax?
>>
>> Thanks in advance for your time.
>>
>> Carol
>>
>> P.S. This PHP 5 and PostgreSQL 8.3.6 on Solaris 10.
>>
>> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++
>> ++++++++++++++++++
>> I've written a query that needs to insert data into two base tables
>> and a bridge table. The code looks like...
>>
>> /* Echo data for database to the screen */
>> echo"

Contact Locator: $cont_loc

Contact Type Rank: $cont_rank

Contact Info Type: $contact_type

New name string: $f_name_new

New name string: $m_name_new

New name string: $l_name_new

New ivl web string: $ivl_web_peop

New cns_web string: $cns_web_peop

New contact rank string: $cont_rank

New contact locator string: $cont_loc

New contact item string: $contact_info1

New contact type string: $contact_type

Re: PHP & Postgres - query not writing to database.

To all who helped.

Thank you very much. I found the problem. There is a leading blank
on the last name field that I couldn't see. It was coming from my
program code.

Thanks for all your help.

Carol

On May 11, 2009, at 4:23 PM, Carol Walter wrote:

> I have copied the queries into psql and wrapped them in a BEGIN and
> COMMIT. Even from psql the queries appear to work but don't store
> the information. There don't appear to be errors in the log either.
>
> Thanks for your help,
>
> Carol
>
> km_tezt=# begin;
> BEGIN
> km_tezt=# INSERT INTO "tblPeople"("fName","mName","lName", ivlweb,
> cnsweb) VALU
> ES ('Frank', 'D',' Oz', 't', 't');
> INSERT 0 1
> km_tezt=# INSERT INTO
> "tblContactInformation"("contactItem","contactType") VALU
> ES ('foz@indiana.edu','0010');
> INSERT 0 1
> km_tezt=# INSERT INTO
> "brdgPeopleContactInformation" ("peopleId","contactInform
> ationId",rank, type) VALUES
> (currval('"tblPeople_peopleId_seq"'),currval('"tblC
> ontactInformation_contactInformationId_seq"'), '1', '100');
> INSERT 0 1
> km_tezt=# commit;
> COMMIT
> km_tezt=# select * from "tblPeople" where "lName" like 'O%';
> peopleId | fName | mName | lName | ivlweb | cnsweb
> ----------+---------+-------+--------+--------+--------
> 404 | Ilka | | Ott | t | t
> 410 | Elinor | | Ostrom | t | t
> 374 | Gregory | | O'Hare | t | t
> 33 | Terry | J. | Ord | t | t
> (4 rows)
>
> On May 10, 2009, at 4:41 AM, danaketh wrote:
>
>> I'd suggest you to copy the echoed queries and run them directly in
>> terminal (if you have access). Also if you have remote access to
>> the database and can use tools like pgAdmin or Navicat, that could
>> help you with testing. Or send me the table structure and I'll try
>> them myself ;)
>>
>> Carol Walter napsal(a):
>>>
>>> Hello,
>>>
>>> I have a PHP program that contains a number of postgres queries.
>>> At the end of the program, it needs to write data to a database.
>>> You can see the code that I'm using below. I have "die" clauses
>>> on all the queries and I have the program echoing the queries that
>>> it runs to the screen. The "die" clause does not execute. The
>>> queries are echoed to the screen, but nothing is being written to
>>> the database. There don't appear to be any errors in the postgres
>>> log or the php log. Is there a function that I can use that will
>>> tell me exactly what is going on here? If there is, can you give
>>> me the syntax?
>>>
>>> Thanks in advance for your time.
>>>
>>> Carol
>>>
>>> P.S. This PHP 5 and PostgreSQL 8.3.6 on Solaris 10.
>>>
>>> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ +++++++
>>> +++++++++++++++++++
>>> I've written a query that needs to insert data into two base
>>> tables and a bridge table. The code looks like...
>>>
>>> /* Echo data for database to the screen */
>>> echo"

Contact Locator: $cont_loc

Contact Type Rank: $cont_rank

Contact Info Type: $contact_type

New name string: $f_name_new

New name string: $m_name_new

New name string: $l_name_new

New ivl web string: $ivl_web_peop

New cns_web string: $cns_web_peop

New contact rank string: $cont_rank

New contact locator string: $cont_loc

New contact item string: $contact_info1

New contact type string: $contact_type

Re: PHP & Postgres - query not writing to database.

--------------050005040409020609090602
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Glad that you found the problem :)

Carol Walter napsal(a):
> To all who helped.
>
> Thank you very much. I found the problem. There is a leading blank
> on the last name field that I couldn't see. It was coming from my
> program code.
>
> Thanks for all your help.
>
> Carol
>
> On May 11, 2009, at 4:23 PM, Carol Walter wrote:
>
>> I have copied the queries into psql and wrapped them in a BEGIN and
>> COMMIT. Even from psql the queries appear to work but don't store
>> the information. There don't appear to be errors in the log either.
>>
>> Thanks for your help,
>>
>> Carol
>>
>> km_tezt=# begin;
>> BEGIN
>> km_tezt=# INSERT INTO "tblPeople"("fName","mName","lName", ivlweb,
>> cnsweb) VALU
>> ES ('Frank', 'D',' Oz', 't', 't');
>> INSERT 0 1
>> km_tezt=# INSERT INTO
>> "tblContactInformation"("contactItem","contactType") VALU
>> ES ('foz@indiana.edu','0010');
>> INSERT 0 1
>> km_tezt=# INSERT INTO "brdgPeopleContactInformation"
>> ("peopleId","contactInform
>> ationId",rank, type) VALUES
>> (currval('"tblPeople_peopleId_seq"'),currval('"tblC
>> ontactInformation_contactInformationId_seq"'), '1', '100');
>> INSERT 0 1
>> km_tezt=# commit;
>> COMMIT
>> km_tezt=# select * from "tblPeople" where "lName" like 'O%';
>> peopleId | fName | mName | lName | ivlweb | cnsweb
>> ----------+---------+-------+--------+--------+--------
>> 404 | Ilka | | Ott | t | t
>> 410 | Elinor | | Ostrom | t | t
>> 374 | Gregory | | O'Hare | t | t
>> 33 | Terry | J. | Ord | t | t
>> (4 rows)
>>
>> On May 10, 2009, at 4:41 AM, danaketh wrote:
>>
>>> I'd suggest you to copy the echoed queries and run them directly in
>>> terminal (if you have access). Also if you have remote access to the
>>> database and can use tools like pgAdmin or Navicat, that could help
>>> you with testing. Or send me the table structure and I'll try them
>>> myself ;)
>>>
>>> Carol Walter napsal(a):
>>>>
>>>> Hello,
>>>>
>>>> I have a PHP program that contains a number of postgres queries.
>>>> At the end of the program, it needs to write data to a database.
>>>> You can see the code that I'm using below. I have "die" clauses on
>>>> all the queries and I have the program echoing the queries that it
>>>> runs to the screen. The "die" clause does not execute. The
>>>> queries are echoed to the screen, but nothing is being written to
>>>> the database. There don't appear to be any errors in the postgres
>>>> log or the php log. Is there a function that I can use that will
>>>> tell me exactly what is going on here? If there is, can you give
>>>> me the syntax?
>>>>
>>>> Thanks in advance for your time.
>>>>
>>>> Carol
>>>>
>>>> P.S. This PHP 5 and PostgreSQL 8.3.6 on Solaris 10.
>>>>
>>>> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++
>>>>
>>>> I've written a query that needs to insert data into two base tables
>>>> and a bridge table. The code looks like...
>>>>
>>>> /* Echo data for database to the screen */
>>>> echo"

Contact Locator: $cont_loc

Contact Type Rank: $cont_rank

Contact Info Type: $contact_type

New name string: $f_name_new

New name string: $m_name_new

New name string: $l_name_new

New ivl web string: $ivl_web_peop

New cns_web string: $cns_web_peop

New contact rank string: $cont_rank

New contact locator string: $cont_loc

New contact item string: $contact_info1

New contact type string: $contact_type