PHP表单与MySql数据库


PHP Form with MySql Database

嗨,我需要一些帮助从数据库创建表单:数据库

我有这个:

global $wpdb;
//$query ="SELECT modelo,ID FROM volumes"; 
$query ="SELECT Modelo,ID FROM volumes order by ID";
$wpdb->query($query)

这个:

<div class="form_fields">
<p>
<label for="modelo">Model:
echo "<select name=Modelo value=''>Modelo</option>"; // list box select command
foreach ($wpdb->query($query) as $row){//Array or records stored in $row
echo "<option value=$row[ID]>$row[Modelo]</option>"; 
/* Option values are added by looping through the array */ 
}
 echo "</select>";// Closing of list box
        </label>
    </p></div>

怎么了?

请检查此项:

<?php
global $wpdb;
$query ="SELECT Modelo,ID FROM volumes order by ID";
$wpdb->query($query);
?>
<div class="form_fields">
  <label for="modelo">Model: </label>
    <select name=Modelo value=''>
      <option>Modelo</option>
         <?php
         foreach ($wpdb->query($query) as $row) {
          ?>
            <option value="<?php echo $row->ID; ?>"><?php echo $row->Modelo; ?></option>
         <?php
         }
            ?>
     </select>
 </div>

试试这个:

<?php
global $wpdb;
//$query ="SELECT modelo,ID FROM volumes"; 
$query = "SELECT Modelo,ID FROM volumes order by ID";
$results = $wpdb->get_results($query);
?>
<div class="form_fields">
    <p>
        <label for="modelo">Model:
            <select name=Modelo>
                <option value=''>Modelo</option>
                <?php
                foreach ($results as $row) {//Array or records stored in $row
                    echo "<option value='{$row->ID}'>{$row->Modelo}</option>";
                    /* Option values are added by looping through the array */
                }
                ?>
            </select>
        </label>
    </p>
</div>

请尝试此

型号:Modelo";foreach($wpdb->query($query)为$row){echo"$行["Modelo"]。";}echo";?>