pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
(no subject)
4+ messages / 4 participants
[nested] [flat]

* (no subject)
@ 2002-04-17 21:03 Hillensbeck, Preston <PHillensbeck@sfbcic.com>
  2002-04-17 21:18 ` Re: Cornelia Boenigk <poppcorn@cornelia-boenigk.de>
  2002-04-17 21:28 ` Re: Chadwick Rolfs <cmr@shell.gis.net>
  2002-04-18 08:25 ` Re: what to do if a query fails Papp, Gyozo <pgerzson@freestart.hu>
  0 siblings, 3 replies; 4+ messages in thread

From: Hillensbeck, Preston @ 2002-04-17 21:03 UTC (permalink / raw)
  To: pgsql-php

I am currently experiencing a problem passing data from a PHP page to
PostgreSQL. 

 I am passing different data types like numeric, and text.  Let me show you
some of the code I am using....

This is the code that I am using to pass the input data to a page called
"checkbook2.php"

<form action="checkbook2.php" method="GET">
  <p align="center">Check Date
    <input type="text" name="check_date" VALUE="">
    Check Number
    <input type="text" name="check_number" VALUE="">
    Check Payee
    <input type="text" name="check_payee" VALUE="">
    Check Amount
    <input type="text" name="check_amount" VALUE="">
  </p>
  <p align="center">Check Transaction Type
    <input type="text" name="check_trans_type" VALUE="">
  </p>
  <input type=submit value="Add New Entry">
  </form>

This is the data from the checkbook2.php that talks to the PostgreSQL
Server.  It is running version 7.2.

$conn=pg_connect("host=192.168.0.2 user=postgres password=postgres
dbname=checkbook");

@$sql="INSERT INTO checking VALUES('$check_date', '$check_num',
'$check_pay', '$check_amount', '$check_trans_type');";

$result=pg_exec($conn, $sql);

check_data is type text
check_num is type int4
check_pay is type text
check_amount is type numeric(8,2)
check_trans_type is type text

The error that comes up is ...
Warning: PostgreSQL query failed: ERROR: Bad numeric input format
'check_trans_type' in /etc/httpd/htdocs/checkbook2.php on line 41

Anyone know what could be going on here??  Please let me know, thanks in
advance! :)





^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re:
  2002-04-17 21:03 (no subject) Hillensbeck, Preston <PHillensbeck@sfbcic.com>
@ 2002-04-17 21:18 ` Cornelia Boenigk <poppcorn@cornelia-boenigk.de>
  2 siblings, 0 replies; 4+ messages in thread

From: Cornelia Boenigk @ 2002-04-17 21:18 UTC (permalink / raw)
  To: pgsql-php

Hi Preston

@$sql="INSERT INTO checking VALUES('$check_date', '$check_num',
'$check_pay', '$check_amount', '$check_trans_type');";

Try your INSERT without '' around '$check_amount'. The quotes are only
used for character-types but not for numeric data.

Regards
Conni




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re:
  2002-04-17 21:03 (no subject) Hillensbeck, Preston <PHillensbeck@sfbcic.com>
@ 2002-04-17 21:28 ` Chadwick Rolfs <cmr@shell.gis.net>
  2 siblings, 0 replies; 4+ messages in thread

From: Chadwick Rolfs @ 2002-04-17 21:28 UTC (permalink / raw)
  To: Hillensbeck, Preston <PHillensbeck@sfbcic.com>; +Cc: pgsql-php

On Wed, 17 Apr 2002, Hillensbeck, Preston wrote:

>     <input type="text" name="check_trans_type" VALUE="">

> 
> @$sql="INSERT INTO checking VALUES('$check_date', '$check_num',
> '$check_pay', '$check_amount', '$check_trans_type');";

> check_trans_type is type text
> 
> The error that comes up is ...
> Warning: PostgreSQL query failed: ERROR: Bad numeric input format
> 'check_trans_type' in /etc/httpd/htdocs/checkbook2.php on line 41
> 

POST_VARS should always be strings.  Have you tried this without the php,
as in psql.  What happens when you replace, in the insert statement,
$check_trans_type, with a correct value?  Is it supposed to be like
withdrawl, deposit...etc?
Good luck


Chadwick Rolfs - cmr@gis.net
Cleveland State University - Student
Music Major - The Holden Arboretum Volunteer
Computer Programmer - Student Employee
--*I finally found powdered water;
I just can't figure out what to add to it*--




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: what to do if a query fails
  2002-04-17 21:03 (no subject) Hillensbeck, Preston <PHillensbeck@sfbcic.com>
@ 2002-04-18 08:25 ` Papp, Gyozo <pgerzson@freestart.hu>
  2 siblings, 0 replies; 4+ messages in thread

