values does not go in to the table
Posted: Thu Jan 16, 2014 1:54 am
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.
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.
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> ";
?>