mysql SET类型和多数据进程用php在sql查询中(Mysql SET type and multi data process with php in sql query)

 所以我一直在尝试在我的网站上创建一个搜索表单，这取决于用户检查的内容（复选框），我花了很多时间在网上研究，但没有找到任何东西，所以我不得不自己做。 所以这里是html的代码 
 
<li><input type="checkbox" name="checkbox[]" value="action"> Action</li>
<li><input type="checkbox" name="checkbox[]" value="Adventure"> Adventure</li>
<li><input type="checkbox" name="checkbox[]" value="Animation"> Animation</li>
<li><input type="checkbox" name="checkbox[]" value="cars"> Cars</li>
<li><input type="checkbox" name="checkbox[]" value="cartoon"> Cartoon</li>
<li><input type="checkbox" name="checkbox[]" value="comedy"> Comedy</li>
 
 这是php 
 
<?php

     if(!empty($_POST['checkbox'])) {

        $Gen3 = implode(" AND * ", $_POST['checkbox']);

     $Gen2= str_replace('*', 'Genre like ', $Gen3); 

                $table='animelist';

                $sql = "SELECT * FROM $table  WHERE Genre like '".$Gen2."' ORDER BY NAME DESC" ;  

                echo $sql;
                $result = mysqli_query($conn, $sql) or die('Erreur SQL !'.$req.'<br>'.mysql_error());

    while($row = $result->fetch_assoc()){

?> 

<li><a href="Anime.php?/anime=<?php echo $row['Name']; ?>"><?php echo $row['Name']; ?></a></li>

<?php ;
}
};
?>
 
 echo $ sql如果我检查两个复选框，例如结果 
 
SELECT * 
FROM animelist 
WHERE Genre like 'action AND Genre like Adventure' 
ORDER BY NAME DESC
 
 所以这里的事情是用户研究的“电影”可能是“动作，冒险”的一套，所以当用户选中复选框时，结果必须是“电影”，这不仅仅是动作和冒险行动。 
 
 现在，如果我只检查一个复选框，evrything工作正常，但当我检查两个或更多时，我什么都没得到 
 
 所以我虽然在变量之前和之后的sql查询是破坏它的那个，所以我不得不骑它们，所以我尝试使用mysql_real_escape_string，但是因为它不再是受理者而且mysqli_real_escape_string不做我被困在这里的工作。 

So I've been trying to create a search form on my website that depends on what the user check ( checkboxes), I've spent many time researching on web but didn't find anything, so I had to do things myself. so here is the code for the html
 
<li><input type="checkbox" name="checkbox[]" value="action"> Action</li>
<li><input type="checkbox" name="checkbox[]" value="Adventure"> Adventure</li>
<li><input type="checkbox" name="checkbox[]" value="Animation"> Animation</li>
<li><input type="checkbox" name="checkbox[]" value="cars"> Cars</li>
<li><input type="checkbox" name="checkbox[]" value="cartoon"> Cartoon</li>
<li><input type="checkbox" name="checkbox[]" value="comedy"> Comedy</li>
 
and here is the php
 
<?php

     if(!empty($_POST['checkbox'])) {

        $Gen3 = implode(" AND * ", $_POST['checkbox']);

     $Gen2= str_replace('*', 'Genre like ', $Gen3); 

                $table='animelist';

                $sql = "SELECT * FROM $table  WHERE Genre like '".$Gen2."' ORDER BY NAME DESC" ;  

                echo $sql;
                $result = mysqli_query($conn, $sql) or die('Erreur SQL !'.$req.'<br>'.mysql_error());

    while($row = $result->fetch_assoc()){

?> 

<li><a href="Anime.php?/anime=<?php echo $row['Name']; ?>"><?php echo $row['Name']; ?></a></li>

<?php ;
}
};
?>
 
the echo $sql if I check two checkboxes for example result
 
SELECT * 
FROM animelist 
WHERE Genre like 'action AND Genre like Adventure' 
ORDER BY NAME DESC
 
so the thing here is that the "movie" that the user would research might be a SET of "Action,Adventure" , so when the user checks the checkboxes the result have to be the "movies" which are both Action and adventure not only Action.
 
for now if I only check one checkbox evrything works fine but when I check two or more I get nothing
 
so I though that the ' in the sql query before and after the variable are the one ruining it, so I had to get ride of them, so I tried to use mysql_real_escape_string, but since its not accepter anymore and the mysqli_real_escape_string doesn't do the job I am stuck here.

原文：https://stackoverflow.com/questions/33979888