pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Richard Dunne <richarddunne1971@yahoo.com>
To: pgsql-php@postgresql.org
Subject: Fw: select * from table not showing everything
Date: Sat, 28 Apr 2007 13:45:11 -0700 (PDT)
Message-ID: <209777.36134.qm@web50311.mail.re2.yahoo.com> (raw)

I am still at a loss.  I deleted everything from the table using 
delete from table;
I then added a row using the php method with the php webpage.  I then checked the table with 
select * from table;

this being the result


 name | address | contact_no 
------+---------+------------
      |         | 
(1 row)

As you can see its detecting an entry in the table but it is not displaying the entry.
Can anyone advise?  I am only geussing at a configuration problem?

Richard.

----- Forwarded Message ----
From: Richard Dunne <richarddunne1971@yahoo.com>
To: pgsql-php@postgresql.org
Sent: Saturday, April 28, 2007 3:09:14 PM
Subject: select * from table not showing everything


I am using a php script via an xmlhttprequest to insert data into a postgresql table from a php web page form.  before submitting the form data, I had 1 entry in my table.  after submitting the form data, I ran a select * from table query which declared there were 2 entries in the table, but it only displayed the original entry.  Is this a know issue?  If this is not the corect forum for this post, please advise.

This is the code.  

php web page

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<? include("http://localhost/Databases/getCustomers.php";;) ?>
<HTML>
<HEAD>
  <TITLE> ALLIED AUTO PARTS </TITLE>
  <meta http-equiv="content-type" content="text/xml; charset=iso-8859-1">
  <META NAME="Generator" CONTENT="EditPlus">
  <META NAME="Author" CONTENT="">
  <META NAME="Keywords" CONTENT="">
  <script language="JavaScript">
function Customers()
{ 
var url="http://localhost/Project/customers.php";;; 
if(window.XMLHttpRequest)
http = new XMLHttpRequest(); 
else if (window.ActiveXObject)
http  = new ActiveXObject(Microsoft.XMLHTTP); 
http.onreadystatechange = function()
{ 
alert(http.readyState);
if(http.readyState == 4)
{
alert(http.status)
if(http.status == 200)
{
response = http.responseText;
alert(response);
}    
else    
{
// + " " + http.statusText;
alert(http.status);
}    
} 
}
http.open("GET", url, true); 
http.setRequestHeader("text"); 
http.send(null); 
} 
</script>
  </HEAD>
    <BODY>
<p align="center">
<form action="viewCustomer.php">
<input type="button" value="View Customers" onclick="return Customers();" />
</form>
<script type="text/javascript" language="javascript">
var numfields;
var numrows;
function viewCustomers()
{
  document.write('<tr>');
  for (i=0; i < numfields; i++)
   {
   document.write('<td>' + fieldname[i] + '</td>');
   }
  document.write('</tr>');
}
for (i=0; i < numrows; i++)
  {
  document.write('<tr>');
  for (j=0; j < numfields; j++)
   {
   document.write('<td>' + customers[i][j] + '</td>');
   }
  document.write('</tr>');
   }
</script>
<p>
<p>
<TABLE align="center">
<TR>
<TD align="center" colspan="6"><H3>Choose from the following funtions</H3></TD>
</TR>
<TR>
<TD><a href="ViewParts.php">View Parts</a></TD>
<TD><a href="Purchases.php">Purchases</a></TD>
<TD><a href="Sales.php">Sales</a></TD>
<TD><a href="UpdateParts.php">Add parts</a></TD>
<TD><a href="UpdateCustomer.php">Update Customer</a></TD>
<TD><a href="UpdateSupplier.php">Update Supplier</a></TD>
</TR>
</TABLE>
</BODY>
</HTML>


php script for inserting form data

<?php 
$connect=pg_connect("dbname=DatabaseName host=localhost user=User password=password");
if (!pg_connection_busy($connect))
{
$result=pg_query($connect, "insert into customer values('$customer_name', '$customer_address', '$customer_contact_no')");
}
echo "New customer added";
?>

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 



view thread (4+ messages)  latest in thread

Message-ID: <209777.36134.qm@web50311.mail.re2.yahoo.com>
Permalink:  ../209777.36134.qm@web50311.mail.re2.yahoo.com/
Also on:    postgresql.org/message-id/209777.36134.qm@web50311.mail.re2.yahoo.com

 · 

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: richarddunne1971@yahoo.com
  Subject: Re: Fw: select * from table not showing everything
  In-Reply-To: <209777.36134.qm@web50311.mail.re2.yahoo.com>
  References: <209777.36134.qm@web50311.mail.re2.yahoo.com>

* 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