pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Hillensbeck, Preston <PHillensbeck@sfbcic.com>
To: 'pgsql-php@postgresql.org' <pgsql-php@postgresql.org>
Date: Wed, 17 Apr 2002 16:03:21 -0500
Message-ID: <040AE3A029B3D51181D000508BC75D0201387762@MERCURY> (raw)

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! :)





view thread (4+ messages)  latest in thread

Message-ID: <040AE3A029B3D51181D000508BC75D0201387762@MERCURY>
Permalink:  ../040AE3A029B3D51181D000508BC75D0201387762@MERCURY/
Also on:    postgresql.org/message-id/040AE3A029B3D51181D000508BC75D0201387762@MERCURY

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: PHillensbeck@sfbcic.com
  Subject: Re: 
  In-Reply-To: <040AE3A029B3D51181D000508BC75D0201387762@MERCURY>
  References: <040AE3A029B3D51181D000508BC75D0201387762@MERCURY>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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