在PHP中从列表框构建查询

Question

I have a page where I am wanting to allow a user to select fields from a select that exist in a table, then display the contents of those fields on screen. I have set-up the select like so

<select name="queryfields" size="12" multiple="multiple" tabindex="1">
<option value="firstname">firstname</option>
<option value="lastname">lastname</option>
<option value="address">address</option>
<option value="phone">phone</option>

And I know to discover what options were selected I can use this:

<?php
    header("Content-Type: text/plain");

    foreach ($_GET['queryfields'] as $selectedOption)
        echo $selectedOption."
";
?>

And that gives me an array of the fields selected. However, how do I then parse the array to generate my full query? For example, let's say that firstname, lastname were selected. I would then want to build my query like this:

Select firstname, lastname from employeedata

Unknown to me, is how to get the data from the array into a select statent like my above code snippet.

Answer 1

Try This:

$sql = '';
$selected_fields = array();   
foreach ($_GET['queryfields'] as $selectedOption){
    //echo $selectedOption."
";
    $selected_fields[] = $selectedOption;
}
if(!empty($selected_fields)){
    $fields = implode(',', $selected_fields);
    $sql = 'SELECT '.$fields.' from employeedata'; 
}

//print query if it is not empty

if(!empty($sql)){
    echo $sql;
}