[SQL PHP]按BETWEEN $ _POST排序 [英] [SQL PHP] Order by BETWEEN $_POST

问题描述

我目前正尝试在HTML页面上的两个给定值之间按表排序。但我收到了一些错误，我找不到原因......



任何人都知道我做错了什么？



注意：未定义的偏移量：D中的10：\Program Files \ xampp \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
注意：未定义的偏移量：50中的D：\Program Files \ xampp \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ b

HTML页面：

 <  表单    action   =   verwerken.php    method   = 发布 >  
 Kies een minimumprijs：
 <  选择 >  
 <  选项    value   =   10   名称  =  min >  10欧元<   / option  >  
 <  选项   值  =  30    name   =  min >  30欧元<   / option  >  
 <  < span class =code-leadattribute>选项    value   =  50    name   =  min >  50 euro <   / option  >  
 <  选项    value   =  100    name   =  min >  100欧元<   / option  >  
 <  < span class =code-leadattribute>选项    value   =  500    name   =  min >  500 euro <   / option  >  
 <   / select  >  
 
 <   br  >  Kies een maximumprijs：
 <   select  >  
 <  选项    value   = < span class =code-keyword> 10    name   =  max >  10 euro <   / option  >  
 <  选项    value   =  30   名称  =  max >  30欧元<   / option  >  
 <  选项    value   =  50    name   =  max >  50欧元<   / option  >  
<  选项   值  =  100   名称  =  max >  100欧元<   / option  >  
 <  选项    value   = < span class =code-keyword> 500    name   =  max >  500欧盟ro <   / option  >  
 <   / select  >  
 
 <   br   >  <  输入    type   =  submit    name   = 提交   值  =   Geef overzicht artikelen >  <   br  >  <   br  >  
 <   / form  >  

PHP PAGE：

 <？  php   
   
   $ con   =   mysqli_connect（  localhost，root，，mysql）;   
   
   //    检查    connection   
   
   if    （mysqli_connect_errno（））    {  
   
       echo    失败        connect         MySQL：      。    mysqli_connect_error（）;   
   
  }   
   
   
   
   $ min     =   mysqli_real_escape_string（$ con，  $ _ POST ['min']）;   
   
   $ max     =   mysqli_real_escape_string（$ con，  $ _POST ['max']）;   
   
  < span class =code-summarycomment> 
   
   $ result     =   mysqli_query（$ con，  SELECT     *     FROM     artikel   
   
   WHERE     Verkoopprijs   
   
   BETWEEN     $ min     AND     $ max   
   
  < span class =code-summarycomment> ORDER     BY     Verkoopprijs）;   
   
   
   
  < span class =code-summarycomment> 
   
   echo    < table     border   ='  1' >  
 <   tr  >  
 <   th  >  Artikelnr <   / th  >  
 <   th  >  Verkoopprijs <   / th  >  
 <   / tr  > ; 
 
 while（$ row = mysqli_fetch_array（$ result））{
 echo<   tr  > ; 
 echo<   td  > 。 $ row ['Artikelnr']。 <   / td  >  ; 
 echo<   td  > 。 $ row ['Verkoopprijs']。 <   / td  >  ; 
 echo<   / tr  > ; 
} 
 
 echo<   / table  > ; 
 
 mysqli_close（$ con）; 
？> 

解决方案

con = mysqli_connect（ localhost，root，，mysql）;

// < span class =code-summarycomment> 检查 连接

if （mysqli_connect_errno（）） {

echo 失败 connect to MySQL： 。 mysqli_connect_error（）;

}

min = mysqli_real_escape_string（

con，

I'm currently trying to order by table between two given values on my HTML page. But I'm getting some errors, and I cannot find out why..

Anyone know what I'm doing wrong?

Notice: Undefined offset: 10 in D:\Program Files\xampp\htdocs\Week 5\verwerken.php on line 8

Notice: Undefined offset: 50 in D:\Program Files\xampp\htdocs\Week 5\verwerken.php on line 9


HTML Page:

<form action="verwerken.php" method="post">
Kies een minimumprijs:
 <select>
    <option value="10" name="min">10 euro</option>
    <option value="30" name="min">30 euro</option>
    <option value="50" name="min">50 euro</option>
    <option value="100" name="min">100 euro</option>
    <option value="500" name="min">500 euro</option>
</select>

<br>Kies een maximumprijs:
 <select>
    <option value="10" name="max">10 euro</option>
    <option value="30" name="max">30 euro</option>
    <option value="50" name="max">50 euro</option>
    <option value="100" name="max">100 euro</option>
    <option value="500" name="max">500 euro</option>
</select>

<br><input type="submit" name="submit" value="Geef overzicht artikelen"><br><br>
</form>

PHP PAGE:

<?php

$con=mysqli_connect("localhost","root","","mysql");

// Check connection

if (mysqli_connect_errno()) {

  echo "Failed to connect to MySQL: " . mysqli_connect_error();

}



$min = mysqli_real_escape_string($con, $_POST['min']);

$max = mysqli_real_escape_string($con, $_POST['max']);



$result = mysqli_query($con,"SELECT * FROM artikel

WHERE Verkoopprijs

BETWEEN $min AND $max

ORDER BY Verkoopprijs");





echo "<table border='1'>
<tr>
<th>Artikelnr</th>
<th>Verkoopprijs</th>
</tr>";

while($row = mysqli_fetch_array($result)) {
  echo "<tr>";
  echo "<td>" . $row['Artikelnr'] . "</td>";
  echo "<td>" . $row['Verkoopprijs'] . "</td>";
  echo "</tr>";
}

echo "</table>";

mysqli_close($con);
?>

解决方案

con=mysqli_connect("localhost","root","","mysql"); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); }

min = mysqli_real_escape_string(

con,

这篇关于[SQL PHP]按BETWEEN $ _POST排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！