values does not go in to the table

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
shehan31
Forum Commoner
Posts: 59
Joined: Sun Aug 29, 2010 5:24 am

values does not go in to the table

Post by shehan31 »

Hello ;
Please refer to the attached script. The information that I entered through a PHP form does not go int the mysql table. I have tried so many things but it does not work. It always gives me the "ERROR" message.
:crazy:

Code: Select all

<?php
$connect = mysql_connect ("localhost","root","abc1234") or die ("error");
mysql_select_db ("rameca") or die ("Error Connecting With The Database");
$queryget1 = mysql_query ("SELECT id FROM quatation " ) or die (" error with table");

if (isset($_POST['Login']))
   { 
//get values from portal.
	$qid=$_POST['Quatation_ID'];
	$cn = $_POST['Customer_Name'];
    $sub = $_POST['Subject'];
    $date = $_POST['Date'];
	$acc = $_POST['acc'];
	$cam = $_POST['Camera'];
	$cuom = $_POST['Cam_UOM'];
	$camu = $_POST['Camera_units'];
	$camup = $_POST['Camera_up'];
	$dvr = $_POST['DVR'];
	$duom = $_POST['dvruom'];
	$mon = $_POST['mon'];
	$muom = $_POST['monuom']; 
	$monun = $_POST['monuni'];
	$mup = $_POST['mup'];
	$netw = $_POST['netw'];
	$serv = $_POST['charge'];
	$dvruni = $_POST['DVR_uni'];
	$dup = $_POST['dup'];
	$con = $_POST['con'];
	$prf = $_POST['pf'];
	
	$sql = "INSERT INTO 'quatation' ('id', 'company', 'subject', 'date', 'network', 'Camera', 'camerauom', 'cameraunits', 'cameraup', 'DVR', 'DVRuom', 'DVRunits', 'DVRup', 'Monitor', 'monuom', 'monunit', 'monup', 'networkcharge', 'service', 'project', 'tp') VALUES ('$qid', '$cn','$sub','$date','$acc','$cam', '$cuom','$camu', '$camup', '$dvr', '$duom', '$dvruni', '$dup','$mon', '$monun', '$mup', '$netw', '$serv', '$prf', '$con')";
	 $result=mysql_query($sql);

	 //$result= $sql;

	 if($result){
	echo "Successful";
	echo "<BR>";
	//echo "<a href='insert.php'>Back to main page</a>";
	}

		else {
			echo "ERROR";
			}
			}
     /*$sql = ($connect,"INSERT INTO quatation  VALUES ('$qid', '$cn','$sub','$date','$acc','$cam', '$cuom','$camu', '$camup', '$dvr', '$duom', '$dvruni', '$dup','$mon', '$muom','$monun', '$mup', '$netw', '$serv',  '$prf', '$con')");
 } */
  
/*while ( $row = mysql_fetch_assoc ($queryget1) ){
   $id = $row['id'];
    if($id==$qid){
		echo"The quatation exsist.";
	}
		else{
			
		}
		
	  }
 }  */  

