Обсуждение: select * from table not showing everything

Поиск
Список
Период
Сортировка

select * from table not showing everything

От
Richard Dunne
Дата:
I am using a php script via an xmlhttprequest to insert data into a postgresql table from a php web page form.  before
submittingthe form data, I had 1 entry in my table.  after submitting the form data, I ran a select * from table query
whichdeclared there were 2 entries in the table, but it only displayed the original entry.  Is this a know issue?  If
thisis 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

Re: select * from table not showing everything

От
John DeSoi
Дата:
On Apr 28, 2007, at 10:09 AM, Richard Dunne wrote:

> $result=pg_query($connect, "insert into customer values
> ('$customer_name', '$customer_address', '$customer_contact_no')");

Are these really the first columns in the customer table? If not, you
need to specify the target columns in the insert, e.g.

insert into customer (customer_name, customer_address,
customer_contact_no) values ('$customer_name', '$customer_address',
'$customer_contact_no')

Even if these are the first columns, it is not a good idea to leave
the column specs out since your code will break if you change the
table in an incompatible way.





John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL