我是PHP新手,希望能有所帮助.
我试图用我的SQL数据库中的数据填充HTML下拉列表.
我希望能够从下拉列表中选择一个项目,然后使用数据库中的相关记录来填充HTML表.
到目前为止,我已经设法连接到数据库并从相关表中检索所有数据.
有人可以帮我设置下拉列表中的内容吗?
谢谢
$username = 'root';
$password = '';
$conn = new PDO( 'mysql:host=localhost; dbname=Oaktown', $username, $password );
$sql ="SELECT RoundNumber, RoundDate, HomeTeam, HomeTeamScore, AwayTeam, AwayTeamScore FROM Fixture";
$statement = $conn->prepare( $sql );
$statement->execute();
$results = $statement->fetchAll( PDO::FETCH_ASSOC );
?>
Competitions
Fixture Information
Select Round and Game number from the dropdown list under Round Number.
">Round Number
type="submit" name="Get" value="Get Fixture Results">
Results
Round Number: |
echo "
";echo $row['RoundNumber'];
}
?>
Round Date:.echo "
";echo $row['RoundDate'];
}
?>
Home Team:echo "
";echo $row['HomeTeam'];
}
?>
Home Team Score:echo "
";echo $row['HomeTeamScore'];
}
?>
Away Team:echo "
";echo $row['AwayTeam'];
}
?>
Away Team Score:echo "
";echo $row['AwayTeamScore'];
}
?>
解决方法:
使用类似的代码块(如用于表的代码块),您可以执行以下操作:
echo "" . $row['text column'] . "";
}
?>
如果您没有或需要一对值,则只需执行以下操作:
echo "" . $row['text column'] . "";
}
?>
标签:html-select,html,mysql,php
来源: https://codeday.me/bug/20191025/1927648.html