echo"
<form action = 'inputqua.php' method='POST'>
<div id='first_table' style='float:left; width:100%; position:absolute; top:-120px; left:2px; column-gap:40px;'>

 
  <table bgcolor='#FF0000' >
   <tr >
        <td></br></br>
               
        <font size='4' face='times new roman' color='18ff19' pos>Quatation_ID</font>
        </td>
        <td></br></br>
        <input type='text' name='Quatation_ID' maxlength='200'>
        </td>
   </tr>
    <tr>
        <td></br></br>
               
         <font size='4' face='times new roman' color='18ff19'>Customer Name</font>
        </td>
        <td></br></br>
        <input type='text' name='Customer_Name'  maxlength='200'>
        </td></br></br>
   </tr>
   <tr>
        <td></br></br>
               
         <font size='4' face='times new roman' color='18ff19'>Subject</font>
        </td>
        <td></br></br>
        <input type='text' name='Subject'  maxlength='200'>
        </td></br></br>
   </tr>
   
   <tr>
        <td></br></br>
               
         <font size='4' face='times new roman' color='18ff19'>Date</font>
        </td>
        <td></br></br>
        <input type='date' name='Date'  maxlength='200'>
        </td></br></br>
   </tr>
   
   <tr>
        <td></br></br>
               
         <font size='4' face='times new roman' color='18ff19'> Accessories</font>
        </td>
        <td></br></br>
        <input type='text' name='acc'  maxlength='200'>
        </td></br></br>
   </tr>
   
   <tr >
        <td></br></br>
               
        <font size='4' face='times new roman' color='18ff19'>Camera Type</font>
        </td>
        <td></br></br>
        <input type='text' name='Camera' maxlength='200'>
        </td>
   </tr>
    <tr>
        <td></br></br>
               
         <font size='4' face='times new roman' color='18ff19'>Camera UOM</font>
        </td>
        <td></br></br>
        <input type='text' name='Cam_UOM'  maxlength='200'>
        </td></br></br>
   </tr>
   </table>
   </div>
   
   
   
   
   <div id='second_table' style='float:left; width:100%; position:absolute; top:-200px; left:350px; column-gap:40px;'>

 
  <table bgcolor='#FF0000' >
   
   <tr>
        <td></br></br>
               
         <font size='4' face='times new roman' color='18ff19'>Camera Units</font>
        </td>
        <td></br></br>
        <input type='text' name='Camera_units'  maxlength='200'>
        </td></br></br>
   </tr>
   <tr>
        <td></br></br>
               
         <font size='4' face='times new roman' color='18ff19'>Camera(U/P)</font>
        </td>
        <td></br></br>
        <input type='text' name='Camera_up'  maxlength='200'>
        </td></br></br>
   </tr>
   
   
   
   
   <tr>
        <td></br></br>
               
         <font size='4' face='times new roman' color='18ff19'>DVR/NVR model</font>
        </td>
        <td></br></br>
        <input type='text' name='DVR'  maxlength='200'>
        </td></br></br>
   </tr>
   <tr>
        <td></br></br>
               
         <font size='4' face='times new roman' color='18ff19'>DVR/NVR UOM</font>
        </td>
        <td></br></br>
        <input type='text' name='dvruom'  maxlength='200'>
        </td></br></br>
   </tr>
   <tr>
        <td></br></br>
               
         <font size='4' face='times new roman' color='18ff19'>Monitor Type</font>
        </td>
        <td></br></br>
        <input type='text' name='mon'  maxlength='200'>
        </td></br></br>
   </tr>
   <tr>
        <td></br></br>
               
         <font size='4' face='times new roman' color='18ff19'>Monitor Units</font>
        </td>
        <td></br></br>
        <input type='text' name='monuni'  maxlength='200'>
        </td></br></br>
   </tr>
   
   <tr>
        <td></br></br>
               
         <font size='4' face='times new roman' color='18ff19'>Monitor (U/P)</font>
        </td>
        <td></br></br>
        <input type='text' name='mup'  maxlength='200'>
        </td></br></br>
   </tr>
   
   </table>   
   </div>
   
  <div id='Third_table' style='float:left; width:100%; position:absolute; top:-195px; left:700px; column-gap:40px;'> 
  <table bgcolor='#FF0000' >
  <tr>
        <td></br></br>
               
         <font size='4' face='times new roman' color='18ff19'>Network Charge</font>
        </td>
        <td></br></br>
        <input type='text' name='netw'  maxlength='200'>
        </td></br></br>
   </tr>
  
  <tr>
        <td></br></br>
               
         <font size='4' face='times new roman' color='18ff19'>Service Charges</font>
        </td>
        <td></br></br>
        <input type='text' name='charge'  maxlength='200'>
        </td></br></br>
   </tr>
   
   <tr>
        <td></br></br>
               
         <font size='4' face='times new roman' color='18ff19'>Project fee</font>
        </td>
        <td></br></br>
        <input type='text' name='pf'  maxlength='200'>
        </td></br></br>
   </tr>
   
    <tr>
        <td></br></br>
               
         <font size='4' face='times new roman' color='18ff19'>DVR_units</font>
        </td>
        <td></br></br>
        <input type='text' name='DVR_uni'  maxlength='200'>
        </td></br></br>
   </tr>
   <tr>
        <td></br></br>
               
         <font size='4' face='times new roman' color='18ff19'>DVR (U/P)</font>
        </td>
        <td></br></br>
        <input type='text' name='dup'  maxlength='200'>
        </td></br></br>
   </tr>
   <tr>
        <td></br></br>
               
         <font size='4' face='times new roman' color='18ff19'>Contact No</font>
        </td>
        <td></br></br>
        <input type='text' name='con'  maxlength='200'>
        </td></br></br>
   </tr>
  
  <tr>
        <td></br></br>
               
         <font size='4' face='times new roman' color='18ff19'>Monitor UOM</font>
        </td>
        <td></br></br>
        <input type='text' name='monuom'  maxlength='200'>
        </td></br></br>
   </tr>
  </table>   
   </div>
   
   <tr>
       <td align='center' valign='top' colspan='2'>
        <input type='submit' name='Login' value=''style='position:absolute; top:510px; right: 150px; background:url(logoa.jpg); cursor:hand; width:120px;height:35px';>
       </td>
           </tr>
</form> ";



?>
Post Reply