How to Post Javascript to a MySQL Database
- by salientanimal
Hi guys,
I have created a form in HTLM and I m trying to post the information in the form to a MySQL database. My form make suse of a dynamic list selection that needs to be captured to the database. However when submtting the form I get the following error
Error: Unknown column 'coulmn_name' in 'field list'.
Here is my HTML CODE for the form
<td height="94"><p align="justify">CALL TRACKER - ADMIN</p></td>
Customer Name :
E-Mail Address :
</tr>
<tr>
<td width="29%" align="right" valign="middle"><strong>Case Number :</strong></td>
<td>
<input type="text" name="case_number" width="70%" align="left" valign="middle">
</td>
</tr>
<tr>
<td width="29%" align="right" valign="middle"><strong>MSISDN :</strong></td>
<td>
<input type="text" name="msisdn" width="70%" align="left" valign="middle">
</td>
</tr>
<tr>
<td width="29%" align="right" valign="middle">
<strong>Route Cause :</strong></td>
<td width="71%" align="left" valign="middle">
<select name="route_cause" id="category" onChange="javascript: listboxchange1(this.options[this.selectedIndex].value);">
<!-- <select name="route_cause" id="route_cause"> -->
<option value="">Select the Call Reason</option>
<option value="Billing Admin">Billing Admin</option>
<option value="Customer Care">Customer Care</option>
<option value="Insurance">Insurance</option>
<option value="Repairs">Repairs</option>
<option value="SIM Swap">SIM Swap</option>
<option value="UTI">UTI</option>
</select>
</td>
</tr>
<tr>
<td align="right" valign="middle">
<strong>Call Type/Indexed To :</strong></td>
<td align="left" valign="middle">
<script type="text/javascript" language="javascript" name="calltype_indexedto">
<!--
document.write('<select name="subcategory1" onChange="javascript: listboxchange2(this.options[this.selectedIndex].value);"><option value=""></option></select>')
-->
</script>
</td>
</tr>
<tr>
<td align="right" valign="middle">
<strong>Type/TAT :</strong></td>
<td align="left" valign="middle">
<script type="text/javascript" language="javascript" name="type_tat">
<!--
document.write('<select name="subcategory2" onChange="javascript: listboxchange3(this.options[this.selectedIndex].value);"><option value=""></option></select>')
-->
</script>
</td>
</tr>
<tr>
<td width="29%" align="right" valign="middle">
<strong>Escalated To :</strong></td>
<td width="71%" align="left" valign="middle">
<select name="escalatedto" id="escalated_to">
<option value="">Select the Escalation</option>
<option value="Billing Ops">Billing Ops</option>
<option value="Resolvers">Resolvers</option>
<option value="Finance">Finance</option>
<option value="Ressolver">Ressolver</option>
<option value="Nudebt">Nudebt</option>
<option value="Transunion">Transunion</option>
<option value="N/A">N/A</option>
</select>
</td>
</tr>
<tr>
<td width="29%" align="right" valign="middle">
<strong>Requested By :</strong></td>
<td width="71%" align="left" valign="middle">
<select name="requestedby" id="requested_by">
<option value="">UTI Requested By</option>
<option value="Billing">Billing</option>
<option value="Customer Service">Customer Service</option>
<option value="Insurance">Insurance</option>
<option value="Management">Management</option>
<option value="Repairs">Repairs</option>
<option value="Retail Support">Retail Support</option>
<option value="Retentions">Retentions</option>
<option value="SIM Swap">SIM Swap</option>
<option value="WOW">WOW</option>
<option value="N/A">N/A</option>
</select>
</td>
</tr>
<tr>
<td width="29%" align="right" valign="middle">
<strong>Province :</strong></td>
<td width="71%" align="left" valign="middle">
<select name="province" id="province">
<option value="">Select the Province</option>
<option value="Eastern Cape">Eastern Cape</option>
<option value="Gauteng">Gauteng</option>
<option value="Kwa-Zulu Natal">Kwa-Zulu Natal</option>
<option value="Limpopo">Limpopo</option>
<option value="Mpumalanga">Mpumalanga</option>
<option value="North West">North West</option>
<option value="Northern Cape">Northern Cape</option>
<option value="Polokwane">Polokwane</option>
<option value="Western Cape">Western Cape</option>
<option value="Other">Other</option>
</select>
</td>
</tr>
<tr>
<td width="29%" align="right" valign="middle"><strong>Comments :</strong></td>
<td>
<textarea rows ="5" cols="30" name="comments">
</textarea>
</td>
</tr>
<tr>
<td>
<p>
<input type="reset" value="Reset Form"><input type="Submit" value="Submit">
Here is my PHP CODE to write to the Database
<?php
$con = mysql_connect("hostname"
,"mysqusername"
,"mysqlpassword");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("databasename", $con);
$sql="INSERT INTO customer_services_tracker
(customer_name
,customer_email_address
,case_number
,msisdn
,route_cause
,calltype_indexedto
,type_tat
,escalatedto
,requestedby
,province
,comments
)
VALUES
('$_POST[customer_name]'
,'$_POST[customer_email_address]'
,'$_POST[case_number]'
,'$_POST[msisdn]'
,'$_POST[route_cause]'
,'$_POST[calltype_indexedto]'
,'$_POST[type_tat]'
,'$_POST[escalatedto]'
,'$_POST[requestedby]'
,'$_POST[province]'
,'$_POST[comments]')";
$CatName = $rowCat["Name"];
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 record added";
mysql_close($con)
?>