douping7975 2017-04-09 11:06
浏览 520


I have looked at this answer enter link description here

but I am not able to make my code work, this is what i have in my selectcategory.php file. I want to have this variable $selectedcategory set up in this file. Echo command at the bottom is for testing purpose only.

My code:

$query1 = mysqli_query($query, "SELECT category FROM `events` GROUP BY category");
echo "<select name'selectedcategory'>";    
while ($row = mysqli_fetch_assoc($query1)){
    echo "<option value='".$row['category']."'>".$row['category']."</option>";
echo "</select>";

echo $selectedcategory;

Where do I make mistake? In other files I have taken variable by this POST method from INPUT or SELECT element with given name. In this file Error is on line 10 - UNDEFINIED VARIABLE, so where do I make mistake in getting it? Thank you in advance and if more clarification needed, please ask.

ps: I know my code has mistakes, but please concentrate only on getting the variable now. In other questions on this forum people just comment that my code is for example vulnerable for injections but no new information to the question itself or to prevent this injection (problem identified by commenter), I would like to prevent that. Identifing problem by commenter is great way of learning, but please than also provide some arguments why it is a problem or some links which relate to the problem.

  • 写回答

1条回答 默认 最新

  • drsfgwuw61488 2017-04-09 11:27

    Your form fields/values are not stored in $_POST array until after you submit the form.

    You will need to wrap your select field in <form method="POST"></form> and provide a submit button to even get started with this process.

    Start reading:

    If you are submitting to the same page, you may want to use something like this:

    include_once('config.php');  // labeling your connection '$query' doesn't seem like good practice and may trip you up in the future.
    $result=mysqli_query($db,"SELECT category FROM `events` GROUP BY category");
    echo "<form action=\"\" method=\"POST\">";
        echo "<select name=\"selectedcategory\">";
            echo "<option></option>";
                    echo "<option value=\"{$row['category']}\"",($selected==$row['category']?" selected":""),">{$row['category']}</option>";
        echo "</select>";
        echo "<input type=\"submit\" value=\"Submit\">";
    echo "</form>";

    I understand that for someone new to php, an inline condition statement is pretty difficult to read.

    Here is what it looks like over multiple lines:

    echo "<option value=\"{$row['category']}\"";
        echo " selected";  // only mark this option as "selected" if values match
        echo "";  // otherwise, do not mark it with "selected"
    echo ">{$row['category']}</option>";

    If someone ever managed to POST a value that doesn't match any of the database values in the loop, then none of the <option>s would get the select attribute, and the <select> would show the first/top <option> by default.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?



  • ¥50 hyper默认的default switch
  • ¥15 网站打不开,提示502 Bad Gateway
  • ¥20 基于MATLAB的绝热压缩空气储能系统代码咨询
  • ¥15 R语言建立随机森林模型出现的问题
  • ¥20 unity内置语言切换的按钮设置
  • ¥15 中级微观经济学,生产可能性边界问题
  • ¥15 TCP传输时不同网卡传输用时差异过大
  • ¥15 请各位看看我写的属于什么算法,或者有更正确的写法?
  • ¥15 html5 qrcode 扫描器
  • ¥15 爬取网页信息并保存需要完整代码