选择选项菜单,从数据库中读取并使用其值 [英] Select option menu read from database and use it's values
本文介绍了选择选项菜单,从数据库中读取并使用其值的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
<?php
mysql_connect("localhost", "root","") or die(mysql_error());
mysql_select_db("tnews2") or die(mysql_error());
$query = "SELECT name,id FROM categories ORDER BY ID DESC LIMIT 0,6";
$result = mysql_query($query) or die(mysql_error()."[".$query."]");?>
<select name="categories">
<?php while ($row = mysql_fetch_array($result)){
?>
<option value=" <?php $row['path']; ?> ">
<?php echo $row['name']; ?>
</option>
<?php
}
?>
</select>?>
所以这是选择选项菜单,它是我从数据库中读取的值,但是当我尝试获取所选值时,我只会得到第一个.
So this is select option menu and it's value I read from database, but when I try to Get the selected value i get only the first one.
<?php
mysql_connect("localhost", "root","") or die(mysql_error());
mysql_select_db("tnews2") or die(mysql_error());
if(!empty($_POST['title']) && !empty($_POST['date']) && !empty($_POST['txt']) && !empty($_POST['image'])){
$TITLE=$_POST['title'];
$DATE=$_POST['date'];
$TXT=$_POST['txt'];
$IMAGE=$_POST['image'];
$CATEGORIES=$_POST['categories'];
echo $CATEGORIES;
$ANSWER=$_POST['main'];
$MAINPAGE=0;
您能帮我个忙吗,以获取选定的选项
Could you help me with an idea to get the selected option
推荐答案
(减少您的代码)
<?php
mysql_connect("localhost", "root","") or die(mysql_error());
mysql_select_db("tnews2") or die(mysql_error());
$query = "SELECT name,id,path FROM categories ORDER BY ID DESC LIMIT 0,6";
$result = mysql_query($query) or die(mysql_error()."[".$query."]");
?>
<select name="categories">
<?php
while ($row = mysql_fetch_array($result))
{
echo "<option value='".$row['path']."'>'".$row['name']."'</option>";
}
?>
</select>
这篇关于选择选项菜单,从数据库中读取并使用其值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文