我正在构建一个自定义零件构建器,我正在尝试通过生成的零件号搜索MySQL数据库,然后将价格输入表中的单元格。我不知道如何通过生成的零件号进行搜索并输出价格。零件号由JavaScript生成,但示例零件号为133-FTHXFTH-075-N1-00。这是我的ajax脚本
var request = $.ajax({
url: "http://localhost/filenamehere.php",
type: "post",
data: "partnumber"
});
request.done(function (response) {
document.getElementById("price1").innerHTML = response;
});
这是我的php代码
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$result = mysqli_query($con,"SELECT 'LDS_Price_$' FROM list where
Part_Number=**This is wher the generated part number would go** ");
echo "<table border='1'>
<tr>
<th>LDS Price $</th>
</tr>";
while($row = mysqli_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['LDS_Price_$'] . "</td>";
echo "</tr>";
}
echo "</table>";
mysqli_close($con);
?>`
如果您的php文件Si仅返回纯文本的价格...
myPartNumber = '133-FTHxFTH-075-N1-00';
$.ajax({
type: 'POST',
url: "http://localhost/filenamehere.php",
data: { partnumber: myPartNumber },
dataType: 'html',
async: true,
success: function(data) {
$('#price').html(data);
}
});
我希望它能有所帮助