从收集数据使用 PHP 标记

Question

我尝试使用位于我的主页 - index.php 中的此表单中的数据。

    <center> 
<form action="search.php" method="post"> 
<input type="text" name="search" size="30" /> 

<select name='wheretosearch'>
    <option value='Articles'>Articles</option>
    <option value='Users'>Members</option>
    </select>

<input type="submit" value="Search" /> 
</form> 
</center>

这是 search.php 代码的主要部分：

    include "all/config.php";

    $search = $_REQUEST['search'];  //Getting the words


    $split = split(" ",$search);  //If there is more than one I spit them.

     foreach ($split as $array => $value) 
{       $NewResult .= $value;
        }

    $wheretosearch = $_POST['wheretosearch'];

        if ($wheretosearch = 'Articles')
        {$Results = mysql_query("SELECT * FROM bgarticles WHERE title LIKE '%$value%' OR description LIKE '%$value%' OR text LIKE '%$value%' OR tags LIKE '%$value%' OR date LIKE '%$value%' OR author LIKE '%$value%' OR ip LIKE '%$value%' "); 

        while($row = mysql_fetch_array($Results))
    { 
        echo "<div class='top'>";
        echo "<span class='title'>";
        echo "<a href=details.php?id=$row[id]>";
        echo $row['title'];
        echo "</a>";
        echo "</span> <br><br>";
        echo "<span class='author'>";
        echo $row['author'];
        echo "</span>";
        echo "<span class='date'> Date: ";
        echo $row['date'];
        echo "</span> <br><br><br>";
        echo "<br><br></div>" ;
        echo "<div class='bottom'><br><br></div>";
    } 
    }


        if ($wheretosearch = 'members') 
        {$Results2 = mysql_query("SELECT * FROM members WHERE username LIKE '%$value%' OR firstname LIKE '%$value%' OR lastname LIKE '%$value%' "); 

            while($row2 = mysql_fetch_array($Results2))
    { 
        echo "<div class='top'>";
        echo "<span class='title'>";
        echo "<a href=details.php?id=$row2[id]>";
        echo $row2['username'];
        echo "</a>";
        echo "</span> <br><br>";
        echo "<span class='author'>";
        echo $row2['firstname'];
        echo "</span>";
        echo "<span class='date'> Date: ";
        echo $row2['date'];
        echo "</span> <br><br><br>";
        echo "<br><br></div>" ;
        echo "<div class='bottom'><br><br></div>";
    } 

        }

无论我做什么，它总是显示来自两个 mysql 表的数据。为什么？

Answer 1

您使用一个等号来设置一个变量。双等于进行比较。

if ($wheretosearch = 'members') {
// $wheretosearch is now (always) set to 'members'
// this will always trigger
}

if ($wheretosearch == 'members') {
// this will only trigger when the above is true
}

Answer 2

在 if 语句中使用 == 而不是 =。

Answer 3

= != ==

您的 if 条件包含赋值操作，而不是比较操作。

这是常见的错误，很多博客都包含避免这种错误的简单方法。

Answer 4

老实说：http://bobby-tables.com/

（然后检查您的if-子句，您使用的是赋值 (=) 而不是比较 (==)）

Answer 5

您缺少一个等号，因此它正在进行分配而不是测试相等性。

if ($wheretosearch = 'Articles')

应该是......

if ($wheretosearch == 'Articles')

另外：你没有逃避你的查询，所以你的数据库很容易被黑客攻击。在查询中使用变量之前，请像这样转义它们：

$wheretosearch = mysql_real_escape_string($wheretosearch);