0
<?php
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
/*
// Create database

if (mysql_query("CREATE DATABASE admin",$con))
  {
  echo "Database created";
  }
else
  {
  echo "Error creating database: " . mysql_error();
  }
*/

/*
 CREATE TABLE `admin`.`payment_invoice` (
`CompanyName` VARCHAR( 100 ) NOT NULL ,
`InvoiceNo.` INT( 5 ) NOT NULL ,
`Address` VARCHAR( 100 ) NOT NULL ,
`InvoiceDate` DATE NOT NULL ,
`Item` VARCHAR( 100 ) NOT NULL ,
`Description` VARCHAR( 20 ) NOT NULL ,
`Rate` INT( 20 ) NOT NULL ,
`Qty` VARCHAR( 100 ) NOT NULL ,
`Unit` INT( 20 ) NOT NULL ,
`Price` INT( 20 ) NOT NULL ,
`Amount` INT( 20 ) NOT NULL ,
`ServiceTaxRegNo` INT( 20 ) NOT NULL ,
`AmountTotal` INT( 20 ) NOT NULL ,
`PanNo.` INT( 20 ) NOT NULL ,
`ServiceTax` INT( 20 ) NOT NULL ,
`CategoryOfServices` VARCHAR( 100 ) NOT NULL ,
`EducationCess` INT( 20 ) NOT NULL ,
`SecondaryEducationCess` INT( 20 ) NOT NULL,
`ShareOfClame` INT( 20 ) NOT NULL ,
`TotalValue` VARCHAR( 100 ) NOT NULL ,
`InInteger` INT( 10 ) NOT NULL ,
`CheckedBy` VARCHAR( 100 ) NOT NULL ,
`VerifiedBy` VARCHAR( 100 ) NOT NULL ,
`ForBusinessPartner` VARCHAR( 100 ) NOT NULL ,
`ApprovedBy` VARCHAR( 100 ) NOT NULL ,
`AuthorisedSignatory` VARCHAR( 100 ) NOT NULL
) ENGINE = InnoDB 

*/



mysql_query($sql,$con);

mysql_select_db("admin", $con);

 $sql = "INSERT INTO `payment_invoice` (`CompanyName`, `InvoiceNo.`, `Address`, `InvoiceDate`, `Item`, `Description`, `Rate`, `Qty`, `Unit`, `Price`, `Amount`, `ServiceTaxRegNo`, `AmountTotal`, `PanNo.`, `ServiceTax`, `CategoryOfServices`, `EducationCess`, `SecondaryEducationCess`, `ShareOfClame`, `TotalValue`, `InInteger`, `CheckedBy`, `VerifiedBy`, `ForBusinessPartner`, `ApprovedBy`, `AuthorisedSignatory`) VALUES ('$_POST[fname4]','$_POST[fname422]','$_POST[comments]','$_POST[fname42]','$_POST[fname423]','$_POST[fname424]','$_POST[fname425]','$_POST[fname426]','$_POST[fname427]','$_POST[fname428]','$_POST[fname4282]''$_POST[fname43]','$_POST[fname47]''$_POST[fname44]','$_POST[fname48]','$_POST[fname45]','$_POST[fname49]','$_POST[fname410]','$_POST[fname452]','$_POST[fname4102]','$_POST[fname41025]','$_POST[fname41022]''$_POST[fname41023]''$_POST[fname41024]','$_POST[fname410232]','$_POST[fname410252]')";





if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "Congrats! You hav Sucessfully Submitted your information";


$result = mysql_query("SELECT * FROM payment_invoice");

echo "<table border='1'>
<tr>
<th>CompanyName</th>
<th>InvoiceNo</th>
<th>Address</th>
<th>InvoiceDate</th>
<th>Item</th>
<th>Description</th>
<th>Rate</th>
<th>Qty</th>
<th>unit</th>
<th>Price</th>
<th>Amount</th>
<th>ServiceTaxRegNo</th>
<th>AmountTotal</th>
<th>PanNo.</th>
<th>ServiceTax</th>
<th>CategoryOfServices</th>
<th>EducationCess</th>
<th>SecondaryEducationCess</th>
<th>ShareOfClame</th>
<th>TotalValue</th>
<th>InInteger</th>
<th>CheckedBy</th>
<th>VerifiedBy</th>
<th>ForBusinessPartner</th>
<th>ApprovedBy</th>
<th>AuthorisedSignatory</th>
</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['CompanyName'] . "</td>";
  echo "<td>" . $row['InvoiceNo'] . "</td>";
  echo "<td>" . $row['Address'] . "</td>";
  echo "<td>" . $row['InvoiceDate'] . "</td>";
  echo "<td>" . $row['Item'] . "</td>";
  echo "<td>" . $row['Description'] . "</td>";
  echo "<td>" . $row['Rate'] . "</td>";
  echo "<td>" . $row['Qty'] . "</td>";
  echo "<td>" . $row['unit'] . "</td>";
  echo "<td>" . $row['Price'] . "</td>";
  echo "<td>" . $row['Amount'] . "</td>";
  echo "<td>" . $row['ServiceTaxRegNo'] . "</td>";
  echo "<td>" . $row['AmountTotal'] . "</td>";
  echo "<td>" . $row['PanNo.'] . "</td>";
  echo "<td>" . $row['ServiceTax'] . "</td>";
  echo "<td>" . $row['CategoryOfServices'] . "</td>";
  echo "<td>" . $row['EducationCess'] . "</td>";
  echo "<td>" . $row['SecondaryEducationCess'] . "</td>";
  echo "<td>" . $row['ShareOfClame'] . "</td>";
  echo "<td>" . $row['TotalValue'] . "</td>";
  echo "<td>" . $row['InInteger'] . "</td>";
  echo "<td>" . $row['CheckedBy'] . "</td>";
  echo "<td>" . $row['VerifiedBy'] . "</td>";
  echo "<td>" . $row['ForBusinessPartner'] . "</td>";
  echo "<td>" . $row['ApprovedBy'] . "</td>";
  echo "<td>" . $row['AuthorisedSignatory'] . "</td>";
    echo "</tr>";
  }
echo "</table>";

mysql_close($con);
?>

Edited by nav33n: Please use [code][/code] tags to wrap your code for easy readability.

5
Contributors
4
Replies
5
Views
7 Years
Discussion Span
Last Post by diafol
0

Hi gurinder16 and welcome to DaniWeb :)

Looks to me like you are missing one or more commas in the values section of your query. Count your columns, then count the items you are inserting - these need to be equal as your error message implies.

1

darkagn is correct, looks like you are missing multiple commas in the values of the query.

Also, may I suggest that you sanitize the input from the form.. Entering unchecked POST data into your database is asking for trouble.

0

darkagn is correct, looks like you are missing multiple commas in the values of the query.

Also, may I suggest that you sanitize the input from the form.. Entering unchecked POST data into your database is asking for trouble.

Asking? Positively inviting! Mwahahaahaaa.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.