如何将Javascript发送到MySQL数据库？
如何将Javascript发送到MySQL数据库？
提问于 2018-09-17 05:47:10
我用HTML创建了一个表单，并试图将表单中的信息发布到MySQL数据库中。我的表单使用了需要捕获到数据库的动态列表选择。然而，在提交表单时，我会得到以下错误
Error: Unknown column 'coulmn_name' in 'field list'.
这是表单的HTML代码
<td height="94"><p align="justify">CALL TRACKER - ADMIN</p></td>
</tr>
<tr>
<td>
<table width="36%" border="0" align="center" cellpadding="2" cellspacing="0">
<tr>
<td width="29%" align="right" valign="middle"><strong>Customer Name :</strong></td>
<td>
<input type="text" name="customer_name" width="70%" align="left" valign="middle">
</td>
</tr>
<tr>
<td width="29%" align="right" valign="middle"><strong>E-Mail Address :</strong></td>
<td>
<input type="text" name="customer_email_address" width="70%" align="left" valign="middle">
</td>
</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)
?> 回答 2
Stack Overflow用户
发布于 2018-09-17 14:37:38
应该通过将die()更改为死(‘sql：’.$sql‘)来回显SQL语句，错误：‘.mysql_error());
此外，作为一个旁白，不应该仅仅将已提交的变量放在数据库中，谁知道它们包含了什么。
Stack Overflow用户
发布于 2018-09-17 14:50:52
错误：“字段列表”中的未知列'coulmn_name'。
SQL语句可能引用了一个不存在的列（可能是在INSERT INTO中）。检查真实的错误消息，了解正在使用的名称。
一句话：构建类似SQL的字符串（来自用户输入的数据）非常危险 - 如果用户填写“评论”字段，test'); DROP TABLE customer_services_tracker; --您的查询将变得非常邪恶。
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/-100000769
复制相关文章
相似问题