HTML下拉查询

Question

我希望给我的用户一个选项，从下拉菜单中选择他们想要运行的查询，然后当单击菜单时触发查询运行。我在想像这样的..。

姓名-地址-销售人员-完整报告--

因此，例如，如果用户单击菜单中的full report选项，就会触发此查询。

'SELECT DISTINCT jsfdName.baseData AS Name, jsfdAddr.baseData as Address, 
jsfdZip.baseData   AS Zip, jsfdCity.baseData AS City, jsfdState.baseData AS State,   
jsfdEmail.baseData AS Email,jsfdPhone.baseData AS Phone, jsfdPerson.baseData AS Person, 
jsfdContacted.baseData AS Contacted
FROM jos_sobipro_field_data AS jsfdName
JOIN jos_sobipro_field_data AS jsfdAddr USING(sid)
JOIN jos_sobipro_field_data AS jsfdZip USING(sid)
JOIN jos_sobipro_field_data AS jsfdCity USING(sid)
JOIN jos_sobipro_field_data AS jsfdState USING(sid)
JOIN jos_sobipro_field_data AS jsfdEmail USING(sid)
JOIN jos_sobipro_field_data AS jsfdPhone USING(sid)
JOIN jos_sobipro_field_data AS jsfdPerson USING(sid)
JOIN jos_sobipro_field_data AS jsfdContacted USING(sid)
WHERE jsfdName.fid = 36 AND jsfdAddr.fid = 37 AND jsfdZip.fid=38 AND jsfdCity.fid = 39     
AND jsfdState.fid = 41 AND jsfdEmail.fid = 65 AND jsfdPhone.fid = 46 AND jsfdPerson.fid  
= 66 AND jsfdContacted.fid = 63 AND sid > 900';

有什么想法吗？我也试图在一个文件中完成这一切，因为我希望它有密码保护，这样只有用户才能访问它。谢谢你们的帮助。

Answer 1

我假设您了解php、html和sql的基础知识。我只会告诉你如何选择查询。

对于html，我将使用下面的dropdown：

<select name="report">
    <option value="1">Full Report</option>
    <option value="2">Some Other Report</option>
</select>

您可以根据需要使用不同的值重复此操作。

现在来看php (选择查询)：

<?php
switch($_POST['report']) {
    case "1":
        $query = "SOME QUERY TEXT WOULD GO HERE";
        break;
    case "2":
        $query = "TEXT FOR A DIFFERENT QUERY HERE";
        break;
    default:
        //DO SOMETHING HERE IF THE VALUE IS NOT RECOGNIZED
        break;
}
//NOW RUN THE QUERY WITH $query as the string
?>

您可以根据需要添加任意数量的case。