From: Papp, Gyozo @ 2002-04-18 08:25 UTC (permalink / raw)
  To: Hillensbeck, Preston <PHillensbeck@sfbcic.com>; pgsql-php

Hi,

I summarized what to do if a query fails. It's advisable to:

    + var_dump() all variables ($connection, $query and all used in $query)
    + log your queries to see what postgres tries to do
    + check the table definition
    + use explicit column list in INSERT 
    (even so, future pg release may not support abbreviated INSERT syntax)
   
and some additional notes not related to the original topic:

| $conn=pg_connect("host=192.168.0.2 user=postgres password=postgres
| dbname=checkbook");

    + do not connect in to postgres as superuser!
    + escape and quote all user input sent to database backend! 
    (consider using addslashes(), sprintf(), etc.)

For detailed information visit:
http://www.php.net/manual/en/security.database.php 
   


----- Original Message ----- 
From: "Hillensbeck, Preston" <PHillensbeck@sfbcic.com>
To: <pgsql-php@postgresql.org>
Sent: Wednesday, April 17, 2002 11:03 PM
Subject: [PHP] 


| I am currently experiencing a problem passing data from a PHP page to
| PostgreSQL. 
| 
|  I am passing different data types like numeric, and text.  Let me show you
| some of the code I am using....
| 
| This is the code that I am using to pass the input data to a page called
| "checkbook2.php"
| 
| <form action="checkbook2.php" method="GET">
|   <p align="center">Check Date
|     <input type="text" name="check_date" VALUE="">
|     Check Number
|     <input type="text" name="check_number" VALUE="">
|     Check Payee
|     <input type="text" name="check_payee" VALUE="">
|     Check Amount
|     <input type="text" name="check_amount" VALUE="">
|   </p>
|   <p align="center">Check Transaction Type
|     <input type="text" name="check_trans_type" VALUE="">
|   </p>
|   <input type=submit value="Add New Entry">
|   </form>
| 
| This is the data from the checkbook2.php that talks to the PostgreSQL
| Server.  It is running version 7.2.
| 
| $conn=pg_connect("host=192.168.0.2 user=postgres password=postgres
| dbname=checkbook");
| 
| @$sql="INSERT INTO checking VALUES('$check_date', '$check_num',
| '$check_pay', '$check_amount', '$check_trans_type');";
| 
| $result=pg_exec($conn, $sql);
| 
| check_data is type text
| check_num is type int4
| check_pay is type text
| check_amount is type numeric(8,2)
| check_trans_type is type text
| 
| The error that comes up is ...
| Warning: PostgreSQL query failed: ERROR: Bad numeric input format
| 'check_trans_type' in /etc/httpd/htdocs/checkbook2.php on line 41
| 
| Anyone know what could be going on here??  Please let me know, thanks in
| advance! :)
| 
| 
| 
| ---------------------------(end of broadcast)---------------------------
| TIP 2: you can get off all lists at once with the unregister command
|     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)




^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2002-04-18 08:25 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-04-17 21:03  Hillensbeck, Preston <PHillensbeck@sfbcic.com>
2002-04-17 21:18 ` Re: Cornelia Boenigk <poppcorn@cornelia-boenigk.de>
2002-04-17 21:28 ` Re: Chadwick Rolfs <cmr@shell.gis.net>
2002-04-18 08:25 ` Re: what to do if a query fails Papp, Gyozo <pgerzson@freestart.hu>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox