I can't insert data to database through this code.Data alredy exist part is working but after that data not insert to the database.

This is the PHP code.
<?php error_reporting(E_ERROR|E_WARNING);

session_start();


if(isset($_POST['add'])){


$no=$_POST['txtno'];
$refer=$_POST['txtrefer'];
$amount=$_POST['txtamount'];
$state=$_POST['txtstate'];


$dblink = mysql_connect("localhost", "root", "") or die('Not able to connect to server : ' . mysql_error());
mysql_select_db("apperal",$dblink) or die('Not able to select Database : ' . mysql_error()); //hama ekakatama poduwe hadapu connection eka



$sql = "SELECT COUNT(*) AS Count FROM addnewbuyer WHERE styleno LIKE '".$no."'";
  $result = mysql_fetch_array(mysql_query($sql));
  if ($result['Count'] > 0) {
    die('alredy exist');
  }
else
{


$sql1="INSERT INTO `addnewbuyer` (`id`, `styleno`, `buyername`, `buyeraddress`, `phoneno`) VALUES (NULL, '$no', '$refer', '$amount', '$state);";




$write=(mysql_query($sql1,$dblink));

if($write){

echo "<font color='blue'>Data Added Successfully"; 
//$_SESSION['msg']=$msg;
}

else{

$msg="<font color='red'>Data Adding Failed";

$_SESSION['msg']=$msg;
}


}
}
?>

This is my form.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>


 <form id="form_322883" class="appnitro"  method="post" action="chkbyr.php">
    <div class="form_description">
     <h2> Add New Buyer</h2>


     </div>


   <table width="102%">
       <tr>
       <td height="34"><label class="description" for="txtid" value="">BuyerID</label></td>
       <td>  <input id="txtid" name="txtid" class="hidden"  type="BuyerID "  value="" /></td></tr>


         <tr>
    <td height="40"><label class="description" for="txtno">Styleno </label></td>


           <td><input id="txtno" name="txtno"  type="styleno "  value=""/></td></tr>           



         <tr>
    <td height="40"><label class="description" for="txtrefer">BuyerName </label></td>


           <td><input id="txtrefer" name="txtrefer"  type="BuyerName "  value=""/></td></tr>           



     <tr>

      <td height="36"><label class="description" for="txtamount">BuyerAddress </label></td>

<td><input id="txtamount" name="txtamount"  type="BuyerAddress" maxlength="" value=""/></td></tr>

<tr>         
        <td height="42">

        <label class="description" for="txtstate">PhoneNo</label></td>



      <td><input id="txtstate" name="txtstate"  type="PhoneNo"  value=""/></td> 
</tr>          

   <li class="buttons">


<tr>       

   <td> </td>
          <td><input id="saveForm" class="button_text" type="submit" name="add" value="Add" />      <input type="submit"class="button_text" name="update" value="Update" />
            <a href="http://localhost/Apperal/vieww.php">
            <input  type="submit" class="button_text" name="search2" value="view" />    </a>
         <!--   <input type="submit" class="button_text" name="search" value="Search" />-->
            <input type="submit" class="button_text" name="delete" value="Delete" />
        </td>
          <td> </td>
          <td> </td>

          <td> </td>     


</table>     



</form>

</div>
</div>
<div id="box4">
 <p class="mar"><a href="viewadd.php">Back</a></p>
<p class="mar"><a href="index.php">Logout</a></p>

</div>





<div id="footer">
</p>Automated@copyright2012</p>
</div>






</div>









</div>
</div>

</body>
</html>

Line 32 is missing a single quote after $state.

or null is an odd value to put into the id. if autonumbering remove both the field and the null value. otherwise assign a real value

null is an odd value to put into the id

If auto numbering is on, passing NULL is accepted. Personally, I prefer removing it too, but both act the same.

Thnx..I edited the line 32 missing value and I add "mysql_real_escape_string" near to ($_POST['txtno']); in 12,13, & 14 line..It worked!!!Thanx lot...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.