如何从mysql填充选择选项 [英] How can fill select option from mysql

问题描述

$output = '';
if(isset($_POST["query"]))
{
 $search = mysqli_real_escape_string($connect, $_POST["query"]);
 $query = "
  SELECT * FROM deserved 
  WHERE DeName LIKE '".$search."'
 
 ";
}
else
{
 $query = "
  SELECT * FROM deserved  
 ";
}
$result = mysqli_query($connect, $query);
if(mysqli_num_rows($result) > 0)
{
 $output .= '
 
   
 ';
 while($row = mysqli_fetch_array($result))
  
 {
	  
  $output .= '
    <input type="text"  " value="'.$row["DeFamilyNum"].'">
    
      
  ';

 }

我尝试过：



从数据库中选择选项

i需要将输入更改为组合框

What I have tried:

select option from database
i need to change input to combo box

推荐答案

输出 = ' ';
if（isset（

output = ''; if(isset(

_POST [ query]））
{

_POST["query"])) {

search = mysqli_real_escape_string（

search = mysqli_real_escape_string(

这篇关于如何从mysql填充选择选项的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！