Question

我想通过从我的桌子上获取价值来缩小面积。这部法律似乎并不奏效;它所勾画的都是在没有内容的情况下倒台的盒子,我如何能够做到这一点? 或者在这样做时是否有替代程序?

<?
$connection = mysql_connect("localhost", "root", "");
mysql_select_db("test", $connection);
$query = "SELECT full_name FROM test";
$names = mysql_query($query);
function dropDown($content, $result)
 {
while($row = mysql_fetch_row($result))
    {
        $name = $row[0];
        $content .= "<option value= $name >$name</option>";
    }
 }
$content=<<<EOT
           <html>
              <body>
                 <select name="name">
EOT;

dropDown($content, $names)

$content.=<<<EOT
                 </select>
              </body>   
            </html>          


EOT;

echo $content;
?>

Answer 1

页: 1 PHP不是你使用out<>/em>参数的C,仅仅因为它们有时是手法。

function dropDown($result, $fieldName)
{
    $content =   ;
    while($row = mysql_fetch_row($result)) {
        $name = $row[0];
        $content .= "<option value= $name >$name</option>";
    }
    return  <select name=" .$fieldName. "> .$content. </select> ;
}

$content =  <html><body> ;
$content .= dropDown($names,  name );

Answer 2

    here database details      
  mysql_connect( hostname ,  username ,  password );
mysql_select_db( database-name );

     $sql = "SELECT username FROM userregistraton";
        $result = mysql_query($sql);

         echo "<select name= username >";
  while ($row = mysql_fetch_array($result)) {
   echo "<option value= " . $row[ username ] ." >" . $row[ username ] ."</option>";}
   echo "</select>";


      here username is the column of my table(userregistration)
     it works perfectly

or simply the code is 
        <?
         $sql = "SELECT * FROM userregistraton ";
             $result = mysql_query($sql); ?>


 <select name="username" id="username">
<option value="">Select user</option>
    <?php
        while ($row = mysql_fetch_array($result))
        { ?>
          <option value="<?php echo $row[ uid ]?>"         <?php    if($row[ uid ]==$_POST["username"]) echo "selected"; ?> >
   <?php echo $row[ username ];?></option>
   <?php
         } ?>

Answer 3

<?php echo $form->dropDownList($model, courseprefer , array(

 (*value in database table* => displaying value ,
 )); ?>

您可以人工添加这些内容,只是确保阵列中的第一个价值被列入数据库表。

避免错误!

友情链接